void LoadOrganizationAvailablePosts(int OrgID)
{
this.ddlPost.DataSource = "";
this.ddlPost.Items.Clear();
try
{
string desType = "";
if (Session["ApplicationID"].ToString() == "2")
{
desType = "J";
}
else if (Session["ApplicationID"].ToString() == "3")
{
desType = "O";
}
List <ATTOrganizationDesignation> lst = BLLOrganizationDesignation.GetOrganizationDesignation(OrgID, null, desType);
if (lst.Count > 0)
{
ATTOrganizationDesignation obj = new ATTOrganizationDesignation();
obj.DesName = "--- Select Designation ---";
lst.Insert(0, obj);
}
this.ddlPost.DataSource = lst;
this.ddlPost.DataTextField = "DesName";
this.ddlPost.DataValueField = "DesID";
this.ddlPost.DataBind();
}
catch (Exception ex)
{
this.lblStatusMessage.Text = ex.Message;
this.programmaticModalPopup.Show();
}
}
public void LoadOrganizationAvailablePosts()
{
this.ddlPost.DataSource = "";
this.ddlPost.Items.Clear();
try
{
string desType = "J";
Session["PmsRptPostList"] = BLLOrganizationDesignation.GetOrganizationDesignation(null, null, desType);
List <ATTOrganizationDesignation> lst = (List <ATTOrganizationDesignation>)Session["PmsRptPostList"];
if (lst.Count > 0)
{
ATTOrganizationDesignation obj = new ATTOrganizationDesignation();
obj.DesName = "पद छान्नुहोस्";
lst.Insert(0, obj);
}
this.ddlPost.DataSource = lst;
this.ddlPost.DataTextField = "DesName";
this.ddlPost.DataValueField = "DesID";
this.ddlPost.DataBind();
}
catch (Exception ex)
{
throw (ex);
}
}
public static bool SaveOrganizationDesignation(ATTOrganizationDesignation ObjAtt)
{
try
{
return(DLLOrganizationDesignation.SaveOrganizationDesignation(ObjAtt));
}
catch (Exception ex)
{
throw ex;
}
}
public static ObjectValidation Validate(ATTOrganizationDesignation ObjAtt)
{
ObjectValidation OV = new ObjectValidation();
if (ObjAtt.OrgID == 0)
{
OV.IsValid = false;
OV.ErrorMessage = "Select The Organization.";
return(OV);
}
if (ObjAtt.DesID == 0)
{
OV.IsValid = false;
OV.ErrorMessage = "Select The Designation.";
return(OV);
}
if (ObjAtt.TotalSeats == 0)
{
OV.IsValid = false;
OV.ErrorMessage = "Total Seats Cannot Be Empty.";
return(OV);
}
if (ObjAtt.SewaID == 0)
{
OV.IsValid = false;
OV.ErrorMessage = "Select Sewa.";
return(OV);
}
if (ObjAtt.SamuhaID == 0)
{
OV.IsValid = false;
OV.ErrorMessage = "Select Samuha.";
return(OV);
}
if (ObjAtt.UpaSamuhaID == 0)
{
OV.IsValid = false;
OV.ErrorMessage = "Select UpaSamuma.";
return(OV);
}
if (ObjAtt.DesgLevelID == 0)
{
OV.IsValid = false;
OV.ErrorMessage = "Select Shreni.";
return(OV);
}
return(OV);
}
public static bool SaveOrganizationDesignation(ATTOrganizationDesignation ObjAtt)
{
GetConnection Conn = new GetConnection();
OracleConnection DBConn = Conn.GetDbConn(Module.PMS);
OracleTransaction Tran = DBConn.BeginTransaction();
string InsertUpdateSql = "";
if (ObjAtt.Action == "A")
{
InsertUpdateSql = "SP_ADD_ORG_DESIGNATIONS";
}
else if (ObjAtt.Action == "E")
{
InsertUpdateSql = "SP_EDIT_ORG_DESIGNATIONS";
}
try
{
OracleParameter[] ParamArray = new OracleParameter[11];
ParamArray[0] = Utilities.GetOraParam(":p_ORG_ID", ObjAtt.OrgID, OracleDbType.Int64, ParameterDirection.Input);
ParamArray[1] = Utilities.GetOraParam(":p_DES_ID", ObjAtt.DesID, OracleDbType.Int64, ParameterDirection.Input);
ParamArray[2] = Utilities.GetOraParam(":p_CREATED_DATE", ObjAtt.CreatedDate, OracleDbType.Varchar2, ParameterDirection.InputOutput);
ParamArray[3] = Utilities.GetOraParam(":p_PARENT_ORG", ObjAtt.ParentOrg, OracleDbType.Int64, ParameterDirection.Input);
ParamArray[4] = Utilities.GetOraParam(":p_PARENT_DES", ObjAtt.ParentDes, OracleDbType.Int64, ParameterDirection.Input);
ParamArray[5] = Utilities.GetOraParam(":p_TOT_SEATS", ObjAtt.TotalSeats, OracleDbType.Int64, ParameterDirection.Input);
ParamArray[6] = Utilities.GetOraParam(":p_SEWA_ID", ObjAtt.SewaID, OracleDbType.Int64, ParameterDirection.Input);
ParamArray[7] = Utilities.GetOraParam(":p_SAMUHA_ID", ObjAtt.SamuhaID, OracleDbType.Int64, ParameterDirection.Input);
ParamArray[8] = Utilities.GetOraParam(":p_UPASAMUHA_ID", ObjAtt.UpaSamuhaID, OracleDbType.Int64, ParameterDirection.Input);
ParamArray[9] = Utilities.GetOraParam(":p_DESG_LEVEL_ID", ObjAtt.DesgLevelID, OracleDbType.Int64, ParameterDirection.Input);
ParamArray[10] = Utilities.GetOraParam(":p_ENTRY_BY", ObjAtt.EntryBy, OracleDbType.Varchar2, ParameterDirection.Input);
ParamArray[2].Size = 25;
SqlHelper.ExecuteNonQuery(Tran, CommandType.StoredProcedure, InsertUpdateSql, ParamArray);
ObjAtt.CreatedDate = ParamArray[2].Value.ToString();
DLLPost.SavePosts(ObjAtt.LstPosts, ObjAtt.CreatedDate, Tran);
Tran.Commit();
return(true);
}
catch (Exception ex)
{
throw ex;
}
finally
{
Conn.CloseDbConn();
}
}
public static List <ATTOrganizationDesignation> GetOrganizationDesignation(int?orgID, int?desID, string desType)
{
List <ATTOrganizationDesignation> LstOrganizationDesignation = new List <ATTOrganizationDesignation>();
try
{
foreach (DataRow row in DLLOrganizationDesignation.GetOrganizationDesignation(orgID, desID, desType).Rows)
{
ATTOrganizationDesignation ObjAtt = new ATTOrganizationDesignation
(
int.Parse(row["ORG_ID"].ToString()),
int.Parse(row["DES_ID"].ToString()),
int.Parse(row["TOT_SEATS"].ToString()),
int.Parse(row["SEWA_ID"].ToString()),
int.Parse(row["SAMUHA_ID"].ToString()),
int.Parse(row["UPASAMUHA_ID"].ToString()),
int.Parse(row["DESG_LEVEL_ID"].ToString()));
ObjAtt.CreatedDate = (string)row["CREATED_DATE"];
ObjAtt.SewaName = (string)row["SEWA_NAME"];
ObjAtt.SamuhaName = (string)row["SAMUHA_NAME"];
ObjAtt.UpaSamuhaName = (string)row["UPA_SAMUHA_NAME"];
ObjAtt.DesgLevelName = (string)row["LEVEL_NAME"];
ObjAtt.OrgName = (string)row["ORG_NAME"];
ObjAtt.DesName = (string)row["DES_NAME"];
ObjAtt.DesType = (string)row["DES_TYPE"];
if (row["PARENT_ORG"] != System.DBNull.Value)
{
ObjAtt.ParentOrg = int.Parse(row["PARENT_ORG"].ToString());
}
if (row["PARENT_DES"] != System.DBNull.Value)
{
ObjAtt.ParentDes = int.Parse(row["PARENT_DES"].ToString());
}
LstOrganizationDesignation.Add(ObjAtt);
}
return(LstOrganizationDesignation);
}
catch (Exception ex)
{
throw ex;
}
}
protected void btnSave_Click(object sender, EventArgs e)
{
List <ATTOrganizationDesignation> OrgDesignationList = (List <ATTOrganizationDesignation>)Session["OrganizationDesignation"];
ATTOrganizationDesignation objOrgDesignation = new ATTOrganizationDesignation();
ATTPost objPost = new ATTPost();
int intDesignationID = 0;
int intOrganizationID = 0;
int intTotalSeats = 0;
int intSewaID = 0;
int intSamuhaID = 0;
int intUpaSamuhaID = 0;
int intDesgLevelID = 0;
string strUser = ((ATTUserLogin)Session["Login_User_Detail"]).UserName;
if (this.ddlDesignation_Rqd.SelectedIndex > 0)
{
intDesignationID = int.Parse(this.ddlDesignation_Rqd.SelectedValue.ToString());
}
if (this.ddlOrganization_Rqd.SelectedIndex > 0)
{
intOrganizationID = int.Parse(this.ddlOrganization_Rqd.SelectedValue.ToString());
}
if (this.ddlSewa_Rqd.SelectedIndex > 0)
{
intSewaID = int.Parse(this.ddlSewa_Rqd.SelectedValue.ToString());
}
if (this.ddlSamuha_Rqd.SelectedIndex > 0)
{
intSamuhaID = int.Parse(this.ddlSamuha_Rqd.SelectedValue.ToString());
}
if (this.ddlUpaSamuha_Rqd.SelectedIndex > 0)
{
intUpaSamuhaID = int.Parse(this.ddlUpaSamuha_Rqd.SelectedValue.ToString());
}
if (this.ddlDesignationLevel_Rqd.SelectedIndex > 0)
{
intDesgLevelID = int.Parse(this.ddlDesignationLevel_Rqd.SelectedValue.ToString());
}
foreach (GridViewRow row in this.grdDesPost.Rows)
{
CheckBox chkDelete = (CheckBox)(row.Cells[8].FindControl("chkPostSelect"));
if (!chkDelete.Checked)
{
intTotalSeats += 1;
}
}
if (this.grdDesPost.Rows.Count == 0)
{
this.lblStatusMessage.Text = "Enter The Total Quantity And Click Create Post (or) Update Post.";
this.programmaticModalPopup.Show();
return;
}
try
{
objOrgDesignation = new ATTOrganizationDesignation(intOrganizationID, intDesignationID, intTotalSeats, intSewaID, intSamuhaID, intUpaSamuhaID, intDesgLevelID);
ObjectValidation OV = BLLOrganizationDesignation.Validate(objOrgDesignation);
if (!OV.IsValid)
{
this.lblStatusMessage.Text = OV.ErrorMessage;
this.programmaticModalPopup.Show();
return;
}
if (this.txtCreatedDate_DT.Text.Trim() != "")
{
objOrgDesignation.CreatedDate = this.txtCreatedDate_DT.Text.Trim(); //"2066.10.09";
}
objOrgDesignation.EntryBy = strUser;
if (this.grdOrgDesignation.SelectedIndex == -1)
{
objOrgDesignation.Action = "A";
}
else
{
objOrgDesignation.Action = "E";
}
foreach (GridViewRow row in this.grdDesPost.Rows)
{
string strPostName = "";
string strOldPostName = "";
CheckBox cb = (CheckBox)(row.Cells[8].FindControl("chkPostSelect"));
TextBox txtboxPostName = (TextBox)(row.Cells[5].FindControl("txtPostName"));
TextBox txtboxOldPostName = (TextBox)(row.Cells[6].FindControl("txtOldPostName"));
strPostName = txtboxPostName.Text.Trim();
strOldPostName = txtboxOldPostName.Text.Trim();
objPost = new ATTPost(int.Parse(row.Cells[0].Text.ToString()), int.Parse(row.Cells[1].Text.ToString()), row.Cells[8].Text.ToString(), int.Parse(row.Cells[2].Text.ToString()), strPostName, row.Cells[7].Text.ToString().Trim());
objPost.EntryBy = strUser;
objPost.Action = "";
if (row.Cells[2].Text.ToString().Trim() == "0" && !cb.Checked)
{
objPost.Action = "A";
}
if (row.Cells[2].Text.ToString().Trim() != "0")
{
if (cb.Checked)
{
objPost.Action = "D";
}
else if ((strPostName != strOldPostName) && !cb.Checked)
{
objPost.Action = "E";
}
}
if (objPost.Action != "")
{
ObjectValidation OValidate = BLLPost.Validate(objPost);
if (!OValidate.IsValid)
{
this.lblStatusMessage.Text = OValidate.ErrorMessage;
this.programmaticModalPopup.Show();
return;
}
objOrgDesignation.LstPosts.Add(objPost);
}
}
//if (this.ddlParentOrganization.SelectedIndex > 0)
// objOrgDesignation.ParentOrg = int.Parse(this.ddlParentOrganization.SelectedValue.ToString());
//if (this.ddlParentDesignation.SelectedIndex > 0)
// objOrgDesignation.ParentDes = int.Parse(this.ddlParentDesignation.SelectedValue.ToString());
objOrgDesignation.OrgName = this.ddlOrganization_Rqd.SelectedItem.Text;
objOrgDesignation.DesName = this.ddlDesignation_Rqd.SelectedItem.Text;
objOrgDesignation.SewaName = this.ddlSewa_Rqd.SelectedItem.Text;
objOrgDesignation.SamuhaName = this.ddlSamuha_Rqd.SelectedItem.Text;
objOrgDesignation.UpaSamuhaName = this.ddlUpaSamuha_Rqd.SelectedItem.Text;
objOrgDesignation.DesgLevelName = this.ddlDesignationLevel_Rqd.SelectedItem.Text;
if (BLLOrganizationDesignation.SaveOrganizationDesignation(objOrgDesignation))
{
if (this.grdOrgDesignation.SelectedIndex > -1)
{
OrgDesignationList[this.grdOrgDesignation.SelectedIndex].OrgID = int.Parse(this.ddlOrganization_Rqd.SelectedValue.ToString());
OrgDesignationList[this.grdOrgDesignation.SelectedIndex].DesID = int.Parse(this.ddlDesignation_Rqd.SelectedValue.ToString());
OrgDesignationList[this.grdOrgDesignation.SelectedIndex].OrgName = this.ddlOrganization_Rqd.SelectedItem.Text.ToString();
OrgDesignationList[this.grdOrgDesignation.SelectedIndex].DesName = this.ddlDesignation_Rqd.SelectedItem.Text.ToString();
OrgDesignationList[this.grdOrgDesignation.SelectedIndex].TotalSeats = objOrgDesignation.TotalSeats;
}
else
{
OrgDesignationList.Add(objOrgDesignation);
}
this.grdOrgDesignation.DataSource = OrgDesignationList;
this.grdOrgDesignation.DataBind();
this.lblStatusMessage.Text = "**Post Created Successfully";
this.programmaticModalPopup.Show();
ClearControls();
}
}
catch (Exception ex)
{
this.lblStatusMessage.Text = ex.Message;
this.programmaticModalPopup.Show();
}
}
