function UserLogin() {
var username = $("#txtUsername").val();
var passcode = $("#txtPassword").val();
alert(username);
$.ajax({
url: '@Url.Action("Login", "UserAccount")',
type: "POST",
data: { 'username': username, 'passcode': passcode },
datatype: "json",
traditional: true,
contentType: "application/json; charset=utf-8",
success: function (data) {
alert(data.username);
}
});
[HttpPost] public ActionResult Login(string username, string passcode) { if (IsValidUser(username, passcode)) { return RedirectToAction("UserInfo", "UserAccount"); } else { ModelState.AddModelError("", "Your Username or password is invalid"); } return View(); }
private bool IsValidUser(string username, string passcode)
{
string Query = "Select Count(ID) from Users where Username =" + username + " and PassCode = "+ passcode +"";
int count = Convert.ToInt32(NpgSQLHelper.ExecuteScalar(Utility._connectionstring, System.Data.CommandType.Text, Query));
if (count > 0)
{
return true;
}
else
{
return false;
}
}