public ActionResult Register(user_login user_Login) { try { using (var db = new HRISContext()) { var chkUser = (from s in db.user_login where s.user_id == user_Login.user_id select s).FirstOrDefault(); if (chkUser == null) { var keyNew = PasswordHashHelper.GeneratePassword(10); var pass = PasswordHashHelper.EncodePassword(user_Login.password, keyNew); user_Login.password = pass; user_Login.vcode = keyNew; db.user_login.Add(user_Login); db.SaveChanges(); ModelState.Clear(); return(RedirectToAction("LogIn", "Login")); } ViewBag.ErrorMessage = "User Already Exixts!"; return(View()); } } catch (Exception e) { ViewBag.ErrorMessage = "Some exception occured" + e; return(View()); } }
public IHttpActionResult UserPassRecovery(dynamic obj) { JObject je = new JObject(); JObject jo = new JObject(); string getStr = string.Empty; je = (JObject)JsonConvert.DeserializeObject(obj.ToString()); SqlSugarClient sql = datahandle.GetDataConnect(); //校验客户账户是否存在 List <user_login> list_user = sql.Queryable <user_login>().Where(t => t.userName == je["userName"].ToString()).ToList(); if (list_user.Count > 0) { user_login user_LoginModel = list_user.First(); user_LoginModel.userPwd = Md5Control.MD5Encrypt(je["userPwd"].ToString()); int Result = sql.Updateable <user_login>(user_LoginModel).ExecuteCommand(); if (Result == 1) { jo.Add("Message", "修改完成"); jo.Add("Result", 1); } else { jo.Add("Result", 0); jo.Add("Message", "修改失败"); } } return(Json(jo.ToString())); }
public IHttpActionResult Putuser_login(int id, user_login user_login) { if (!ModelState.IsValid) { return(BadRequest(ModelState)); } if (id != user_login.ID) { return(BadRequest()); } db.Entry(user_login).State = EntityState.Modified; try { db.SaveChanges(); } catch (DbUpdateConcurrencyException) { if (!user_loginExists(id)) { return(NotFound()); } else { throw; } } return(StatusCode(HttpStatusCode.NoContent)); }
public bool DeleteAccount(user_login user, String username, String token) { if (new LoginDAOFirebase().CheckToken(username, token)) { if (user.username == username || new LoginDAOSQL().CheckPermission(username) > new LoginDAOSQL().CheckPermission(user.username)) { bool check = new LoginDAOSQL().DeleteAccount(user); if (check) { new LoginDAOFirebase().History(username, "Xóa thành công tài khoản " + user.username); } else { new LoginDAOFirebase().History(username, "Xóa thất bại tài khoản " + user.username); } return(check); } else { new LoginDAOFirebase().History(username, "Xóa thất bại tài khoản " + user.username); return(false); } } else { new LoginDAOFirebase().History(username, "Xóa thất bại tài khoản " + user.username); return(false); } }
public bool InsertAccount(user_login user, String username, String token) { if (new LoginDAOFirebase().CheckToken(username, token)) { if (new LoginDAOSQL().CheckPermission(username) > 1) { bool check = new LoginDAOSQL().InsertAccount(user); if (check) { new LoginDAOFirebase().History(username, "Đăng ký thành công tài khoản " + user.username); } else { new LoginDAOFirebase().History(username, "Đăng ký thất bại tài khoản " + user.username); } return(check); } else { new LoginDAOFirebase().History(username, "Đăng ký thất bại tài khoản " + user.username); return(false); } } else { new LoginDAOFirebase().History(username, "Đăng ký thất bại tài khoản " + user.username); return(false); } }
public IHttpActionResult Getuser_login(int id) { user_login user_login = db.user_login.Find(id); if (user_login == null) { return(NotFound()); } return(Ok(user_login)); }
public IHttpActionResult Postuser_login(user_login user_login) { if (!ModelState.IsValid) { return(BadRequest(ModelState)); } db.user_login.Add(user_login); db.SaveChanges(); return(CreatedAtRoute("DefaultApi", new { id = user_login.ID }, user_login)); }
public IHttpActionResult Deleteuser_login(int id) { user_login user_login = db.user_login.Find(id); if (user_login == null) { return(NotFound()); } db.user_login.Remove(user_login); db.SaveChanges(); return(Ok(user_login)); }
public IHttpActionResult PwdUpdate(dynamic obj) { JObject je = new JObject(); JObject jo = new JObject(); try { je = (JObject)JsonConvert.DeserializeObject(obj.ToString()); LoggerHelp.LogInfo("PwdUpdate接收数据:" + je); SqlSugarClient sql = datahandle.GetDataConnect(); List <user_login> user_Logins = sql.Queryable <user_login>().Where(t => t.userName == je["userName"].ToString()).ToList(); if (user_Logins.Count == 1) { user_login user_Login = user_Logins[0]; if (user_Login.userPwd == Md5Control.MD5Encrypt(je["userPwdOld"].ToString())) { user_Login.userPwd = Md5Control.MD5Encrypt(je["userPwdNew"].ToString()); int Result = sql.Updateable(user_Login).ExecuteCommand(); if (Result == 1) { jo.Add("Result", 1); jo.Add("Message", "密码更换成功"); } else { jo.Add("Result", 0); jo.Add("Message", "密码更换失败"); } } else { jo.Add("Result", 0); jo.Add("Message", "原密码错误"); } } else { jo.Add("Result", 0); jo.Add("Message", "用户名不存在"); } } catch (Exception error) { jo.Add("Result", 3); jo.Add("Message", error.Message); } LoggerHelp.LogInfo("PwdUpdate返回数据:" + jo); return(Json(jo.ToString())); }
public bool DeleteAccount(user_login login) { try { user_login animal = db.user_logins.Single(u => u.ID == login.ID); db.user_logins.DeleteOnSubmit(animal); db.SubmitChanges(); return(true); } catch { return(false); } }
public bool InsertAccount(user_login login) { try { login.password = CreateMD5(login.password); db.user_logins.InsertOnSubmit(login); db.SubmitChanges(); return(true); } catch { return(false); } }
public IHttpActionResult GetRegisMsg(object obj) { JObject je = new JObject(); JObject jo = new JObject(); try { string getStr = string.Empty; je = (JObject)JsonConvert.DeserializeObject(obj.ToString()); LoggerHelp.LogInfo("GetRegisMsg接收数据:" + je); //判断一下用户名是否存在是否被注册过 SqlSugarClient sql = datahandle.GetDataConnect(); List <user_login> list_user = sql.Queryable <user_login>().Where(t => t.userName == je["userName"].ToString()).ToList(); if (list_user.Count > 0) { jo.Add("Result", 3); jo.Add("Message", "用户名已存在"); } else { user_login user = new user_login(); user.userName = je["userName"].ToString(); user.userPwd = Md5Control.MD5Encrypt(je["userPwd"].ToString()); user.userID = dataTransfer.StringToHexString(user.userName + je["userPwd"].ToString(), Encoding.UTF8); //user.id = Convert.ToInt32(je["id"].ToString()); int Result = sql.Insertable(user).ExecuteCommand(); if (Result == 1) { jo.Add("Message", "注册成功"); jo.Add("Result", 1); } else { jo.Add("Result", 0); jo.Add("Message", "注册失败"); } } } catch (Exception error) { jo.Add("Result", 4); jo.Add("Message", error.Message); } LoggerHelp.LogInfo("GetRegisMsg返回数据:" + jo); return(Json(jo.ToString())); }
public IHttpActionResult LoginCheck(user_login user) { user_login foundUser = db.user_login.Where(a => a.user_username.Equals(user.user_username)).FirstOrDefault(); if (foundUser == null) { return(NotFound()); } else if (foundUser != null && user.user_password.Equals(foundUser.user_password)) { return(Ok("Correct")); } else { return(NotFound()); } }
/// <summary> /// 用户注册 /// </summary> /// <param name="phone">手机号</param> /// <param name="password">密码</param> /// <param name="name">用户名</param> /// <param name="code">验证码</param> /// <returns></returns> public ActionResult Regist(string phone, string password, string name, string code) { //验证验证码 password = password.Trim(); if (!yzm(phone, code)) { return(Json(new { status = 1, desc = "验证码错误,请再申请一遍" }, JsonRequestBehavior.AllowGet)); } ; var query = bd.user_login.Where(p => p.name == phone).AsNoTracking(); if (query.Any()) { return(Json(new { status = 1, desc = "该手机号已经注册,请登录" }, JsonRequestBehavior.AllowGet)); } ; var log = new user { name = name, phone = phone, ins_date = DateTime.Now, disabled = false, last_login_date = DateTime.Now, last_login_ip = GetUserIP() }; bd.user.Add(log); bd.SaveChanges(); var log_l = new user_login { ins_date = DateTime.Now, uid = log.uid, name = phone, password = Encrypt.DesEncrypt(password, "heiban"), type = "phone" }; bd.user_login.Add(log_l); bd.SaveChanges(); string biaozhi = log.uid.ToString() + "asd" + DateTime.Now.ToString(); Redis.setHash("user", log.uid.ToString(), biaozhi); return(Json(new { status = 0, desc = "注册成功", msg = new { uid = Encrypt.DesEncrypt(biaozhi, "heiban") } }, JsonRequestBehavior.AllowGet)); }
public object PostLoginInfo([FromBody] user_login userLogin) { using (var entities = new iBlogEntities()) { var idEntity = entities.user_login.SqlQuery("SELECT * FROM user_login where user_id = " + userLogin.user_id); var isNUllCount = idEntity.ToList().Count; if (isNUllCount == 0) { return("User ID Do Not Exist"); } var check = userLogin.password.Equals(idEntity.ToArray()[0].password); if (check) { return("Verified"); } } return("User ID Do Not Exist or Wrong Password"); }
protected void Page_Load(object sender, EventArgs e) { try { obj = (user_login)Session["Uesrinfo"]; } catch { obj = new user_login(); } if (obj == null) { obj = new user_login(); } if (!obj.islogin) { Response.Redirect("."); } }
public ActionResult Edit(string id) { if (string.IsNullOrEmpty(id)) { return(new HttpStatusCodeResult(HttpStatusCode.BadRequest)); } //var user_Login = (from u in db.user_login // where u.user_id == id // select u).ToList(); user_login user_Login = db.user_login.Find(id); if (user_Login == null) { return(HttpNotFound()); } return(View(user_Login)); }
protected void Button1_Click(object sender, EventArgs e) { if (Session["loginform"].ToString() == captcha.Text) { string str = ""; bool is_ok = false; int j = 0; PDBC db = new PDBC("honarjoo"); db.Connect(); using (DataTable dt = db.Select("SELECT [id],[name],[us],[pass] FROM [dbo].[login]")) { for (int i = 0; i < dt.Rows.Count; i++) { while (j == i) { if (dt.Rows[j].ItemArray[2].ToString() == inputun.Text && dt.Rows[j].ItemArray[3].ToString() == inputPass.Text) { str = dt.Rows[j].ItemArray[1].ToString(); is_ok = true; break; } j++; db.DC(); } } if (is_ok == true) { user_login login = new user_login() { name = str, islogin = true }; Session["Uesrinfo"] = login; Response.Redirect("show.aspx"); } else { } } } }
public ActionResult Create(user_login user_Login) { try { var check = (from s in db.user_login where s.user_id == user_Login.user_id select s).FirstOrDefault(); if (check == null) { var keyNew = PasswordHashHelper.GeneratePassword(10); var pass = PasswordHashHelper.EncodePassword(user_Login.user_id + DateTime.Now.Year.ToString(), keyNew); user_login _Login = new user_login { user_id = user_Login.user_id, password = pass, vcode = keyNew, role = user_Login.role, status = user_Login.status, date_created = DateTime.Now }; karyawan karyawan = new karyawan { user_id = _Login.user_id }; db.user_login.Add(_Login); db.karyawan.Add(karyawan); db.SaveChanges(); ModelState.Clear(); return(Json("0", JsonRequestBehavior.AllowGet)); } return(Json("1", JsonRequestBehavior.AllowGet)); } catch (DbEntityValidationException e) { return(Json("2", JsonRequestBehavior.AllowGet)); } }
public IHttpActionResult UserLogin(dynamic obj) { JObject je = new JObject(); JObject jo = new JObject(); try { je = (JObject)JsonConvert.DeserializeObject(obj.ToString()); LoggerHelp.LogInfo("UserLogin接收数据:" + Md5Control.MD5Encrypt(je.ToString())); SqlSugarClient sql = datahandle.GetDataConnect(); List <user_login> list_user = sql.Queryable <user_login>().Where(t => t.userName == je["userName"].ToString()).ToList(); if (list_user.Count == 1) { user_login user_Login = list_user[0]; if (user_Login.userPwd == Md5Control.MD5Encrypt(je["userPwd"].ToString())) { jo.Add("Result", 1); jo.Add("Message", "登录成功"); } else { jo.Add("Result", 0); jo.Add("Message", "登录失败,密码错误"); } } else { jo.Add("Result", 2); jo.Add("Message", "用户不存在,请先注册!"); } } catch (Exception error) { jo.Add("Result", -1); jo.Add("Message", error.Message); } LoggerHelp.LogInfo("UserLogin返回数据:" + jo); return(Json(jo.ToString())); }
private void btnUpdate_Click(object sender, EventArgs e) { MatrixLinQDataContext con = new MatrixLinQDataContext(); user_login uc = con.user_logins.SingleOrDefault(x => x.uName == Utility.UserName && x.uPassword == this.txtCurrentPassword.Text); if (uc != null) { uc.uPassword = newPass.Text; con.SubmitChanges(); this.Dispose(); MessageBox.Show("Password Changed"); } else { MessageBox.Show("Error"); txtCurrentPassword.Text = ""; newPass.Text = ""; rePass.Text = ""; } }
public string insertsToTUBUSER(string posted) { user_login obj = JsonConvert.DeserializeObject <user_login>(posted); sessionCaptcha = obj.captcha; string str = ""; bool is_ok = false; int j = 0; PDBC db = new PDBC("honarjoo"); db.Connect(); using (DataTable dt = db.Select("SELECT [id],[name],[us],[pass] FROM [dbo].[login]")) { for (int i = 0; i < dt.Rows.Count; i++) { while (j == i) { if (dt.Rows[j].ItemArray[2].ToString() == obj.us && dt.Rows[j].ItemArray[3].ToString() == obj.pass) { str = dt.Rows[j].ItemArray[1].ToString(); is_ok = true; break; } j++; db.DC(); } } if (is_ok == true) { return(str); } else { return("-1"); } } }
public ActionResult EditPost(user_login user_Login) { var user = db.user_login.Find(user_Login.user_id); user.role = user_Login.role; user.status = user_Login.status; user.date_modified = DateTime.Now; try { db.user_login.Attach(user); db.Entry(user).Property(x => x.role).IsModified = true; db.Entry(user).Property(x => x.status).IsModified = true; db.Entry(user).Property(x => x.date_modified).IsModified = true; db.SaveChanges(); return(Json("0", JsonRequestBehavior.AllowGet)); } catch (DataException) { return(Json("1", JsonRequestBehavior.AllowGet)); } }
public bool UpdateAccount(user_login login) { try { user_login data = db.user_logins.SingleOrDefault(Login => Login.ID == login.ID); if (data != null) { data.ID = login.ID; data.username = login.username; data.password = CreateMD5(login.password); data.permission = login.permission; db.SubmitChanges(); return(true); } else { return(false); } } catch { return(false); } }
public void AddUser(UserData item) { hasError = false; try { TraditionAssetEntities db = new TraditionAssetEntities(); var data = new user_login() { username = item.username, password = item.password, is_active = item.is_active, create_date = DateTime.Now, modified_date = DateTime.Now }; db.user_login.Add(data); db.SaveChanges(); MessageBox.Show("Insert complete"); } catch (Exception ex) { errorMessage = "Add error, " + ex.Message; hasError = true; } }
public ActionResult Index(user_login user_Login) { try { using (var db = new HRISContext()) { var user = db.user_login.FirstOrDefault(m => m.user_id == user_Login.user_id); if (user != null) { var hashCode = user.vcode; var encodingPasswordString = PasswordHashHelper.EncodePassword(user_Login.password, hashCode); var query = db.karyawan .Join(db.user_login, k => k.user_id, u => u.user_id, (k, u) => new { k, u }) .Where(x => x.u.user_id == user_Login.user_id && x.u.password.Equals(encodingPasswordString)) .Select(x => new { x.k.user_id, x.k.karyawan_id, x.u.status }) .FirstOrDefault(); if (query != null) { if (query.status) { Session["user_id"] = query.user_id; Session["emp_id"] = query.karyawan_id; var emp_id = (int)Session["emp_id"]; var hist_kary = db.hist_karyawan .OrderByDescending(x => x.tgl_mulai) .Where(x => x.karyawan_id == emp_id) .Select(x => new { x.gol_jabatan_id, x.divisi_id }) .Take(1) .FirstOrDefault(); Session["pos"] = hist_kary.gol_jabatan_id != null ? hist_kary.gol_jabatan_id : -1; Session["divisi_id"] = hist_kary.divisi_id != null ? hist_kary.divisi_id : -1; async.UpdateWorkdaysAndAge(emp_id); if (user.role == "superuser") { return(RedirectToAction("Index", "Home", new { area = "Admin" })); } else { return(RedirectToAction("Index", "Home", new { area = "Employee" })); } } else { ViewBag.ErrorMsg = "Your account has not been activated. Please contact administrator."; return(View()); } } ViewBag.ErrorMsg = "Invalid username or password"; return(View()); } ViewBag.ErrorMsg = "Invalid username or password"; return(View()); } } catch (DataException e) { ViewBag.ErrorMsg = "Error :" + e.Message; return(View()); } }