public void DeleteUser(int userID) { tb_Users ExisitingUserDetail = db.tb_Users.Where(x => x.UserID == userID).FirstOrDefault(); if (ExisitingUserDetail != null) { db.tb_Users.Remove(ExisitingUserDetail); } db.SaveChanges(); }
public void UpdateUserDetail(tb_Users _Users) { tb_Users ExisitingUserDetail = db.tb_Users.Where(x => x.UserID == _Users.UserID).FirstOrDefault(); if (ExisitingUserDetail != null) { ExisitingUserDetail.FullName = _Users.FullName; ExisitingUserDetail.Mobile = _Users.Mobile; db.SaveChanges(); } }
public void UpdateUserPassword(tb_Users _Users) { tb_Users ExisitingUserDetail = db.tb_Users.Where(x => x.UserID == _Users.UserID).FirstOrDefault(); if (ExisitingUserDetail != null) { ExisitingUserDetail.HashPassword = _Users.HashPassword; db.SaveChanges(); } }
public void UpdateUserPassword(NewUsersViewModel _Users) { tb_Users ExistingUser = _userRepository.GetUserByID(_Users.UserID).FirstOrDefault(); if (ExistingUser != null) { tb_Users UserToUpdate = new tb_Users { HashPassword = _Users.HashPassword, }; _userRepository.UpdateUserDetail(UserToUpdate); } }
public bool Update(tb_Users entity) { try { db.Entry(entity).State = EntityState.Modified; db.SaveChanges(); return(true); } catch { return(false); } }
public void InsertUser(NewUsersViewModel _Users) { Encryption encryption = new Encryption(); tb_Users newUser = new tb_Users { Email = _Users.Email, FullName = _Users.FullName, HashPassword = encryption.EnCrypt(_Users.HashPassword), }; _userRepository.InsertUser(newUser); }
public NewUsersViewModel GetUserByID(int UserID) { tb_Users ExistingUser = _userRepository.GetUserByID(UserID).FirstOrDefault(); NewUsersViewModel GottenUser = null; if (ExistingUser != null) { GottenUser = new NewUsersViewModel { Email = ExistingUser.Email, }; } return(GottenUser); }
public string DisableUser(int userID) { var Response = "Failed"; tb_Users ExisitingUserDetail = db.tb_Users.Where(x => x.UserID == userID).FirstOrDefault(); if (ExisitingUserDetail != null) { ExisitingUserDetail.IsActive = false; db.SaveChanges(); Response = "Success"; return(Response); } return(Response); }
public string DisableUser(int userID) { string status = "failed"; tb_Users ExistingUser = _userRepository.GetUserByID(userID).FirstOrDefault(); if (ExistingUser != null) { tb_Users UserToDisable = new tb_Users { UserID = userID, IsActive = false }; _userRepository.UpdateUserDetail(UserToDisable); status = "success"; } return(status); }
//-----------------------------Delete User---------------------------- public JsonResult DeleteUser(int UserId) { LaunSysDBEntities db = new LaunSysDBEntities(); bool result = false; tb_Users User = db.tb_Users.SingleOrDefault(x => x.StatusId == 1 && x.UserId == UserId); /// tb_Users User = db.tb_Users.SingleOrDefault(x => x.tb_Status.Status == true && x.UserId == UserId); if (User != null) { //set the customer id to true, there fore hide it from the table\ //User.tb_Status.Status = false; User.StatusId = 2; db.SaveChanges(); result = true; } return(Json(result, JsonRequestBehavior.AllowGet)); }
public ActionResult Create(FormCollection collection) { try { var username = collection["UserName"].ToString(); var password = collection["Passwod"].ToString(); tb_Users user = new tb_Users(); user.UserName = username; user.Passwod = password; databaseEntitties.tb_Users.Add(user); databaseEntitties.SaveChanges(); return(RedirectToAction("Index")); } catch { return(View()); } }
public ActionResult Edit(UsersModel entity) { if (ModelState.IsValid) { var Input = new tb_Users(); Input.Id = entity.Id; Input.RoleId = entity.RoleId; Input.UserName = entity.UserName; Input.UserEmail = entity.UserEmail; Input.UserPassword = mhPass.MahoaMD5(entity.UserPassword); Input.Status = entity.Status; Input.Date = entity.Date; Input.Modified = DateTime.Now; Dao.Update(Input); } ViewBag.RoleId = new SelectList(RDao.ListAll(), "Id", "RoleName", entity.RoleId); return(View(entity)); }
public ActionResult Add(tb_Users entity) { if (ModelState.IsValid) { var Input = new tb_Users(); Input.RoleId = entity.RoleId; Input.UserName = entity.UserName; Input.UserEmail = entity.UserEmail; Input.UserPassword = mhPass.MahoaMD5(entity.UserPassword); Input.Status = true; Input.Date = DateTime.Now; Input.Modified = DateTime.Now; Dao.Insert(Input); return(RedirectToAction("Index")); } ViewBag.RoleId = new SelectList(RDao.ListAll(), "Id", "RoleName", entity.RoleId); return(View(entity)); }
public object Login(string email, string password) { Encryption Enc = new Encryption(); var CheckedEncString = Enc.EnCrypt(password); tb_Users ExisitingUserDetail = db.tb_Users.Where(x => x.Email == email || x.HashPassword == CheckedEncString).SingleOrDefault(); var Resp = new LoginResponse { UserId = 3, LoginResult = "Success" }; return(Resp); }
//-----------------------------Add/Edit---------------------------- public ActionResult AddEdit(int UserId) { LaunSysDBEntities db = new LaunSysDBEntities(); List <tb_Role> RoleList = db.tb_Role.ToList(); ViewBag.VRoleLists = new SelectList(RoleList, "RoleId", "Rolename"); List <tb_Division> DivisionList = db.tb_Division.ToList(); ViewBag.VDivisionLists = new SelectList(DivisionList, "DivisionId", "Divisionname"); List <tb_Branch> BranchList = db.tb_Branch.ToList(); ViewBag.VBranchLists = new SelectList(BranchList, "BranchId", "Branchname"); List <tb_Department> DeptList = db.tb_Department.ToList(); ViewBag.VDeptLists = new SelectList(DeptList, "DeptId", "Deptname"); List <tb_Status> StatusList = db.tb_Status.ToList(); ViewBag.VStatusLists = new SelectList(StatusList, "StatusId", "Status"); UsersViewModel Model = new UsersViewModel(); if (UserId > 0) { tb_Users Users = db.tb_Users.SingleOrDefault(x => x.UserId == UserId && x.tb_Status.Status == true); Model.UserId = Users.UserId; Model.Email = Users.Email; Model.Password = Users.Password; Model.RoleId = Users.RoleId; Model.DivisionId = Users.DivisionId; Model.BranchId = Users.BranchId; Model.DeptId = Users.DeptId; Model.StatusId = Users.StatusId; } return(PartialView("AddEditViewPartialView", Model)); }
public ActionResult Index(AdminModel entity) { if (ModelState.IsValid) { var RoleName = entity.RoleName; long RoleId = 0; var Role = Dao.GetByName(RoleName); if (Role != null) { RoleId = Role.Id; var User = new tb_Users(); User.Date = DateTime.Now; User.Modified = DateTime.Now; User.RoleId = RoleId; User.Status = true; User.UserEmail = entity.UserEmail; User.UserName = entity.UserName; User.UserPassword = mhPass.MahoaMD5(entity.UserPassword); UDao.Insert(User); } else { Role = new tb_Roles(); Role.RoleName = RoleName; Role.RoleDescription = "Người quản trị cao nhất!"; Role.RoleAction = 7; Dao.Insert(Role); RoleId = Role.Id; var User = new tb_Users(); User.Date = DateTime.Now; User.Modified = DateTime.Now; User.RoleId = RoleId; User.Status = true; User.UserEmail = entity.UserEmail; User.UserName = entity.UserName; User.UserPassword = mhPass.MahoaMD5(entity.UserPassword); UDao.Insert(User); } return(RedirectToAction("Index")); } return(View(entity)); }
public void InsertUser(tb_Users _Users) { db.tb_Users.Add(_Users); db.SaveChanges(); }
public ActionResult Index(UsersViewModel Model) { try { //if (ModelState.IsValid == true) //{ LaunSysDBEntities db = new LaunSysDBEntities(); //------------------------To populate the drop down lists--------------------------- List <tb_Role> RoleList = db.tb_Role.ToList(); ViewBag.VRoleLists = new SelectList(RoleList, "RoleId", "Rolename"); List <tb_Division> DivisionList = db.tb_Division.ToList(); ViewBag.VDivisionLists = new SelectList(DivisionList, "DivisionId", "Divisionname"); List <tb_Branch> BranchList = db.tb_Branch.ToList(); ViewBag.VBranchLists = new SelectList(BranchList, "BranchId", "Branchname"); List <tb_Department> DeptList = db.tb_Department.ToList(); ViewBag.VDeptLists = new SelectList(DeptList, "DeptId", "Deptname"); List <tb_Status> StatusList = db.tb_Status.ToList(); ViewBag.VStatusLists = new SelectList(StatusList, "StatusId", "Status"); //---------------------------------------------------------------------------------- if (Model.UserId > 0) { //UPDATE EXISTING RECORD tb_Users Users = db.tb_Users.SingleOrDefault(x => x.UserId == Model.UserId && x.tb_Status.Status == true); Users.UserId = Model.UserId; Users.Email = Model.Email; Users.Password = Model.Password; Users.RoleId = Model.RoleId; Users.DivisionId = Model.DivisionId; Users.BranchId = Model.BranchId; Users.DeptId = Model.DeptId; Users.StatusId = Model.StatusId; db.SaveChanges(); } else { //INSERT NEW RECORD tb_Users Users = new tb_Users(); Users.UserId = Model.UserId; Users.Email = Model.Email; var pass = System.Text.Encoding.UTF8.GetBytes(Model.Password); Users.Password = Convert.ToBase64String(pass); // Users.Password = Model.Password; Users.RoleId = Model.RoleId; Users.DivisionId = Model.DivisionId; Users.BranchId = Model.BranchId; Users.DeptId = Model.DeptId; Users.StatusId = Model.StatusId; db.tb_Users.Add(Users); db.SaveChanges(); } return(View(Model)); //} } catch (Exception ex) { throw ex; } }
public long Insert(tb_Users entity) { db.tb_Users.Add(entity); db.SaveChanges(); return(entity.Id); }
public ActionResult LoginUser(UsersViewModel Model) { if (ModelState.IsValid) { string result = "fail"; if (Model.Email == "*****@*****.**" && Model.Password == "admin") { Session["Email"] = "*****@*****.**"; Session["Password"] = "******"; Session["UserDepartment"] = "Default"; Session["UserRole"] = "Admin"; result = "Admin"; return(RedirectToAction("Index", "Clients")); } else { LaunSysDBEntities db = new LaunSysDBEntities(); var pass = System.Text.Encoding.UTF8.GetBytes(Model.Password); var encpass = Convert.ToBase64String(pass); tb_Users User = db.tb_Users.SingleOrDefault(x => x.Email == Model.Email && x.Password == encpass); //tb_Users User = db.tb_Users.SingleOrDefault(x => x.Email == Model.Email && x.Password == Model.Password); if (User != null) { Session["Email"] = User.Email; Session["Password"] = User.Password; if (User.tb_Department.Deptname != null) { Session["UserDepartment"] = User.tb_Department.Deptname; } Session["UserRole"] = User.tb_Role.Rolename; if (User.RoleId == 1) { result = "Admin"; return(RedirectToAction("Index", "Clients")); } else if (User.RoleId == 2) { result = "Manager"; return(RedirectToAction("Index", "Home")); } } else { //FlashMessage.Info("Your informational message"); //FlashMessage.Confirmation("Your confirmation message"); //FlashMessage.Warning("Your warning message"); //FlashMessage.Danger("Your danger alert"); //FlashMessage.Danger("Message title", "Your danger alert"); FlashMessage.Confirmation("Invalid Login Details"); return(RedirectToAction("Login", "Access")); // return RedirectToAction("Index", "Users"); } if (result == "fail") { FlashMessage.Confirmation("Invalid Login failed"); return(RedirectToAction("Login", "Access")); ///return RedirectToAction("Index", "Users"); } //if (result == "Admin") //{ // return RedirectToAction("Index", "Clients"); //} //if (result == "Manager") //{ //} //return Json(result, JsonRequestBehavior.AllowGet); } } return(View()); }