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