MVC Code snippets

Thursday, 21 April 2016

Add proxy class for wcf service through Visual studio Command promt

Open VS command Prompt and give path of svcutil
and add service

see the below url for ur reference
http://www.codeproject.com/Articles/786601/Ways-to-generate-proxy-for-WCF-Service

Sunday, 14 February 2016

Encrypt and Decrypt Connectionstring and AppSettings Sections in web.config

Encrypt:

aspnet_regiis.exe -pef "appSettings" "D:\Sample\WebSite1" -prov "DataProtectionConfigurationProvider"

aspnet_regiis.exe -pef "connectionStrings" "D:\Sample\WebSite1" -prov "DataProtectionConfigurationProvider"

Decrypt:

aspnet_regiis.exe -pdf "appSettings" "D:\Sample\WebSite1"

aspnet_regiis.exe -pdf "connectionStrings" "D:\Sample\WebSite1"

Sunday, 10 January 2016

Access Resource values for db values

ddlState.Items(index).Value = ds.Tables(0).Rows(index)("Region_Code")
ddlState.Items(index).Text = GetLocalResourceObject(ds.Tables(0).Rows(index)("Resource_key").ToString() + ".Text").ToString

Monday, 4 January 2016

Jquery Text Easy Counter

Jquery text easy Counter shown below

<h2>EasyCountrer</h2>

