public void ProcessRequest(HttpContext context) { page = (context.Request["page"] == null) ? 1 : int.Parse(context.Request["page"].ToString()); rows = (context.Request["rows"] == null) ? 20 : int.Parse(context.Request["rows"].ToString()); sort = (context.Request["sort"] == null) ? "processnumber desc" : context.Request["sort"].ToString(); order = (context.Request["order"] == null) ? "desc" : context.Request["order"].ToString(); string strUser = ((FormsIdentity)context.User.Identity).Ticket.UserData; user = JsonConvert.DeserializeObject <TBL_USER>(strUser); string action = context.Request["action"]; switch (action) { //获取列表 case "getPageList": getPageList(context); break; //获取列表 case "getList": getList(context); break; //删除 case "delete": delete(context); break; //个数 case "getCount": GetCount(context); break; //出入库操作 case "GetInoroutStock": GetInoroutStock(context); break; } }
private void getLoginUser(HttpContext context) { string json = ""; try { string strUser = ((FormsIdentity)context.User.Identity).Ticket.UserData; TBL_USER user = JsonConvert.DeserializeObject <TBL_USER>(strUser); List <TBL_USER> userList = userBLL.GetList(" and a.userid='" + user.userid + "' ").ToList <TBL_USER>(); if (userList.Count > 0) { user = userList[0]; json = "{IsSuccess:'true',Message:'" + JsonConvert.SerializeObject(user) + "'}"; } else { json = "{IsSuccess:'false',Message:'无此用户!'}"; } } catch (Exception ex) { logger.Error(ex.Message); json = "{IsSuccess:'false',Message:'操作失败!'}"; } json = JsonConvert.SerializeObject(json); context.Response.ContentType = "application/json"; //返回JSON结果 context.Response.Write(json); context.Response.End(); }
public ActionResult editUser(HttpPostedFile filename, TBL_USER model) { if (ModelState.IsValid) { try { var OldModel = db.TBL_USER.Where(X => X.USER_ID == model.USER_ID).FirstOrDefault(); OldModel.NAME = model.NAME; OldModel.ADDRESS = model.ADDRESS; OldModel.GENDER = model.GENDER; OldModel.DOB = model.DOB; OldModel.CONTACT = model.CONTACT; OldModel.IMAGE = model.IMAGE; if (filename != null) { string pic = System.IO.Path.GetExtension(filename.FileName); string name = Guid.NewGuid().ToString() + pic; string path = System.IO.Path.Combine( Server.MapPath("~/Contents/upload/Doctor"), name); // file is uploaded filename.SaveAs(path); OldModel.IMAGE = name; } db.SaveChanges(); return(Json(new { title = "Success", successMessage = "Successfully Updated !" })); } catch (Exception ex) { return(Json(new { title = "Error", errorMessage = ex.ToString() })); } } else { return(PartialView(model)); } }
public ActionResult Verify() { var id = Session["id"].ToString(); TBL_USER tu = new TBL_USER(); return(View(tu)); }
/// <summary> /// 修改TBL_USER表的数据 /// </summary> /// <param name="whereLambda"> (u=>u.userId == info.userId, info) == true </param> /// 判断有无userId /// <param name="info"> info是需要修改的信息 </param> /// <notice>权限信息的修改需要判断用户身份</notice> /// <notice>修改密码用专门的方法来修改,这里只管资料</notice> public static Boolean UpdateUserInfo(Expression <Func <TBL_USER, bool> > whereLambda, TBL_USER info) { try { using (LampNetEntities db = new LampNetEntities()) { DbQuery <TBL_USER> dataObject = db.TBL_USER.Where(whereLambda) as DbQuery <TBL_USER>; TBL_USER oldInfo = dataObject.FirstOrDefault(); oldInfo.userName = info.userName; oldInfo.userSex = info.userSex; oldInfo.userPhone = info.userPhone; oldInfo.userWechat = info.userWechat; oldInfo.userStatus = info.userStatus; oldInfo.userLlogtime = info.userLlogtime; oldInfo.userExptime = info.userExptime; oldInfo.userAut = info.userAut; oldInfo.userNote = info.userNote; db.SaveChanges(); return(true); } } catch { return(false); } }
public ActionResult addUser(TBL_USER model) { if (ModelState.IsValid) { //var result = db.TBL_DISEASE.Create(model) model.USER_ID = db.TBL_USER.Add(model).USER_ID; model.PASSWORD = com.EncodePass(model.PASSWORD, "shpud"); db.SaveChanges(); if (model.USER_ID > 0) { return(Json(new { successMessage = "Successfully Registered!" })); } else { Response.StatusCode = (int)HttpStatusCode.SeeOther; return(Json(new { errorMessage = "Something went wrong!" })); } } else { return(PartialView(model)); } }
public IHttpActionResult Put(int id, TBL_USER tBL_USER) { if (!ModelState.IsValid) { return(BadRequest(ModelState)); } if (id != tBL_USER.ID) { return(BadRequest()); } db.Entry(tBL_USER).State = EntityState.Modified; try { db.SaveChanges(); } catch (DbUpdateConcurrencyException) { if (!Exists(id)) { return(NotFound()); } else { throw; } } return(StatusCode(HttpStatusCode.NoContent)); }
public string Login(TBL_USER user) { try { //从数据库中查找数据 TBL_USER[] users_array = Areas.ToolsHelper.SelectTools.SelectUserInfo(u => u.userId == user.userId, u => u.userId); //string MD5Pwd = Areas.MD5Helper.MD5Helper.encrypt(user.userPwd.Trim()); if (users_array == null) { Response.Write("<script>alert('用户名错误!');</script>"); Response.Redirect(Url.Action("Index", "Login", new { area = "" })); } //取密码 string Pwd = users_array[0].userPwd.ToString(); if (Pwd != null && Pwd == users_array[0].userPwd) { HttpCookie cookieName = new HttpCookie("userId"); cookieName.Value = users_array[0].userName; cookieName.Expires = DateTime.Now.AddHours(1); System.Web.HttpContext.Current.Response.Cookies.Add(Areas.CookiesHelper.CookiesHelper.creatCookieHours("userId", users_array[0].ToString(), 1)); System.Web.HttpContext.Current.Response.Cookies.Add(cookieName); Response.Redirect(Url.Action("Index", "MainIndex", new { area = "" })); return("登录成功"); } else { return("密码错误"); } } catch (Exception ex) { return(ex.ToString()); } }
private void btnSave_Click(object sender, EventArgs e) { conn.Open(); SqlCommand command = new SqlCommand("SELECT USER_USERNAME FROM TBL_USERS WHERE USER_USERNAME LIKE'" + txtUsername.Text + "'", conn); string get_uname = Convert.ToString(command.ExecuteScalar()); conn.Close(); if (txtLastname.Text == "" || txtFirstname.Text == "" || txtMiddlename.Text == "" || txtUsername.Text == "" || txtPassword.Text == "" || txtContactNo.Text == "" || PB_image.ImageLocation == null) { MessageBox.Show("Information Required! Please fill out the necessary fields", "Ooops !", MessageBoxButtons.OK, MessageBoxIcon.Hand); } else if (txtUsername.Text == get_uname) { MessageBox.Show("Username exist already", "Ooops !", MessageBoxButtons.OK, MessageBoxIcon.Hand); } else { Control_variables.type = "Administrator"; TBL_USER u = new TBL_USER(); string dateNow = DateTime.Now.ToShortDateString(); u.USER_IMAGE = Control_variables.img; Image im = Image.FromFile(Control_variables.img); u.USER_IMAGE = Photo.byteArrayToBase64String(Photo.imageToByteArray(im)); db.SP_USERSAVE(txtLastname.Text, txtFirstname.Text, txtMiddlename.Text, txtUsername.Text, txtPassword.Text, txtContactNo.Text, Control_variables.type, int.Parse(cmbutype.SelectedValue.ToString()), Control_variables.img); MessageBox.Show("Successfully Saved!", "", MessageBoxButtons.OK, MessageBoxIcon.Information); ClearAll(); } }
private void btnSave_Click(object sender, EventArgs e) { if (!Invalid()) { try { using (TBL_USER_DATA_ACCESS uda = new TBL_USER_DATA_ACCESS()) { TBL_USER user = new TBL_USER(); user.USERNAME = txtUsername.Text.Trim(); user.PASSWORD = uda.Encrypt(txtPassword.Text.Trim(), true); user.IS_ACTIVE = true; uda.SaveUser(user); this.Close(); } } catch (Exception ex) { MessageBox.Show(ex.ToString(), "Error", MessageBoxButtons.OKCancel, MessageBoxIcon.Error); } } else { } }
private void btnDelete_Click(object sender, EventArgs e) { USER_ID = 0; try { foreach (DataGridViewRow row in dataGridViewUser.SelectedRows) { USER_ID = Convert.ToInt32(row.Cells[0].Value); } //MessageBox.Show(SEASON_ID.ToString()); if (USER_ID != 0) { using (LicenseDataContext _context = new LicenseDataContext()) { TBL_USER user = (from u in _context.TBL_USERs where u.USER_ID == USER_ID select u).FirstOrDefault(); user.IS_ACTIVE = false; _context.SubmitChanges(); }; } } catch (Exception ex) { MessageBox.Show(ex.ToString(), "Error", MessageBoxButtons.OKCancel, MessageBoxIcon.Error); } finally { using (TBL_USER_DATA_ACCESS uda = new TBL_USER_DATA_ACCESS()) { dataGridViewUser.DataSource = uda.ShowUserAllIncludeInActive(); } GC.Collect(); } }
private void btnSave_Click(object sender, EventArgs e) { if (!Invalid()) { try { using (TBL_USER_DATA_ACCESS uda = new TBL_USER_DATA_ACCESS()) { using (_contex = new LicenseDataContext()) { TBL_USER user = (from u in _contex.TBL_USERs where u.USER_ID == ControlUser.USER_ID select u).FirstOrDefault(); user.PASSWORD = user_data.Encrypt(txtPwdNew.Text.Trim(), true); _contex.SubmitChanges(); } } this.Close(); } catch (Exception ex) { MessageBox.Show(ex.ToString(), "Error", MessageBoxButtons.OKCancel, MessageBoxIcon.Error); } } else { } }
private void updatepaw(HttpContext context) { string userid = context.Request["userid"]; string password = context.Request["password"]; string json = ""; TBL_USER user = new TBL_USER(); user.userid = userid; user.password = FormsAuthentication.HashPasswordForStoringInConfigFile(password, "MD5"); try { if (userBLL.UpdatePwd(user)) { json = "{IsSuccess:'false',Message:'操作成功!'}"; } else { json = "{IsSuccess:'false',Message:'操作失败!'}"; } } catch (Exception ex) { logger.Error(ex.Message); json = "{IsSuccess:'false',Message:'操作失败!'}"; //json = JsonConvert.SerializeObject("{IsSuccess:'false',Message:'保存失败!'}"); } json = JsonConvert.SerializeObject(json); context.Response.ContentType = "application/json"; //返回JSON结果 context.Response.Write(json); context.Response.End(); }
public bool RemoveUser(long userID) { return(m_Locker.Synchronized(userID, () => { var deleted = TBL_USER.Remove(userID); if (!deleted) { return false; } var posts = TBL_USERPOST.Get(userID) as List <long>; if (posts == null) { return true; } TBL_USERPOST.Remove(userID); //todo Rewrite with table.RemoveReturning() foreach (var postID in posts) { TBL_POST.Remove(postID); } return true; })); }
public IHttpActionResult Post(TBL_USER tBL_USER) { if (!ModelState.IsValid) { return(BadRequest(ModelState)); } db.TBL_USER.Add(tBL_USER); try { db.SaveChanges(); } catch (DbUpdateException) { if (Exists(tBL_USER.ID)) { return(Conflict()); } else { throw; } } return(CreatedAtRoute("DefaultApi", new { id = tBL_USER.ID }, tBL_USER)); }
/// <summary> /// 获取当前登陆人的部门id /// </summary> /// <param name="context"></param> /// <returns></returns> public static string getOrgId(HttpContext context) { string strUser = ((FormsIdentity)context.User.Identity).Ticket.UserData; TBL_USER user = JsonConvert.DeserializeObject <TBL_USER>(strUser); //获取当前用户信息 return(user.organizationid); }
//获取图标需要的数据 private void getContainer(HttpContext context) { string json = ""; //1.获取当前登录用户数据 string strUser = ((FormsIdentity)context.User.Identity).Ticket.UserData; TBL_USER user = JsonConvert.DeserializeObject <TBL_USER>(strUser); //2.获取则线图时间 string Data = context.Request["Date"].ToString() == "" ? DateTime.Now.ToString("yyyy-MM") : context.Request["Date"].ToString(); //string Data = "2016-12"; //出入账sql语句. string sql = "select SUM(amount) amount,CONVERT(varchar(10),appeardate,120) appeardate from tbl_capitalaccount_flowrecord where flowrecordtype='入账' and organizationid='" + user.organizationid + "' and CONVERT(varchar(7),appeardate,120)='" + Data + "' group by CONVERT(varchar(10),appeardate,120) ORDER BY appeardate"; string sql1 = " select SUM(amount) amount,CONVERT(varchar(10),appeardate,120) appeardate from tbl_capitalaccount_flowrecord where flowrecordtype='出账' and organizationid='" + user.organizationid + "' and CONVERT(varchar(7),appeardate,120)='" + Data + "' group by CONVERT(varchar(10),appeardate,120) ORDER BY appeardate"; IList <MODEL.Capital.TBL_CAPITALACCOUNT_FLOWRECORD> flowList = flowBll.GetListByOrgan(sql); IList <MODEL.Capital.TBL_CAPITALACCOUNT_FLOWRECORD> flowList1 = flowBll.GetListByOrgan(sql1); Dictionary <string, object> obj = new Dictionary <string, object>(); int days = DateTime.DaysInMonth(DateTime.Now.Year, DateTime.Now.Month); obj.Add("total", days); obj.Add("rows", flowList); obj.Add("total1", days); obj.Add("rows1", flowList1); json = JsonConvert.SerializeObject(obj); context.Response.ContentType = "application/json"; context.Response.Write(json); context.ApplicationInstance.CompleteRequest(); }
private void getCount(HttpContext context) { //1. 获取前端参数 string flowrecordtype = context.Request["flowrecordtype"].ToString(); string source = context.Request["source"].ToString(); string organization = ""; if (context.Request["Oneself"].ToString() == "1") { string strUser = ((FormsIdentity)context.User.Identity).Ticket.UserData; TBL_USER user = JsonConvert.DeserializeObject <TBL_USER>(strUser); organization = user.organizationid; } else { organization = context.Request["Organization"].ToString(); } string appeardate = context.Request["StartTime"].ToString(); string endDate = context.Request["EndTime"].ToString(); string sql = ""; string json = ""; if (!string.IsNullOrEmpty(flowrecordtype) && flowrecordtype != "全部") { sql += " and flowrecordtype='" + flowrecordtype + "'"; } if (!string.IsNullOrEmpty(source) && source != "全部") { sql += " and source='" + source + "'"; } if (!string.IsNullOrEmpty(organization) && organization != "全部") { organization = CFunctions.getChildByParentId(organization); sql += " and organizationid in(" + organization + ")"; } if (!string.IsNullOrEmpty(appeardate)) { sql += " and Convert(varchar(10),appeardate,120)>='" + Convert.ToDateTime(appeardate) + "'"; } if (!string.IsNullOrEmpty(endDate)) { sql += " and Convert(varchar(10),appeardate,120)<='" + Convert.ToDateTime(endDate) + "'"; } try { int count = flowBll.GetCount(sql); json = "{\"IsSuccess\":\"true\",\"Count\":" + count + "}"; } catch { json = "{\"IsSuccess\":\"false\",\"Count\":0}"; } context.Response.ContentType = "application/json"; //返回JSON结果 context.Response.Write(json); context.Response.End(); }
public void SaveUser(TBL_USER user) { using (_context = new LicenseDataContext()) { _context.TBL_USERs.InsertOnSubmit(user); _context.SubmitChanges(); } }
//获取登录人的经办 public static string getMyHandledTask(HttpContext context) { TBL_USER user = getUser(context); List <WorkFlow.Model.FLOW_TASK> taskList = WorkFlow.BLL.Operate.getMyHandledTask(user.userid, "", "", ""); List <WorkFlow.Model.FLOW_TASK> fiveList = (from p in taskList select p).Take(4).ToList(); string json = JsonConvert.SerializeObject(fiveList); return(json); }
public ActionResult UserSelect(TBL_USER user) { try { if (user.userId != 0) { int sumPage = GetSumPage(30); int nowPage = 1; TBL_USER[] allInfo = GetPagedList(1, 30, u => u.userId == u.userId, u => u.userId); ViewBag.nowPage = nowPage; ViewBag.sumPage = sumPage; TBL_USER[] info = SelectTools.SelectUserInfo(u => u.userId == user.userId, u => u.userId); if (info == null || info.Length == 0) { return(Content("没有此展示!")); } ViewBag.allInfo = allInfo; ViewBag.info = info; HttpCookie cookie = Request.Cookies["userId"]; if (cookie.Name != null) { ViewBag.user = cookie.Value; } return(View()); } else { int sumPage = GetSumPage(30); int nowPage = 1; TBL_USER[] allInfo = GetPagedList(1, 30, u => u.userId == u.userId, u => u.userId); ViewBag.nowPage = nowPage; ViewBag.sumPage = sumPage; TBL_USER[] info = SelectTools.SelectUserInfo(u => u.userName == user.userName, u => u.userId); if (info == null || info.Length == 0) { return(Content("没有此展示!")); } ViewBag.allInfo = allInfo; ViewBag.info = info; HttpCookie cookie = Request.Cookies["userId"]; if (cookie.Name != null) { ViewBag.user = cookie.Value; } return(View()); } } catch { return(Content("查询失败!(ERROR)")); } }
private void getList(HttpContext context) { //1. 获取前端参数 string flowrecordtype = context.Request["flowrecordtype"].ToString(); string source = context.Request["source"].ToString(); string organization = ""; if (context.Request["Oneself"].ToString() == "1") { string strUser = ((FormsIdentity)context.User.Identity).Ticket.UserData; TBL_USER user = JsonConvert.DeserializeObject <TBL_USER>(strUser); organization = user.organizationid; } else { organization = context.Request["Organization"].ToString(); } string appeardate = context.Request["StartTime"].ToString(); string endDate = context.Request["EndTime"].ToString(); string json = ""; string sql = " select A.flowrecordid,A.organizationid,A.capitalaccountid,A.flowrecordtype,A.amount,convert(varchar(11),A.appeardate,120) appeardate,A.processnumber,A.source,B.organizationname from tbl_capitalaccount_flowrecord A inner join TBL_ORGANIZATION B ON(A.organizationid=B.organizationid)"; if (!string.IsNullOrEmpty(flowrecordtype) && flowrecordtype != "全部") { sql += " and flowrecordtype='" + flowrecordtype + "'"; } if (!string.IsNullOrEmpty(source) && source != "全部") { sql += " and source='" + source + "'"; } if (!string.IsNullOrEmpty(organization) && organization != "全部") { organization = CFunctions.getChildByParentId(organization); sql += " and A.organizationid in(" + organization + ")"; } if (!string.IsNullOrEmpty(appeardate)) { sql += " and Convert(varchar(10),A.appeardate,120)>='" + Convert.ToDateTime(appeardate) + "'"; } if (!string.IsNullOrEmpty(endDate)) { sql += " and Convert(varchar(10),A.appeardate,120)<='" + Convert.ToDateTime(endDate) + "'"; } int count = 0; int tocount = 0; IList <MODEL.Capital.TBL_CAPITALACCOUNT_FLOWRECORD> obj = flowBll.GetPageList(sql, sort + " " + order, page, rows, out count, out tocount); if (obj.Count > 0) { json = JsonConvert.SerializeObject(obj); } context.Response.ContentType = "application/json"; context.Response.Write(json); context.ApplicationInstance.CompleteRequest(); }
private void getUser(HttpContext context) { string strUser = ((FormsIdentity)context.User.Identity).Ticket.UserData; TBL_USER user = JsonConvert.DeserializeObject <TBL_USER>(strUser); string json = JsonConvert.SerializeObject(user); context.Response.ContentType = "application/json"; context.Response.Write(json); context.ApplicationInstance.CompleteRequest(); }
public IHttpActionResult Get(int id) { TBL_USER tBL_USER = db.TBL_USER.Find(id); if (tBL_USER == null) { return(NotFound()); } return(Ok(tBL_USER)); }
public HttpResponseMessage Post(int id, [FromBody] TBL_USER value) { if (id == 0) { db.TBL_USER.Add(value); } else { db.Entry(value).State = EntityState.Modified; } return(ToJson(db.SaveChanges())); }
public IHttpActionResult Delete(int id) { TBL_USER tBL_USER = db.TBL_USER.Find(id); if (tBL_USER == null) { return(NotFound()); } db.TBL_USER.Remove(tBL_USER); db.SaveChanges(); return(Ok(tBL_USER)); }
public List <TBL_USER> Search(TBL_USER e, DateTime?startDatetime = null, DateTime?finishDatetime = null, int?userGroupId = 0) { userGroupId = userGroupId ?? 0; finishDatetime = finishDatetime == null ? (DateTime?)null : finishDatetime.Value.AddHours(23).AddMinutes(59).AddSeconds(59); var q = _dal.Get(k => k.STATUS && (string.IsNullOrEmpty(e.NAME) || (k.NAME == null || k.NAME.ToUpper().Contains(e.NAME.ToUpper()))) && (string.IsNullOrEmpty(e.SURNAME) || (k.SURNAME == null || k.SURNAME.ToUpper().Contains(e.SURNAME.ToUpper()))) && (string.IsNullOrEmpty(e.USERNAME) || (k.USERNAME == null || k.USERNAME.ToUpper().Contains(e.USERNAME.ToUpper()))) && (string.IsNullOrEmpty(e.EMAIL) || (k.EMAIL == null || k.EMAIL.ToUpper().Contains(e.EMAIL.ToUpper()))) && (userGroupId == 0 || k.TBL_USER_PERMISSION.Any(a => a.USERGROUP_ID == userGroupId)) ).OrderBy(o => o.NAME).ThenBy(t => t.SURNAME).ToList(); return(q); }
public async Task <TBL_USER> Register(TBL_USER user, string password) { byte[] passwordHash, passwordSalt; CreatePasswordhash(password, out passwordHash, out passwordSalt); //out passes a ref of passwordHash user.A_PASSWORD_HASH = passwordHash; user.A_PASSWORD_SALT = passwordSalt; await _context.TBL_USER.AddAsync(user); await _context.SaveChangesAsync(); return(user); }
public ActionResult Login(TBL_USER model) { try { var user = db.TBL_USER.Where(x => x.EMAIL == model.EMAIL).FirstOrDefault(); if (user != null) { var enpas = com.EncodePass(model.PASSWORD, "shpud"); var userpass = db.TBL_USER.Where(x => x.PASSWORD == enpas && x.EMAIL == model.EMAIL).FirstOrDefault(); if (userpass != null) { if (user.STATUS == "Unverified") { Session["id"] = user.USER_ID; return(Json(new { success = true, verified = false, error = false, successMessage = "Verification Needed" })); } else { int userid = user.USER_ID; Session["userid"] = userid; Session["fullname"] = user.NAME; Session["email"] = user.EMAIL; Session["role"] = user.ROLE; string[] name = Session["fullname"].ToString().Split(' '); Session["firstname"] = name[0]; return(Json(new { success = true, verified = true, error = false, successMessage = "Logged in Successfully", role = Session["role"].ToString() })); } //return RedirectToAction("Dashboard", "Admin", new {userid=user }); } else { //Response.StatusCode = (int)HttpStatusCode.SeeOther; return(Json(new { success = false, error = true, title = "Password Incorrect", errorMessage = "Please recheck your password and try again! " })); } } else { //Response.StatusCode = (int)HttpStatusCode.SeeOther; return(Json(new { success = false, error = true, title = "Incorrect Email", errorMessage = "No user found with this email.\n Please rechek your email Address!" })); } } catch (Exception ex) { Response.StatusCode = (int)HttpStatusCode.SeeOther; return(Json(new { success = false, error = true, title = "Server Error", errorMessage = ex.ToString() })); } }
private void btnUpdatepass_Click(object sender, EventArgs e) { DataClasses1DataContext db = new DataClasses1DataContext(); int count = 0; if (txtOldpass.Text == "" || txtNewpass.Text == "" || txtRetypepass.Text == "") { MessageBox.Show("Please input data", "Ooops !", MessageBoxButtons.OK, MessageBoxIcon.Hand); } else { var scan = db.SP_VERIFYPASSWORD(txtUserID.Text, txtOldpass.Text); db.SubmitChanges(); foreach (SP_VERIFYPASSWORDResult user in scan) { count++; if (txtNewpass.Text.Length >= 8) { if (txtNewpass.Text == txtRetypepass.Text) { user.USER_PASSWORD = txtNewpass.Text; db.SP_CHANGEPASSWORD(Control_variables.current_id, user.USER_PASSWORD); TBL_USER user2 = new TBL_USER(); MessageBox.Show("Password Successfully Changed", "Success !", MessageBoxButtons.OK, MessageBoxIcon.Information); //CLEAR TEXTBOXES txtOldpass.Clear(); txtNewpass.Clear(); txtRetypepass.Clear(); groupChangePass.Visible = false; } else { MessageBox.Show("Password did not match", "Ooops !", MessageBoxButtons.OK, MessageBoxIcon.Hand); } } else { MessageBox.Show("Password must be contain atleast 8 characters long ", "Ooops !", MessageBoxButtons.OK, MessageBoxIcon.Hand); } } if (count == 0) { MessageBox.Show("Old password Incorrect", "Ooops !", MessageBoxButtons.OK, MessageBoxIcon.Hand); } } }