public JsonResult Update_Account(Admin_Account obj) { List <Admin_Account> Acc = Admin_Account.Query("Where Id=@0", obj.Id).ToList(); try { if (Acc.Any()) { if (!string.IsNullOrEmpty(obj.PasswordHash)) { Acc.FirstOrDefault().PasswordHash = WebsiteExtension.EncryptPassword(obj.PasswordHash); } Acc.FirstOrDefault().UserName = obj.UserName; Acc.FirstOrDefault().FullName = obj.FullName; Acc.FirstOrDefault().TypeId = obj.TypeId; Acc.FirstOrDefault().Mobile = obj.Mobile; Acc.FirstOrDefault().Email = obj.Email; Acc.FirstOrDefault().Address = obj.Address; Acc.SingleOrDefault().UpdatedDate = DateTime.Now; Acc.FirstOrDefault().Save(); } } catch (Exception ex) { return(Json(0)); } return(Json(new { Result = 1, Records = Acc })); }
public JsonResult Change_Account_Active(Admin_Account obj) { List <Admin_Account> Acc = Admin_Account.Query("Where Id=@0", obj.Id).ToList(); try { if (Acc.Count > 0) { Acc.FirstOrDefault().Active = obj.Active; Acc.FirstOrDefault().Save(); } } catch { return(Json(0)); } return(Json(new { Result = 1, Records = Acc })); }
public ActionResult Login(Admin_Account md) { var error = String.Empty; if (md.UserName != null || md.UserName != "") { var convertPass = WebsiteExtension.EncryptPassword(md.PasswordHash); try { List <Admin_Account> CheckUser = Admin_Account.Query("Where UserName=@0 AND PasswordHash=@1 AND BranchId=@2 AND Status=1", md.UserName, convertPass, 1).ToList(); if (CheckUser.Count > 0 && CheckUser.Count < 2) { Session["UserID"] = CheckUser.FirstOrDefault().Id.ToString(); Session["TypeId"] = CheckUser.FirstOrDefault().TypeId.ToString(); Session["UserName"] = CheckUser.FirstOrDefault().UserName.ToString(); Session["BranchId"] = CheckUser.FirstOrDefault().BranchId.ToString(); Session.Timeout = 120; return(Redirect("/")); } else { return(Redirect("/Login/Login")); } } catch (Exception ex) { return(Redirect("/Login/Login")); } } else { return(Redirect("/Login/Login")); } }
public JsonResult Get_Account_List(DataModel obj) { string order = string.Empty; int totalRecords = int.MinValue; if (obj._od != null) { order = " Order By " + obj._od.FirstOrDefault().Key + " " + obj._od.FirstOrDefault().Value; } List <Admin_Account> AccList_source = new List <Admin_Account>(); List <Admin_Account_Config> AccList = new List <Admin_Account_Config>(); string msg = string.Empty; try { if (obj._c != null) { string querystring = ""; foreach (var k in obj._c) { switch (k.Key) { case "DisplayName": querystring += k.Value.ToString(); break; default: querystring += k.Key + "=" + k.Value.ToString(); break; } if (!k.Equals(obj._c.Last())) { querystring += " AND "; } } AccList_source = Admin_Account.Query("Where Status=1 AND " + querystring + order + "").ToList(); } else { AccList_source = Admin_Account.Query("Where Status=1 " + order + "").ToList(); } // Map du lieu sang Model khac var config = new MapperConfiguration(cfg => { cfg.CreateMap <Admin_Account, Admin_Account_Config>(); }); IMapper mapper = config.CreateMapper(); AccList = mapper.Map <List <Admin_Account>, List <Admin_Account_Config> >(AccList_source); int pSize = obj._lm; totalRecords = AccList.Count(); if (totalRecords > 1) { AccList = AccList.Skip(obj._os).Take(pSize).ToList(); } } catch (Exception ex) { msg = ex.ToString(); } return(Json(new { Result = 1, TotalRecordCount = totalRecords, Records = AccList, Message = msg }, JsonRequestBehavior.AllowGet)); }