$(document).ready(function () {

$("#easy").jqEasyCounter(

{

'maxChars': 160,

'maxCharsWarning': 150

});

</script>

OutPut:

Thursday, 17 December 2015

How to Bind Table Using Angular JS

Bind Table Using Angular JS

View:

<tr >

<td>First Name</td>

<td>Location</td>

</tr>

<td>{{data.UserName}}</td>

<td>{{data.FirstName}}</td>

<td>{{data.LastName}}</td>

<td>{{data.Location}}</td>

</tr>

</table>

</div>

var aps = angular.module('repeatTable', []).controller('practiece1', function ($scope, $http) {

alert("");

$http.get('/AngularJS/TableData').success(function (data) {

alert(data);

$scope.tabledata = data;

});

</script>

In Controller:

public ActionResult TableData()

{

var text = context.UserInfoes.ToList();

return Json(text,JsonRequestBehavior.AllowGet);

}

Casacading Dropdowns using Angular JS

Cascading Dropdown using Angular JS shown below

In view

Layout = null;

}

<!DOCTYPE html>

<html>

<head>

<title>AngularJS1</title>

</head>

<option value="">-- Select Country --</option>

</select>

<option value="">-- Select State --</option>

</select>

</div>

</html>

var app = angular.module('myApp', []);

app.controller('MyCtrl', function ($scope, $http) {

$http({

method: 'Get',

url: '/AngularJS/GetCountries'

}).success(function (data) {

$scope.countries = data;

}).error(function (data, status, headers, config) {

$scope.message = 'Unexpected Error';

});

$scope.GetStates = function () {

var countryId = $scope.country;

alert(countryId);

if (countryId) {

$http({

method: 'POST',

url: '/AngularJS/GetStates/',

data: JSON.stringify({ countryId: countryId })

}).success(function (data) {

$scope.states = data;

}).error(function (data, status, headers, config) {

$scope.message = 'Unexpected Error';

});

}

else {

$scope.states = null;

}

})

</script>

In Controller

public ActionResult AngularJS1()

{

return View();

}

public JsonResult GetCountries()

{

var ret = context.Countries.Select(x => new { x.CountryId, x.CountryName }).ToList();

return Json(ret, JsonRequestBehavior.AllowGet);

}

[HttpPost]

public JsonResult GetStates(int countryId)

{

var ret = context.States.Where(x => x.CountryId == countryId).Select(x => new { x.StateId, x.StateName }).ToList();

return Json(ret);

}

Wednesday, 9 December 2015

CRUD Operations in Classic ASP

Crud Operations In Classic ASP
First Open Visual Studio
Goto File-New Web Site- Templates -Visual Basics - Asp.net Empty Website

Create website and add new item ->select html template- give name as List.asp

<!DOCTYPE html>

<head>

<h1>Sample Classic Asp </h1>

dim db_connection

db_connection = "Provider=SQLOLEDB.1;Server=WEBDEL33\SQL2008R2;Database=Kavitha;Uid=sa; Pwd=Pwd4sql2008;"

set conn = server.createobject("adodb.connection")

set Cmd = Server.CreateObject("ADODB.Command")

'-------------------------------------------------------

conn.open (db_connection)

'-------------------------------------------------------

set rs = Server.CreateObject("ADODB.RecordSet")

sql="select * from Address"

set rs = Conn.execute(sql)

'if (rs.bof and rs.eof) then

'response.Write "<span class=""error"">No Record Found</span>"

'response.End

'end if

</head>

<body>

<tr>

<td>Delete</td>

<td>Mobile</td>

<td>Email</td>

</tr>

while not rs.eof

<tr>

<td><a href="add.asp?Name=<%=rs("Name")%>" class="news_frm"><%=rs("Name")%></a></td>

<td><a href="Delete.asp?Id=<%=rs("Id")%>" class="news">Delete</a>

</td>

</tr>

rs.movenext

wend

</table>

</div>

<a href="add.asp">NewMember</a>

New Member/Update in add.asp:

<!DOCTYPE html>

<head>

function Submit_page() {

if ($("#Name").val() == "") {

alert("Enter Name.");

return false;

}

if ($("#Text1").val() == "") {

alert("Enter Mobile.");

return false;

}

if ($("#Text2").val() == "") {

alert("Enter Email.");

return false;

}

if ($("#Text6").val() == "") {

alert("Enter Password.");

return false;

}

else

return true;

}

</script>

dim db_connection

db_connection = "Provider=SQLOLEDB.1;Server=WEBDEL33\SQL2008R2;Database=Kavitha;Uid=sa; Pwd=Pwd4sql2008;"

set conn = server.createobject("adodb.connection")

set Cmd = Server.CreateObject("ADODB.Command")

'-------------------------------------------------------

conn.open (db_connection)

'-------------------------------------------------------

set rs = Server.CreateObject("ADODB.RecordSet")

Name = request.QueryString("Name")

if Name <> "" then

sSQL = "SELECT top 1 * FROM Address where Name = '" & Name & "'"

'response.Write sSQL

set rs = Conn.execute(sSQL)

if not(rs.bof and rs.eof) then

Mobile = rs("Mobile")

Email = rs("Email")

Country =rs("Country")

State = rs("State")

City = rs("City")

Password = rs("Password")

Address = rs("Address")

Id=rs("Id")

end if

</head>

<body>

<table>

<tr>

<td>

Name

</td>

<td>

<% if Id <> "" then %><input type="hidden" name="Id" id="Id" value="<%=Id%>" /><% end if %>

</tr>

<tr>

<td>

Mobile

</td>

</tr>

<tr>

<td>

</td>

</tr>

<tr>

<td>

Country

</td>

</tr>

<tr>

<td>

State

</td>

</tr>

<tr>

<td>

City

</td>

</tr>

<tr>

<td>

Password

</td>

</tr>

<tr>

<td>

Address

</td>

</tr>

<tr>

<td>

</td>

<td>

</td>

</tr>

</table>

</form>

</body>

</html>

Updating /Inserting in posting.asp:

<!DOCTYPE html>

<head>

</head>

<body>

dim db_connection

db_connection = "Provider=SQLOLEDB.1;Server=WEBDEL33\SQL2008R2;Database=Kavitha;Uid=sa; Pwd=Pwd4sql2008;"

set conn = server.createobject("adodb.connection")

set Cmd = Server.CreateObject("ADODB.Command")

'-------------------------------------------------------

conn.open (db_connection)

'-------------------------------------------------------

set rs = Server.CreateObject("ADODB.RecordSet")

Name = request.form("Name")

Mobile = request.form("Mobile")

Email= request.form("Email")

Address = request.form("Address")

Country = request.form("Country")

State= request.form("State")

City = request.form("City")

Password = request.form("Password")

Id=request.Form("Id")

if(Id>0) then

sSQL="Update Address SET Mobile='" &Mobile& "',Email='" &Email& "', Country='" & Country & "',State='" & State & "',City='" & City & "',Password='" & Password & "',Address='" & Address& "'where Id='" & Id & "'"

else

sSQL= "INSERT INTO Address (Name,Mobile,Email,Address,Country,State,City,Password) values('" &(Name)& "','"&(Mobile) & "','"&(Email)&"','"&(Address)&"','"&(Country)&"','"&(State)&"','"&(City)&"','"&(Password)&"')"

end if

conn.execute(sSQL)

response.Redirect("database.asp")

</body>

</html>

Delete Member in Delete.asp:

dim db_connection

db_connection = "Provider=SQLOLEDB.1;Server=WEBDEL33\SQL2008R2;Database=Kavitha;Uid=sa; Pwd=Pwd4sql2008;"

set conn = server.createobject("adodb.connection")

set Cmd = Server.CreateObject("ADODB.Command")

'-------------------------------------------------------

conn.open (db_connection)

'-------------------------------------------------------

set rs = Server.CreateObject("ADODB.RecordSet")

Id=request.QueryString("Id")

if(Id>0) then

sSQL="Exec sp_deleteaddress "&request.QueryString("Id")&""

conn.execute(sSQL)

response.Redirect("database.asp")

end if

MVC Code snippets

Translate

Thursday, 21 April 2016

Add proxy class for wcf service through Visual studio Command promt

Sunday, 14 February 2016

Encrypt and Decrypt Connectionstring and AppSettings Sections in web.config

Sunday, 10 January 2016

Access Resource values for db values

Monday, 4 January 2016

Jquery Text Easy Counter

Jquery text easy Counter shown below

OutPut:

Thursday, 17 December 2015

How to Bind Table Using Angular JS

Casacading Dropdowns using Angular JS

Wednesday, 9 December 2015

CRUD Operations in Classic ASP

About Me