public async Task <IActionResult> Edit([Bind("UserCode,UserName,EmpCode,DeptId,Position,CompanyCode,aspnetuser_Id,UserImagePath,Id,Is_Active,Created_Date,Created_By,Updated_Date,Updated_By")] M_User m_User) { try { if (ModelState.IsValid) { m_User.Updated_By = await base.CurrentUserId(); ResultObject resultObj; try { using (var userBll = new UserBLL()) { resultObj = await userBll.UpdateUser(m_User); _cache.Remove("CACHE_ADMINISTRATOR_USER"); } return(Json(new { success = true, data = (M_User)resultObj.ObjectValue, message = "User Update." })); } catch (Exception ex) { return(Json(new { success = false, data = m_User, message = ex.Message })); } } var err = ModelState.Values.SelectMany(x => x.Errors).Select(x => x.ErrorMessage).ToList(); return(Json(new { success = false, errors = err, data = m_User, message = "Update Failed" })); } catch (Exception ex) { return(BadRequest(new { success = false, message = ex.Message })); } }
public List <M_User> GetList(M_User objUser) { var ObjList = new List <M_User>(); try { using (_objUnitOfWork = new UnitOfWork()) { var queryObjList = _objUnitOfWork._M_User_Repository.Query(); if (!string.IsNullOrWhiteSpace(objUser.Name)) { queryObjList = queryObjList.Where(x => x.Name.Contains(objUser.Name)); } if (!string.IsNullOrWhiteSpace(objUser.Phone)) { queryObjList = queryObjList.Where(x => x.Phone.Contains(objUser.Phone)); } ObjList = queryObjList.OrderByDescending(x => x.CreatedDate).ToList(); } } catch (Exception ex) { throw ex; } return(ObjList); }
public async Task <ResultObject> DeleteUser(M_User user) { var resultObj = new ResultObject { RowAffected = -1, ObjectValue = user }; using (var context = new MasterDbContext(contextOptions)) { using (var transaction = context.Database.BeginTransaction()) { try { MySqlParameter[] sqlParams = new MySqlParameter[] { new MySqlParameter("strId", user.Id), new MySqlParameter("strDelete_By", user.Updated_By) }; resultObj.RowAffected = await context.Database.ExecuteSqlCommandAsync("call sp_user_delete( ?, ?)", parameters : sqlParams); transaction.Commit(); return(resultObj); } catch (Exception ex) { transaction.Rollback(); throw ex; } } } }
public ActionResult ChangePassword(M_User item) { string userID = Session["userID"].ToString(); var row = db.M_User.Where(x => x.UserID == userID).FirstOrDefault(); if (item.Password != null) { row.Password = item.Password; } try { db.SaveChanges(); } catch (DbEntityValidationException dbEx) { foreach (var validationErrors in dbEx.EntityValidationErrors) { foreach (var validationError in validationErrors.ValidationErrors) { Trace.TraceInformation("Property: {0} Error: {1}", validationError.PropertyName, validationError.ErrorMessage); } } } System.Threading.Thread.Sleep(3000); return(RedirectToAction("Index1", "Home")); }
public async Task <ActionResult> Login(M_User _ObjUser) { try { if (!string.IsNullOrWhiteSpace(_ObjUser.UserName) && !string.IsNullOrWhiteSpace(_ObjUser.UserPassword)) { var vUserObject = _objLogin.CheckUser(_ObjUser); if (vUserObject != null) { UpdateAuthenticationDetail(vUserObject); return(Json(new { Result = true, Message = "Login Sucess", RedirectTo = Url.Action("Index", "Home") }, JsonRequestBehavior.AllowGet)); } else { return(Json(new { Result = false, Message = "Login Failed, Please enter valid user name and password!" }, JsonRequestBehavior.AllowGet)); } } } catch (Exception ex) { throw ex; } return(Json(new { Result = false, Message = "Login Failed, Please enter valid user name and password!" }, JsonRequestBehavior.AllowGet)); }
public ActionResult Edit(string userid) { ViewBag.AState = "EDIT"; M_User User = SQLDBHelperClient.CreateUser().Query(userid); return(View("Edit", User)); }
public ActionResult Create(M_User objUser) { try { bool bAnyError = false; if (ModelState.IsValid) { var vNameExists = _blUser.CheckByNameNEmail(objUser.UserName, objUser.Email); if (vNameExists != null) { if (vNameExists.UserName == objUser.UserName) { ViewBag.ErrorMsg = "User Name alreay exists in our system"; } else if (vNameExists.Email == objUser.Email) { ViewBag.ErrorMsg = "Email alreay exists in our system"; } bAnyError = true; } if (bAnyError == false) { M_User _Obj_M_User = new M_User() { Id = Guid.NewGuid(), Name = objUser.Name, Phone = objUser.Phone, Email = objUser.Email, UserName = objUser.UserName, UserPassword = objUser.UserPassword, RoleId = objUser.RoleId, CreatedBy = _objAuthentication.UserName, CreatedDate = DateTime.Now, }; var vReturnObj = _blUser.Create(_Obj_M_User); } } else { bAnyError = true; } if (bAnyError) { var vRoleList = _blUser.GetRoleList().Select(x => new SelectListItem { Text = x.RoleName, Value = x.Id }); ViewBag.RoleList = vRoleList; return(View(objUser)); } return(RedirectToAction("Index", "User")); } catch (Exception ex) { throw ex; } }
public M_User CheckUser(M_User ObjUser) { try { var vItem = _objUnitOfWork._M_User_Repository.GetFirstOrDefault(x => x.UserName == ObjUser.UserName && x.UserPassword == ObjUser.UserPassword); return(vItem); } catch (Exception ex) { throw ex; } }
/// <summary> /// 插入用户 /// </summary> /// <param name="entity">用户类</param> /// <returns>操作结果</returns> public bool InsertUser(M_User entity) { try { return(this.Insert(entity)); } catch (Exception ex) { LogHelper.Error(ex); return(false); } }
public M_User Add(M_User user, List <int> roles) { user.LoginName = user.LoginName.ToLower(); user.State = 0; user.CreateTime = DateTime.Now; user.Password = SecurityHelper.GetSHA256SignString(user.Password); user = dbContext.M_User.Insert.Add(user); UpdateRole(user.Id, roles); return(user); }
/// <summary> /// 更新用户 /// </summary> /// <param name="entity">用户类</param> /// <returns>操作结果</returns> public bool UpdateUser(M_User entity) { try { return(this.Update(entity)); } catch (Exception ex) { LogHelper.Error(ex); return(false); } }
public ActionResult Edit(M_User m_User) { m_User.UpdatedDate = DateTime.Now; if (ModelState.IsValid) { db.Entry(m_User).State = EntityState.Modified; db.SaveChanges(); return(RedirectToAction("Index")); } return(View(m_User)); }
public ActionResult Create(M_User m_User) { m_User.CreatedDate = DateTime.Now; m_User.UpdatedDate = DateTime.Now; if (ModelState.IsValid) { db.M_User.Add(m_User); db.SaveChanges(); return(RedirectToAction("Index")); } return(View(m_User)); }
public string GetUserRoleName(M_User ObjUser) { try { var vItem = (from u in _objUnitOfWork.M_User_Repository.Get() join r in _objUnitOfWork._M_Roles_Repository.Get() on u.RoleId equals r.Id where u.UserName == ObjUser.UserName select new { RoleName = r.RoleName }).FirstOrDefault(); return(vItem.RoleName); } catch (Exception ex) { throw ex; } }
public UserModel CheckLogin(UserModel umodel) { LibraryEntities3 db = new LibraryEntities3(); M_User um = db.M_User.Where(m => m.UserID == umodel.UserID && m.Password == umodel.Password).SingleOrDefault(); if (um == null) { return(null); } else { umodel.UserID = um.UserID; umodel.UserName = um.UserName; return(umodel); } }
public M_User Delete(M_User ObjUser) { try { using (_objUnitOfWork = new UnitOfWork()) { _objUnitOfWork._M_User_Repository.Delete(ObjUser.Id); _objUnitOfWork.Save(); } } catch (Exception ex) { throw ex; } return(ObjUser); }
// GET: Admin/Edit/5 public ActionResult Edit(int?id) { ViewBag.VMainMenu = db.C_Menu.Where(x => x.MenuSeq == "201").Select(x => x.MenuName).FirstOrDefault(); ViewBag.AccessTypeDropDown = db.M_DropDownParam.Where(x => x.Type == "AccessType"); if (id == null) { return(new HttpStatusCodeResult(HttpStatusCode.BadRequest)); } M_User m_User = db.M_User.Find(id); if (m_User == null) { return(HttpNotFound()); } return(View(m_User)); }
public static bool Update(UserViewModel entity) { bool result = true; try { using (var db = new MarComContext()) { if (entity.Id == 0) { M_User user = new M_User(); user.Username = entity.Username; user.Password = entity.Password; user.M_Role_Id = entity.M_Role_Id; user.M_Employee_Id = entity.M_Employee_Id; user.Is_Delete = entity.Is_Delete; user.Create_By = "Admin"; user.Create_Date = DateTime.Now; db.M_User.Add(user); db.SaveChanges(); } else { M_User user = db.M_User.Where(us => us.Id == entity.Id).FirstOrDefault(); if (user != null) { user.Username = entity.Username; user.Password = entity.Password; user.M_Role_Id = entity.M_Role_Id; user.M_Employee_Id = entity.M_Employee_Id; user.Is_Delete = entity.Is_Delete; user.Update_By = "Admin"; user.Update_Date = DateTime.Now; db.SaveChanges(); } } } } catch (Exception) { result = false; } return(result); }
public M_User GetById(Guid UserId) { var ObjUser = new M_User(); try { using (_objUnitOfWork = new UnitOfWork()) { ObjUser = _objUnitOfWork._M_User_Repository.GetById(UserId); } } catch (Exception ex) { throw ex; } return(ObjUser); }
public ActionResult Edit(M_User muser) { if (ModelState.IsValid) { SQLDBHelperClient.CreateUser().Update(muser); ViewBag.Succ = "1"; ViewBag.Msg = "数据编辑成功!"; //return View("Query"); return(View("Edit")); } else { //ViewData["succ"] = "0"; ViewBag.Succ = "0"; ViewBag.Msg = "数据编辑失败!"; return(View(muser)); } }
public ActionResult Add(M_User muser) { muser.AddOrUpdateUserID = ""; bool iTrue = SQLDBHelperClient.CreateUser().Add(muser); if (iTrue) { ViewBag.Succ = "1"; ViewBag.Msg = "数据添加成功!"; return(View(new M_User())); } else { ViewBag.Succ = "0"; ViewBag.Msg = "数据添加失败!"; return(View(muser)); } }
public ActionResult Delete(M_User objUser) { try { if (!string.IsNullOrWhiteSpace(Convert.ToString(objUser.Id))) { var vObj = _blUser.GetById(objUser.Id); if (vObj != null) { _blUser.Delete(objUser); } } } catch (Exception ex) { throw ex; } return(Json(objUser)); }
private async Task <APIResult> SignIn(M_User user) { var token = Guid.NewGuid().ToString("N"); var key = SignInKey + token; await redisClient.GetDatabase().StringSetAsync(key, user.Id); await redisClient.GetDatabase().KeyExpireAsync(key, TimeSpan.FromSeconds(ExpireTime)); var detail = new { user.Id, user.ImgFace, user.Name, user.LoginName, token }; return(APIResult.成功.SetData("detail", detail)); }
public async Task <ResultObject> UpdateUser(M_User user) { var resultObj = new ResultObject { RowAffected = -1, ObjectValue = user }; using (var context = new MasterDbContext(contextOptions)) { using (var transaction = context.Database.BeginTransaction()) { try { context.Entry(user).State = EntityState.Modified; MySqlParameter[] sqlParams = new MySqlParameter[] { new MySqlParameter("strId", user.Id), new MySqlParameter("strUserCode", user.UserCode), new MySqlParameter("strUserName", user.UserName), new MySqlParameter("strEmpCode", user.EmpCode), new MySqlParameter("strDeptId", user.DeptId), new MySqlParameter("strPosition", user.Position), new MySqlParameter("strCompanyCode", user.CompanyCode), new MySqlParameter("straspnetuser_Id", user.aspnetuser_Id), new MySqlParameter("strIs_Active", user.Is_Active), new MySqlParameter("strUpdated_By", user.Updated_By), new MySqlParameter("strUserImagePath", user.UserImagePath) }; //Output Parameter no need to define. @`strId` resultObj.RowAffected = await context.Database.ExecuteSqlCommandAsync("call sp_user_update(?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?)", parameters : sqlParams); transaction.Commit(); return(resultObj); } catch (Exception ex) { transaction.Rollback(); throw ex; } } } }
public async Task <ResultObject> InsertUser(M_User user) { var resultObj = new ResultObject { RowAffected = -1, ObjectValue = user }; using (var context = new MasterDbContext(contextOptions)) { using (var transaction = context.Database.BeginTransaction()) { try { MySqlParameter[] sqlParams = new MySqlParameter[] { new MySqlParameter("strUserCode", user.UserCode), new MySqlParameter("strUserName", user.UserName), new MySqlParameter("strEmpCode", user.EmpCode), new MySqlParameter("strDeptId", user.DeptId), new MySqlParameter("strPosition", user.Position), new MySqlParameter("strCompanyCode", user.CompanyCode), new MySqlParameter("straspnetuser_Id", user.aspnetuser_Id), new MySqlParameter("strIs_Active", user.Is_Active), new MySqlParameter("strCreated_By", user.Created_By), new MySqlParameter("strUserImagePath", user.UserImagePath) }; resultObj.RowAffected = await context.Database.ExecuteSqlCommandAsync("call sp_user_insert(@`strId`, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?)", parameters : sqlParams); //new department after insert. var newUser = context.User.FromSql("SELECT * FROM m_user WHERE Id = @`strId`;").ToListAsync(); resultObj.ObjectValue = newUser.Result[0]; transaction.Commit(); return(resultObj); } catch (Exception ex) { transaction.Rollback(); throw ex; } } } }
/// <summary> /// 注册用户 /// </summary> /// <param name="entity">用户类</param> /// <param name="userAcc">账号类</param> /// <returns>操作结果</returns> public bool SignUp(M_User entity, M_UserAcc userAcc) { try { var db = DbFactory.GetSugarInstance(); var result = db.Ado.UseTran(() => { db.Insertable <M_User>(entity).ExecuteCommand(); db.Insertable <M_UserAcc>(userAcc).ExecuteCommand(); }); return(result.IsSuccess); } catch (Exception ex) { LogHelper.Error(ex); return(false); } }
/// <summary> /// 根据身份证ID获取用户信息 /// </summary> /// <param name="cradNo">身份证</param> /// <returns></returns> public M_User GetUserInfoByCardNo(string cradNo) { M_User mUser = null; var httpClient = new OAuthHttpClient(OAuthToken) { BaseAddress = new Uri(string.Format("{0}/ATM/GetUserInfoByCardNo?cradNo={1}", "http://rempapi.e24health.com/Screen", cradNo)) }; var response = httpClient.GetAsync("").Result; if (response.StatusCode == HttpStatusCode.OK) { var subResult = response.Content.ReadAsStringAsync().Result; if (subResult != null) { subResult = subResult.Substring(1, subResult.Length - 2); mUser = JsonConvert.DeserializeObject <M_User>(subResult); } } return(mUser); }
/// <summary> /// 用户登录 /// </summary> /// <param name="account">账号</param> /// <param name="pwd">密码</param> /// <returns></returns> public M_User Login(string account, string pwd) { M_User mUser = null; var httpClient = new OAuthHttpClient(OAuthToken) { BaseAddress = new Uri(string.Format("{0}/ATM/Login?account={1}&pwd={2}", "http://rempapi.e24health.com/Screen", account, pwd)) }; var response = httpClient.GetAsync("").Result; if (response.StatusCode == HttpStatusCode.OK) { var subResult = response.Content.ReadAsStringAsync().Result; if (subResult != null) { subResult = subResult.Substring(1, subResult.Length - 2); mUser = JsonConvert.DeserializeObject <M_User>(subResult); } } return(mUser); }
public string SaveUser(UserModel um) { LibraryEntities3 lbe = new LibraryEntities3(); string msg = string.Empty; M_User mb = new M_User(); mb.UserID = um.UserID; mb.UserName = um.UserName; mb.Password = um.Password; try { lbe.M_User.Add(mb); lbe.SaveChanges(); msg = "OK"; } catch (Exception ex) { msg = ex.ToString(); } return(msg); }
public static bool Delete(int id) { bool result = true; try { using (var db = new MarComContext()) { M_User user = db.M_User.Where(us => us.Id == id).FirstOrDefault(); if (user != null) { user.Is_Delete = true; db.SaveChanges(); } } } catch (Exception ex) { result = false; } return(result); }