public static List <ATTUsers> GetUserList(DataTable tbl)
{
List <ATTUsers> UserLST = new List <ATTUsers>();
try
{
foreach (DataRow row in tbl.Rows)
{
ATTUsers UserObj = new ATTUsers(
(string)row["USER_NAME"].ToString(),
(string)row["PASSWORD"].ToString(),
"",
(string)row["CREATEDBY"].ToString(),
(DateTime)row["CREATED_DATE"],
(DateTime)row["VALID_UPTO"],
(string)row["ACTIVE"].ToString(),
"E",
(row["P_ID"] == System.DBNull.Value) ? 0 : double.Parse(row["P_ID"].ToString())
);
UserObj.LSTUserRoles = new BLLUserRoles().GetUserRoles((string)row["USER_NAME"].ToString());
UserLST.Add(UserObj);
}
return(UserLST);
}
catch (Exception ex)
{
throw ex;
}
}
protected bool IsUserValid()
{
ATTUsers objUsers = new ATTUsers(
this.txtUserName_RQD.Text,
this.txtPassword_RQD.Text,
this.txtRePassword_RQD.Text,
((ATTUserLogin)Session["Login_User_Detail"]).UserName,
DateTime.Now,
(this.txtValidUpto_REDT.Text == "") ? DateTime.Parse("01/01/0001") : DateTime.Parse(this.txtValidUpto_REDT.Text),
(this.chkActive.Checked == true) ? "Y" : "N",
"",
(this.txtPersonID.Text == "") ? 0 : double.Parse(this.txtPersonID.Text)
);
ObjectValidation OV = BLLUsers.Validate(objUsers);
if (OV.IsValid == false)
{
this.lblStatusMessage.Text = OV.ErrorMessage;
this.programmaticModalPopup.Show();
return(false);
}
ATTOrganizationUsers objOrgUser = new ATTOrganizationUsers
(int.Parse(this.DDLOgranization.SelectedValue.ToString()),
txtUserName_RQD.Text,
((ATTUserLogin)Session["Login_User_Detail"]).UserName,
DateTime.Now.AddYears(1).ToString(),
""
);
OV = BLLOrganizationUsers.Validate(objOrgUser);
if (OV.IsValid == false)
{
this.lblStatusMessage.Text = OV.ErrorMessage;
this.programmaticModalPopup.Show();
return(false);
}
if (BLLUsers.ValidateDate(txtValidUpto_REDT.Text) == false)
{
this.lblStatusMessage.Text = "Invalid Date Format: Date should be in DD/MM/YYYY Format";
this.programmaticModalPopup.Show();
return(false);
}
return(true);
}
public static bool AddUsers(ATTUsers objUser, OracleTransaction Tran)
{
double?pID;
try
{
string InsertUpdateSP = "";
if (objUser.Action == "A")
{
InsertUpdateSP = "SP_ADD_USERS";
}
else
{
InsertUpdateSP = "SP_EDIT_USERS";
}
if (objUser.PID == 0)
{
pID = null;
}
else
{
pID = objUser.PID;
}
OracleParameter[] ParamArray = new OracleParameter[6];
ParamArray[0] = Utilities.GetOraParam(":p_user_name", objUser.Username, OracleDbType.Varchar2, ParameterDirection.Input);
ParamArray[1] = Utilities.GetOraParam(":p_password", objUser.Password, OracleDbType.Varchar2, ParameterDirection.Input);
ParamArray[2] = Utilities.GetOraParam(":p_createdby", objUser.CreatedBy, OracleDbType.Varchar2, ParameterDirection.Input);
ParamArray[3] = Utilities.GetOraParam(":p_active", objUser.Active, OracleDbType.Varchar2, ParameterDirection.Input);
ParamArray[4] = Utilities.GetOraParam(":p_valid_upto", objUser.ValidUpto, OracleDbType.Date, ParameterDirection.Input);
ParamArray[5] = Utilities.GetOraParam(":p_PID", pID, OracleDbType.Double, ParameterDirection.Input);
SqlHelper.ExecuteNonQuery(Tran, CommandType.StoredProcedure, InsertUpdateSP, ParamArray);
return(true);
}
catch (System.Exception ex)
{
throw ex;
}
}
public static ObjectValidation Validate(ATTUsers objUsers)
{
ObjectValidation OV = new ObjectValidation();
if (objUsers.Username == "")
{
OV.IsValid = false;
OV.ErrorMessage = "Username cannot be Blank.";
return(OV);
}
if (objUsers.Password == "")
{
OV.IsValid = false;
OV.ErrorMessage = "Password cannot be Blank";
return(OV);
}
if (objUsers.Password != objUsers.RePassword)
{
OV.IsValid = false;
OV.ErrorMessage = "Password Mismatched";
return(OV);
}
if (objUsers.ValidUpto.ToShortDateString() == "01/01/0001")
{
OV.IsValid = false;
OV.ErrorMessage = "Valid Upto Can't Be Left Blank";
return(OV);
}
//if (ValidateDate(objUsers.ValidUpto)==false )
//{
// OV.IsValid = false;
// OV.ErrorMessage = "Invalid Date Format. Date should be in DD/MM/YYYY Format";
// return OV;
//}
return(OV);
}
protected void btn_Save_Click(object sender, EventArgs e)
{
try
{
if (lstUsers.SelectedIndex == -1)
{
List <ATTUsers> lstAllUsers = (List <ATTUsers>)Session["AllUsers"];
ATTUsers objUser = lstAllUsers.Find
(
delegate(ATTUsers usr)
{
return(usr.Username == this.txtUserName_RQD.Text.Trim());
}
);
if (objUser != null)
{
this.lblStatusMessage.Text = "User Already Exists.....";
this.programmaticModalPopup.Show();
return;
}
}
if (IsUserValid() == false)
{
return;
}
ATTOrganizationUsers objOrgUser;
if (DDLTransferTo.SelectedIndex == 0)
{
objOrgUser = new ATTOrganizationUsers
(
(DDLTransferTo.SelectedIndex == 0) ? int.Parse(this.DDLOgranization.SelectedValue) : int.Parse(this.DDLTransferTo.SelectedValue),
txtUserName_RQD.Text,
"",
"",
(lstUsers.SelectedIndex != -1) ? "E" : "A"
);
}
else
{
objOrgUser = new ATTOrganizationUsers
(
(DDLTransferTo.SelectedIndex == -1) ? int.Parse(this.DDLOgranization.SelectedValue) : int.Parse(this.DDLTransferTo.SelectedValue),
txtUserName_RQD.Text,
"",
"",
"A"
);
}
string ActvnSts;
if (DDLTransferTo.SelectedIndex > 0)
{
ActvnSts = "N";
}
else
{
ActvnSts = (chkActive.Checked == true) ? "Y" : "N";
}
objOrgUser.ObjUsers = new ATTUsers
(
this.txtUserName_RQD.Text,
this.txtPassword_RQD.Text,
this.txtRePassword_RQD.Text,
((ATTUserLogin)Session["Login_User_Detail"]).UserName,
DateTime.Now,
DateTime.Parse(this.txtValidUpto_REDT.Text),
ActvnSts,
(lstUsers.SelectedIndex != -1) ? "E" : "A",
(this.txtPersonID.Text == "")?0:double.Parse(this.txtPersonID.Text)
);
objOrgUser.LSTUserRoles = BLLUserRoles.GetLSTUserRoles(AddUserRoles());
if (BLLOrganizationUsers.AddOrgUser(objOrgUser) == true)
{
if (lstUsers.SelectedIndex != -1)
{
List <ATTOrganization> lstOrganization = (List <ATTOrganization>)Session["Organization"];
List <ATTOrganizationUsers> lstOrgUser = lstOrganization[this.DDLOgranization.SelectedIndex].LSTOrgUsers;
if (DDLTransferTo.SelectedIndex == 0)
{
//EDITS THE LIST AFTER UPDATE IN THE DATABASE
lstOrgUser[lstUsers.SelectedIndex].ObjUsers = new ATTUsers
(
this.txtUserName_RQD.Text,
this.txtPassword_RQD.Text,
this.txtRePassword_RQD.Text,
((ATTUserLogin)Session["Login_User_Detail"]).UserName,
DateTime.Now,
DateTime.Parse(txtValidUpto_REDT.Text),
(chkActive.Checked == true) ? "Y" : "N",
"E",
(this.txtPersonID.Text == "") ? 0 :double.Parse(this.txtPersonID.Text)
);
lstOrgUser[lstUsers.SelectedIndex].LSTUserRoles.Clear();
foreach (GridViewRow gvRow in grdRoles.Rows)
{
if (gvRow.Cells[5].Text != "R")
{
ATTUserRoles objUserRoles = new ATTUserRoles
(
txtUserName_RQD.Text,
int.Parse(gvRow.Cells[0].Text),
(gvRow.Cells[4].Text != " ") ? gvRow.Cells[4].Text : (string)Session["NepDate"],
"",
int.Parse(gvRow.Cells[2].Text),
"E"
);
objUserRoles.ObjRoles = new ATTRoles
(
int.Parse(gvRow.Cells[0].Text),
int.Parse(gvRow.Cells[2].Text),
(string)gvRow.Cells[1].Text,
"",
"E"
);
objUserRoles.ObjApplications = new ATTApplication
(
int.Parse(gvRow.Cells[2].Text),
"",
gvRow.Cells[3].Text,
"",
"E"
);
lstOrgUser[lstUsers.SelectedIndex].LSTUserRoles.Add(objUserRoles);
}
}
}
else if (DDLTransferTo.SelectedIndex > 0)
{
//TRANSFER TO OTHER ORGANIZATION
lstOrgUser[lstUsers.SelectedIndex].LSTUserRoles.Clear();
lstOrgUser.RemoveAt(lstUsers.SelectedIndex);
//BINDS NEW USERLIST
this.lstUsers.DataSource = lstOrgUser;
this.lstUsers.DataTextField = "Username";
this.lstUsers.DataValueField = "Username";
this.lstUsers.DataBind();
}
}
else
{
//ADDS THE NEW USER IN THE LIST
List <ATTOrganization> lstOrganization = (List <ATTOrganization>)Session["Organization"];
List <ATTOrganizationUsers> lstOrgUser = lstOrganization[this.DDLOgranization.SelectedIndex].LSTOrgUsers;
List <ATTUserRoles> lstUserRoles = new List <ATTUserRoles>();
foreach (GridViewRow gvRow in grdRoles.Rows)
{
if (gvRow.Cells[5].Text != "R")
{
ATTUserRoles objUserRoles = new ATTUserRoles
(
txtUserName_RQD.Text,
int.Parse(gvRow.Cells[0].Text),
(string)Session["NepDate"],
"",
int.Parse(gvRow.Cells[2].Text),
"E"
);
objUserRoles.ObjRoles = new ATTRoles
(
int.Parse(gvRow.Cells[0].Text),
int.Parse(gvRow.Cells[2].Text),
(string)gvRow.Cells[1].Text,
"",
"E"
);
objUserRoles.ObjApplications = new ATTApplication
(
int.Parse(gvRow.Cells[2].Text),
"",
gvRow.Cells[3].Text,
"",
"E"
);
lstUserRoles.Add(objUserRoles);
}
}
ATTOrganizationUsers objOrgUsers = new ATTOrganizationUsers(
int.Parse(DDLOgranization.SelectedValue),
txtUserName_RQD.Text,
"",
"",
"E"
);
objOrgUser.LSTUserRoles = lstUserRoles;
objOrgUser.ObjUsers = new ATTUsers
(
txtUserName_RQD.Text,
txtPassword_RQD.Text,
txtRePassword_RQD.Text,
((ATTUserLogin)Session["Login_User_Detail"]).UserName,
DateTime.Now,
DateTime.Parse(txtValidUpto_REDT.Text),
(chkActive.Checked == true) ? "Y" : "N",
"E",
(this.txtPersonID.Text == "") ? 0 :double.Parse(this.txtPersonID.Text)
);
lstOrgUser.Add(objOrgUser);
this.lstUsers.DataSource = lstOrgUser;
this.lstUsers.DataTextField = "Username";
this.lstUsers.DataValueField = "Username";
this.lstUsers.DataBind();
}
txtUserName_RQD.Enabled = true;
ClearContros();
}
}
catch (Exception ex)
{
this.lblStatusMessage.Text = "<CENTER>Error In Saving User..</CENTER><BR><BR>" + ex.ToString();
this.programmaticModalPopup.Show();
}
}
protected void lstUsers_SelectedIndexChanged(object sender, EventArgs e)
{
try
{
lstApplications.SelectedIndex = -1;
if (this.DDLTransferTo.Items.Count <= 0)
{
List <ATTOrganization> lstAllOrg = BLLOrganization.GetOrganization();
ATTOrganization orgToRemove = lstAllOrg.Find
(
delegate(ATTOrganization objOrg)
{
return(objOrg.OrgID == int.Parse(this.DDLOgranization.SelectedValue));
}
);
lstAllOrg.Remove(orgToRemove);
lstAllOrg.Insert(0, new ATTOrganization(0, "--- Select Organization ---", "", "", 0));
this.DDLTransferTo.DataSource = lstAllOrg;
this.DDLTransferTo.DataTextField = "OrgName";
this.DDLTransferTo.DataValueField = "OrgID";
this.DDLTransferTo.DataBind();
}
List <ATTOrganization> lstOrganization = (List <ATTOrganization>)Session["Organization"];
List <ATTUserRoles> lstUserRoles = lstOrganization[DDLOgranization.SelectedIndex].LSTOrgUsers[lstUsers.SelectedIndex].LSTUserRoles;
lstUserRoles.Sort(delegate(ATTUserRoles a1, ATTUserRoles a2) { return(a1.ApplID.CompareTo(a2.ApplID)); });
grdRoles.DataSource = lstUserRoles;
grdRoles.DataBind();
ATTUsers objUsers = lstOrganization[DDLOgranization.SelectedIndex].LSTOrgUsers[lstUsers.SelectedIndex].ObjUsers;
this.txtPersonID.Text = (objUsers.PID == 0)?"":objUsers.PID.ToString();
this.txtUserName_RQD.Text = objUsers.Username;
this.txtPassword_RQD.Attributes.Add("value", objUsers.Password);
this.txtRePassword_RQD.Attributes.Add("value", objUsers.Password);
//txtValidUpto_RDT.Text = objUsers.ValidUpto.ToShortDateString();
string dt = this.FormateDate(objUsers.ValidUpto);
txtValidUpto_REDT.Text = dt;
if (objUsers.Active == "Y")
{
this.chkActive.Checked = true;
}
else
{
this.chkActive.Checked = false;
}
this.txtUserName_RQD.Enabled = false;
this.lblTransferTo.Visible = true;
this.DDLTransferTo.Visible = true;
this.chklstRoles.DataSource = "";
this.chklstRoles.DataBind();
// txtPassword_RQD.ReadOnly = true;
//txtRePassword_RQD.Enabled = false;
}
catch (Exception ex)
{
throw ex;
}
}
