public static int UserValidation(String UserName, String Password) {
string PasswordCrypto = Util.GetEncryptedPassword(Password);
int result = 0;
using (var ctx = new ExponentPortalEntities()) {
var query = from data in ctx.MSTR_User
where ((data.UserName.Equals(UserName)
&& (data.Password.Equals(PasswordCrypto)))
|| (data.GeneratedPassword.Equals(PasswordCrypto)))
select data;
var _objuserdetail = query.ToList();
if (_objuserdetail.Count > 0)
{
if (_objuserdetail[0].GeneratedPassword == PasswordCrypto)
{
string updatesql = "update MSTR_User set Password='******',GeneratedPassword='' where UserId=" + _objuserdetail[0].UserId;
Util.doSQL(updatesql);
}
else { }
}
result = _objuserdetail.Count;
}
return result;
}
public static int UserIsActive(String UserName, String Password)
{
try
{
string PasswordCrypto = Util.GetEncryptedPassword(Password);
int result = 0;
using (var ctx = new ExponentPortalEntities())
{
var _objuserdetail = (from data in ctx.MSTR_User
where (data.UserName == UserName
&& data.Password == PasswordCrypto)
select data.IsActive).ToList();
if (_objuserdetail.Count > 0)
{
string isactive = _objuserdetail[0].ToString();
if (isactive == "True")
{
result = 1;
}
else
{
result = 0;
}
}
else
{
result = 0;
}
}
return result;
}
catch (Exception ex)
{
Util.ErrorHandler(ex);
System.Web.HttpContext.Current.Response.Write("<script>alert('Please Check Database Connection');</script>");
return -1;
}
}
