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); //} }