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; } }