public async Task <ActionResult> Authenticate(string username)
{
var rs = new JsonRs
{
Status = "00",
Message = "Đăng nhập lỗi"
};
try
{
var obj = Cache.Get <UserModel>(username + System.Web.HttpContext.Current.Session.SessionID);
if (obj != null)
{
Cache.Remove(username + System.Web.HttpContext.Current.Session.SessionID);
System_User user = null;
rs = _userService.Authenticate(obj.UserName, obj.Password, ref user);
if (user != null)
{
var branchCode = string.Empty;
Session[Constant.SessionKey.UserName] = user.UserName;
return(Json(new { result = rs }, JsonRequestBehavior.AllowGet));
}
}
return(Json(new { result = rs }, JsonRequestBehavior.AllowGet));
}
catch (Exception ex)
{
_log.Error("Login is error: username:{0} - Message: {1}", username, ex);
return(Json(new { result = rs }, JsonRequestBehavior.AllowGet));
}
}
public IHttpActionResult PutSystem_User(long id, System_User system_User)
{
if (!ModelState.IsValid)
{
return(BadRequest(ModelState));
}
if (id != system_User.ID)
{
return(BadRequest());
}
db.Entry(system_User).State = EntityState.Modified;
try
{
db.SaveChanges();
}
catch (DbUpdateConcurrencyException)
{
if (!System_UserExists(id))
{
return(NotFound());
}
else
{
throw;
}
}
return(StatusCode(HttpStatusCode.NoContent));
}
public static void MarkAuthenticate(System_User user, Vw_UserInfo userInfo)
{
HttpContext.Current.Session["username"] = user.UserName;
HttpContext.Current.Session["userid"] = user.Id;
HttpContext.Current.Session["===user==="] = user;
HttpContext.Current.Session["===userInfo==="] = userInfo;
}
public MessageReport Update(string _id, System_User obj)
{
var report = new MessageReport();
try
{
var query = Builders <System_User> .Filter.Eq(e => e._id, _id);
var update = Builders <System_User> .Update
.Set(x => x.Password, obj.Password)
.Set(x => x.Name, obj.Name)
.Set(x => x.UserAvatar, obj.UserAvatar)
.Set(x => x.Address, obj.Address)
.Set(x => x.Phone, obj.Phone)
.Set(x => x.SupperUser, obj.SupperUser)
.Set(x => x.IsActive, obj.IsActive);
_System_UserRepository.Update(query, update);
report.Success = true;
report.Message = "Cập nhật tài khoản thành công!";
}
catch (Exception ex)
{
report.Message = ex.Message;
}
return(report);
}
/// <summary>
/// 添加
/// </summary>
/// <param name="entity">实体</param>
/// <returns></returns>
public int Add(System_User entity)
{
try
{
if (dr == null)
{
dr = new CallDatabase();
}
dr.InitiCommand("insert into Sys_User([LoginName],[Pwd],[UserName],[Remarks])values(@LoginName,@Pwd,@UserName,@Remarks);select @@identity");
dr.AddParameters("LoginName", DbType.String, 30, entity.LoginName);
dr.AddParameters("Pwd", DbType.String, 20, entity.Pwd);
dr.AddParameters("UserName", DbType.String, 8, entity.UserName);
dr.AddParameters("Remarks", DbType.String, 200, entity.Remarks);
int value = Convert.ToInt32(dr.ExecuteScalar());
entity.Id = value;
dr.Close();
return(0);
}
catch (Exception ex)
{
using (ILog_Error log = new Log_Error_Generate())
{
log.Title = ex.Message;
log.Content = ex.StackTrace;
log.Generatelog();
}
return(-1);
}
}
public ActionResult DeleteConfirmed(long id)
{
System_User system_User = db.System_User.Find(id);
db.System_User.Remove(system_User);
db.SaveChanges();
return(RedirectToAction("Index"));
}
/// <summary>
/// 登录成功之后保存的信息
/// </summary>
private void UserInfoSave(System_User entity)
{
User_Login_Config user_Entity = new User_Login_Config();
user_Entity.Id = entity.Id;
user_Entity.IsAdmin = entity.IsAdmin;
user_Entity.LoginName = entity.LoginName;
user_Entity.UserName = entity.UserName;
ReadConfigFile.UserLongInfo = user_Entity;
}
public ActionResult Edit([Bind(Include = "User_id,User_name,User_password,User_department,User_email,User_badge")] System_User system_User)
{
if (ModelState.IsValid)
{
db.Entry(system_User).State = EntityState.Modified;
db.SaveChanges();
return(RedirectToAction("Index"));
}
return(View(system_User));
}
public bool ChangePwd(Guid userId, string newPwd)
{
using (DataProvider dp = new DataProvider())
{
System_User user = data.GetUserById(dp, userId);
user.Password = newPwd;
dp.SaveChanges();
return(true);
}
}
public ActionResult Edit([Bind(Include = "ID,CompanyID,UserName,UserShort,UserSex,UserAddress,UserAccont,UserPasswd,IsBindMobile,UserMobile,IsBindCard,UserCard,WxOpenId,WxUnionid,UserGrade,LoginDate,OrderID,Status")] System_User system_User)
{
if (ModelState.IsValid)
{
db.Entry(system_User).State = EntityState.Modified;
db.SaveChanges();
return(RedirectToAction("Index"));
}
ViewBag.CompanyID = new SelectList(db.System_Company, "ID", "CompanyName", system_User.CompanyID);
return(View(system_User));
}
public ActionRes GetSystem_User(long id)
{
System_User system_User = db.System_User.Find(id);
if (system_User == null)
{
return(ActionRes.Fail(""));
}
return(ActionRes.Success(system_User));
}
public ActionResult Create([Bind(Include = "User_id,User_name,User_password,User_department,User_email,User_badge")] System_User system_User)
{
if (ModelState.IsValid)
{
db.System_User.Add(system_User);
db.SaveChanges();
return(RedirectToAction("Index"));
}
return(View(system_User));
}
public IHttpActionResult PostSystem_User(System_User system_User)
{
if (!ModelState.IsValid)
{
return(BadRequest(ModelState));
}
db.System_User.Add(system_User);
db.SaveChanges();
return(CreatedAtRoute("DefaultApi", new { id = system_User.ID }, system_User));
}
public IHttpActionResult DeleteSystem_User(long id)
{
System_User system_User = db.System_User.Find(id);
if (system_User == null)
{
return(NotFound());
}
db.System_User.Remove(system_User);
db.SaveChanges();
return(Ok(system_User));
}
// GET: User/Details/5
public ActionResult Details(long?id)
{
if (id == null)
{
return(new HttpStatusCodeResult(HttpStatusCode.BadRequest));
}
System_User system_User = db.System_User.Find(id);
if (system_User == null)
{
return(HttpNotFound());
}
return(View(system_User));
}
// GET: User/Edit/5
public ActionResult Edit(long?id)
{
if (id == null)
{
return(new HttpStatusCodeResult(HttpStatusCode.BadRequest));
}
System_User system_User = db.System_User.Find(id);
if (system_User == null)
{
return(HttpNotFound());
}
ViewBag.CompanyID = new SelectList(db.System_Company, "ID", "CompanyName", system_User.CompanyID);
return(View(system_User));
}
public ActionRes GetOpenId()
{
HttpContextBase context = (HttpContextBase)Request.Properties["MS_HttpContext"];
WeChatInfo wechatInfo = Helper.GetOpenId(context.Request["js_code"]);
System_User systemUser = db.System_User.Where(user => user.WxOpenId == wechatInfo.openid).FirstOrDefault();
if (systemUser != null)
{
return(ActionRes.Success(systemUser));
}
else
{
return(ActionRes.Success(wechatInfo));
}
}
public MessageReport Create(System_User obj)
{
var rp = new MessageReport();
try
{
_System_UserRepository.Add(obj);
rp.Success = true;
rp.Message = "Thêm tài khoản thành công!";
}
catch (Exception ex)
{
rp.Message = ex.Message;
}
return(rp);
}
/// <summary>
/// 更新
/// </summary>
/// <param name="entity">实体</param>
/// <returns></returns>
public int Update(System_User entity)
{
if (dr == null)
{
dr = new CallDatabase();
}
dr.InitiCommand("Update Sys_User set [LoginName]=@LoginName,[Pwd]=@Pwd,[UserName]=@UserName,[Remarks]=@Remarks where [Id]=@Id ");
dr.AddParameters("LoginName", DbType.String, 30, entity.LoginName);
dr.AddParameters("Pwd", DbType.String, 20, entity.Pwd);
dr.AddParameters("UserName", DbType.String, 8, entity.UserName);
dr.AddParameters("Remarks", DbType.String, 200, entity.Remarks);
dr.AddParameters("Id", DbType.Int32, entity.Id);
int value = dr.ExecuteNonQuery();
dr.Close();
return(value);
}
//-------------------------------------------------------------------------------------------
public bool LogIn_byPhoneNumber(string phonenumber, string passcode, out System_User user)
{
//Weavver.Sys.User item = DatabaseHelper.Session.CreateCriteria(typeof(Weavver.Sys.User))
// .Add(NHibernate.Criterion.Restrictions.Eq("PhoneNumber", phonenumber))
// .Add(NHibernate.Criterion.Restrictions.Eq("PassCode", passcode))
// .SetCacheable(true)
// .UniqueResult<Weavver.Sys.User>();
////if (item == null)
//// return false;
////item.Password = newPassword;
////item.Commit();
//user = item;
user = null;
return false;
}
//-------------------------------------------------------------------------------------------
public bool LogIn_byPhoneNumber(string phonenumber, string passcode, out System_User user)
{
//Weavver.Sys.User item = DatabaseHelper.Session.CreateCriteria(typeof(Weavver.Sys.User))
// .Add(NHibernate.Criterion.Restrictions.Eq("PhoneNumber", phonenumber))
// .Add(NHibernate.Criterion.Restrictions.Eq("PassCode", passcode))
// .SetCacheable(true)
// .UniqueResult<Weavver.Sys.User>();
////if (item == null)
//// return false;
////item.Password = newPassword;
////item.Commit();
//user = item;
user = null;
return(false);
}
public bool EditUser(UserModel model)
{
List <System_UserRole> userRoleList = new List <System_UserRole>();
if (model.RoleId != null && model.RoleId.Count > 0)
{
foreach (var m in model.RoleId)
{
userRoleList.Add(new System_UserRole()
{
UserId = model.Id,
RoleId = m,
CreateUser = model.UpdateUser,
CreateTime = DateTime.Now
});
}
}
using (DataProvider dp = new DataProvider())
{
if (data.GetUserNameCount(dp, model, true) > 0)
{
return(false);
}
System_User entity = data.GetUserById(dp, model.Id);
entity.UserName = model.UserName;
entity.TrueName = model.TrueName;
entity.IsEnabled = model.IsEnabled;
entity.UpdateUser = model.Id;
entity.UpdateTime = DateTime.Now;
data.DeleteUserRole(dp, model.Id);
if (userRoleList.Count > 0)
{
data.AddUserRole(dp, userRoleList);
}
try
{
dp.SaveChanges();
return(true);
}
catch
{
return(false);
}
}
}
public bool AddUser(UserModel model)
{
System_User entity = Mapper.Map <System_User>(model);
entity.Id = Guid.NewGuid();
entity.Password = Common.MD5Encrypt.MD5Encrypt64("123456");
entity.IsDel = false;
entity.CreateTime = DateTime.Now;
List <System_UserRole> userRoleList = new List <System_UserRole>();
if (model.RoleId != null && model.RoleId.Count > 0)
{
foreach (var m in model.RoleId)
{
userRoleList.Add(new System_UserRole()
{
UserId = entity.Id,
RoleId = m,
CreateUser = entity.CreateUser,
CreateTime = DateTime.Now
});
}
}
using (DataProvider dp = new DataProvider())
{
if (data.GetUserNameCount(dp, model, false) > 0)
{
return(false);
}
data.AddUser(dp, entity);
if (userRoleList.Count > 0)
{
data.AddUserRole(dp, userRoleList);
}
try
{
dp.SaveChanges();
return(true);
}
catch
{
return(false);
}
}
}
public bool DeleteUser(List <UserModel> model)
{
if (model == null || model.Count == 0)
{
return(false);
}
using (DataProvider dp = new DataProvider())
{
foreach (UserModel m in model)
{
System_User entity = data.GetUserById(dp, m.Id);
entity.IsDel = true;
entity.UpdateUser = m.UpdateUser;
entity.UpdateTime = DateTime.Now;
}
dp.SaveChanges();
return(true);
}
}
private void SaveButton_Click(object sender, EventArgs e)
{
if (System_User != null)
{
var entity = system_User_Controls1.User_Entity;
System_User.ConfirmPwd = system_User_Controls1.ConfirmPwd;
if (System_User.RepeatVerify_Update(entity))
{
if (System_User.Update(entity) > -1)
{
this.DialogResult = MessageBox.Show("更新用户成功!", "用户更新提示", MessageBoxButtons.OK);
this.Close();
}
}
else
{
MessageBox.Show(System_User.Messages, "用户更新提示");
}
}
}
public async Task <bool> Add(System_User user, string Password, string Role)
{
try
{
bool roleExists = await roleManager.RoleExistsAsync(Role);
if (!roleExists)
{
// first we create Admin rool
var role = new IdentityRole();
role.Name = Role;
await roleManager.CreateAsync(role);
}
///Add User
var result = await userManager.CreateAsync(user, Password);
IdentityResult = result;
if (result.Succeeded)
{
var currentUser = await userManager.FindByNameAsync(user.UserName);
var roleresult = await userManager.AddToRoleAsync(currentUser, Role);
return(true);
}
else
{
return(false);
}
}
catch (Exception objEx)
{
await AddError(objEx);
return(false);
}
}
private void btnlogin_Click(object sender, EventArgs e)
{
System_User login = new System_User
{
UserName = txtuser.Text,
Password = txtpass.Text
};
var users = help.GetUsers(login);
string ezbItemValue = comboBox1.SelectedItem.ToString();
if (users.Count > 0)
{
foreach (var item in users)
{
if (item.UserType.Trim() == ezbItemValue)
{
MessageBox.Show("You are login as " + item.UserName);
if (comboBox1.SelectedIndex == 0)
{
BankDashboard f = new BankDashboard();
f.Show();
Hide();
}
else
{
BankDashboardT ff = new BankDashboardT();
ff.Show();
Hide();
}
}
}
}
else
{
MessageBox.Show("Wrong username or password!");
}
}
public bool AddUser(Vw_Core_User vwCoreUser)
{
using (var db = _connectionFactory.Open())
{
using (var trans = db.OpenTransaction())
{
try
{
var user = new System_User
{
};
db.Insert(user);
trans.Commit();
return(true);
}
catch (Exception ex)
{
_logger.Error("Add user error: " + ex);
trans.Rollback();
return(false);
}
}
}
}
public UserModel GetUserModel(Guid userId)
{
using (DataProvider dp = new DataProvider())
{
System_User entity = data.GetUserById(dp, userId);
if (entity == null)
{
return(null);
}
UserModel model = Mapper.Map <UserModel>(entity);
List <System_Role> roleList = new RoleData().GetUserRole(dp, userId);
model.RoleId = new List <Guid>();
model.UserRole = new List <RoleModel>();
if (roleList != null && roleList.Count > 0)
{
foreach (var m in roleList)
{
model.RoleId.Add(m.Id);
model.UserRole.Add(Mapper.Map <RoleModel>(m));
}
}
return(model);
}
}
public bool Save(EmployeeModel model)
{
using (DataProvider dp = new DataProvider())
{
var entity = data.GetEmpById(dp, model.Id);
if (entity == null)
{
if (model.IsRelateUser)
{
System_User user = new System_User()
{
Id = Guid.NewGuid(),
CreateTime = DateTime.Now,
CreateUser = model.CreateUser,
IsDel = false,
IsEnabled = true,
Password = Common.MD5Encrypt.MD5Encrypt64("123456"),
TrueName = model.EmpName,
UserName = model.RelateUserName
};
model.RelateUserId = user.Id;
dp.System_User.Add(user);
if (model.RelateRoleIds != null && model.RelateRoleIds.Count > 0)
{
model.RelateRoleIds.ForEach(m =>
{
System_UserRole relate = new System_UserRole()
{
UserId = user.Id,
RoleId = m,
CreateTime = DateTime.Now,
CreateUser = model.CreateUser
};
dp.System_UserRole.Add(relate);
});
}
}
model.Id = Guid.NewGuid();
model.IsDel = false;
model.CreateTime = DateTime.Now;
dp.PM_Employee.Add(Mapper.Map <PM_Employee>(model));
}
else
{
entity.EmpName = model.EmpName;
entity.PhoneNumber = model.PhoneNumber;
entity.DepartmentId = model.DepartmentId;
entity.UpdateUser = model.UpdateUser;
entity.UpdateTime = DateTime.Now;
var user = dp.System_User.FirstOrDefault(m => m.Id == entity.RelateUserId);
if (user != null)
{
user.TrueName = entity.EmpName;
}
}
try
{
dp.SaveChanges();
return(true);
}
catch
{
throw;
}
}
}
public void AddUser(DataProvider dp, System_User entity)
{
dp.System_User.Add(entity);
}
