public static List <ATTEmployeeLeave> LeaveCheck(ATTEmployeeLeave objEmpLeave) { List <ATTEmployeeLeave> lstEmpLeaveApp = new List <ATTEmployeeLeave>(); try { //foreach (ATTLeaveTypeEmployee var in LSTEmpLeave) //{ foreach (DataRow drow in DLLEmployeeLeaveApprove.LeaveCheck(objEmpLeave).Rows) { ATTEmployeeLeave objEmpAppCheck = new ATTEmployeeLeave(); objEmpAppCheck.OutMessage = drow["Out_Message"].ToString(); objEmpAppCheck.PeriodType = drow["Period_Type"].ToString(); objEmpAppCheck.PeriodCount = int.Parse(drow["Period_Count"].ToString()); objEmpAppCheck.PFY = drow["Fiscal_Year"].ToString(); //if (objEmpAppCheck.OutMessage == "OK") //{ // get_ok(objEmpAppCheck.PeriodCount, objEmpAppCheck.PFY, objEmpAppCheck.PeriodType); //} lstEmpLeaveApp.Add(objEmpAppCheck); } //} return(lstEmpLeaveApp); } catch (Exception ex) { throw ex; } }
protected void btnApprAdd_Click(object sender, EventArgs e) { if (txtApprName.Text != "") { this.btnAppSubmit.Enabled = true; } string msg = EmptyMessage(); if (msg != "") { this.lblStatusMessage.Text = msg; this.programmaticModalPopup.Show(); return; } else { try { List <ATTEmployeeLeave> LSTEmpLeave = (List <ATTEmployeeLeave>)Session["EmployeeLeave"]; ATTEmployeeLeave objEmpLST = LSTEmpLeave[grdRecLeaveApplications.SelectedIndex]; //bool a = txtApprName.HasAttributes; objEmpLST.AppByID = int.Parse(txtApprName.Attributes["ID"].ToString()); objEmpLST.AppByName = this.txtApprName.Text; objEmpLST.AppDate = this.txtApprDate.Text; objEmpLST.AppFrom = this.txtApprFrom.Text; objEmpLST.AppTo = this.txtApprTo.Text; objEmpLST.AppDays = int.Parse(txtApprDays.Text); if (chkbxAppr.Checked == true) { objEmpLST.Approved = "Y"; } else { objEmpLST.Approved = "N"; } objEmpLST.AppReason = this.txtApprReason.Text; objEmpLST.Action = "E"; //LSTEmpLeave[grdRecLeaveApplications.SelectedIndex] = objEmpLST; //grdRecLeaveApplications.SelectedIndex = -1; Session["EmployeeLeave"] = LSTEmpLeave; grdRecLeaveApplications.DataSource = LSTEmpLeave; grdRecLeaveApplications.DataBind(); btnAppSubmit.Enabled = true; //grdRecLeaveApplications.SelectedIndex = -1; ClearControls("Search"); ClearControls("Submit"); } catch (Exception ex) { this.lblStatusMessage.Text = ex.Message.ToString(); this.programmaticModalPopup.Show(); return; } } }
public static DataTable LeaveCheck(ATTEmployeeLeave var) { GetConnection conn = new GetConnection(); OracleConnection DBConn = conn.GetDbConn(Module.PMS); string InsertUpdateDLSP = "SP_LEAVE_CHECK"; try { DataTable dt = new DataTable(); //foreach (ATTEmployeeLeave var in lstEmpLeave) //{ OracleParameter[] paramArray = new OracleParameter[9]; paramArray[0] = Utilities.GetOraParam(":P_EMP_ID", var.EmpID, OracleDbType.Int32, ParameterDirection.Input); paramArray[1] = Utilities.GetOraParam("P_FROM_DATE", var.AppFrom, OracleDbType.Varchar2, ParameterDirection.Input); paramArray[2] = Utilities.GetOraParam("P_TO_DATE", var.AppTo, OracleDbType.Varchar2, ParameterDirection.Input); paramArray[3] = Utilities.GetOraParam("P_NO_OF_DAYS", var.AppDays, OracleDbType.Int32, ParameterDirection.Input); paramArray[4] = Utilities.GetOraParam("P_LEAVE_TYPE_ID", var.LeaveTypeID, OracleDbType.Int32, ParameterDirection.Input); paramArray[5] = Utilities.GetOraParam("P_OUT_MSG", null, OracleDbType.Varchar2, ParameterDirection.Output); paramArray[5].Size = 100; paramArray[6] = Utilities.GetOraParam("P_PERIOD_TYPE", null, OracleDbType.Varchar2, ParameterDirection.Output); paramArray[6].Size = 1; paramArray[7] = Utilities.GetOraParam("P_PERIOD_COUNT", null, OracleDbType.Int32, ParameterDirection.Output); paramArray[8] = Utilities.GetOraParam("P_FY", null, OracleDbType.Varchar2, ParameterDirection.Output); paramArray[8].Size = 5; DataSet ds = SqlHelper.ExecuteDataset(DBConn, CommandType.StoredProcedure, InsertUpdateDLSP, paramArray); string out_msg = paramArray[5].Value.ToString(); string period_type = paramArray[6].Value.ToString(); int period_count = int.Parse(paramArray[7].Value.ToString()); string p_fy = paramArray[8].ToString(); //making a datatable for the above variables dt.Columns.Add(new DataColumn("Out_Message")); dt.Columns.Add(new DataColumn("Period_Type")); dt.Columns.Add(new DataColumn("Period_Count")); dt.Columns.Add(new DataColumn("Fiscal_Year")); DataRow drw = dt.NewRow(); drw["Out_Message"] = out_msg; drw["Period_Type"] = period_type; drw["Period_Count"] = period_count; drw["Fiscal_Year"] = p_fy; dt.Rows.Add(drw); //dt = (DataTable)ds.Tables[0]; //} return(dt); } catch (Exception ex) { throw ex; } }
public static bool LeaveApprove(ATTEmployeeLeave objEmpLeave) { try { return(DLLEmployeeLeaveApprove.LeaveApprove(objEmpLeave)); } catch (Exception ex) { throw ex; } }
protected void OkButton2_Click(object sender, EventArgs e) { List <ATTEmployeeLeave> lstEmployeeLeave = (List <ATTEmployeeLeave>)Session["EmployeeLeave"]; ATTEmployeeLeave objEmp = lstEmployeeLeave[int.Parse(Session["index"].ToString())]; if (BLLEmployeeLeaveApprove.LeaveApprove(objEmp)) { this.lblStatusMessage.Text = "Information Saved"; this.programmaticModalPopup.Show(); } }
protected void btnAppSubmit_Click1(object sender, EventArgs e) { try { List <ATTEmployeeLeave> lstEmployeeLeave = (List <ATTEmployeeLeave>)Session["EmployeeLeave"]; ATTEmployeeLeave objEmp = lstEmployeeLeave[int.Parse(Session["index"].ToString())]; objEmp.EntryBy = Session["UserName"].ToString(); if (objEmp.Approved == "N") { if (BLLEmployeeLeaveApprove.LeaveApprove(objEmp)) { this.lblStatusMessage.Text = "Employee Leave Approved Successfully"; this.programmaticModalPopup.Show(); grdRecLeaveApplications.DataSource = BLLEmployeeLeave.GetEmployeeLeave(null, "APP"); grdRecLeaveApplications.DataBind(); } } else { List <ATTEmployeeLeave> LSTLvAPP = BLLEmployeeLeaveApprove.LeaveCheck(objEmp); if (LSTLvAPP[0].OutMessage != "OK") { this.lblStatusMessage2.Text = LSTLvAPP[0].OutMessage; this.programmaticModalPopup2.Show(); return; } else if (LSTLvAPP[0].OutMessage == "OK") { if (BLLEmployeeLeaveApprove.LeaveApprove(objEmp)) { this.lblStatusMessage.Text = "Employee Leave Approved Successfully"; this.programmaticModalPopup.Show(); this.CollapsiblePanelExtender1.Collapsed = true; this.CollapsiblePanelExtender1.ClientState = "true"; grdRecLeaveApplications.DataSource = BLLEmployeeLeave.GetEmployeeLeave(null, "APP"); grdRecLeaveApplications.DataBind(); } } } ClearControls("Submit"); } catch (Exception ex) { this.lblStatusMessage.Text = ex.Message.ToString(); this.programmaticModalPopup.Show(); } }
protected void btnAppSubmit_Click1(object sender, EventArgs e) { try { List <ATTEmployeeLeave> lstEmployeeLeave = (List <ATTEmployeeLeave>)Session["EmployeeLeave"]; ATTEmployeeLeave objEmp = lstEmployeeLeave[int.Parse(Session["index"].ToString())]; objEmp.EntryBy = Session["UserName"].ToString(); if (objEmp.Approved == "N") { if (BLLEmployeeLeaveApprove.LeaveApprove(objEmp)) { this.lblStatusMessage.Text = "Information Saved"; this.programmaticModalPopup.Show(); } } else { List <ATTEmployeeLeave> LSTLvAPP = BLLEmployeeLeaveApprove.LeaveCheck(objEmp); if (LSTLvAPP[0].OutMessage != "OK") { this.lblStatusMessage2.Text = LSTLvAPP[0].OutMessage; this.programmaticModalPopup2.Show(); } else if (LSTLvAPP[0].OutMessage == "OK") { if (BLLEmployeeLeaveApprove.LeaveApprove(objEmp)) { this.lblStatusMessage.Text = "Information Saved"; this.programmaticModalPopup.Show(); } } } //if (BLLEmployeeLeave.SaveEmpLeaveApplication(lstEmployeeLeave)) //{ // this.lblStatusMessage.Text = "Information Saved."; // this.programmaticModalPopup.Show(); //} ClearControls("Submit"); } catch (Exception ex) { this.lblStatusMessage.Text = ex.Message.ToString(); this.programmaticModalPopup.Show(); } }
protected void btnApplSubmit_Click(object sender, EventArgs e) { if (ddlAppType.SelectedIndex == 0) { lblStatusMessage.Text = "Please Select leave Type first"; programmaticModalPopup.Show(); return; } if (txtEmpDate.Text == "") { lblStatusMessage.Text = "Please Enter Application Date first"; programmaticModalPopup.Show(); return; } List <ATTEmployeeLeave> LSTEmpLeave = new List <ATTEmployeeLeave>(); try { ATTEmployeeLeave att = new ATTEmployeeLeave(); att.EmpID = int.Parse(Session["UserID"].ToString()); att.EmpFullName = Session["UserName"].ToString(); att.ReqdFrom = txtEmpLvFrom.Text; att.ReqdTo = txtEmpLvTo.Text; att.LeaveTypeID = int.Parse(this.ddlAppType.SelectedValue.ToString()); att.EmpDays = int.Parse(txtEmpLvDays.Text.ToString()); att.ApplDate = txtEmpDate.Text; att.EmpReason = txtEmpLvResn.Text; att.EntryBy = Session["UserName"].ToString(); att.EntryDate = ""; att.Action = "A"; LSTEmpLeave.Add(att); if (BLLEmployeeLeave.SaveEmpLeaveApplication(LSTEmpLeave)) { ClearControls(); lblStatusMessage.Text = "Saved Successfully"; programmaticModalPopup.Show(); } } catch (Exception ex) { lblStatusMessage.Text = ex.Message; programmaticModalPopup.Show(); } }
public static bool LeaveApprove(ATTEmployeeLeave var) { OracleTransaction Tran; GetConnection conn = new GetConnection(); OracleConnection DBConn = conn.GetDbConn(Module.PMS); Tran = DBConn.BeginTransaction(); try { string InsertUpdateDLSP = "SP_LEAVE_APPROVE"; OracleParameter[] paramArray = new OracleParameter[16]; paramArray[0] = Utilities.GetOraParam("P_IS_OTHERS", null, OracleDbType.Varchar2, ParameterDirection.Input); paramArray[1] = Utilities.GetOraParam(":P_EMP_ID", var.EmpID, OracleDbType.Int32, ParameterDirection.Input); paramArray[2] = Utilities.GetOraParam(":P_LEAVE_TYPE_ID", var.LeaveTypeID, OracleDbType.Int32, ParameterDirection.Input); paramArray[3] = Utilities.GetOraParam(":P_APPL_DATE", var.ApplDate, OracleDbType.Varchar2, ParameterDirection.Input); paramArray[4] = Utilities.GetOraParam(":P_APP_BY", var.AppByID, OracleDbType.Int32, ParameterDirection.Input); paramArray[5] = Utilities.GetOraParam(":P_APP_DATE", var.AppDate, OracleDbType.Varchar2, ParameterDirection.Input); paramArray[6] = Utilities.GetOraParam(":P_APP_FROM_DATE", var.AppFrom, OracleDbType.Varchar2, ParameterDirection.Input); paramArray[7] = Utilities.GetOraParam(":P_APP_TO_DATE", var.AppTo, OracleDbType.Varchar2, ParameterDirection.Input); paramArray[8] = Utilities.GetOraParam(":P_APP_NO_OF_DAYS", var.AppDays, OracleDbType.Int32, ParameterDirection.Input); paramArray[9] = Utilities.GetOraParam(":P_APP_YES_NO", var.Approved, OracleDbType.Varchar2, ParameterDirection.Input); paramArray[10] = Utilities.GetOraParam(":P_APP_REASON", var.AppReason, OracleDbType.Varchar2, ParameterDirection.Input); paramArray[11] = Utilities.GetOraParam(":P_LEAVE_FY", null, OracleDbType.Varchar2, ParameterDirection.Input); paramArray[12] = Utilities.GetOraParam("P_LEAVE_PERIOD_UNIT", null, OracleDbType.Int32, ParameterDirection.Input); paramArray[13] = Utilities.GetOraParam("P_PERIOD_TYPE", null, OracleDbType.Varchar2, ParameterDirection.Input); paramArray[14] = Utilities.GetOraParam("P_PERIOD_COUNT", null, OracleDbType.Int32, ParameterDirection.Input); paramArray[15] = Utilities.GetOraParam("P_LEAVE_TAKEN_CNT", null, OracleDbType.Int32, ParameterDirection.Input); SqlHelper.ExecuteNonQuery(Tran, CommandType.StoredProcedure, InsertUpdateDLSP, paramArray); Tran.Commit(); } catch (Exception ex) { Tran.Rollback(); throw ex; } finally { DBConn.Close(); } return(true); }
public static List <ATTEmployeeLeave> GetEmpDesLeave(int eid) { List <ATTEmployeeLeave> lstEmployeeLeave = new List <ATTEmployeeLeave>(); try { foreach (DataRow row in DLLEmployeeLeave.GetEmpDesLeave(eid).Rows) { ATTEmployeeLeave ObjAtt = new ATTEmployeeLeave(); ObjAtt.LeaveTypeID = int.Parse(row["LEAVE_TYPE_ID"].ToString()); ObjAtt.NoOfDays = int.Parse(row["NO_OF_DAYS"].ToString()); ObjAtt.LeaveType = row["LEAVE_TYPE_NAME"].ToString(); lstEmployeeLeave.Add(ObjAtt); } return(lstEmployeeLeave); } catch (Exception ex) { throw ex; } }
public static List <ATTEmployeeLeave> GetaApprovedLeave(string fromdate, string todate, int orgid, int desid) { List <ATTEmployeeLeave> LSTApprovedLeaves = new List <ATTEmployeeLeave>(); try { foreach (DataRow row in DLLEmployeeLeaveApprove.GetApprovedLeaves(fromdate, todate, orgid, desid).Rows) { ATTEmployeeLeave objEmpApprLeaves = new ATTEmployeeLeave(); objEmpApprLeaves.EmpID = int.Parse(row["EMP_ID"].ToString()); objEmpApprLeaves.EmpFullName = row["EMPFULLNAME"].ToString(); //objEmpApprLeaves.AppTo=row["TO_DATE"].ToString(); objEmpApprLeaves.ApprovedLeaves = row["EMP_APPR_LEAVE"].ToString(); LSTApprovedLeaves.Add(objEmpApprLeaves); } return(LSTApprovedLeaves); } catch (Exception ex) { throw ex; } }
public static List <ATTEmployeeLeave> GetEmployeeLeave(int?empID, string REQ_REC_APP) { List <ATTEmployeeLeave> lstEmployeeLeave = new List <ATTEmployeeLeave>(); try { if (REQ_REC_APP == "REQ") { foreach (DataRow row in DLLEmployeeLeave.GetEmployeeLeave(empID, REQ_REC_APP).Rows) { ATTEmployeeLeave ObjAtt = new ATTEmployeeLeave(); ObjAtt.EmpID = int.Parse(row["EMP_ID"].ToString()); ObjAtt.EmpFullName = row["EMPLOYEENAME"].ToString(); ObjAtt.ApplDate = row["APPL_DATE"].ToString(); ObjAtt.LeaveTypeID = int.Parse(row["LEAVE_TYPE_ID"].ToString()); ObjAtt.LeaveType = row["LEAVE_TYPE_NAME"].ToString(); ObjAtt.ReqdFrom = row["REQ_FROM_DATE"].ToString(); ObjAtt.ReqdTo = row["REQ_TO_DATE"].ToString(); ObjAtt.EmpDays = int.Parse(row["REQ_NO_OF_DAYS"].ToString()); ObjAtt.EmpReason = row["REQ_REASON"].ToString(); //ObjAtt.EntryBy = row["ENTRY_BY"].ToString(); //ObjAtt.EntryDate = row["ENTRY_DATE"].ToString(); ObjAtt.Action = ""; lstEmployeeLeave.Add(ObjAtt); } } else if (REQ_REC_APP == "REC") { foreach (DataRow row in DLLEmployeeLeave.GetEmployeeLeave(empID, REQ_REC_APP).Rows) { ATTEmployeeLeave ObjAtt = new ATTEmployeeLeave(); ObjAtt.EmpID = int.Parse(row["EMP_ID"].ToString()); ObjAtt.EmpFullName = row["EMPLOYEENAME"].ToString(); ObjAtt.ApplDate = row["APPL_DATE"].ToString(); ObjAtt.LeaveTypeID = int.Parse(row["LEAVE_TYPE_ID"].ToString()); ObjAtt.LeaveType = row["LEAVE_TYPE_NAME"].ToString(); ObjAtt.ReqdFrom = row["REQ_FROM_DATE"].ToString(); ObjAtt.ReqdTo = row["REQ_TO_DATE"].ToString(); ObjAtt.EmpDays = int.Parse(row["REQ_NO_OF_DAYS"].ToString()); ObjAtt.EmpReason = row["REQ_REASON"].ToString(); ObjAtt.RecByName = row["RCMDNAME"].ToString(); ObjAtt.RecDate = row["REC_DATE"].ToString(); ObjAtt.RecFrom = row["REC_FROM_DATE"].ToString(); ObjAtt.RecTo = row["REC_TO_DATE"].ToString(); if (row["REC_NO_OF_DAYS"].ToString() == "") { ObjAtt.RecDays = null; } else { ObjAtt.RecDays = int.Parse(row["REC_NO_OF_DAYS"].ToString()); } ObjAtt.Recommended = row["REC_YES_NO"].ToString(); ObjAtt.RecReason = row["REC_REASON"].ToString(); ObjAtt.Action = ""; lstEmployeeLeave.Add(ObjAtt); } } else if (REQ_REC_APP == "APP") { foreach (DataRow row in DLLEmployeeLeave.GetEmployeeLeave(empID, REQ_REC_APP).Rows) { ATTEmployeeLeave ObjAtt = new ATTEmployeeLeave(); ObjAtt.EmpID = int.Parse(row["EMP_ID"].ToString()); ObjAtt.EmpFullName = row["EMPLOYEENAME"].ToString(); ObjAtt.ApplDate = row["APPL_DATE"].ToString(); ObjAtt.LeaveTypeID = int.Parse(row["LEAVE_TYPE_ID"].ToString()); ObjAtt.LeaveType = row["LEAVE_TYPE_NAME"].ToString(); ObjAtt.ReqdFrom = row["REQ_FROM_DATE"].ToString(); ObjAtt.ReqdTo = row["REQ_TO_DATE"].ToString(); ObjAtt.EmpDays = int.Parse(row["REQ_NO_OF_DAYS"].ToString()); ObjAtt.EmpReason = row["REQ_REASON"].ToString(); ObjAtt.RecByName = row["RCMDNAME"].ToString(); ObjAtt.RecDate = row["REC_DATE"].ToString(); ObjAtt.RecFrom = row["REC_FROM_DATE"].ToString(); ObjAtt.RecTo = row["REC_TO_DATE"].ToString(); if (row["REC_NO_OF_DAYS"].ToString() == "") { ObjAtt.RecDays = null; } else { ObjAtt.RecDays = int.Parse(row["REC_NO_OF_DAYS"].ToString()); } ObjAtt.RecReason = row["REC_REASON"].ToString(); ObjAtt.Recommended = row["REC_YES_NO"].ToString(); ObjAtt.AppByName = row["APPNAME"].ToString(); ObjAtt.AppDate = row["APP_DATE"].ToString(); ObjAtt.AppFrom = row["APP_FROM_DATE"].ToString(); ObjAtt.AppTo = row["APP_TO_DATE"].ToString(); if (row["APP_NO_OF_DAYS"].ToString() == "") { ObjAtt.AppDays = null; } else { ObjAtt.AppDays = int.Parse(row["APP_NO_OF_DAYS"].ToString()); } ObjAtt.Approved = row["APP_YES_NO"].ToString(); ObjAtt.AppReason = row["APP_REASON"].ToString(); ObjAtt.Action = ""; lstEmployeeLeave.Add(ObjAtt); } } return(lstEmployeeLeave); } catch (Exception ex) { throw ex; } }
protected void btnAddRecommendation_Click(object sender, EventArgs e) { if (this.grdEmployee.SelectedIndex == -1) { this.lblStatusMessage.Text = "**कर्मचारी छान्नुहोस्"; this.programmaticModalPopup.Show(); } string msg = EmptyMessage("rec"); if (msg != "") { this.lblStatusMessage.Text = msg; this.programmaticModalPopup.Show(); return; } else { try { List <ATTEmployeeLeave> lstEmployeeLeave = (List <ATTEmployeeLeave>)Session["EmployeeLeave"]; ATTEmployeeLeave objEmpLST = lstEmployeeLeave[grdLeaveApplications.SelectedIndex]; int empid = lstEmployeeLeave[grdLeaveApplications.SelectedIndex].EmpID; int recid = int.Parse(txtRecName.Attributes["ID"].ToString()); if (recid == empid) { btnRecSubmit.Enabled = false; this.lblStatusMessage.Text = "**सिफारिस गर्ने कर्मचारी मिलेन....</n>**र्कपया अर्को कर्मचारी छान्नुहोस्"; this.programmaticModalPopup.Show(); this.txtRecName.Text = ""; this.txtRecName.Focus(); return; } objEmpLST.RecByID = int.Parse(txtRecName.Attributes["ID"].ToString()); objEmpLST.RecByName = this.txtRecName.Text; objEmpLST.RecDate = this.txtRecDate.Text; objEmpLST.RecFrom = this.txtRecFrom.Text; objEmpLST.RecTo = this.txtRecTo.Text; objEmpLST.RecDays = int.Parse(txtRecDays.Text); if (chkbxRec.Checked == true) { objEmpLST.Recommended = "Y"; } else { objEmpLST.Recommended = "N"; } objEmpLST.RecReason = this.txtRecReason.Text; //objEmpLST.Approved = "N"; objEmpLST.Action = "E"; //LSTEmpLeave.Add(objEmpLST); Session["EmployeeLeave"] = lstEmployeeLeave; grdLeaveApplications.DataSource = lstEmployeeLeave; grdLeaveApplications.DataBind(); btnRecSubmit.Enabled = true; grdLeaveApplications.SelectedIndex = -1; ClearControls(1, 0, 2, 0); } catch (Exception ex) { this.lblStatusMessage.Text = ex.Message.ToString(); this.programmaticModalPopup.Show(); return; } } }
//button events protected void btnAddApplication_Click(object sender, EventArgs e) { if (this.grdEmployee.SelectedIndex == -1) { this.lblStatusMessage.Text = "**कर्मचारी छान्नुहोस्"; this.programmaticModalPopup.Show(); } ddlAppType.Enabled = true; string msg = EmptyMessage("appl"); if (msg != "") { this.lblStatusMessage.Text = msg; this.programmaticModalPopup.Show(); return; } else { try { List <ATTEmployeeLeave> LSTEmpLeave = (List <ATTEmployeeLeave>)Session["EmployeeLeave"]; if (LSTEmpLeave == null) { LSTEmpLeave = new List <ATTEmployeeLeave>(); } ATTEmployeeLeave objEmpLST = new ATTEmployeeLeave(); if (this.grdLeaveApplications.SelectedIndex > -1) { objEmpLST = LSTEmpLeave[grdLeaveApplications.SelectedIndex]; objEmpLST.EmpID = int.Parse(txtEmpName.Attributes["ID"].ToString()); objEmpLST.EmpFullName = this.txtEmpName.Text; objEmpLST.ApplDate = this.txtEmpDate.Text; objEmpLST.LeaveTypeID = int.Parse(this.ddlAppType.SelectedValue.ToString()); objEmpLST.LeaveType = this.ddlAppType.SelectedItem.ToString(); objEmpLST.ReqdFrom = this.txtEmpLvFrom.Text; objEmpLST.ReqdTo = this.txtEmpLvTo.Text; objEmpLST.EmpDays = int.Parse(this.txtEmpLvDays.Text.ToString()); objEmpLST.EmpReason = this.txtEmpLvResn.Text; objEmpLST.EntryBy = Session["UserName"].ToString(); objEmpLST.EntryDate = ""; objEmpLST.Action = "E"; } else { objEmpLST.EmpID = int.Parse(grdEmployee.SelectedRow.Cells[0].Text); int searchEmp = objEmpLST.EmpID; List <ATTEmployeeLeave> LST = LSTEmpLeave.FindAll( delegate(ATTEmployeeLeave obj) { return(searchEmp == obj.EmpID); } ); if (LST.Count > 0) { this.lblStatusMessage.Text = "This employee have already applied for leave and is not yet recommended"; this.programmaticModalPopup.Show(); this.btnApplSubmit.Enabled = false; return; } objEmpLST.EmpFullName = this.txtEmpName.Text; objEmpLST.ApplDate = this.txtEmpDate.Text; objEmpLST.LeaveTypeID = int.Parse(this.ddlAppType.SelectedValue.ToString()); objEmpLST.LeaveType = this.ddlAppType.SelectedItem.ToString(); objEmpLST.ReqdFrom = this.txtEmpLvFrom.Text; objEmpLST.ReqdTo = this.txtEmpLvTo.Text; objEmpLST.EmpDays = int.Parse(this.txtEmpLvDays.Text.ToString()); objEmpLST.EmpReason = this.txtEmpLvResn.Text; objEmpLST.EntryBy = Session["UserName"].ToString(); objEmpLST.EntryDate = ""; objEmpLST.Action = "A"; LSTEmpLeave.Add(objEmpLST); } Session["EmployeeLeave"] = LSTEmpLeave; grdLeaveApplications.DataSource = LSTEmpLeave; grdLeaveApplications.DataBind(); if (LSTEmpLeave.Count > 0) { this.grdLeaveApplications.Visible = true; btnApplSubmit.Enabled = true; } else { this.grdLeaveApplications.Visible = false; btnApplSubmit.Enabled = false; } ClearControls(1, 2, 0, 0); } catch (Exception ex) { this.lblStatusMessage.Text = ex.Message.ToString(); this.programmaticModalPopup.Show(); return; } } }
protected void btnSearch_Click(object sender, EventArgs e) { //int leaveCount=0; if (ddlMonth.SelectedIndex <= 0) { this.lblStatusMessage.Text = "महिना छान्नुहोस्"; this.programmaticModalPopup.Show(); return; } GetCalender(); GetMonthlyHolidays(); int sata = (int)Session["Saturdays_Date"]; int holidayCounts = (int)Session["MonthlyHolidaysCount"]; foreach (GridViewRow rw in this.grdAttendance.Rows) { rw.Cells[36].Text = holidayCounts.ToString(); rw.Cells[37].Text = sata.ToString(); } int orgid = int.Parse(this.ddlOrganization.SelectedValue.ToString()); int desid = 0; if (this.ddlDesignation.SelectedIndex > 0) { desid = int.Parse(this.ddlDesignation.SelectedValue.ToString()); } //----------------------------------------------------------------------------------------------------------- #region Leave DataTable dt = SetDataTable(); string FromDate = ddlYear.SelectedValue + "/" + ddlMonth.SelectedValue + "/" + "01"; string ToDate = ""; if (ddlMonth.SelectedIndex > 0 && ddlMonth.SelectedValue != "12") { ToDate = ddlYear.SelectedValue + "/" + 00 + (int.Parse(ddlMonth.SelectedValue) + 1) + "/" + "01"; } else if (ddlMonth.SelectedIndex > 0 & ddlMonth.SelectedValue == "12") { ToDate = (int.Parse(ddlYear.SelectedValue) + 1) + "/" + 00 + (int.Parse(ddlMonth.SelectedValue) + 1) + "/" + "01"; } List <ATTEmployeeLeave> LSTEmpLeave = BLLEmployeeLeaveApprove.GetaApprovedLeave(FromDate, ToDate, orgid, desid); List <ATTEmployeeLeave> PersonLv = new List <ATTEmployeeLeave>(); foreach (ATTEmployeeLeave lst in LSTEmpLeave) { bool existed = PersonLv.Exists( delegate(ATTEmployeeLeave obj) { return(obj.EmpID == lst.EmpID); } ); if (!existed) { ATTEmployeeLeave objLeave = new ATTEmployeeLeave(); objLeave = lst; PersonLv.Add(objLeave); } } if (PersonLv.Count > 0) { foreach (ATTEmployeeLeave lsts in PersonLv) { DataRow dr = dt.NewRow(); int i = LSTEmpLeave.FindIndex(delegate(ATTEmployeeLeave obj) { return(obj.EmpID == lsts.EmpID); } ); if (i >= 0) { dr[1] = LSTEmpLeave[i].EmpFullName.ToString(); dt.Rows.Add(dr); } } } if (LSTEmpLeave.Count > 0) { int k = 0; foreach (ATTEmployeeLeave lsts in LSTEmpLeave) { if (lsts.ApprovedLeaves.Trim() != "") { string[] lvs = lsts.ApprovedLeaves.Split(','); for (int j = 0; j < lvs.Length; j++) { if (lvs[j].Length == 1) { lvs[j] = "0" + lvs[j]; } dt.Rows[k][lvs[j]] = "L"; } dt.Rows[k]["Leave"] = lvs.Length; } k++; } } else { DataRow dr = dt.NewRow(); dt.Rows.Add(dr); //GetCalender(); } #endregion //----------------------------------------------------------------------------------------------------------- #region Present string yearmonth = this.ddlYear.SelectedValue.ToString() + "/" + ddlMonth.SelectedValue.ToString(); List <ATTAttendance> LSTAttendance = BLLAttendance.GetEmpAttendance(orgid, desid, yearmonth); List <ATTAttendance> Persons = new List <ATTAttendance>(); foreach (ATTAttendance lst in LSTAttendance) { bool existed = Persons.Exists( delegate(ATTAttendance obj) { return(obj.EmpID == lst.EmpID); } ); if (!existed) { ATTAttendance objAttn = new ATTAttendance(); objAttn = lst; Persons.Add(objAttn); } } //DataTable dt = SetDataTable(); if (Persons.Count > 0) { foreach (ATTAttendance lst in Persons) { int i = LSTEmpLeave.FindIndex(delegate(ATTEmployeeLeave obj) { return(obj.EmpID == lst.EmpID); } ); if (i >= 0) { //DataRow dr = dt.NewRow(); //dt.Rows[i]["FullName"] = lst.EmpFullName.ToString(); List <ATTAttendance> LST = LSTAttendance.FindAll(delegate(ATTAttendance obj) { return(lst.EmpID == obj.EmpID); }); foreach (ATTAttendance var in LST) { string day = var.PresentDate.Substring((var.PresentDate.LastIndexOf('/') + 1), 2); if (day != null) { dt.Rows[i][day] = "P"; } } } } } //else //{ // DataRow dr = dt.NewRow(); // dt.Rows.Add(dr); // //GetCalender(); //} #endregion //----------------------------------------------------------------------------------------------------------- string holidays = Session["Month"].ToString(); //string fromDate=holidays.Substring(1,4) ((str.LastIndexOf('/') + 1), (str.Length - (str.LastIndexOf('/') + 1))); int sat = (int)Session["Saturdays_Date"]; int holidayCount = (int)Session["MonthlyHolidaysCount"]; int daysCount = (int)Session["Days"]; //int leaveCount = (int)Session["ApprovedLeavesCount"]; //foreach (GridViewRow rw in this.grdAttendance.Rows) //{ // //rw.Cells[35].Text = LeaveCount.ToString(); // rw.Cells.["Holiday"].Text = holidayCount.ToString(); // rw.Cells["Weekend"].Text = sat.ToString(); //} foreach (DataRow rw in dt.Rows) { int leaveCount = 0; string lvCnt = rw["Leave"].ToString(); if (lvCnt != "") { leaveCount = int.Parse(lvCnt); } //rw.Cells[35].Text = LeaveCount.ToString(); rw["Holiday"] = holidayCount.ToString(); rw["Weekend"] = sat.ToString(); string workingDays = (daysCount - (holidayCount + sat)).ToString(); rw["WorkingDays"] = workingDays; Session["WorkDays"] = workingDays; foreach (DataColumn dc in dt.Columns) { string st = rw[dc].ToString().Trim(); if (st == "") { rw[dc] = "A"; } } string ACheck = rw["Leave"].ToString().Trim(); string FCheck = rw["FullName"].ToString().Trim(); if (ACheck == "A") { rw["Leave"] = ""; } if (FCheck == "A") { rw["FullName"] = ""; } } int colCount = dt.Columns.Count; foreach (DataRow dr in dt.Rows) { int AbsCount = 0; int PresCount = 0; for (int i = 0; i < colCount - 1; i++) { if (dr[i].ToString() == "A") { AbsCount++; } else if (dr[i].ToString() == "P") { PresCount++; } } dr["Absent"] = AbsCount.ToString(); dr["Present"] = PresCount.ToString(); } grdAttendance.DataSource = dt; grdAttendance.DataBind(); Session["Data"] = dt; }
//button events protected void btnAddApplication_Click(object sender, EventArgs e) { ddlAppType.Enabled = true; string msg = EmptyMessage("appl"); if (msg != "") { this.lblStatusMessage.Text = msg; this.programmaticModalPopup.Show(); return; } else { try { List <ATTEmployeeLeave> LSTEmpLeave = (List <ATTEmployeeLeave>)Session["EmployeeLeave"]; if (LSTEmpLeave == null) { LSTEmpLeave = new List <ATTEmployeeLeave>(); } else if (LSTEmpLeave.Count > 0) { btnApplSubmit.Enabled = true; } ATTEmployeeLeave objEmpLST = new ATTEmployeeLeave(); objEmpLST.EmpID = int.Parse(txtEmpName.Attributes["ID"].ToString()); objEmpLST.EmpFullName = this.txtEmpName.Text; objEmpLST.ApplDate = this.txtEmpDate.Text; objEmpLST.LeaveTypeID = int.Parse(this.ddlAppType.SelectedValue.ToString()); objEmpLST.LeaveType = this.ddlAppType.SelectedItem.ToString(); objEmpLST.ReqdFrom = this.txtEmpLvFrom.Text; objEmpLST.ReqdTo = this.txtEmpLvTo.Text; objEmpLST.EmpDays = int.Parse(this.txtEmpLvDays.Text.ToString()); objEmpLST.EmpReason = this.txtEmpLvResn.Text; objEmpLST.EntryBy = Session["UserName"].ToString(); objEmpLST.EntryDate = ""; objEmpLST.Action = "A"; if (grdLeaveApplications.SelectedIndex == -1) { //if (lstLeaveTypeEmployee.Count > 0) //{ foreach (ATTEmployeeLeave leave in LSTEmpLeave) { if (leave.LeaveTypeID == int.Parse(ddlAppType.SelectedValue)) { grdLeaveApplications.SelectedIndex = -1; this.lblStatusMessage.Text = " This Leave Type Already Exists. "; this.programmaticModalPopup.Show(); return; } } //} LSTEmpLeave.Add(objEmpLST); } else { objEmpLST.Action = (LSTEmpLeave[grdLeaveApplications.SelectedIndex].Action == "A" ? "A" : "E"); LSTEmpLeave[grdLeaveApplications.SelectedIndex] = objEmpLST; } Session["EmployeeLeave"] = LSTEmpLeave; grdLeaveApplications.DataSource = LSTEmpLeave; grdLeaveApplications.DataBind(); if (LSTEmpLeave.Count > 0) { this.grdLeaveApplications.Visible = true; } ClearControls(1, 2, 0); } catch (Exception ex) { this.lblStatusMessage.Text = ex.Message.ToString(); this.programmaticModalPopup.Show(); return; } } }