public bool UpdateUser(tbl_Users row) { try { using (var db = new SoneriCISEntities()) { tbl_Users u = new DAL.tbl_Users(); u = db.tbl_Users.Where(a => a.ID == row.ID).FirstOrDefault(); u.IsActive = row.IsActive; u.RoleTitle = row.RoleTitle; u.UserLogin = row.UserLogin; u.UserName = row.UserName; u.ExpiryDate = row.ExpiryDate; u.EmpCode = row.EmpCode; if (row.UserPassword == "") { u.UserPassword = u.UserPassword; } else { u.UserPassword = row.UserPassword; } u.IsActive = row.IsActive; u.AuthorizationStatus = row.AuthorizationStatus; u.AuthorizationComments = row.AuthorizationComments; db.SaveChanges(); } return(true); } catch (Exception ex) { return(false); } }
public bool ChangePassword(int UserID, string UserPassword) { try { using (var db = new SoneriCISEntities()) { tbl_Users u = new DAL.tbl_Users(); u = db.tbl_Users.Where(a => a.ID == UserID).FirstOrDefault(); u.IsActive = u.IsActive; u.RoleTitle = u.RoleTitle; u.UserLogin = u.UserLogin; u.UserName = u.UserName; u.UserPassword = UserPassword; u.IsActive = u.IsActive; db.SaveChanges(); } return(true); } catch (Exception ex) { return(false); } }
public bool CheckPassword(int UserID, string UserPassword) { try { using (var db = new SoneriCISEntities()) { tbl_Users u = new DAL.tbl_Users(); u = db.tbl_Users.Where(a => a.ID == UserID && a.UserPassword == UserPassword).FirstOrDefault(); if (u == null) { return(false); } else { return(true); } } } catch (Exception ex) { return(false); } }