public dtoUserAccount Get(dtoUserAccount t) { string hash = ""; using (MD5 md5Hash = MD5.Create()) { hash = GetMd5Hash(md5Hash, t.passWord); } var sqlString = String.Format("select top 1 * from tbl_users where username = '******' and password = '******'", t.userName, hash); t = DBContext.Database.SqlQuery<dtoUserAccount>(sqlString).FirstOrDefault(); if (t !=null) { sqlString = string.Format("update tbl_users set dateLastLogin = '******' where userId = {1}",DateTime.Now,t.userId ); var q = DBContext.Database.ExecuteSqlCommand(sqlString); } return t; }
public JsonResult GetAllUsers() { var currentUser = (dtoUserAccount) Session["CurrentUser"]; var page = int.Parse(Request["page"]); var recordPerPage = int.Parse(Request["recordPerPage"]); var isExport = false; var filter = new dtoUserAccount { userName = Request["searchUserName"], firstName = Request["searchFirstName"], lastName = Request["searchLastName"], emailAddress = Request["searchEmailAddress"], branchId = (Request["searchBranchId"] == "null" || Request["searchBranchId"] == "") ? 0 : Convert.ToInt32(Request["searchBranchId"]) }; var list = serviceUserAccount.GetAllUsers2(page, recordPerPage, filter, isExport); //totalRecords = serviceUserAccount.GetRecordCount(filter); //int count = list.Count(); return Json(list); }
public dtoResult Delete(dtoUserAccount t) { throw new NotImplementedException(); }
public dtoResult Update(dtoUserAccount t) { string hash = ""; var result = new dtoResult(); try { using (MD5 md5Hash = MD5.Create()) { hash = GetMd5Hash(md5Hash, t.passWord); } var user = DBContext.tbl_users.FirstOrDefault(d => d.userId == t.userId); if (user != null) { user.userName = t.userName; user.firstName = t.firstName; user.middleName = t.userName; user.lastName = t.lastName; user.passWord = hash; user.branchId = t.branchId; } DBContext.SaveChanges(); //t.userName = obj.userName; result.isSuccessful = true; result.returnObj = t; } catch (Exception ex) { result.isSuccessful = false; result.errorMsg = ex.ToString(); } return result; }
public dtoResult Insert(dtoUserAccount t) { string hash = ""; using (MD5 md5Hash = MD5.Create()) { hash= GetMd5Hash(md5Hash, t.passWord); } var result = new dtoResult(); try { var obj = new tbl_users { userName = t.userName, passWord = hash, firstName = t.firstName, lastName = t.lastName, middleName = t.middleName, branchId = t.branchId, emailAddress = t.emailAddress, status = 1, dateCreated = DateTime.Now }; DBContext.tbl_users.Add(obj); DBContext.SaveChanges(); t.userName = obj.userName; result.isSuccessful = true; result.returnObj = t; } catch (Exception ex) { result.isSuccessful = false; result.errorMsg = ex.ToString(); } return result; }
public ActionResult GetAllUsers_old(jQueryDataTableParamModel param) { var filter = new dtoUserAccount { userId = Request["userId"] == "" ? 0 : Convert.ToInt32( Request["userId"]), firstName = Request["firstname"], lastName = Request["lastname"], emailAddress = Request["emailAddress"], userName = Request["userName"], branchId = Request["branchId"] == "" ? 0 : Convert.ToInt32(Request["branchId"]) }; var list = serviceUserAccount.GetAllUsers(param.sSearch ?? "", filter); int count = list.Count(); return Json(new { param.sEcho, iTotalRecords = count, iTotalDisplayRecords = 10, aaData = list } , JsonRequestBehavior.AllowGet); }
public JsonResult AddEditUser(dtoUserAccount user) { var result = user.userId == 0 ? serviceUserAccount.Register(user) : serviceUserAccount.Update(user); return Json(result); }
public JsonResult LoginUser(dtoUserAccount user) { var result = serviceUserAccount.ValidateCredentials(user); var resultObject = (dtoUserAccount) result.returnObj; if (result.isSuccessful) { FormsAuthentication.SetAuthCookie(resultObject.userName, false); Session["CurrentUser"] = resultObject; } return Json(result); }