public static List <ATTPost> GetPost(int?PostId)
{
List <ATTPost> LstPost = new List <ATTPost>();
try
{
foreach (DataRow row in DLLPost.GetPost(PostId).Rows)
{
ATTPost ObjAtt = new ATTPost
(
int.Parse(row["POST_ID"].ToString()),
row["POST_NAME"].ToString()
);
List <ATTPostLevel> PostLevelList = BLLPostLevel.GetPostLevel(ObjAtt.PostID);
ObjAtt.LstPostLevel = PostLevelList.FindAll(delegate(ATTPostLevel att) { return(att.PostID == ObjAtt.PostID); });
LstPost.Add(ObjAtt);
}
return(LstPost);
}
catch (Exception ex)
{
throw ex;
}
}
public static List <ATTPost> GetAllDesgPost(int?orgID, int?desID, string created_date)
{
List <ATTPost> LstOrgDesgPost = new List <ATTPost>();
try
{
foreach (DataRow row in DLLPost.GetAllDesgPost(orgID, desID, created_date).Rows)
{
ATTPost ObjAtt = new ATTPost
(
int.Parse(row["ORG_ID"].ToString()),
int.Parse(row["DES_ID"].ToString()),
(row["CREATED_DATE"] == System.DBNull.Value ? "" : (string)row["CREATED_DATE"]),
int.Parse(row["POST_ID"].ToString()),
(row["POST_NAME"] == System.DBNull.Value ? "" : (string)row["POST_NAME"]),
(row["OCCUPIED"] == System.DBNull.Value ? "" : (string)row["OCCUPIED"]));
ObjAtt.DesName = (string)row["DES_NAME"];
LstOrgDesgPost.Add(ObjAtt);
}
return(LstOrgDesgPost);
}
catch (Exception ex)
{
throw ex;
}
}
void ManageAvailablePost()
{
List <ATTPost> lstCurrentPost = Session["CurrentPostList"] as List <ATTPost>;
foreach (GridViewRow row in this.grdPostList.Rows)
{
ATTPost obj = lstCurrentPost.Find
(
delegate(ATTPost p)
{
return(p.OrgID == int.Parse(row.Cells[2].Text) &&
p.DesID == int.Parse(row.Cells[3].Text) &&
p.CreatedDate == row.Cells[14].Text &&
p.PostID == int.Parse(row.Cells[4].Text));
}
);
if (obj != null)
{
this.UsedPostList.Add(obj);
this.CurrentPostList.Remove(obj);
break;
}
}
this.ddlAvailablePost_Rqd.Items.Clear();
this.ddlAvailablePost_Rqd.Items.Add(new ListItem("--- छान्नुहोस ---", "0"));
this.ddlAvailablePost_Rqd.DataSource = lstCurrentPost;
this.ddlAvailablePost_Rqd.DataTextField = "RDPOSTNAMEWITHCREATIONDATE";//"RDPOSTNAMEWITHCREATIONDATE";
this.ddlAvailablePost_Rqd.DataValueField = "RDPOSTIDWITHCREATIONDATE";
this.ddlAvailablePost_Rqd.DataBind();
}
public static bool SavePosts(ATTPost ObjAtt)
{
try
{
return(true);//DLLOrganizationDesignation.SaveOrganizationDesignation(ObjAtt);
}
catch (Exception ex)
{
throw ex;
}
}
public static bool SavePost(ATTPost ObjAtt)
{
try
{
return(DLLPost.SavePost(ObjAtt));
}
catch (Exception ex)
{
throw ex;
}
}
public static ObjectValidation Validate(ATTPost ObjAtt)
{
ObjectValidation OV = new ObjectValidation();
if (ObjAtt.PostName == "")
{
OV.IsValid = false;
OV.ErrorMessage = "Post Name Cannot Be Blank.";
return(OV);
}
return(OV);
}
public static bool SavePost(ATTPost ObjAtt)
{
GetConnection Conn = new GetConnection();
OracleConnection DBConn;
OracleTransaction Tran;
string InsertUpdatePostSql = "";
try
{
DBConn = Conn.GetDbConn(Module.DLPDS);
Tran = DBConn.BeginTransaction();
if (ObjAtt.PostID == 0)
{
InsertUpdatePostSql = "SP_ADD_POST";
}
else
{
InsertUpdatePostSql = "SP_EDIT_POST";
}
OracleParameter[] ParamArray = new OracleParameter[2];
ParamArray[0] = Utilities.GetOraParam(":p_POST_ID", ObjAtt.PostID, OracleDbType.Int64, ParameterDirection.InputOutput);
ParamArray[1] = Utilities.GetOraParam(":p_POST_NAME", ObjAtt.PostName, OracleDbType.Varchar2, ParameterDirection.Input);
SqlHelper.ExecuteNonQuery(Tran, CommandType.StoredProcedure, InsertUpdatePostSql, ParamArray);
int PostID = int.Parse(ParamArray[0].Value.ToString());
ObjAtt.PostID = PostID;
DLLPostLevel.SavePostLevel(ObjAtt.LstPostLevel, Tran, PostID);
Tran.Commit();
return(true);
}
catch (Exception ex)
{
throw ex;
}
finally
{
Conn.CloseDbConn();
}
}
protected void btnSubmit_Click(object sender, EventArgs e)
{
List <ATTPost> PostList = (List <ATTPost>)Session["Post"];
int PostID;
if (lstPost.SelectedIndex == -1)
{
PostID = 0;
}
else
{
PostID = int.Parse(lstPost.SelectedValue.ToString());
}
try
{
ATTPost ObjAtt = new ATTPost(PostID, txtPostName_Rqd.Text.Trim());
foreach (GridViewRow row in grdPostLevel.Rows)
{
if (row.Cells[3].Text.Trim() != " ")
{
ATTPostLevel attPL = new ATTPostLevel(int.Parse(row.Cells[0].Text.ToString()), int.Parse(row.Cells[1].Text.ToString()), row.Cells[2].Text.Trim(), row.Cells[3].Text.Trim());
ObjAtt.LstPostLevel.Add(attPL);
}
}
ObjectValidation OV = BLLPost.Validate(ObjAtt);
if (OV.IsValid == false)
{
lblStatusMessage.Text = OV.ErrorMessage;
this.programmaticModalPopup.Show();
return;
}
for (int i = 0; i < lstPost.Items.Count; i++)
{
if (lstPost.SelectedIndex != i)
{
if (PostList[i].PostName.ToLower() == txtPostName_Rqd.Text.Trim().ToLower())
{
this.lblStatusMessage.Text = "Post Name Already Exists";
this.programmaticModalPopup.Show();
return;
}
}
}
BLLPost.SavePost(ObjAtt);
if (lstPost.SelectedIndex > -1)
{
PostList[lstPost.SelectedIndex].PostID = ObjAtt.PostID;
PostList[lstPost.SelectedIndex].PostName = ObjAtt.PostName;
PostList[lstPost.SelectedIndex].LstPostLevel.Clear();
foreach (GridViewRow row in grdPostLevel.Rows)
{
if (row.Cells[3].Text.Trim() != "D")
{
ATTPostLevel attPL = new ATTPostLevel(int.Parse(row.Cells[0].Text.ToString()), int.Parse(row.Cells[1].Text.ToString()), row.Cells[2].Text, "");
PostList[lstPost.SelectedIndex].LstPostLevel.Add(attPL);
}
}
}
else
{
PostList.Add(ObjAtt);
}
lstPost.DataSource = PostList;
lstPost.DataTextField = "PostName";
lstPost.DataValueField = "PostID";
lstPost.DataBind();
ClearControls();
}
catch (Exception ex)
{
this.lblStatusMessage.Text = ex.Message;
this.programmaticModalPopup.Show();
return;
}
}
protected void btnCreatePost_Click(object sender, EventArgs e)
{
string msg = "";
int count = 0;
if (this.ddlOrganization_Rqd.SelectedIndex == 0)
{
msg += "<br/>**कार्यालय छान्नुहोस्<br/>";
count++;
}
if (this.ddlDesignation_Rqd.SelectedIndex == 0)
{
msg += "**पद छान्नुहोस्<br/>";
count++;
}
if (this.ddlDesignationLevel_Rqd.SelectedIndex == 0)
{
msg += "**श्रेणी छान्नुहोस्<br/>";
count++;
}
if (this.txtTotalSeats_Rqd.Text == "")
{
msg += "**संख्या भर्नुहोस्";
count++;
}
if (count > 0)
{
this.lblStatusMessage.Text = msg;
this.programmaticModalPopup.Show();
return;
}
try
{
if (this.grdOrgDesignation.SelectedIndex == -1)
{
List <ATTPost> NewDesPost = new List <ATTPost>();
for (int i = 1; i <= int.Parse(this.txtTotalSeats_Rqd.Text); i++)
{
ATTPost post = new ATTPost();
post.OrgID = int.Parse(this.ddlOrganization_Rqd.SelectedValue.ToString());
post.DesID = int.Parse(this.ddlDesignation_Rqd.SelectedValue.ToString());
post.PostID = 0;
post.OrgName = this.ddlOrganization_Rqd.SelectedItem.Text;
post.DesName = this.ddlDesignation_Rqd.SelectedItem.Text;
post.PostName = this.ddlDesignation_Rqd.SelectedItem.Text;
post.Occupied = "NO";
post.CreatedDate = this.txtCreatedDate_DT.Text.Trim();
NewDesPost.Add(post);
}
this.grdDesPost.DataSource = NewDesPost;
this.grdDesPost.DataBind();
}
else
{
List <ATTPost> PostList = (List <ATTPost>)Session["PostTbl"];
if (int.Parse(this.txtTotalSeats_Rqd.Text.ToString()) < this.grdDesPost.Rows.Count)
{
this.lblStatusMessage.Text = "Total Quantity Should Be Less Than (or) Equal To Previous Quantity.";
this.programmaticModalPopup.Show();
return;
}
for (int i = 1; i <= int.Parse(this.txtTotalSeats_Rqd.Text) - this.grdDesPost.Rows.Count; i++)
{
ATTPost post = new ATTPost();
post.OrgID = int.Parse(this.ddlOrganization_Rqd.SelectedValue.ToString());
post.DesID = int.Parse(this.ddlDesignation_Rqd.SelectedValue.ToString());
post.OrgName = this.ddlOrganization_Rqd.SelectedItem.Text;
post.DesName = this.ddlDesignation_Rqd.SelectedItem.Text;
post.PostName = this.ddlDesignation_Rqd.SelectedItem.Text;
post.Occupied = "NO";
post.CreatedDate = this.txtCreatedDate_DT.Text.Trim();
PostList.Add(post);
}
this.grdDesPost.DataSource = PostList;
this.grdDesPost.DataBind();
}
}
catch (Exception ex)
{
this.lblStatusMessage.Text = ex.Message;
this.programmaticModalPopup.Show();
return;
}
}
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();
}
}
