public bool UpdateUserAccount(Users_Model users_Model) { using (var _dbContext = new SalesTrackingSystemEntities()) { try { var data = _dbContext.Users.Where(act => act.UserID == users_Model.UserID).FirstOrDefault(); data.UserProfileID = users_Model.UserProfileID; data.DistrubitorID = users_Model.DistrubitorID; data.FullName = users_Model.FullName; data.MobileNo = users_Model.MobileNo; if (users_Model.ImageString != null) { data.ImageString = users_Model.ImageString; } data.UsersStatus = users_Model.UsersStatus; _dbContext.SaveChanges(); return(true); } catch (Exception) { return(false); } } }
public ActionResult UserDelete(Users_Model user_) { var User_Name = user_.FullName; var UserData = new Users_Model(); Verification_Interface verification_ = new Verification_service(); var Message = ""; try { if (Users_Interface_.UserExists(user_.UserID)) { UserData = Users_Interface_.GetModelOnlyById(user_.UserID); if (UserData.DistrubitorID != null) { if (Users_Interface_.MakeDistrubitorNull(user_.UserID)) { Message = ", distributor account unlinked"; } //make distributor null first } if (verification_.VerificationExists(user_.UserID)) { if (verification_.DeleteVerification(user_.UserID)) { Message += ", verification details removed"; } //delete verification first } /*delede user folder*/ string Root = "~/UserInformation"; string Email = UserData.Email; string RootDir = Server.MapPath(Root + "/" + Email); if (Directory.Exists(RootDir)) { Directory.Delete(RootDir, true); Message += ", user directory deleted"; } if (Users_Interface_.DeleteUser(user_.UserID)) { /*delete user*/ Message += " and user deleted finally."; return(Json(User_Name + "'s " + Message)); } else { return(Json("Error")); } } else { Session["Error"] = User_Name + " not found!!"; return(View("Users")); } } catch (Exception e) { return(Json("Error" + e.ToString())); } }
public void ProcessRequest(HttpContext context) { context.Response.ContentType = "text/plain"; Users_Model usermodel = new Users_Model(); usermodel.LoginPwd = context.Request.Form["txtpwd"]; usermodel.NickName = context.Request.Form["txtnick"]; usermodel.Sex = context.Request.Form["txtsex"]; usermodel.Age = Convert.ToInt32(context.Request.Form["txtage"]); usermodel.FaceId = Convert.ToInt32(context.Request.Form["txtface"]); usermodel.Friend = Convert.ToInt32(context.Request.Form["txtfriend"]); usermodel.Name = context.Request.Form["txtname"]; usermodel.StarId = Convert.ToInt32(context.Request.Form["txtstar"]); usermodel.BloodId = Convert.ToInt32(context.Request.Form["txtblood"]); Users_Service userservice = new Users_Service(); if (userservice.AddUser(usermodel)) { context.Response.Redirect("Index.ashx"); } else { context.Response.Redirect("Error.ashx"); } }
public List <Users_Model> GetPageList(int start, int end) { string sql = "select * from(select *,row_number() over(order by id) as num from users)as t where num>=@start and num<=@end"; SqlParameter[] pars = { new SqlParameter("@start", start), new SqlParameter("@end", end) }; DataTable da = DbHelperSql.GetTable(sql, CommandType.Text, pars); List <Users_Model> list = null; if (da.Rows.Count > 0) { list = new List <Users_Model>(); Users_Model userm = null; foreach (DataRow row in da.Rows) { userm = new Users_Model(); loadEnitity(row, userm); list.Add(userm); } } return(list); }
private void btn_Save_Click(object sender, EventArgs e) { usr = new Users_Model(); if (PerformValidation(gb_Main)) { FRM2BL(); bool DialogDel = MessageBox.Show("Are you sure to EDIT this Data", "EDIT", MessageBoxButtons.YesNo, MessageBoxIcon.Question) == DialogResult.Yes; if (DialogDel) { crud = new User_CRUD(); if (crud.Update(usr)) { MessageBox.Show("Data UPDATED !!"); this.Close(); } else { MessageBox.Show("Data FAILED UPDATED !!"); this.Close(); } } else { MessageBox.Show("Wrong Password !!"); } ((frm_user_employee)f).displayTable(); ((frm_user_employee)f).Clear(); } }
public void ProcessRequest(HttpContext context) { context.Response.ContentType = "text/plain"; //Reguster //string name = context.Request["name"]; //User_Service userSer = new User_Service(); //if (userSer.FindUser(name)!=null) //{ // context.Response.Write("此用户存在"); //} //else //{ // context.Response.Write("可用"); //} //Login string userName = context.Request["name"]; string userPwd = context.Request["pwd"]; User_Service userSer = new User_Service(); string msg = string.Empty; Users_Model usermodel = null; if (userSer.CheckLoginUser(userName, userPwd, out msg, out usermodel)) { context.Session["usermodel"] = usermodel; //ajax必须返回消息 context.Response.Write("yes:" + msg); } else { context.Response.Write("no:" + msg); } }
public int AddUser(Users_Model usermodel) { string sql = "insert into users values(@pwd,@nick,@sex,@age,@face,@friend,@name,@star,@blood)"; SqlParameter[] pars = { new SqlParameter("@pwd", SqlDbType.VarChar, 20), new SqlParameter("@nick", SqlDbType.VarChar, 20), new SqlParameter("@sex", SqlDbType.Char, 2), new SqlParameter("@age", SqlDbType.Int), new SqlParameter("@face", SqlDbType.Int), new SqlParameter("@friend", SqlDbType.Int), new SqlParameter("@name", SqlDbType.VarChar, 20), new SqlParameter("@star", SqlDbType.Int), new SqlParameter("@blood", SqlDbType.Int) }; pars[0].Value = usermodel.LoginPwd; pars[1].Value = usermodel.NickName; pars[2].Value = usermodel.Sex; pars[3].Value = usermodel.Age; pars[4].Value = usermodel.FaceId; pars[5].Value = usermodel.Friend; pars[6].Value = usermodel.Name; pars[7].Value = usermodel.StarId; pars[8].Value = usermodel.BloodId; return(DbHelperSql.ExecuteNonQuery(sql, CommandType.Text, pars)); }
protected void btnSaveUser_Click(object sender, EventArgs e) { if (txtPassword1.Text == txtPassword2.Text) { Users_Model mdlUsers = new Users_Model(); mdlUsers.User_Name = txtUserName.Text.Trim(); mdlUsers.User_Email = txtUserEmail.Text.Trim(); mdlUsers.User_Domain = txtUserDomain.Text.Trim(); mdlUsers.User_Password = WSICryptography.Encrypt(txtPassword1.Text.Trim()); mdlUsers.User_Access = ddUserAccess.SelectedValue; if (Session["userMode"].ToString() == "Save") { Users.Save(oCon, mdlUsers); } else if (Session["userMode"].ToString() == "Update") { mdlUsers.idUser = Convert.ToInt32(Session["idUser"].ToString()); Users.Update(oCon, mdlUsers); } clearUser(); getUserView(); } }
/// <summary> /// 对cookie进行校检 /// </summary> private void CheckCookie() { if (Request.Cookies["ck1"] != null && Request.Cookies["ck2"] != null) { string userName = Request.Cookies["ck1"].Value; string userPwd = Request.Cookies["ck2"].Value; BLL.User_Service userService = new BLL.User_Service(); Users_Model usermodel = userService.FindUser(userName); if (usermodel != null) { //判断用户数据库中存储的密码是否与cookie中存储的密码一致 if (userPwd == usermodel.LoginPwd) { //先赋值 才能跳转 Session["usermodel"] = usermodel; //Response.Redirect("SessionSuc.aspx"); UserPwd = userPwd; UserName = userName; Checked = "checked"; //Request.Cookies["ck1"].Expires = DateTime.Now.AddDays(-1); //Request.Cookies["ck2"].Expires = DateTime.Now.AddDays(-1); } } //如果Cookie中是有值的,但是Cookie存储的用户名或密码不正确,表示用户名和密码被篡改了,那么只能继续出现登录页面。那么该 cOOKIE也没有必要存在了。 Response.Cookies["ck1"].Expires = DateTime.Now.AddDays(-1); Response.Cookies["ck2"].Expires = DateTime.Now.AddDays(-1); } }
public int UpdateUser(Users_Model usermodel) { string sql = "update users set loginpwd=@pwd,NickName=@nick,sex=@sex,age=@age,faceid=@face,FriendShipPolicyId=@friend,Name=@name,StarId=@star,BloodTypeId=@blood where id=@id"; SqlParameter[] pars = { new SqlParameter("@pwd", SqlDbType.VarChar, 20), new SqlParameter("@nick", SqlDbType.VarChar, 20), new SqlParameter("@sex", SqlDbType.Char, 2), new SqlParameter("@age", SqlDbType.Int), new SqlParameter("@face", SqlDbType.Int), new SqlParameter("@friend", SqlDbType.Int), new SqlParameter("@name", SqlDbType.VarChar, 20), new SqlParameter("@star", SqlDbType.Int), new SqlParameter("@blood", SqlDbType.Int), new SqlParameter("@id", SqlDbType.Int) }; pars[0].Value = usermodel.LoginPwd; pars[1].Value = usermodel.NickName; pars[2].Value = usermodel.Sex; pars[3].Value = usermodel.Age; pars[4].Value = usermodel.FaceId; pars[5].Value = usermodel.Friend; pars[6].Value = usermodel.Name; pars[7].Value = usermodel.StarId; pars[8].Value = usermodel.BloodId; pars[9].Value = usermodel.Id; return(DbHelperSql.ExecuteNonQuery(sql, CommandType.Text, pars)); }
/// <summary> /// 1、用户登陆 /// </summary> /// <param name="UName"></param> /// <returns></returns> public Users_Model Users_Login(string UName) { Users_Model obj = null; //采用数组存储参数 SqlParameter[] ter = new SqlParameter[] { new SqlParameter("@UName", UName) }; using (SqlDataReader dr = SqlHelper.ExecuteReader("Users_Login", ter)) { if (dr.Read())//如果没有从数据库中读取数据那么说明该用户不存在 { obj = new Users_Model() { UserID = (int)dr["UserID"], //用户ID UName = dr["UName"].ToString(), //用户唯一标识 Pwd = dr["Pwd"].ToString(), //密 码 RegisTime = dr["RegisTime"].ToString(), //注册时间 LastTime = dr["LastTime"].ToString(), //最后一次登陆时间 IsVaild = (bool)dr["IsVaild"], //是否有效 }; } } return(obj); }
/// <summary> ///展示要修改的数据 /// </summary> private void ShowEdit() { int id; if (int.TryParse(Request.QueryString["id"], out id)) { Users_Model usermodel = userservice.FindUser(id); UserModel = usermodel; } }
private void BL2FRM() { usr = new Users_Model(); txt_Nama.Text = usr._Name; txt_Password.Text = usr._Password; txt_Status.Text = usr._Status; txt_Sex.Text = usr._Sex; dtp_BirthDate.Value = usr._BirthDate; rtb_Address.Text = usr._Address; }
private void FRM2BL() { usr = new Users_Model(); usr._Name = txt_Nama.Text; usr._Password = txt_Password.Text; usr._Status = txt_Status.Text; usr._Sex = txt_Sex.Text; usr._BirthDate = dtp_BirthDate.Value; usr._Address = rtb_Address.Text; }
public void ProcessRequest(HttpContext context) { context.Response.ContentType = "text/plain"; int id = Convert.ToInt32(context.Request["id"]); BLL.User_Service userSer = new BLL.User_Service(); Users_Model usermodel = userSer.FindUser(id); System.Web.Script.Serialization.JavaScriptSerializer js = new System.Web.Script.Serialization.JavaScriptSerializer(); context.Response.Write(js.Serialize(usermodel)); }
public void LoadForm() { usr = new Users_Model(); txt_Nama.Text = ((frm_user_employee)f).txt_Nama.Text; txt_Password.Text = ((frm_user_employee)f).txt_Password.Text; txt_Status.Text = ((frm_user_employee)f).txt_Status.Text; txt_Sex.Text = ((frm_user_employee)f).txt_Sex.Text; dtp_BirthDate.Text = ((frm_user_employee)f).dtp_BirthDate.Text; rtb_Address.Text = ((frm_user_employee)f).rtb_Address.Text; cb_IsEmployee.Checked = ((frm_user_employee)f).cb_IsEmployee.Checked; cb_IsEmployee.Text = "ISEmployee"; }
public Users_Model FindUser(int id) { string sql = "select * from users where id=@id"; Users_Model usermodel = null; DataTable da = DbHelperSql.GetTable(sql, CommandType.Text, new SqlParameter("@id", id)); if (da.Rows.Count > 0) { usermodel = new Users_Model(); loadEnitity(da.Rows[0], usermodel); } return(usermodel); }
private void loadEnitity(DataRow row, Users_Model userModel) { userModel.Id = Convert.ToInt32(row["Id"]); userModel.LoginPwd = row["LoginPwd"] != DBNull.Value ? row["LoginPwd"].ToString() : string.Empty; userModel.NickName = row["NickName"] != DBNull.Value ? row["NickName"].ToString() : string.Empty; userModel.Sex = row["Sex"] != DBNull.Value ? row["Sex"].ToString() : string.Empty; userModel.Age = Convert.ToInt32(row["Age"]); userModel.FaceId = Convert.ToInt32(row["FaceId"]); userModel.Friend = Convert.ToInt32(row["FriendShipPolicyId"]); userModel.Name = row["Name"] != DBNull.Value ? row["Name"].ToString() : string.Empty; userModel.StarId = Convert.ToInt32(row["StarId"]); userModel.BloodId = Convert.ToInt32(row["BloodTypeId"]); }
/// <summary> /// 2、用户注册 /// </summary> /// <param name="us"></param> /// <returns></returns> public bool Users_Register(Users_Model us) { if (Users_Login2(us.UName) != null) { return(false);//用户已经存在 } //采用数组存储参数 SqlParameter[] param = new SqlParameter[] { new SqlParameter("@UserName", us.UName), new SqlParameter("@Pwd", us.Pwd) }; return(SqlHelper.ExecuteNonQuery("Users_Register", param)); }
/// <summary> /// 检验用户是否存在 /// </summary> /// <param name="UName"></param> /// <returns></returns> public Users_Model Users_Login2(string UName) { Users_Model obj = null; //采用数组存储参数 SqlParameter[] ter = new SqlParameter[] { new SqlParameter("@UName", UName) }; using (SqlDataReader dr = SqlHelper.ExecuteReader("Users_Login", ter)) { if (dr.Read())//如果没有从数据库中读取数据那么说明该用户不存在 { obj = new Users_Model(); } } return(obj); }
public bool SaveUserAccount(Users_Model users_Model) { using (var db_Context = new SalesTrackingSystemEntities()) { using (DbContextTransaction db = db_Context.Database.BeginTransaction()) { try { var UserData = new User() { UserID = GetNewUserId(), UserProfileID = users_Model.UserProfileID, FullName = users_Model.FullName, PasswordHash = users_Model.PasswordHash, Email = users_Model.Email, MobileNo = users_Model.MobileNo, ImageString = users_Model.ImageString, UsersStatus = users_Model.UsersStatus, DateCreated = DateTime.Now }; db_Context.Users.Add(UserData); db_Context.SaveChanges(); var userId = UserData.UserID; Verification_Interface verification_ = new Verification_service(); var DataVarification = new Verification() { VerificationID = verification_.GetNewVerificationId(), UserID = userId, IsVerified = false, DateCreated = DateTime.Now }; db_Context.Verifications.Add(DataVarification); db_Context.SaveChanges(); db.Commit(); return(true); } catch (DbEntityValidationException) { db.Rollback(); return(false); } } } }
private void FRM2BL() { usr = new Users_Model(); usr._Name = txt_Nama.Text; usr._Password = txt_Password.Text; usr._Status = txt_Status.Text; usr._Sex = txt_Sex.Text; usr._BirthDate = dtp_BirthDate.Value; usr._Address = rtb_Address.Text; if (cb_IsEmployee.Checked) { usr.IsEmployee = "1"; } else { usr.IsEmployee = "0"; } usr.UserId = ((frm_user_employee)f).id_user; }
public List <Users_Model> GetUsers() { string sql = "select * from users"; DataTable da = DbHelperSql.GetTable(sql, CommandType.Text); List <Users_Model> list = null; if (da.Rows.Count > 0) { list = new List <Users_Model>(); Users_Model usermodel = new Users_Model(); foreach (DataRow row in da.Rows) { usermodel = new Users_Model(); loadEnitity(row, usermodel); list.Add(usermodel); } } return(list); }
private void FRM2BL() { usr = new Users_Model(); usr._Name = txt_Nama.Text; usr._Password = txt_Password.Text; usr._Status = txt_Status.Text; usr._Sex = txt_Sex.Text; usr._BirthDate = dtp_BirthDate.Value; usr._Address = rtb_Address.Text; if (cb_IsEmployee.Checked) { usr.IsEmployee = "1"; } else { usr.IsEmployee = "0"; } id_user = dgv.SelectedRows[0].Cells["user_id"].Value.ToString(); usr.UserId = id_user; }
/// <summary> /// 判断用户的用户名密码是否正确 /// </summary> /// <param name="userName">用户名</param> /// <param name="userPwd">密码</param> /// <param name="msg">返回的信息</param> /// <param name="usermodel">返回的登录用户的信息</param> /// <returns></returns> public bool CheckLoginUser(string userName, string userPwd, out string msg, out Users_Model usermodel) { usermodel = dao.FindUser(userName); if (usermodel != null) { if (usermodel.LoginPwd == userPwd) { msg = "登陆成功"; return(true); } else { msg = "用户名或密码错误"; return(false); } } else { msg = "此用户不存在"; return(false); } }
private void PostEditUser() { Users_Model usermodel = new Users_Model(); usermodel.LoginPwd = Request.Form["txtpwd"]; usermodel.NickName = Request.Form["txtnick"]; usermodel.Sex = Request.Form["txtsex"]; usermodel.Age = Convert.ToInt32(Request.Form["txtage"]); usermodel.FaceId = Convert.ToInt32(Request.Form["txtface"]); usermodel.Friend = Convert.ToInt32(Request.Form["txtfriend"]); usermodel.Name = Request.Form["txtname"]; usermodel.StarId = Convert.ToInt32(Request.Form["txtstar"]); usermodel.BloodId = Convert.ToInt32(Request.Form["txtblood"]); usermodel.Id = Convert.ToInt32(Request.Form["id"]); if (userservice.UpdateUser(usermodel)) { Response.Redirect("Index.aspx"); } else { Response.Redirect("Error.html"); } }
private void CheckUser() { string userName = Request.Form["txtClientID"]; string userPwd = Request.Form["txtPassword"]; BLL.User_Service userService = new BLL.User_Service() ; //提示信息 string msg = string.Empty; Users_Model usermodel = null; if (userService.CheckLoginUser(userName, userPwd, out msg, out usermodel)) { //判断用户是否选择了自动登录 if (!string.IsNullOrEmpty(Request.Form["autoLogin"])) { HttpCookie cookie1 = new HttpCookie("ck1", userName); HttpCookie cookie2 = new HttpCookie("ck2", userPwd); //HttpCookie cookie = new HttpCookie("ck", Common.MD5Com.GetMd5String(userPwd)); cookie1.Expires = DateTime.Now.AddDays(3); cookie2.Expires = DateTime.Now.AddDays(3); Response.Cookies.Add(cookie1); Response.Cookies.Add(cookie2); } Session["usermodel"] = usermodel; Session.Timeout = 3; Response.Redirect("SessionSuc.aspx"); } else { ErrorMsg = msg; } }
public bool Insert(Users_Model usr) { bool result = false; try { DBCon = new DBConnection(); sql = string.Format(@"INSERT INTO `cinema_simd`.`user` (`Name`, `Password`, `Status`, `Sex`, `BirthDate`, `Address`, `IsEmployee`) VALUES ('{0}', '{1}', '{2}', '{3}', '{4}', '{5}', '{6}');", usr._Name, usr._Password, usr._Status, usr._Sex, usr._BirthDate.ToString("yyyy-MM-dd"), usr._Address, usr._IsEmployee); DBCon.ConnectionOpen(); cmd = new MySqlCommand(sql, DBCon.Connection); result = cmd.ExecuteNonQuery() == 1; DBCon.ConnectionClose(); } catch (Exception ex) { Console.WriteLine(ex); } return(result); }
public bool Update(Users_Model usr) { bool result = false; try { DBCon = new DBConnection(); sql = string.Format(@"UPDATE `user` SET `name`='{0}', `password` = '{1}', `status` = '{2}', `sex` = '{3}', `birthDate` = '{4}', `Address` = '{5}', `IsEmployee` = '{6}' WHERE `user_Id` = '{7}';", usr._Name, usr._Password, usr._Status, usr._Sex, usr._BirthDate.ToString("yyyy-MM-dd"), usr.Address, usr.IsEmployee, usr.UserId); DBCon.ConnectionOpen(); cmd = new MySqlCommand(sql, DBCon.Connection); result = cmd.ExecuteNonQuery() == 1; DBCon.ConnectionClose(); } catch (Exception ex) { Console.WriteLine(ex); } return(result); }
public void ProcessRequest(HttpContext context) { context.Response.ContentType = "text/plain"; Users_Model usermodel = new Users_Model(); usermodel.LoginPwd = context.Request["txtpwd"]; usermodel.NickName = context.Request["txtnick"]; usermodel.Sex = context.Request["txtsex"]; usermodel.Age = Convert.ToInt32(context.Request["txtage"]); usermodel.FaceId = Convert.ToInt32(context.Request["txtface"]); usermodel.Friend = Convert.ToInt32(context.Request["txtfriend"]); usermodel.Name = context.Request["txtname"]; usermodel.StarId = Convert.ToInt32(context.Request["txtstar"]); usermodel.BloodId = Convert.ToInt32(context.Request["txtblood"]); BLL.User_Service userSer = new BLL.User_Service(); if (userSer.AddUser(usermodel)) { context.Response.Write("yes"); } else { context.Response.Write("no"); } }