ATTEmployeeWorkDivision GetFilter()
{
ATTEmployeeWorkDivision empWorkDiv = new ATTEmployeeWorkDivision();
empWorkDiv.UnitType = "MY";
return(empWorkDiv);
}
private ATTEmployeeWorkDivision GetEmployeeFilter()
{
ATTEmployeeWorkDivision EmployeeSearch = new ATTEmployeeWorkDivision();
if (this.txtSymbolNo.Text.Trim() != "")
{
EmployeeSearch.SymbolNo = this.txtSymbolNo.Text.Trim();
}
if (this.ddlOrganization.SelectedIndex > 0)
{
EmployeeSearch.OrgID = int.Parse(this.ddlOrganization.SelectedValue);
}
if (this.ddlBranch.SelectedIndex > 0)
{
EmployeeSearch.OrgUnitID = int.Parse(this.ddlBranch.SelectedValue);
}
if (this.ddlDesignation.SelectedIndex > 0)
{
EmployeeSearch.DesID = int.Parse(this.ddlDesignation.SelectedValue);
}
//if (this.ddlFant.SelectedIndex > 0) EmployeeSearch.SectionID = int.Parse(this.ddlFant.SelectedValue);
EmployeeSearch.DesType = "O";
//EmployeeSearch.ToDate = null;
return(EmployeeSearch);
}
protected void lstOrgUnits_SelectedIndexChanged(object sender, EventArgs e)
{
try
{
ATTEmployeeWorkDivision attEWD = new ATTEmployeeWorkDivision();
attEWD.OrgID = orgID;
attEWD.OrgUnitID = int.Parse(lstOrgUnits.SelectedValue);
attEWD.DesType = "O";
List <ATTEmployeeWorkDivision> lstEWD = BLLEmployeeWorkDivision.SearchEmployee(attEWD);
grdClerk.DataSource = lstEWD;
grdClerk.DataBind();
List <ATTSectionClerkCase> SecClerkList = BLLSectionClerkCase.GetSecClerkCase(double.Parse(Session["CaseID"].ToString()));
ATTSectionClerkCase att = new ATTSectionClerkCase();
foreach (GridViewRow row in grdClerk.Rows)
{
CheckBox cb = (CheckBox)row.Cells[0].FindControl("chkSelect");
att = SecClerkList.Find(delegate(ATTSectionClerkCase objAtt)
{
return(objAtt.SectionClerkID == double.Parse(row.Cells[1].Text.ToString()));
});
if (att != null)
{
cb.Checked = true;
row.Cells[5].Text = "U";
}
}
}
catch (Exception ex)
{
lblStatusMessage.Text = ex.Message;
programmaticModalPopup.Show();
}
}
public static List <ATTEmployeeWorkDivision> SearchEmployee(ATTEmployeeWorkDivision objEmpDiv)
{
try
{
List <ATTEmployeeWorkDivision> LSTWrkDiv = new List <ATTEmployeeWorkDivision>();
foreach (DataRow row in DLLEmployeeWorkDivision.SearchEmployee(objEmpDiv).Rows)
{
ATTEmployeeWorkDivision obj = new ATTEmployeeWorkDivision();
obj.EmpID = int.Parse(row["EMP_ID"].ToString());
string first_name = row["FIRST_NAME"].ToString();
string mid_name = row["MID_NAME"].ToString();
string sur_name = row["SUR_NAME"].ToString();
if (mid_name != "")
{
obj.FullName = first_name + " " + mid_name + " " + sur_name;
}
else
{
obj.FullName = first_name + " " + sur_name;
}
//obj.OrgEmpNo = int.Parse(row["ORG_EMP_NO"].ToString());
obj.Gender = row["GENDER"].ToString();
obj.OrgID = int.Parse(row["ORG_ID"].ToString());
obj.OrgName = row["ORG_NAME"].ToString();
obj.DesID = int.Parse(row["DES_ID"].ToString());
obj.DesName = row["DES_NAME"].ToString();
obj.DesType = row["DES_TYPE"].ToString();
obj.CreatedDate = row["CREATED_DATE"].ToString();
obj.PostID = int.Parse(row["POST_ID"].ToString());
obj.FromDate = row["FROM_DATE"].ToString();
if (row["ORG_UNIT_ID"] != System.DBNull.Value)
{
obj.OrgUnitID = int.Parse(row["ORG_UNIT_ID"].ToString());
}
obj.UnitName = row["UNIT_NAME"].ToString();
obj.UnitType = row["UNIT_TYPE"].ToString();
//if (row["SECTION_ID"]!= System.DBNull.Value)
//{
// obj.SectionID = int.Parse(row["SECTION_ID"].ToString());
//}
//obj.SectionName=row["SECTION_NAME"].ToString();
obj.UnitFromDate = row["UNIT_FROM_DATE"].ToString();
obj.ToDate = row["TO_DATE"].ToString();
obj.Responsibility = row["RESPONSIBILITY"].ToString();
obj.IsHeadOfUnit = row["UNIT_HEAD"].ToString();
obj.Action = "";
LSTWrkDiv.Add(obj);
}
return(LSTWrkDiv);
}
catch (Exception ex)
{
throw ex;
}
}
public static DataTable SearchEmployee(ATTEmployeeWorkDivision objEmpWrkDiv)
{
try
{
string strSelect = "";
strSelect = "SELECT * FROM VW_EMP_WORK_DISTRIBUTION WHERE 1=1 ";
List <OracleParameter> ParamList = new List <OracleParameter>();
if (objEmpWrkDiv.OrgID > 0)
{
strSelect += "AND ORG_ID = :OrgID";
ParamList.Add(Utilities.GetOraParam(":OrgID", objEmpWrkDiv.OrgID, OracleDbType.Int64, ParameterDirection.Input));
}
if (objEmpWrkDiv.OrgUnitID != null)
{
strSelect += " AND ORG_UNIT_ID = :OrgUnitID";
ParamList.Add(Utilities.GetOraParam(":OrgUnitID", objEmpWrkDiv.OrgUnitID, OracleDbType.Int64, ParameterDirection.Input));
}
if (objEmpWrkDiv.SectionID > 0)
{
strSelect += " AND SECTION_ID = :SectionID";
ParamList.Add(Utilities.GetOraParam(":SectionID", objEmpWrkDiv.SectionID, OracleDbType.Int64, ParameterDirection.Input));
}
if (objEmpWrkDiv.DesType != null)
{
strSelect += " AND DES_TYPE= :DesType";
ParamList.Add(Utilities.GetOraParam(":DesType", objEmpWrkDiv.DesType, OracleDbType.Varchar2, ParameterDirection.Input));
}
if (objEmpWrkDiv.DesID > 0)
{
strSelect += " AND DES_ID = :DesID";
ParamList.Add(Utilities.GetOraParam(":DesID", objEmpWrkDiv.DesID, OracleDbType.Int64, ParameterDirection.Input));
}
if (objEmpWrkDiv.SymbolNo != null)
{
strSelect += " AND SYMBOL_NO = :SymbolNo";
ParamList.Add(Utilities.GetOraParam(":SymbolNo", objEmpWrkDiv.SymbolNo, OracleDbType.Varchar2, ParameterDirection.Input));
}
strSelect += " ORDER BY ORG_ID";
GetConnection conn = new GetConnection();
OracleConnection obj = conn.GetDbConn(Module.PMS);
DataSet ds = SqlHelper.ExecuteDataset(obj, CommandType.Text, strSelect, ParamList.ToArray());
return((DataTable)ds.Tables[0]);
}
catch (Exception ex)
{
throw ex;
}
}
private ATTEmployeeWorkDivision GetFilterOU()
{
ATTEmployeeWorkDivision EmployeeSearch = new ATTEmployeeWorkDivision();
if (this.ddlTransfdOrg.SelectedIndex > 0)
{
EmployeeSearch.OrgID = int.Parse(this.ddlTransfdOrg.SelectedValue);
}
if (this.ddlTransOrgUnit.SelectedIndex > 0)
{
EmployeeSearch.OrgUnitID = int.Parse(this.ddlTransOrgUnit.SelectedValue);
}
return(EmployeeSearch);
}
private void LoadTamildaar()
{
ATTEmployeeWorkDivision obj = new ATTEmployeeWorkDivision();
obj.OrgID = courtID;
obj.DesType = "O";
obj.UnitType = "M";
List <ATTEmployeeWorkDivision> lst = BLLEmployeeWorkDivision.SearchEmployee(obj);
grdTamilDaar.DataSource = lst;
grdTamilDaar.DataBind();
grdEmpSearch.DataSource = lst;
grdEmpSearch.DataBind();
}
protected void ddlSendUnit_SelectedIndexChanged(object sender, EventArgs e)
{
if (ddlSendUnit.SelectedIndex < 1)
{
grdSendEmp.DataSource = null;
grdSendEmp.DataBind();
}
else
{
ATTEmployeeWorkDivision obj = new ATTEmployeeWorkDivision();
obj.OrgID = int.Parse(ddlSendUnit.SelectedValue);
obj.OrgUnitID = int.Parse(ddlSendUnit.SelectedValue);
grdSendEmp.DataSource = GetOrgUnits(obj);
grdSendEmp.DataBind();
}
}
void LoadOrgSectionsClrk()
{
try
{
ATTEmployeeWorkDivision attEWD = new ATTEmployeeWorkDivision();
attEWD.OrgID = orgID;
attEWD.OrgUnitID = int.Parse(DDLSection.SelectedValue);
attEWD.DesType = "O";
List <ATTEmployeeWorkDivision> lstEWD = BLLEmployeeWorkDivision.SearchEmployee(attEWD);
//lstEWD.Insert(0, new ATTEmployeeWorkDivision("शाखा क्लर्क छान्नुस्"));
cbSectionClerk.DataSource = lstEWD;
cbSectionClerk.DataTextField = "FullName";
cbSectionClerk.DataValueField = "EmpID";
cbSectionClerk.DataBind();
}
catch (Exception ex)
{
lblStatusMessage.Text = ex.Message;
programmaticModalPopup.Show();
}
}
private List <ATTEmployeeWorkDivision> GetOrgUnits(ATTEmployeeWorkDivision ob)
{
return(BLLEmployeeWorkDivision.SearchEmployee(ob));
}
private ATTEmployeeWorkDivision GetEmpByPost()
{
ATTEmployeeWorkDivision EmployeeSearch = new ATTEmployeeWorkDivision();
return(EmployeeSearch);
}
protected void btnAdd_Click(object sender, EventArgs e)
{
CollapsiblePanelExtender1.Collapsed = false;
CollapsiblePanelExtender1.ClientState = "false";
this.btnSearchCancel.Enabled = false;
if (grdEmpSearch.SelectedIndex == -1 && grdEmployeeWork.SelectedIndex == -1)
{
this.lblStatusMessage.Text = "कर्मचारी छान्नुहोस्";
this.programmaticModalPopup.Show();
return;
}
if (ddlUnit.SelectedIndex < 1)
{
this.lblStatusMessage.Text = "कर्मचारी छान्नुहोस्";
this.programmaticModalPopup.Show();
return;
}
if (txtFromDate.Text == "")
{
this.lblStatusMessage.Text = "मिति छुट्यो";
this.programmaticModalPopup.Show();
return;
}
try
{
List <ATTEmployeeWorkDivision> lstSave = (List <ATTEmployeeWorkDivision>)Session["EmpWorkDivSave"];
if (grdEmpSearch.SelectedIndex >= 0 && grdEmployeeWork.SelectedIndex == -1)
{
ATTEmployeeWorkDivision objEmpWrkDiv = new ATTEmployeeWorkDivision();
GridViewRow rw = grdEmpSearch.Rows[grdEmpSearch.SelectedIndex];
objEmpWrkDiv.EmpID = int.Parse(rw.Cells[1].Text);
bool exists = lstSave.Exists(
delegate(ATTEmployeeWorkDivision obj)
{
return(obj.EmpID == objEmpWrkDiv.EmpID);
}
);
if (!exists)
{
bool val = false;
if (Server.HtmlDecode(rw.Cells[17].Text) == "" || rw.Cells[17].Text == " ")
{
val = true;
}
else
{
val = (CheckDateIsValid(rw.Cells[17].Text, this.txtFromDate.Text));
}
if (val)
{
objEmpWrkDiv.FullName = rw.Cells[2].Text;
objEmpWrkDiv.OrgID = int.Parse(rw.Cells[4].Text);
objEmpWrkDiv.OrgName = rw.Cells[5].Text;
objEmpWrkDiv.DesID = int.Parse(rw.Cells[6].Text);
objEmpWrkDiv.DesName = rw.Cells[7].Text;
objEmpWrkDiv.CreatedDate = rw.Cells[9].Text;
objEmpWrkDiv.PostID = int.Parse(rw.Cells[10].Text);
objEmpWrkDiv.FromDate = rw.Cells[11].Text;
objEmpWrkDiv.OrgUnitID = int.Parse(this.ddlUnit.SelectedValue);
objEmpWrkDiv.UnitName = this.ddlUnit.SelectedItem.ToString();
//objEmpWrkDiv.SectionID = int.Parse(this.ddlSection.SelectedValue);
//objEmpWrkDiv.SectionName = this.ddlSection.SelectedItem.ToString();
objEmpWrkDiv.UnitFromDate = this.txtFromDate.Text;
objEmpWrkDiv.Responsibility = this.txtResponsibility.Text;
objEmpWrkDiv.EntryBy = Session["UserName"].ToString();
if (this.chkUnitHead.Checked == true)
{
bool pres = lstSave.Exists(
delegate(ATTEmployeeWorkDivision obj)
{
return(obj.UnitName == objEmpWrkDiv.UnitName &&
obj.IsHeadOfUnit == "Y");
}
);
if (pres)
{
EnableDisableAddPanel(false);
grdEmpSearch.SelectedIndex = -1;
lblStatusMessage.Text = "Another Unit Head Already Exists";
programmaticModalPopup.Show();
return;
}
else
{
List <ATTEmployeeWorkDivision> lstEmpWrkDiv = (List <ATTEmployeeWorkDivision>)Session["EmpWorkDiv"];
bool present = lstEmpWrkDiv.Exists(
delegate(ATTEmployeeWorkDivision obj)
{
return(obj.UnitName == objEmpWrkDiv.UnitName &&
obj.IsHeadOfUnit == "Y");
}
);
if (present)
{
EnableDisableAddPanel(false);
grdEmpSearch.SelectedIndex = -1;
lblStatusMessage.Text = "Another Unit Head Already Exists";
programmaticModalPopup.Show();
return;
}
else
{
objEmpWrkDiv.IsHeadOfUnit = "Y";
}
}
}
else
{
objEmpWrkDiv.IsHeadOfUnit = "N";
}
//if (this.chkSectionHead.Checked == true)
//{
// objEmpWrkDiv.IsHeadOfSection = "Y";
//}
//else
//{
// objEmpWrkDiv.IsHeadOfSection = "N";
//}
objEmpWrkDiv.Action = "A";
lstSave.Add(objEmpWrkDiv);
}
else
{
this.lblStatusMessage.Text = " data has invalid date<br/>**New From Date Greater Than Previous From Date";
this.programmaticModalPopup.Show();
this.txtFromDate.Text = "";
ddlUnit.SelectedIndex = -1;
txtResponsibility.Text = "";
chkUnitHead.Checked = false;
this.txtFromDate.Focus();
grdEmpSearch.SelectedIndex = -1;
return;
}
}
else
{
EnableDisableAddPanel(false);
grdEmpSearch.SelectedIndex = -1;
lblStatusMessage.Text = "Already Assigned";
programmaticModalPopup.Show();
return;
}
}
else if (grdEmployeeWork.SelectedIndex >= 0)
{
List <ATTEmployeeWorkDivision> lstEmpWrkDiv = (List <ATTEmployeeWorkDivision>)Session["EmpWorkDiv"];
if (chkUnitHead.Checked)
{
List <ATTEmployeeWorkDivision> lst = lstEmpWrkDiv.FindAll(
delegate(ATTEmployeeWorkDivision obj)
{
return(obj.OrgUnitID == int.Parse(ddlUnit.SelectedValue));
}
);
if (lst.Count > 0)
{
bool exist = lst.Exists(
delegate(ATTEmployeeWorkDivision obj)
{
return(obj.IsHeadOfUnit == "Y");
}
);
if (exist)
{
lblStatusMessage.Text = "Another Unit Head Already Exists";
programmaticModalPopup.Show();
return;
}
}
}
ATTEmployeeWorkDivision objEmpWrkDiv = lstSave[grdEmployeeWork.SelectedIndex];
int indx = lstEmpWrkDiv.FindIndex(
delegate(ATTEmployeeWorkDivision obj)
{
return(obj.EmpID == objEmpWrkDiv.EmpID);
}
);
bool validd = false;
if (indx >= 0)
{
string oldDate = lstEmpWrkDiv[indx].UnitFromDate;
string newDate = txtFromDate.Text;
if (oldDate.Trim() == "")
{
validd = true;
}
else
{
validd = CheckDateIsValid(oldDate, newDate);
}
}
if (validd)
{
objEmpWrkDiv.OrgUnitID = int.Parse(ddlUnit.SelectedValue);
objEmpWrkDiv.UnitName = ddlUnit.SelectedItem.ToString();
objEmpWrkDiv.IsHeadOfUnit = (chkUnitHead.Checked) ? "Y" : "N";
objEmpWrkDiv.Responsibility = txtResponsibility.Text;
objEmpWrkDiv.UnitFromDate = txtFromDate.Text;
}
else
{
this.lblStatusMessage.Text = " data has invalid date<br/>**New From Date Greater Than Previous From Date";
this.programmaticModalPopup.Show();
this.txtFromDate.Text = "";
ddlUnit.SelectedIndex = -1;
txtResponsibility.Text = "";
chkUnitHead.Checked = false;
this.txtFromDate.Focus();
grdEmpSearch.SelectedIndex = -1;
return;
}
}
grdEmployeeWork.DataSource = lstSave;
grdEmployeeWork.DataBind();
ClearControls("add");
}
catch (Exception ex)
{
throw ex;
}
grdEmployeeWork.SelectedIndex = -1;
grdEmpSearch.SelectedIndex = -1;
EnableDisableAddPanel(false);
//}
}
