//static Dictionary<int, String> DictionaryLogonUser = new Dictionary<int, String>(); public int GetMaxUserID() { using (productmanageEntities productmanageEntities = new productmanageEntities()) { int maxID = productmanageEntities.user.Max(w => w.user_id); return(maxID); } }
public bool ModifyPassword(int aUserID, String aNewPassword) { using (productmanageEntities productmanageEntities = new productmanageEntities()) { var lUserList = from r in productmanageEntities.user where r.user_id == aUserID select r; if (lUserList.Count() > 0) { user lUser = lUserList.First(); lUser.user_password = aNewPassword; productmanageEntities.SaveChanges(); return(true); } else { return(false); } } }
public override bool ValidateUser(string username, string password) { try { using (productmanageEntities entities = new productmanageEntities()) { var result = from r in entities.user where (r.user_name == username && r.user_password == password) select r; if (result.Count() > 0) { return(true); } else { return(false); } } } catch (System.Exception ex) { return(false); } }
protected override User GetAuthenticatedUser(IPrincipal principal) { using (productmanageEntities productmanageEntities = new productmanageEntities()) { User user = new User(); try { var result = from r in productmanageEntities.user where r.user_name == principal.Identity.Name select r; if (result.Count() > 0) { ProductManager.Web.Model.user lUser = result.First(); user.Name = lUser.user_name; user.UserName = lUser.user_cname; user.RightDictionary = new Dictionary <int, bool>(); user.IsFreeze = lUser.user_is_freeze.GetValueOrDefault(false); user.DepartmentID = lUser.user_department_id.GetValueOrDefault(0); user.UserID = lUser.user_id; user.Password = lUser.user_password; user.IsManager = lUser.isManager.GetValueOrDefault(false); if (lUser.user_department_id.HasValue) { user.Department = lUser.department.department_name; } if (lUser.user_name == "admin") { { var actionresult = from rs in productmanageEntities.action select rs; foreach (ProductManager.Web.Model.action action in actionresult) { user.RightDictionary.Add(action.action_id, true); } } } else { //Role action { var roleactionresult = from rs in productmanageEntities.role_action where rs.role_id == lUser.user_department_id select rs; //var roleactionresult = from rs in productmanageEntities.role_action where rs.role_id == userrole.role_id select rs; foreach (ProductManager.Web.Model.role_action roleaction in roleactionresult) { bool lIsPermit; if (user.RightDictionary.TryGetValue(roleaction.action_id.Value, out lIsPermit)) { user.RightDictionary.Remove(roleaction.action_id.Value); } user.RightDictionary.Add(roleaction.action_id.Value, roleaction.isPermit.Value); } } { var useractionresult = from r in productmanageEntities.user_action where r.user_id == lUser.user_id select r; foreach (ProductManager.Web.Model.user_action useraction in useractionresult) { bool lIsPermit; if (user.RightDictionary.TryGetValue(useraction.action_id.Value, out lIsPermit)) { user.RightDictionary.Remove(useraction.action_id.Value); } user.RightDictionary.Add(useraction.action_id.Value, useraction.isPermit.Value); } } } } } catch (System.Exception ex) { } return(user); } }