protected void btn_Save_Click(object sender, EventArgs e)
{
try
{
string pwdType = string.Empty;
string pwdCol = string.Empty;
string oldVal = string.Empty;
string newVal = string.Empty;
if (Convert.ToInt32(rcmb_UserManagersEmployee.SelectedItem.Value) > 0 && rtxt_UserManagerEmail.Text == string.Empty)
{
ViewState["PASSCODE"] = txt_PassCode.Text;
ViewState["PASSWORD"] = rtxt_UserManagerPassword.Text;
txt_PassCode.Attributes.Add("value", Convert.ToString(ViewState["PASSCODE"]));
rtxt_UserManagerPassword.Attributes.Add("value", Convert.ToString(ViewState["PASSWORD"]));
BLL.ShowMessage(this, "Please enter Email ID for this Employee in Employee screen");
return;
}
if ((rcmb_UserManagersEmployee.SelectedItem.Text == "Select") && rtxt_UserManagerEmail.Text == string.Empty)
{
ViewState["PASSCODE"] = txt_PassCode.Text;
ViewState["PASSWORD"] = rtxt_UserManagerPassword.Text;
txt_PassCode.Attributes.Add("value", Convert.ToString(ViewState["PASSCODE"]));
rtxt_UserManagerPassword.Attributes.Add("value", Convert.ToString(ViewState["PASSWORD"]));
BLL.ShowMessage(this, "Please Enter Email ID");
return;
}
if (rtxt_UserManagerPassword.Text.Length < 4 || rtxt_UserManagerPassword.Text.Length > 14)
{
BLL.ShowMessage(this, "Password Length Should be Minimum 4 & Maximum 14 Characters.");
return;
}
if (txt_PassCode.Text.Length < 4 || txt_PassCode.Text.Length > 14)
{
BLL.ShowMessage(this, "PassCode Length Should be Minimum 4 & Maximum 14 Characters.");
return;
}
if (Convert.ToInt32(Session["EMP_ID"]) != (-1))
{
StringBuilder sb = new StringBuilder();
IList <RadListBoxItem> collection = rlst_BusinessUnit.Items;
if (collection.Count != 0)
{
SMHR_LOGININFO _obj_Smhr_LoginInfo = new SMHR_LOGININFO();
//_obj_Smhr_LoginInfo.OPERATION = operation.CheckEmp;
//_obj_Smhr_LoginInfo.ORGANISATION_ID = Convert.ToInt32(Session["ORG_ID"]);
//_obj_Smhr_LoginInfo.LOGIN_EMP_ID = Convert.ToInt32(rcmb_UserManagersEmployee.SelectedItem.Value);
//DataTable dt_emp1 = new DataTable();
//dt_emp1 = BLL.get_emp(_obj_Smhr_LoginInfo);
//if (Convert.ToInt32(dt_emp1.Rows[0]["count"]) == 0)
//{
_obj_Smhr_LoginInfo.LOGIN_EMP_ID = Convert.ToInt32(rcmb_UserManagersEmployee.SelectedItem.Value);
_obj_Smhr_LoginInfo.LOGIN_TYPE = Convert.ToInt32(rcmb_UserManagerUserGroups.SelectedItem.Value);
_obj_Smhr_LoginInfo.LOGIN_USERNAME = BLL.ReplaceQuote(rtxt_UserManagerUserName.Text);
_obj_Smhr_LoginInfo.LOGIN_PASSWORD = BLL.PasswordEncrypt(BLL.ReplaceQuote(rtxt_UserManagerPassword.Text));
_obj_Smhr_LoginInfo.LOGIN_PASS_CODE = BLL.PasswordEncrypt(BLL.ReplaceQuote(txt_PassCode.Text));
_obj_Smhr_LoginInfo.LOGIN_EMAILID = BLL.ReplaceQuote(rtxt_UserManagerEmail.Text);
//_obj_Smhr_LoginInfo.LOGIN_STATUS = chk_UserManagerStatus.Checked;
if (rcmb_UserManagerStatus.SelectedValue == "1")
{
_obj_Smhr_LoginInfo.LOGIN_STATUS = true;
}
else
{
_obj_Smhr_LoginInfo.LOGIN_STATUS = false;
}
_obj_Smhr_LoginInfo.ORGANISATION_ID = Convert.ToInt32(rcmb_Organisation.SelectedValue);
_obj_Smhr_LoginInfo.CREATEDBY = Convert.ToInt32(Session["USER_ID"]); // ### Need to Get the Session
_obj_Smhr_LoginInfo.CREATEDDATE = DateTime.Now;
_obj_Smhr_LoginInfo.LASTMDFBY = Convert.ToInt32(Session["USER_ID"]); // ### Need to Get the Session
_obj_Smhr_LoginInfo.LASTMDFDATE = DateTime.Now;
string str = string.Empty;
foreach (RadListBoxItem item in rlst_BusinessUnit.Items)
{
str += item.Value + ",";
}
if (str.Length > 0)
{
str = str.Remove(str.Length - 1, 1);
}
_obj_Smhr_LoginInfo.LOGIN_BUSINESSUNITID = str;
switch (((Button)sender).ID.ToUpper())
{
case "BTN_UPDATE":
_obj_Smhr_LoginInfo.LOGIN_ID = Convert.ToInt32(lbl_UserManagerID.Text);
_obj_Smhr_LoginInfo.OPERATION = operation.Check;
_obj_Smhr_LoginInfo.ORGANISATION_ID = Convert.ToInt32(Session["ORG_ID"]);
if (Convert.ToString(BLL.get_LoginInfo(_obj_Smhr_LoginInfo).Rows[0]["Count"]) != "0")
{
BLL.ShowMessage(this, "User Name Already Exists");
return;
}
_obj_Smhr_LoginInfo.OPERATION = operation.Update;
_obj_Smhr_LoginInfo.ORGANISATION_ID = Convert.ToInt32(rcmb_Organisation.SelectedValue);
if (BLL.set_LoginInfo(_obj_Smhr_LoginInfo))
{
BLL.ShowMessage(this, "Information Updated Successfully");
}
else
{
BLL.ShowMessage(this, "Information Not Updated");
}
if (strPass != rtxt_UserManagerPassword.Text || strPass1 != txt_PassCode.Text) //for Login Password & Login Passcode
{
if (strPass1 != txt_PassCode.Text)
{
pwdType = "Pass Code";
pwdCol = "LOGIN_PASS_CODE";
oldVal = strPass1;
newVal = txt_PassCode.Text;
BLL.ExecuteNonQuery("EXEC USP_SMHR_AUDITTRAILS @OPERATION = 'INSERT',@SMHR_AUDIT_FORM_ID = '64', @SMHR_AUDIT_FORMNAME = 'Users', " +
"@SMHR_AUDIT_SUBFORMNAME = 'Users', @SMHR_AUDIT_TRANSACTIONDESC = 'Users - " + rtxt_UserManagerUserName.Text + " was updated" +
"', @SMHR_AUDIT_COLUMN = '" + pwdCol + "', " + "@SMHR_AUDIT_OLDVALUE = '" + oldVal + "', @SMHR_AUDIT_NEWVALUE = '" + newVal +
"',@SMHR_AUDIT_MODIFIEDBY = '" + Convert.ToInt32(Session["USER_ID"]) + "', " + "@SMHR_AUDIT_CONTROL_COLUMN = '" + pwdType + "'");
}
if (strPass != rtxt_UserManagerPassword.Text)
{
pwdType = "Password";
pwdCol = "LOGIN_PASSWORD";
oldVal = strPass;
newVal = rtxt_UserManagerPassword.Text;
BLL.ExecuteNonQuery("EXEC USP_SMHR_AUDITTRAILS @OPERATION = 'INSERT',@SMHR_AUDIT_FORM_ID = '64', @SMHR_AUDIT_FORMNAME = 'Users', " +
"@SMHR_AUDIT_SUBFORMNAME = 'Users', @SMHR_AUDIT_TRANSACTIONDESC = 'Users - " + rtxt_UserManagerUserName.Text + " was updated" +
"', @SMHR_AUDIT_COLUMN = '" + pwdCol + "', " + "@SMHR_AUDIT_OLDVALUE = '" + oldVal + "', @SMHR_AUDIT_NEWVALUE = '" + newVal +
"',@SMHR_AUDIT_MODIFIEDBY = '" + Convert.ToInt32(Session["USER_ID"]) + "', " + "@SMHR_AUDIT_CONTROL_COLUMN = '" + pwdType + "'");
}
}
break;
case "BTN_SAVE":
_obj_Smhr_LoginInfo.OPERATION = operation.Check;
_obj_Smhr_LoginInfo.ORGANISATION_ID = 0;
if (Convert.ToString(BLL.get_LoginInfo(_obj_Smhr_LoginInfo).Rows[0]["Count"]) != "0")
{
BLL.ShowMessage(this, "User Name already Exists");
return;
}
_obj_Smhr_LoginInfo.OPERATION = operation.CheckEmp;
_obj_Smhr_LoginInfo.ORGANISATION_ID = Convert.ToInt32(Session["ORG_ID"]);
_obj_Smhr_LoginInfo.LOGIN_EMP_ID = Convert.ToInt32(rcmb_UserManagersEmployee.SelectedItem.Value);
DataTable dt_emp = new DataTable();
dt_emp = BLL.get_emp(_obj_Smhr_LoginInfo);
if (Convert.ToInt32(dt_emp.Rows[0]["count"]) == 0)
{
_obj_Smhr_LoginInfo.OPERATION = operation.Insert;
_obj_Smhr_LoginInfo.ORGANISATION_ID = Convert.ToInt32(rcmb_Organisation.SelectedValue);
if (BLL.set_LoginInfo(_obj_Smhr_LoginInfo))
{
BLL.ShowMessage(this, "Information Saved Successfully");
}
else
{
BLL.ShowMessage(this, "Information Not Saved");
}
}
else
{
BLL.ShowMessage(this, "Selected Employee is already assigned");
return;
}
break;
default:
break;
}
Rm_UM_page.SelectedIndex = 0;
LoadGrid();
Rg_UserManager.DataBind();
//}
//else
//{
// BLL.ShowMessage(this, "Selected Employee is already assigned");
// return;
//}
}
else
{
BLL.ShowMessage(this, "Please Add Business Unit");
DataTable dt = ViewState["dt"] as DataTable;
//string strPass = BLL.PasswordDecrypt(Convert.ToString(dt.Rows[0]["LOGIN_PASSWORD"]));
//string strPass1 = BLL.PasswordDecrypt(Convert.ToString(dt.Rows[0]["LOGIN_PASS_CODE"]));
ViewState["PASSCODE"] = txt_PassCode.Text;
ViewState["PASSWORD"] = rtxt_UserManagerPassword.Text;
txt_PassCode.Attributes.Add("value", Convert.ToString(ViewState["PASSCODE"]));
rtxt_UserManagerPassword.Attributes.Add("value", Convert.ToString(ViewState["PASSWORD"]));
//string strPass = Convert.ToString(dt.Rows[0]["LOGIN_PASSWORD"]);
//rtxt_UserManagerPassword.Attributes.Add("value", strPass);
//txt_PassCode.Attributes.Add("value", strPass1);
}
}
else
{
SMHR_LOGININFO _obj_Smhr_LoginInfo = new SMHR_LOGININFO();
_obj_Smhr_LoginInfo.LOGIN_EMP_ID = Convert.ToInt32(rcmb_UserManagersEmployee.SelectedItem.Value);
_obj_Smhr_LoginInfo.LOGIN_TYPE = Convert.ToInt32(rcmb_UserManagerUserGroups.SelectedItem.Value);
_obj_Smhr_LoginInfo.LOGIN_USERNAME = BLL.ReplaceQuote(rtxt_UserManagerUserName.Text);
_obj_Smhr_LoginInfo.LOGIN_PASSWORD = BLL.PasswordEncrypt(BLL.ReplaceQuote(rtxt_UserManagerPassword.Text));
_obj_Smhr_LoginInfo.LOGIN_PASS_CODE = BLL.PasswordEncrypt(BLL.ReplaceQuote(txt_PassCode.Text));
_obj_Smhr_LoginInfo.LOGIN_EMAILID = BLL.ReplaceQuote(rtxt_UserManagerEmail.Text);
//_obj_Smhr_LoginInfo.LOGIN_STATUS = chk_UserManagerStatus.Checked;
if (rcmb_UserManagerStatus.SelectedValue == "1")
{
_obj_Smhr_LoginInfo.LOGIN_STATUS = true;
}
else
{
_obj_Smhr_LoginInfo.LOGIN_STATUS = false;
}
_obj_Smhr_LoginInfo.ORGANISATION_ID = Convert.ToInt32(rcmb_Organisation.SelectedValue);
_obj_Smhr_LoginInfo.CREATEDBY = Convert.ToInt32(Session["USER_ID"]); // ### Need to Get the Session
_obj_Smhr_LoginInfo.CREATEDDATE = DateTime.Now;
_obj_Smhr_LoginInfo.LASTMDFBY = Convert.ToInt32(Session["USER_ID"]); // ### Need to Get the Session
_obj_Smhr_LoginInfo.LASTMDFDATE = DateTime.Now;
string str = string.Empty;
foreach (RadListBoxItem item in rlst_BusinessUnit.Items)
{
str += item.Value + ",";
}
if (str.Length > 0)
{
str = str.Remove(str.Length - 1, 1);
}
_obj_Smhr_LoginInfo.LOGIN_BUSINESSUNITID = str;
switch (((Button)sender).ID.ToUpper())
{
case "BTN_UPDATE":
_obj_Smhr_LoginInfo.LOGIN_ID = Convert.ToInt32(lbl_UserManagerID.Text);
_obj_Smhr_LoginInfo.OPERATION = operation.Check;
_obj_Smhr_LoginInfo.ORGANISATION_ID = 0;
if (Convert.ToString(BLL.get_LoginInfo(_obj_Smhr_LoginInfo).Rows[0]["Count"]) != "0")
{
BLL.ShowMessage(this, "User Name Already Exists");
return;
}
_obj_Smhr_LoginInfo.OPERATION = operation.Update;
_obj_Smhr_LoginInfo.ORGANISATION_ID = Convert.ToInt32(rcmb_Organisation.SelectedValue);
if (BLL.set_LoginInfo(_obj_Smhr_LoginInfo))
{
BLL.ShowMessage(this, "Information Updated Successfully");
}
else
{
BLL.ShowMessage(this, "Information Not Updated");
}
if (strPass != rtxt_UserManagerPassword.Text || strPass1 != txt_PassCode.Text) //for Login Password & Login Passcode
{
if (strPass1 != txt_PassCode.Text)
{
pwdType = "Pass Code";
pwdCol = "LOGIN_PASS_CODE";
oldVal = strPass1;
newVal = txt_PassCode.Text;
BLL.ExecuteNonQuery("EXEC USP_SMHR_AUDITTRAILS @OPERATION = 'INSERT',@SMHR_AUDIT_FORM_ID = '64', @SMHR_AUDIT_FORMNAME = 'Users', " +
"@SMHR_AUDIT_SUBFORMNAME = 'Users', @SMHR_AUDIT_TRANSACTIONDESC = 'Users - " + rtxt_UserManagerUserName.Text + " was updated" +
"', @SMHR_AUDIT_COLUMN = '" + pwdCol + "', " + "@SMHR_AUDIT_OLDVALUE = '" + oldVal + "', @SMHR_AUDIT_NEWVALUE = '" + newVal +
"',@SMHR_AUDIT_MODIFIEDBY = '" + Convert.ToInt32(Session["USER_ID"]) + "', " + "@SMHR_AUDIT_CONTROL_COLUMN = '" + pwdType + "'");
}
if (strPass != rtxt_UserManagerPassword.Text)
{
pwdType = "Password";
pwdCol = "LOGIN_PASSWORD";
oldVal = strPass;
newVal = rtxt_UserManagerPassword.Text;
BLL.ExecuteNonQuery("EXEC USP_SMHR_AUDITTRAILS @OPERATION = 'INSERT',@SMHR_AUDIT_FORM_ID = '64', @SMHR_AUDIT_FORMNAME = 'Users', " +
"@SMHR_AUDIT_SUBFORMNAME = 'Users', @SMHR_AUDIT_TRANSACTIONDESC = 'Users - " + rtxt_UserManagerUserName.Text + " was updated" +
"', @SMHR_AUDIT_COLUMN = '" + pwdCol + "', " + "@SMHR_AUDIT_OLDVALUE = '" + oldVal + "', @SMHR_AUDIT_NEWVALUE = '" + newVal +
"',@SMHR_AUDIT_MODIFIEDBY = '" + Convert.ToInt32(Session["USER_ID"]) + "', " + "@SMHR_AUDIT_CONTROL_COLUMN = '" + pwdType + "'");
}
}
break;
case "BTN_SAVE":
_obj_Smhr_LoginInfo.OPERATION = operation.Check;
_obj_Smhr_LoginInfo.ORGANISATION_ID = 0;
if (Convert.ToString(BLL.get_LoginInfo(_obj_Smhr_LoginInfo).Rows[0]["Count"]) != "0")
{
BLL.ShowMessage(this, "User Name already Exists");
return;
}
_obj_Smhr_LoginInfo.OPERATION = operation.Insert;
_obj_Smhr_LoginInfo.ORGANISATION_ID = Convert.ToInt32(rcmb_Organisation.SelectedValue);
if (BLL.set_LoginInfo(_obj_Smhr_LoginInfo))
{
BLL.ShowMessage(this, "Information Saved Successfully");
}
else
{
BLL.ShowMessage(this, "Information Not Saved");
}
break;
default:
break;
}
Rm_UM_page.SelectedIndex = 0;
LoadGrid();
Rg_UserManager.DataBind();
}
}
catch (Exception ex)
{
SMHR.BLL.Error_Log(Session["USER_ID"].ToString(), ex.TargetSite.ToString(), ex.Message.Replace("'", "''"), "frm_Users", ex.StackTrace, DateTime.Now);
Response.Redirect("~/Frm_ErrorPage.aspx");
}
}
protected void btn_Save_Click(object sender, EventArgs e)
{
try
{
SMHR_LOGININFO _obj_Smhr_LoginInfo = new SMHR_LOGININFO();
_obj_Smhr_LoginInfo.LOGIN_EMP_ID = Convert.ToInt32(rcmb_UserManagersEmployee.SelectedItem.Value);
_obj_Smhr_LoginInfo.LOGIN_TYPE = Convert.ToInt32(rcmb_UserManagerUserGroups.SelectedItem.Value);
_obj_Smhr_LoginInfo.LOGIN_USERNAME = BLL.ReplaceQuote(rtxt_UserManagerUserName.Text);
_obj_Smhr_LoginInfo.LOGIN_PASSWORD = BLL.PasswordEncrypt(BLL.ReplaceQuote(rtxt_UserManagerPassword.Text));
_obj_Smhr_LoginInfo.LOGIN_PASS_CODE = BLL.PasswordEncrypt(BLL.ReplaceQuote(txt_PassCode.Text));
_obj_Smhr_LoginInfo.LOGIN_EMAILID = BLL.ReplaceQuote(rtxt_UserManagerEmail.Text);
//_obj_Smhr_LoginInfo.LOGIN_STATUS = chk_UserManagerStatus.Checked;
if (rcmb_UserManagerStatus.SelectedValue == "1")
{
_obj_Smhr_LoginInfo.LOGIN_STATUS = true;
}
else
{
_obj_Smhr_LoginInfo.LOGIN_STATUS = false;
}
_obj_Smhr_LoginInfo.ORGANISATION_ID = Convert.ToInt32(rcmb_Organisation.SelectedValue);
_obj_Smhr_LoginInfo.CREATEDBY = Convert.ToInt32(Session["USER_ID"]); // ### Need to Get the Session
_obj_Smhr_LoginInfo.CREATEDDATE = DateTime.Now;
_obj_Smhr_LoginInfo.LASTMDFBY = Convert.ToInt32(Session["USER_ID"]); // ### Need to Get the Session
_obj_Smhr_LoginInfo.LASTMDFDATE = DateTime.Now;
string str = string.Empty;
foreach (RadListBoxItem item in rlst_BusinessUnit.Items)
{
str += item.Value + ",";
}
if (str.Length > 0)
{
str = str.Remove(str.Length - 1, 1);
}
_obj_Smhr_LoginInfo.LOGIN_BUSINESSUNITID = str;
switch (((Button)sender).ID.ToUpper())
{
case "BTN_UPDATE":
_obj_Smhr_LoginInfo.LOGIN_ID = Convert.ToInt32(lbl_UserManagerID.Text);
_obj_Smhr_LoginInfo.OPERATION = operation.Check;
if (Convert.ToString(BLL.get_LoginInfo(_obj_Smhr_LoginInfo).Rows[0]["Count"]) != "1")
{
BLL.ShowMessage(this, "User Name Already Exists");
return;
}
_obj_Smhr_LoginInfo.OPERATION = operation.Update;
if (BLL.set_LoginInfo(_obj_Smhr_LoginInfo))
{
BLL.ShowMessage(this, "Information Saved Successfully");
}
else
{
BLL.ShowMessage(this, "Information Not Saved");
}
break;
case "BTN_SAVE":
_obj_Smhr_LoginInfo.OPERATION = operation.Check;
if (Convert.ToString(BLL.get_LoginInfo(_obj_Smhr_LoginInfo).Rows[0]["Count"]) != "0")
{
BLL.ShowMessage(this, "User Name already Exists");
return;
}
_obj_Smhr_LoginInfo.OPERATION = operation.Insert;
if (BLL.set_LoginInfo(_obj_Smhr_LoginInfo))
{
BLL.ShowMessage(this, "Information Saved Successfully");
}
else
{
BLL.ShowMessage(this, "Information Not Saved");
}
break;
default:
break;
}
Rm_UM_page.SelectedIndex = 0;
LoadGrid();
Rg_UserManager.DataBind();
}
catch (Exception ex)
{
SMHR.BLL.Error_Log(Session["USER_ID"].ToString(), ex.TargetSite.ToString(), ex.Message.Replace("'", "''"), "frm_Admin", ex.StackTrace, DateTime.Now);
Response.Redirect("~/Frm_ErrorPage.aspx");
}
}
