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