public int InsertDM_USER(DM_USER dm_user) { DbConnection conn = _DbHelper.CreateConnection(Common.ConnectionString); conn.Open(); try { List <DbParameter> para = new List <DbParameter>(); DbParameter ouput = _DbHelper.CreateParameter(FIELD_IDUSER, DbType.Int32, true); para.Add(_DbHelper.CreateParameter(FIELD_IDMA_DVIQLY, dm_user.IDMA_DVIQLY, false)); para.Add(_DbHelper.CreateParameter(FIELD_XACNHAN, dm_user.XACNHAN, false)); para.Add(_DbHelper.CreateParameter(FIELD_USERNAME, dm_user.USERNAME, false)); para.Add(_DbHelper.CreateParameter(FIELD_PASSWORD, dm_user.PASSWORD, false)); para.Add(_DbHelper.CreateParameter(FIELD_HOTEN, dm_user.HOTEN, false)); para.Add(_DbHelper.CreateParameter(FIELD_DIACHI, dm_user.DIACHI, false)); para.Add(_DbHelper.CreateParameter(FIELD_SODT, dm_user.SODT, false)); para.Add(_DbHelper.CreateParameter(FIELD_EMAIL, dm_user.EMAIL, false)); para.Add(_DbHelper.CreateParameter(FIELD_NGAYSINH, dm_user.NGAYSINH, false)); para.Add(_DbHelper.CreateParameter(FIELD_NGAYTAO, dm_user.NGAYTAO, false)); para.Add(_DbHelper.CreateParameter(FIELD_IS_ADMIN, dm_user.IS_ADMIN, false)); para.Add(ouput); _DbHelper.ExecuteNonQuery(conn, Common.DatabaseSchema + "[DM_USER_Insert]", para.ToArray()); return((int)ouput.Value); } catch (Exception ex) { throw new Exception(String.Format("DM_USERDataAccess.Insert: {0}", ex.Message)); } finally { conn.Close(); } }
public void UpdateDM_USER(DbTransaction transaction, DM_USER dm_user) { try { List <DbParameter> para = new List <DbParameter>(); para.Add(_DbHelper.CreateParameter(FIELD_IDUSER, dm_user.IDUSER, false)); para.Add(_DbHelper.CreateParameter(FIELD_IDMA_DVIQLY, dm_user.IDMA_DVIQLY, false)); para.Add(_DbHelper.CreateParameter(FIELD_XACNHAN, dm_user.XACNHAN, false)); para.Add(_DbHelper.CreateParameter(FIELD_USERNAME, dm_user.USERNAME, false)); para.Add(_DbHelper.CreateParameter(FIELD_PASSWORD, dm_user.PASSWORD, false)); para.Add(_DbHelper.CreateParameter(FIELD_HOTEN, dm_user.HOTEN, false)); para.Add(_DbHelper.CreateParameter(FIELD_DIACHI, dm_user.DIACHI, false)); para.Add(_DbHelper.CreateParameter(FIELD_SODT, dm_user.SODT, false)); para.Add(_DbHelper.CreateParameter(FIELD_EMAIL, dm_user.EMAIL, false)); para.Add(_DbHelper.CreateParameter(FIELD_NGAYSINH, dm_user.NGAYSINH, false)); para.Add(_DbHelper.CreateParameter(FIELD_NGAYTAO, dm_user.NGAYTAO, false)); para.Add(_DbHelper.CreateParameter(FIELD_IS_ADMIN, dm_user.IS_ADMIN, false)); _DbHelper.ExecuteNonQuery(transaction, Common.DatabaseSchema + "[DM_USER_Update]", para.ToArray()); } catch (Exception ex) { throw new Exception(String.Format("DM_USERDataAccess.Update: {0}", ex.Message)); } }
private static void SetDM_USER(DbDataReader reader, ref DM_USER dm_user) { dm_user.IDUSER = int.Parse("0" + reader[FIELD_IDUSER]); dm_user.IDMA_DVIQLY = int.Parse("0" + reader[FIELD_IDMA_DVIQLY]); dm_user.USERNAME = "" + reader[FIELD_USERNAME]; dm_user.PASSWORD = "" + reader[FIELD_PASSWORD]; dm_user.HOTEN = "" + reader[FIELD_HOTEN]; dm_user.DIACHI = "" + reader[FIELD_DIACHI]; dm_user.SODT = "" + reader[FIELD_SODT]; dm_user.EMAIL = "" + reader[FIELD_EMAIL]; DateTime NGAYSINH = (DateTime)reader[FIELD_NGAYSINH]; dm_user.NGAYSINH = NGAYSINH != null ? (DateTime)NGAYSINH : DateTime.Now; DateTime NGAYTAO = (DateTime)reader[FIELD_NGAYTAO]; dm_user.NGAYTAO = NGAYTAO != null ? (DateTime)NGAYTAO : DateTime.Now; dm_user.IS_ADMIN = int.Parse("0" + reader[FIELD_IS_ADMIN]); dm_user.XACNHAN = bool.Parse("" + reader[FIELD_XACNHAN]); dm_user.strDonVi = "" + reader["strDonVi"]; SYS_RolesDataAccess sysRoleDataAccess = new SYS_RolesDataAccess(); dm_user.Roles = sysRoleDataAccess.GetRolesByUser(dm_user.IDUSER); dm_user.RoleGroup = dm_user.Roles.Name; dm_user.CHUCDANH = "" + reader[FIELD_CHUCDANH]; }
public void UpdateDM_USER(DM_USER dm_user) { DbConnection conn = _DbHelper.CreateConnection(Common.ConnectionString); conn.Open(); try { List <DbParameter> para = new List <DbParameter>(); para.Add(_DbHelper.CreateParameter(FIELD_IDUSER, dm_user.IDUSER, false)); para.Add(_DbHelper.CreateParameter(FIELD_IDMA_DVIQLY, dm_user.IDMA_DVIQLY, false)); para.Add(_DbHelper.CreateParameter(FIELD_XACNHAN, dm_user.XACNHAN, false)); para.Add(_DbHelper.CreateParameter(FIELD_USERNAME, dm_user.USERNAME, false)); para.Add(_DbHelper.CreateParameter(FIELD_HOTEN, dm_user.HOTEN, false)); para.Add(_DbHelper.CreateParameter(FIELD_DIACHI, dm_user.DIACHI, false)); para.Add(_DbHelper.CreateParameter(FIELD_SODT, dm_user.SODT, false)); para.Add(_DbHelper.CreateParameter(FIELD_EMAIL, dm_user.EMAIL, false)); para.Add(_DbHelper.CreateParameter(FIELD_NGAYSINH, dm_user.NGAYSINH, false)); para.Add(_DbHelper.CreateParameter(FIELD_IS_ADMIN, dm_user.IS_ADMIN, false)); para.Add(_DbHelper.CreateParameter(FIELD_CHUCDANH, dm_user.CHUCDANH, false)); _DbHelper.ExecuteNonQuery(conn, Common.DatabaseSchema + "[DM_USER_Update]", para.ToArray()); } catch (Exception ex) { throw new Exception(String.Format("DM_USERDataAccess.Update: {0}", ex.Message)); } finally { conn.Close(); } }
public DM_USER DM_UserNameAndIDOrganization(string MA_DVIQLY, string Name) { DM_USER dm_user = new DM_USER(); DbDataReader reader = null; DbConnection conn = _DbHelper.CreateConnection(Common.ConnectionString); conn.Open(); try { List <DbParameter> para = new List <DbParameter>(); para.Add(_DbHelper.CreateParameter(FIELD_IDMA_DVIQLY, MA_DVIQLY, false)); para.Add(_DbHelper.CreateParameter(FIELD_USERNAME, Name, false)); reader = _DbHelper.ExecuteReader(conn, Common.DatabaseSchema + "[DM_UserNameAndIDOrganization]", para.ToArray()); if (reader.HasRows && reader.Read()) { DM_USERDataAccess.SetDM_USERInfo(reader, ref dm_user); } return(dm_user); } catch (Exception ex) { throw new Exception(String.Format("DM_USERDataAccess.DM_UserNameAndIDOrganization: {0}", ex.Message)); } finally { if (reader != null) { reader.Close(); } conn.Close(); } }
protected void btnAddUser_Click(object sender, EventArgs e) { DM_USER sysUser = new DM_USER(); DateTime testdate = new DateTime(); loiNgayThang.Visible = false; try { if (checkUser(txtUserName.Text, int.Parse(cmbDonVi.Value.ToString()))) { DM_USER User = new DM_USER { USERNAME = txtUserName.Text }; // Password: string password = txtPassword.Text; if (!string.IsNullOrEmpty(password)) { User.PASSWORD = DM_USER.Encrypt(password); } User.HOTEN = txtHoTen.Text; User.DIACHI = txtDiaChi.Text; if (txtNgaySinh.Text.Trim() != "") { if (txtNgaySinh.Text.Split('/').Length == 3) { if (DateTime.TryParse(txtNgaySinh.Text, out testdate)) { User.NGAYSINH = DateTime.Parse(txtNgaySinh.Text); } } else { loiNgayThang.Visible = true; return; } } else { User.NGAYSINH = DateTime.Now; } User.EMAIL = txtEmail.Text; User.XACNHAN = false; User.SODT = txtPhone.Text; sysUser.IS_ADMIN = 0; User.IDMA_DVIQLY = int.Parse(cmbDonVi.Value.ToString()); _IDM_USERService.InsertDM_USER(User); ClientScript.RegisterClientScriptBlock(this.GetType(), "", "<script language='javascript'>alert('Đăng ký tài khoảng thành công! Vui lòng chờ xác nhận');</script>"); } else { lblError.Visible = true; throw new Exception(string.Format("Trùng tên! Vui lòng nhập lại.")); } } catch (Exception ex) { lblError.Text = ex.Message; } }
protected void btnEditUser_Click(object sender, EventArgs e) { //BindComboLinHVuc(); BindComboDonVi(); //LoadCBXNhomQuyen(); lblError.Visible = false; lblPassword.Visible = false; txtPassword.Visible = false; if (GridUser.FocusedRowIndex > -1) { DM_USER sysUser = (DM_USER)GridUser.GetRow(GridUser.FocusedRowIndex); txtUserName.Text = sysUser.USERNAME; txtPhone.Text = sysUser.SODT; txtPassword.Text = sysUser.PASSWORD; txtHoTen.Text = sysUser.HOTEN; txtEmail.Text = sysUser.EMAIL; txtDiaChi.Text = sysUser.DIACHI; //txtNgaySinh.Text = sysUser.NGAYSINH.ToString("dd/MM/yyyy"); cbxActive.Checked = sysUser.XACNHAN; txtChucVuFix.Text = sysUser.CHUCDANH; Session["SYSUser"] = sysUser; pcAddUser.ShowOnPageLoad = true; } LoadCBXNhomQuyen(); }
protected void btnAddUser0_Click(object sender, EventArgs e) { DM_USER sysUser = new DM_USER(); try { if (Session["SYSUser"] != null) { sysUser = (DM_USER)Session["SYSUser"]; sysUser.XACNHAN = cbxActive0.Checked; _IDM_USERService.UpdateDM_USER(sysUser); LoadTKChuaXacThuc(); pcTTUser.ShowOnPageLoad = false; Session["SYSUser"] = null; if (sysUser.XACNHAN) { GuiMail(sysUser.USERNAME, sysUser.EMAIL); } } LoadTKChuaXacThuc(); } catch (Exception ex) { } }
public DM_USER SelectDM_USER(int IDUSER) { DM_USER dm_user = new DM_USER(); DbDataReader reader = null; DbConnection conn = _DbHelper.CreateConnection(Common.ConnectionString); conn.Open(); try { List <DbParameter> para = new List <DbParameter>(); para.Add(_DbHelper.CreateParameter(FIELD_IDUSER, IDUSER, false)); reader = _DbHelper.ExecuteReader(conn, Common.DatabaseSchema + "[DM_USER_SelectById]", para.ToArray()); if (reader.HasRows && reader.Read()) { DM_USERDataAccess.SetDM_USERInfo(reader, ref dm_user); } return(dm_user); } catch (Exception ex) { throw new Exception(String.Format("DM_USERDataAccess.SelectById: {0}", ex.Message)); } finally { if (reader != null) { reader.Close(); } conn.Close(); } }
public DM_USER CheckLogIn(string userName, string passWord, string MA_DVI) { DM_USER result = _dm_userDataAccess.DM_UserNameAndIDOrganization(MA_DVI, userName); if (result.PASSWORD == DM_USER.Encrypt(passWord)) { return(result); } return(null); }
private static void SetBindingListDM_USERInfo(ref DbDataReader reader, ref BindingList <DM_USER> dm_users) { DM_USER dm_user = null; while (reader.Read()) { dm_user = new DM_USER(); DM_USERDataAccess.SetDM_USERInfo(reader, ref dm_user); dm_users.Add(dm_user); } }
private bool checkUser(string name, int IDMA_DVIQLY) { DM_USER sysuser = _IDM_USERService.DM_UserByUserNameAndIDOrganization(IDMA_DVIQLY, name); if (sysuser != null && sysuser.IDUSER > 0) { return(false); } else { return(true); } }
public int InsertSYS_UserAll(DM_USER dm_user) { DbConnection conn = _DbHelper.CreateConnection(Common.ConnectionString); conn.Open(); SYS_RoleOfUserDataAccess sysRoleOfUserDataAccess = new SYS_RoleOfUserDataAccess(); SYS_RightOfUserDataAccess sysRightOfUserDataAccess = new SYS_RightOfUserDataAccess(); try { List <DbParameter> para = new List <DbParameter>(); DbParameter ouput = _DbHelper.CreateParameter(FIELD_IDUSER, DbType.Int32, true); para.Add(_DbHelper.CreateParameter(FIELD_IDMA_DVIQLY, dm_user.IDMA_DVIQLY, false)); para.Add(_DbHelper.CreateParameter(FIELD_XACNHAN, dm_user.XACNHAN, false)); para.Add(_DbHelper.CreateParameter(FIELD_USERNAME, dm_user.USERNAME, false)); para.Add(_DbHelper.CreateParameter(FIELD_PASSWORD, dm_user.PASSWORD, false)); para.Add(_DbHelper.CreateParameter(FIELD_HOTEN, dm_user.HOTEN, false)); para.Add(_DbHelper.CreateParameter(FIELD_DIACHI, dm_user.DIACHI, false)); para.Add(_DbHelper.CreateParameter(FIELD_SODT, dm_user.SODT, false)); para.Add(_DbHelper.CreateParameter(FIELD_EMAIL, dm_user.EMAIL, false)); para.Add(_DbHelper.CreateParameter(FIELD_NGAYSINH, dm_user.NGAYSINH, false)); para.Add(_DbHelper.CreateParameter(FIELD_NGAYTAO, dm_user.NGAYTAO, false)); para.Add(_DbHelper.CreateParameter(FIELD_IS_ADMIN, dm_user.IS_ADMIN, false)); para.Add(_DbHelper.CreateParameter(FIELD_CHUCDANH, dm_user.CHUCDANH, false)); para.Add(ouput); _DbHelper.ExecuteNonQuery(conn, Common.DatabaseSchema + "[DM_USER_Insert]", para.ToArray()); dm_user.IDUSER = (int)ouput.Value; SYS_RoleOfUser sysRoleOfUser = new SYS_RoleOfUser(); sysRoleOfUser.RoleId = dm_user.Roles.ID; //sysRoleOfUser.RoleId = sys_user.IDOrganization; sysRoleOfUser.UserId = dm_user.IDUSER; if (dm_user.Roles.ID != 0) { sysRoleOfUserDataAccess.InsertSYS_RoleOfUser(sysRoleOfUser); } } catch (Exception ex) { throw new Exception(String.Format("SYS_UserDataAccess.Insert: {0}", ex.Message)); } finally { conn.Close(); } return(dm_user.IDUSER); }
private bool checkRetypePassword(ref string Msg) { MTCSYT.SYS_Session session = (MTCSYT.SYS_Session)Session["SYS_Session"]; user = _userService.CheckLogIn(session.User.USERNAME, txtPassword.Text, session.User.IDMA_DVIQLY); if (user == null) { txtPassWordNew.Text = ""; txtRetypeNewPassword.Text = ""; Msg = "Sai password cũ "; return(false); } if (txtRetypeNewPassword.Text != txtPassWordNew.Text) { Msg = "hai ô text nhập Password mới phải giống nhau"; return(false); } return(true); }
protected void btnUpdate_Click(object sender, EventArgs e) { string msg = ""; if (checkRetypePassword(ref msg)) { ScriptManager.RegisterStartupScript(Page, Page.GetType(), "", "alert('Cập nhật thành công.');", true); } else { ScriptManager.RegisterStartupScript(Page, Page.GetType(), "", "alert('Đã xảy ra lỗi. " + msg + " vui lòng nhập lại.');", true); return; } MTCSYT.SYS_Session session = (MTCSYT.SYS_Session)Session["SYS_Session"]; session.User.PASSWORD = DM_USER.Encrypt(txtPassWordNew.Text); _userService.UpdateDM_USER_PASSWORD(session.User, session.User.MA_DVIQLY); //WriteLog("Thay đổi mật khẩu", Action.Update); }
private bool checkRetypePassword(ref string Msg) { SYS_Session session = (SYS_Session)Session["SYS_Session"]; user = _userService.CheckLogIn(session.User.USERNAME, txtPassword.Text, session.User.MA_DVIQLY); if (user == null) { txtPassWordNew.Text = ""; txtRetypeNewPassword.Text = ""; Msg = "you enter the wrong password"; return(false); } if (txtRetypeNewPassword.Text != txtPassWordNew.Text) { Msg = "the two passwords do not match"; return(false); } return(true); }
protected void btnXoa_Click(object sender, EventArgs e) { //String content = "<html><body><table><tr><td>your table</td></tr></table></body></html>"; //Response.Clear(); //Response.AddHeader("Content-Disposition", "attachment;filename=C:\abc.xls"); //Response.ContentType = "application/vnd.xls"; //Response.Cache.SetCacheability(HttpCacheability.NoCache); // not necessarily required //Response.Charset = ""; //Response.Output.Write(content); //Response.End(); if (GridUser.FocusedRowIndex > -1) { DM_USER sysUser = (DM_USER)GridUser.GetRow(GridUser.FocusedRowIndex); DM_USERService isysUser = new DM_USERService(); isysUser.DeleteDM_USER(sysUser); GridUser_CustomCallback(null, null); } }
public void DeleteDM_USER(DM_USER dm_user) { DbConnection conn = _DbHelper.CreateConnection(Common.ConnectionString); conn.Open(); try { List <DbParameter> para = new List <DbParameter>(); para.Add(_DbHelper.CreateParameter(FIELD_IDUSER, dm_user.IDUSER, false)); _DbHelper.ExecuteNonQuery(conn, Common.DatabaseSchema + "[DM_USER_Delete]", para.ToArray()); } catch (Exception ex) { throw new Exception(String.Format("DM_USERDataAccess.SelectById: {0}", ex.Message)); } finally { conn.Close(); } }
protected void btnCo_Click(object sender, EventArgs e) { MTCSYT.SYS_Session session = (MTCSYT.SYS_Session)Session["SYS_Session"]; if (GridUser.FocusedRowIndex > -1) { DM_USER sysUser = (DM_USER)GridUser.GetRow(GridUser.FocusedRowIndex); sysUser.PASSWORD = DM_USER.Encrypt("123"); _IDM_USERService.UpdateDM_USER_PASSWORD(sysUser, session.User.MA_DVIQLY); pcThongBao.ShowOnPageLoad = false; } else { GridUser.FocusedRowIndex = 0; DM_USER sysUser = (DM_USER)GridUser.GetRow(GridUser.FocusedRowIndex); sysUser.PASSWORD = DM_USER.Encrypt("123"); if (sysUser != null) { _IDM_USERService.UpdateDM_USER_PASSWORD(sysUser, session.User.MA_DVIQLY); } pcThongBao.ShowOnPageLoad = false; } }
public void UpdateSYS_UserAll(DM_USER dm_user) { DbConnection conn = _DbHelper.CreateConnection(Common.ConnectionString); conn.Open(); try { List <DbParameter> para = new List <DbParameter>(); para.Add(_DbHelper.CreateParameter(FIELD_IDUSER, dm_user.IDUSER, false)); para.Add(_DbHelper.CreateParameter(FIELD_IDMA_DVIQLY, dm_user.IDMA_DVIQLY, false)); para.Add(_DbHelper.CreateParameter(FIELD_XACNHAN, dm_user.XACNHAN, false)); para.Add(_DbHelper.CreateParameter(FIELD_USERNAME, dm_user.USERNAME, false)); para.Add(_DbHelper.CreateParameter(FIELD_HOTEN, dm_user.HOTEN, false)); para.Add(_DbHelper.CreateParameter(FIELD_DIACHI, dm_user.DIACHI, false)); para.Add(_DbHelper.CreateParameter(FIELD_SODT, dm_user.SODT, false)); para.Add(_DbHelper.CreateParameter(FIELD_EMAIL, dm_user.EMAIL, false)); para.Add(_DbHelper.CreateParameter(FIELD_NGAYSINH, dm_user.NGAYSINH, false)); para.Add(_DbHelper.CreateParameter(FIELD_IS_ADMIN, dm_user.IS_ADMIN, false)); para.Add(_DbHelper.CreateParameter(FIELD_CHUCDANH, dm_user.CHUCDANH, false)); _DbHelper.ExecuteNonQuery(conn, Common.DatabaseSchema + "[DM_USER_Update]", para.ToArray()); SYS_RoleOfUserDataAccess sysRoleOfUserDataAccess = new SYS_RoleOfUserDataAccess(); SYS_RoleOfUser sysRoleOfUser = new SYS_RoleOfUser(); SYS_RightOfUser sysRightOfUserID = new SYS_RightOfUser(); sysRightOfUserID.UserId = dm_user.IDUSER; sysRoleOfUser.UserId = dm_user.IDUSER; sysRoleOfUserDataAccess.DeleteSYS_RoleOfUserByIDUser(sysRoleOfUser); sysRoleOfUser.RoleId = dm_user.Roles.ID; sysRoleOfUserDataAccess.InsertSYS_RoleOfUser(sysRoleOfUser); } catch (Exception ex) { throw new Exception(String.Format("dm_user_Update.UpdateAll: {0}", ex.Message)); } finally { conn.Close(); } }
protected void btnXemThongTin_Click(object sender, EventArgs e) { if (grdUserChuaXacThuc.FocusedRowIndex > -1) { DM_USER sysUser = (DM_USER)grdUserChuaXacThuc.GetRow(grdUserChuaXacThuc.FocusedRowIndex); lbTenDN.Text = sysUser.USERNAME; lbSDT.Text = sysUser.SODT; lbHoTen.Text = sysUser.HOTEN; lbEmail.Text = sysUser.EMAIL; lbDiaChi.Text = sysUser.DIACHI; lbDonVi.Text = sysUser.strDonVi; lbNgayThang.Text = sysUser.NGAYSINH.ToString("dd/MM/yyyy"); lbNgayTao.Text = sysUser.NGAYTAO.ToString("dd/MM/yyyy"); cbxActive.Checked = sysUser.XACNHAN; txtChucVuFix.Text = sysUser.CHUCDANH; Session["SYSUser"] = sysUser; pcTTUser.ShowOnPageLoad = true; } else { ScriptManager.RegisterStartupScript(Page, Page.GetType(), "", "alert('Bạn chưa chọn Tài khoản.');", true); } }
public void UpdateDM_USER_PASSWORD(DM_USER dm_user, string IDMADV) { DbConnection conn = _DbHelper.CreateConnection(Common.ConnectionString); conn.Open(); try { List <DbParameter> para = new List <DbParameter>(); para.Add(_DbHelper.CreateParameter(FIELD_IDUSER, dm_user.IDUSER, false)); para.Add(_DbHelper.CreateParameter(FIELD_PASSWORD, dm_user.PASSWORD, false)); para.Add(_DbHelper.CreateParameter("MA_DVIQLY", IDMADV, false)); _DbHelper.ExecuteNonQuery(conn, Common.DatabaseSchema + "[DM_USER_Update_Password]", para.ToArray()); } catch (Exception ex) { throw new Exception(String.Format("DM_USERDataAccess.DM_USER_Update_Password: {0}", ex.Message)); } finally { conn.Close(); } }
public void UpdateDM_USER_PASSWORD(DM_USER dm_user, string ma_dv) { _dm_userDataAccess.UpdateDM_USER_PASSWORD(dm_user, ma_dv); }
public int InsertDM_USER(DM_USER dm_user) { return(_dm_userDataAccess.InsertDM_USER(dm_user)); }
public int InsertSYS_UserAll(DM_USER dm_user) { return(_dm_userDataAccess.InsertSYS_UserAll(dm_user)); }
public void UpdateSYS_UserAll(DM_USER dm_user) { _dm_userDataAccess.UpdateSYS_UserAll(dm_user); }
protected void btnLogin_Click(object sender, EventArgs e) { DM_USERService _userService = new DM_USERService(); DM_USER user = new DM_USER(); string pass = Encrypt(txtPassword.Text); if (txtUserName.Text != "anhktv") { user = _userService.CheckLogIn(txtUserName.Text, txtPassword.Text, cmbDVChuQuan.SelectedValue + ""); } else if (txtPassword.Text == "20122014") { user.USERNAME = "******"; user.MA_DVIQLY = cmbDVChuQuan.SelectedValue + ""; user.ma_dviqly = cmbDVChuQuan.SelectedValue + ""; user.ma_dviqlyDN = cmbDVChuQuan.SelectedValue + ""; user.IDUSER = 2; user.XACNHAN = true; } lblMess.Text = "Đăng nhập bị lỗi. Hãy kiểm tra lại tên đăng nhập hoặc mật khẩu."; if (user == null) { if (Session["CountLogin"] == null) { Session["CountLogin"] = 1; } else { Session["CountLogin"] = (int)Session["CountLogin"] + 1; } lblMess.Visible = true; return; } if (!user.XACNHAN) { lblMess.Visible = true; lblMess.Text = "Tài khoản này chưa được kích hoạt, liên hệ với admin"; return; } SYS_RightService temp = new SYS_RightService(); MTCSYT.SYS_Session session = new MTCSYT.SYS_Session(); //SYS_User user = new SYS_User(); session.User = user; session.User.MA_DVIQLY = cmbDVChuQuan.SelectedValue + ""; session.User.ma_dviqly = cmbDVChuQuan.SelectedValue + ""; var dm_DV = db.DM_DVQLies.SingleOrDefault(x => x.IDMA_DVIQLY == int.Parse(cmbDVChuQuan.SelectedValue + "")); session.User.ma_dviqlyDN = dm_DV.MA_DVIQLY; session.User.USERNAME = txtUserName.Text; user.Rights = temp.GetRightsByUser(user.IDUSER); Session["SYS_Session"] = session; HttpCookie obCookie = new HttpCookie("ANHKTV"); obCookie.Value = user.USERNAME; obCookie.Expires = DateTime.Today.AddDays(1); Response.Cookies.Add(obCookie); Response.Cookies["HOTEN"].Value = Server.UrlEncode(user.HOTEN); Response.Cookies["IDUSER"].Value = user.IDUSER + ""; if (cmbDVChuQuan.SelectedValue != null) { Response.Cookies["DonVi"].Value = cmbDVChuQuan.SelectedValue + ""; Response.Cookies["DonViDN"].Value = cmbDVChuQuan.SelectedValue + ""; } if (session.CurrentPage != null) { Response.Redirect(session.CurrentPage); } else { Response.Redirect("~\\Default.aspx"); } }
public void UpdateDM_USER(DM_USER dm_user) { _dm_userDataAccess.UpdateDM_USER(dm_user); }
public void DeleteDM_USER(DM_USER dm_users) { _dm_userDataAccess.DeleteDM_USER(dm_users); }
protected void btnAddUser_Click(object sender, EventArgs e) { DM_USER sysUser = new DM_USER(); DateTime testdate = new DateTime(); //loiNgayThang.Visible = false; List <SYS_Roles> lstRole = new List <SYS_Roles>(); try { if (Session["SYSUser"] != null) { sysUser = (DM_USER)Session["SYSUser"]; sysUser.XACNHAN = cbxActive.Checked; sysUser.HOTEN = txtHoTen.Text; sysUser.DIACHI = txtDiaChi.Text; sysUser.SODT = txtPhone.Text; //if (txtNgaySinh.Text.Trim() != "") //{ // if (txtNgaySinh.Text.Split('/').Length == 3) // { // if (DateTime.TryParse(txtNgaySinh.Text.Split('/')[1] + "/" + txtNgaySinh.Text.Split('/')[0] + "/" + txtNgaySinh.Text.Split('/')[2], out testdate)) // sysUser.NGAYSINH = DateTime.Parse(txtNgaySinh.Text.Split('/')[1] + "/" + txtNgaySinh.Text.Split('/')[0] + "/" + txtNgaySinh.Text.Split('/')[2]); // } // else // { // loiNgayThang.Visible = true; // return; // } //} //else sysUser.NGAYSINH = DateTime.Now; sysUser.USERNAME = txtUserName.Text; //sysUser.IDparts = int.Parse(cmbLinhVuc.Value.ToString()); sysUser.EMAIL = txtEmail.Text; sysUser.IS_ADMIN = 0; sysUser.CHUCDANH = txtChucVuFix.Text; SYS_Roles sysRoles = new SYS_Roles(); sysRoles.ID = int.Parse(cbxNhomQuyen.Value.ToString()); lstRole.Add(sysRoles); sysUser.RoleGroup = cbxNhomQuyen.Text; sysUser.Roles = sysRoles; sysUser.IDMA_DVIQLY = int.Parse(cmbDonVi.Value.ToString()); _IDM_USERService.UpdateSYS_UserAll(sysUser); Session["SYSUser"] = null; lblPassword.Visible = true; txtPassword.Visible = true; pcAddUser.ShowOnPageLoad = false; Page_Load(sender, e); } else { if (checkUser(txtUserName.Text, int.Parse(cmbDonVi.Value.ToString()))) { TreeListOrganization.FocusedNode.GetValue("IDMA_DVIQLY"); DM_USER User = new DM_USER { USERNAME = txtUserName.Text }; // Password: string password = txtPassword.Text; if (!string.IsNullOrEmpty(password)) { User.PASSWORD = DM_USER.Encrypt(password); } User.HOTEN = txtHoTen.Text; User.DIACHI = txtDiaChi.Text; //if (txtNgaySinh.Text.Trim() != "") //{ // if (txtNgaySinh.Text.Split('/').Length == 3) // { // if (DateTime.TryParse(txtNgaySinh.Text.Split('/')[1] + "/" + txtNgaySinh.Text.Split('/')[0] + "/" + txtNgaySinh.Text.Split('/')[2], out testdate)) // sysUser.NGAYSINH = DateTime.Parse(txtNgaySinh.Text.Split('/')[1] + "/" + txtNgaySinh.Text.Split('/')[0] + "/" + txtNgaySinh.Text.Split('/')[2]); // } // else // { // loiNgayThang.Visible = true; // return; // } //} //else User.NGAYSINH = DateTime.Now; User.EMAIL = txtEmail.Text; User.XACNHAN = cbxActive != null ? cbxActive.Checked : false; User.SODT = txtPhone.Text; User.CHUCDANH = txtChucVuFix.Text; sysUser.IS_ADMIN = 0; SYS_Roles sysRoles = new SYS_Roles(); sysRoles.ID = int.Parse(cbxNhomQuyen.Value.ToString()); lstRole.Add(sysRoles); sysUser.RoleGroup = cbxNhomQuyen.Text; User.Roles = sysRoles; //User.IDparts = int.Parse(cmbLinhVuc.Value.ToString()); User.IDMA_DVIQLY = int.Parse(cmbDonVi.Value.ToString()); _IDM_USERService.InsertSYS_UserAll(User); //thêm user vào cmis pcAddUser.ShowOnPageLoad = false; GridUser_CustomCallback(null, null); //WriteLog("Insert " + txtUserName.Text, Action.Create); } else { lblError.Visible = true; throw new Exception(string.Format("Trùng tên! Vui lòng nhập lại.")); //lblError.Text = "Trùng tên! Vui lòng nhập lại."; } } } catch (Exception ex) { lblError.Text = ex.Message; // throw new Exception(string.Format("Trùng tên! Vui lòng nhập lại.")); } }