protected void btnDelete_Click(object sender, EventArgs e)
{
var lstUsers = grvUsers.GetSelectedFieldValues(grvUsers.KeyFieldName);
int intCurrentUserID = Convert.ToInt32(Session["UserId"]);
if ((lstUsers != null) && (lstUsers.Count > 0)) //Disable
{
foreach (int i in lstUsers)
{
if (intCurrentUserID == i)
{
lbMessage.Text = "You can not delete your account";
return;
}
//delete info in all other table
deleteAllOtherTables(i);
TBL_NGUOI_DUNG objUser = entities.TBL_NGUOI_DUNG.Where(x => x.Id == i).FirstOrDefault();
entities.TBL_NGUOI_DUNG.Remove(objUser);
entities.SaveChanges();
}
Response.Redirect(Commons.ConstURL.URL_USER_VIEW);
}
else //No record to delte
{
Commons.ValidationFuncs.errorMessage_TimeDelay(Commons.TitleConst.getTitleConst("MSG_CHOOSE_ROW_TO_DELETE"), Page);
}
}
private void setInputs(TBL_NGUOI_DUNG objUserLogin)
{
objUserLogin.UserName = txtUsername.Text;
objUserLogin.FullName = txtFullName.Text;
objUserLogin.Email = txtEmail.Text;
if (!String.IsNullOrEmpty(txtPassword_1.Text))
{
objUserLogin.Password = Formats.GetMD5(txtPassword_1.Text);
}
objUserLogin.isEnabled = (bool)(cbActiveSatus.Checked ? true : false);
}
private void getOutputs(TBL_NGUOI_DUNG objUserLogin)
{
txtUsername.Text = objUserLogin.UserName;
txtFullName.Text = objUserLogin.FullName;
txtEmail.Text = objUserLogin.Email;
if (objUserLogin.isEnabled == true)
{
cbActiveSatus.Checked = true;
}
else
{
cbActiveSatus.Checked = false;
}
}
protected void btnSave_Click(object sender, EventArgs e)
{
int intVaiTroID = Convert.ToInt32(drpDS_Quyen.SelectedValue);
var lstUserId = grvUsers.GetSelectedFieldValues(grvUsers.KeyFieldName);
// Xóa user khỏi group nếu không chọn
var orgUserId = entities.TBL_NGUOI_DUNG_QUYEN.Where(x => x.ID_QUYEN == intVaiTroID).Select(x => x.ID_NGUOI_DUNG).ToList();
foreach (int u in orgUserId)
{
if (!lstUserId.Contains(u))
{
TBL_NGUOI_DUNG_QUYEN removeObj = entities.TBL_NGUOI_DUNG_QUYEN.FirstOrDefault(x => x.ID_QUYEN == intVaiTroID && x.ID_NGUOI_DUNG == u);
entities.TBL_NGUOI_DUNG_QUYEN.Remove(removeObj);
entities.SaveChanges();
}
}
// Thêm user vào group nếu chọn nhưng chưa có trong group
foreach (int i in lstUserId)
{
bool b = entities.TBL_NGUOI_DUNG_QUYEN.Where(x => x.ID_QUYEN == intVaiTroID && x.ID_NGUOI_DUNG == i).Any();
if (!b)
{
//Update status User
TBL_NGUOI_DUNG objNhanVien = entities.TBL_NGUOI_DUNG.Find(i);
//objNhanVien.isEnabled = false;
//Insert VAI_TRO cho USER
TBL_NGUOI_DUNG_QUYEN obj = new TBL_NGUOI_DUNG_QUYEN();
//if (entities.jos_rights_users.Count() > 0) obj.id = entities.jos_rights_users.Max(x => x.id) + 1;
//else obj.id=1;
obj.ID_QUYEN = (int)intVaiTroID;
obj.ID_NGUOI_DUNG = (int)i;
//obj.CREATED = obj.LASTMODIFY = DateTime.Now;
//obj.CREATEDBY = obj.MODIFYBY = CheckUserInfo.GetUserId();
entities.TBL_NGUOI_DUNG_QUYEN.Add(obj);
entities.SaveChanges();
}
}
//Display Message Box
Commons.ValidationFuncs.errorMessage_TimeDelay(Commons.TitleConst.getTitleConst("MSG_UPDATE_SUCCESFULLY"), Page);
}
protected void insert_TBL_NGUOI_DUNG(DataTable dt)
{
foreach (DataRow row in dt.Rows)
{
//Add User
TBL_NGUOI_DUNG objUserLogin = new TBL_NGUOI_DUNG();
objUserLogin.UserName = row["USER_NAME"].ToString().Trim();
objUserLogin.FullName = row["HO_VA_TEN"].ToString().Trim();
objUserLogin.Email = row["EMAIL"].ToString().Trim();
objUserLogin.Tel = row["DIEN_THOAI"].ToString().Trim();
objUserLogin.Password = Formats.GetMD5(strDefaultPass);
objUserLogin.isEnabled = true;
entities.TBL_NGUOI_DUNG.Add(objUserLogin);
entities.SaveChanges();
//Assign to Department
TBL_NGUOI_DUNG_PHONG_BAN objDept = new TBL_NGUOI_DUNG_PHONG_BAN();
objDept.UserID = objUserLogin.Id;
objDept.DepartmentID = 1;//1: Phong PTSPDVPM
objDept.isDeleted = false;
entities.TBL_NGUOI_DUNG_PHONG_BAN.Add(objDept);
entities.SaveChanges();
}
}
protected void btnSignIn_Click(object sender, EventArgs e)
{
try
{
//kiem tra xem co phai truy cap tu dong khong - check
/*if (Captcha.Code != Request.Params["tbCode"])
* {
* string alert = "Mã Captcha chưa đúng, yêu cầu nhập lại!";
* string alert2 = "Captcha code wrong, please try again!";
* lbNotice.Text = string.Format(@"<div class='alert alert-danger alert-dismissible fade in' role='alert'>
* <button type='button' class='close' data-dismiss='alert'>
* <span aria-hidden='true'>×</span>
* <span class='sr-only'>Close</span>
* </button>
* <strong>{0}</strong>
* </br>
* <strong class='english'>{1}</strong>
* </div>", alert, alert2);
* return;
* }*/
lbNotice.Text = String.Empty;
TBL_NGUOI_DUNG obj = null;
//if (ConfigurationManager.AppSettings["LDAPConnect"].ToUpper() == "TRUE")
{
//string username = txtUsername.Text + ConfigurationManager.AppSettings["LDAPDomain"];
//if (UserValidate(username, txtPassword.Text))
{
//int count = entities.USERLOGINs.ToList().Count;
string strPassword = Formats.GetMD5(txtPassword.Text);
//var lstUsers = entities.TBL_NGUOI_DUNG.Where(x => x.UserName.Equals(txtUsername.Text) && x.Password.Equals(strPassword) && ((bool)x.isEnabled)).ToList();
var lstUsers = entities.TBL_NGUOI_DUNG.Where(x => x.UserName.Equals(txtUsername.Text) && ((bool)x.isEnabled)).ToList();
if (lstUsers.Count > 1)
{
/*if (chkDoanhNghiep.Checked == true)
* {
* int idDoanhNghiep = Convert.ToInt32(cboDoanhNghiep.SelectedValue);
* obj = lstUsers.FirstOrDefault(x => x.IDDOANH_NGHIEP == idDoanhNghiep);
* }
* else
* {
* lbNotice.Text = "Chưa chọn doanh nghiệp!";
* return;
* }*/
}
else
{
obj = lstUsers.FirstOrDefault();
}
if (obj != null)
{
if (obj.isEnabled == false)
{
lbNotice.Text = "Tài khoản bị khóa!";
return;
}
Session[ATCL_Consts.SESSION_NAME_USER_ID] = obj.Id.ToString();
if (!String.IsNullOrEmpty(Request.QueryString["returnUrl"]))
{
Response.Redirect(Request.QueryString["returnUrl"].ToString());
}
else
{
Response.Redirect(Commons.TitleConst.getTitleConst("URL_HOME_PAGE"));
}
}
else
{
lbNotice.Text = "Tài khoản không có quyền truy cập!";
return;
}
}
/*else
* {
* lbNotice.Text = "Sai tên đăng nhập hoặc mật khẩu!";
* return;
* }*/
}
}
catch (Exception ex)
{
lbNotice.Text = "Lỗi: " + Formats.GetMD5(txtPassword.Text) + ex.Message + ex.TargetSite + ex.StackTrace;
}
}
protected void btnSubmit_Click(object sender, EventArgs e)
{
try
{
TBL_NGUOI_DUNG objSearchUser = new TBL_NGUOI_DUNG();
bool blPassword = true;
if (String.IsNullOrEmpty(txtUsername.Text))
{
Commons.ValidationFuncs.errorMessage_TimeDelay("You must type User name", Page);
return;
}
if (String.IsNullOrEmpty(txtFullName.Text))
{
Commons.ValidationFuncs.errorMessage_TimeDelay("You must type Full name", Page);
return;
}
if (String.IsNullOrEmpty(txtUserID.Text)) //Create New
{
entities.TBL_NGUOI_DUNG.Add(objSearchUser);
//Check Password
if (String.IsNullOrEmpty(txtPassword_1.Text) || String.IsNullOrEmpty(txtPassword_2.Text))
{
Commons.ValidationFuncs.errorMessage_TimeDelay("You must type the password", Page);
return;
}
}
else //Update
{
int intUserID = Convert.ToInt32(txtUserID.Text);
objSearchUser = entities.TBL_NGUOI_DUNG.Where(x => x.Id == intUserID).FirstOrDefault();
}
//check Password
if (!String.IsNullOrEmpty(txtPassword_1.Text))
{
if (!txtPassword_1.Text.Equals(txtPassword_2.Text))
{
blPassword = false;
}
}
else if (!String.IsNullOrEmpty(txtPassword_2.Text))
{
if (!txtPassword_2.Text.Equals(txtPassword_1.Text))
{
blPassword = false;
}
}
if (!blPassword)
{
Commons.ValidationFuncs.errorMessage_TimeDelay("Password is incorrect", Page);
return;
}
setInputs(objSearchUser);
entities.SaveChanges();
//Save into JOS_GROUPS_USERS tbl
var lstGrvObj = grvObj.GetSelectedFieldValues(grvObj.KeyFieldName);
if ((lstGrvObj != null) && (lstGrvObj.Count > 0)) //Disable
{
//delete all records in JOS_GROUPS_USERS tbl with User's ID
var lstDelete = entities.TBL_NGUOI_DUNG_PHONG_BAN.Where(x => x.UserID == objSearchUser.Id).ToList();
foreach (var itemDel in lstDelete)
{
entities.TBL_NGUOI_DUNG_PHONG_BAN.Remove(itemDel);
entities.SaveChanges();
}
//Insert into JOS_GROUPS_USERS
foreach (int item in lstGrvObj)
{
TBL_NGUOI_DUNG_PHONG_BAN objGroupUser = new TBL_NGUOI_DUNG_PHONG_BAN();
objGroupUser.DepartmentID = item;
objGroupUser.UserID = objSearchUser.Id;
entities.TBL_NGUOI_DUNG_PHONG_BAN.Add(objGroupUser);
entities.SaveChanges();
}
}
backURL();
}
catch (Exception ex)
{
lbMessage.Text = ex.Message;
}
}
