public void GetReport() { DateTime FromDate = new DateTime(); DateTime ToDate = new DateTime(); string Emplist = string.Empty; if (Session["EmpList"] == null) { Response.Redirect("../Attendance_Report/AttendanceReport.aspx"); } else { FromDate = objsys.getDateForInput(Session["FromDate"].ToString()); ToDate = objsys.getDateForInput(Session["ToDate"].ToString()); Emplist = Session["EmpList"].ToString(); DataTable dtFilter = new DataTable(); AttendanceDataSet rptdata = new AttendanceDataSet(); rptdata.EnforceConstraints = false; AttendanceDataSetTableAdapters.sp_Set_Employee_Holiday_ReportTableAdapter adp = new AttendanceDataSetTableAdapters.sp_Set_Employee_Holiday_ReportTableAdapter(); adp.Fill(rptdata.sp_Set_Employee_Holiday_Report, int.Parse(Session["CompId"].ToString()), Convert.ToDateTime(FromDate), Convert.ToDateTime(ToDate)); if (Emplist != "") { dtFilter = new DataView(rptdata.sp_Set_Employee_Holiday_Report, "Emp_Id in (" + Emplist.Substring(0, Emplist.Length - 1) + ") ", "", DataViewRowState.CurrentRows).ToTable(); } string CompanyName = ""; string CompanyAddress = ""; string Imageurl = ""; DataTable DtCompany = objComp.GetCompanyMasterById(Session["CompId"].ToString()); DataTable DtAddress = ObjAddress.GetAddressChildDataByAddTypeAndAddRefId("Company", Session["CompId"].ToString()); if (DtCompany.Rows.Count > 0) { CompanyName = DtCompany.Rows[0]["Company_Name"].ToString(); Imageurl = "~/CompanyResource/" + Session["CompId"].ToString() + "/" + DtCompany.Rows[0]["Logo_Path"].ToString(); } if (DtAddress.Rows.Count > 0) { CompanyAddress = DtAddress.Rows[0]["Address"].ToString(); } RptShift.SetImage(Imageurl); RptShift.setTitleName("Holiday Report" + " From " + FromDate.ToString(objsys.SetDateFormat()) + " To " + ToDate.ToString(objsys.SetDateFormat())); RptShift.setcompanyname(CompanyName); RptShift.setaddress(CompanyAddress); RptShift.DataSource = dtFilter; RptShift.DataMember = "sp_Set_Employee_Holiday_Report"; rptViewer.Report = RptShift; rptToolBar.ReportViewer = rptViewer; } }
private void xrTableCell20_BeforePrint(object sender, System.Drawing.Printing.PrintEventArgs e) { int sum = 0; DateTime fromdate = objSys.getDateForInput(System.Web.HttpContext.Current.Session["FromDate"].ToString()); DateTime ToDate = objSys.getDateForInput(System.Web.HttpContext.Current.Session["ToDate"].ToString()); DataTable dt = objAttReg.GetAttendanceRegDataByEmpId(xrTableCell20.Text, fromdate.ToString(), ToDate.ToString()); dt = new DataView(dt, "Is_Absent='True'", "", DataViewRowState.CurrentRows).ToTable(); if (dt.Rows.Count > 0) { sum = dt.Rows.Count; } xrTableCell20.Text = sum.ToString(); }
protected void btnSearch_Click(object sender, EventArgs e) { if (txtFromDate.Text == "" || txtFromDate.Text == "") { DisplayMessage("Fill From Date And To Date"); return; } try { objSys.getDateForInput(txtFromDate.Text); } catch (Exception) { DisplayMessage("From Date Not In Proper Format"); return; } try { objSys.getDateForInput(txtToDate.Text); } catch (Exception) { DisplayMessage("To Date Not In Proper Format"); return; } if (objSys.getDateForInput(txtToDate.Text) < objSys.getDateForInput(txtFromDate.Text)) { DisplayMessage("From Date Cannot Be Greater Than To Date"); return; } DataTable dt = new DataTable(); dt = objAttLog.GetAttendanceLogByDate(Session["CompId"].ToString(), objSys.getDateForInput(txtFromDate.Text).ToString(), objSys.getDateForInput(txtToDate.Text).ToString()); dt = new DataView(dt, "Verified_Type='By Manual'", "", DataViewRowState.CurrentRows).ToTable(); if (dt.Rows.Count > 0) { gvEmpLog.DataSource = dt; gvEmpLog.DataBind(); Session["dtEmpLog"] = dt; lblTotalRecord1.Text = Resources.Attendance.Total_Records + " : " + dt.Rows.Count.ToString() + ""; } else { gvEmpLog.DataSource = null; gvEmpLog.DataBind(); Session["dtEmpLog"] = null; } }
private void xrTableCell19_BeforePrint(object sender, System.Drawing.Printing.PrintEventArgs e) { int sum = 0; DateTime fromdate = objSys.getDateForInput(System.Web.HttpContext.Current.Session["FromDate"].ToString()); DateTime ToDate = objSys.getDateForInput(System.Web.HttpContext.Current.Session["ToDate"].ToString()); DataTable dt = objAttReg.GetAttendanceRegDataByEmpId(xrTableCell19.Text, fromdate.ToString(), ToDate.ToString()); dt = new DataView(dt, "EarlyMin<>0", "", DataViewRowState.CurrentRows).ToTable(); if (dt.Rows.Count > 0) { for (int i = 0; i < dt.Rows.Count; i++) { sum += int.Parse(dt.Rows[i]["EarlyMin"].ToString()); } } xrTableCell19.Text = GetHours(sum.ToString()); }
protected void btnApply_Click(object sender, EventArgs e) { if (txtFromDate.Text == "") { DisplayMessage("Enter From Date"); txtFromDate.Focus(); rbtnMonthly.Checked = false; rbtnYearly.Checked = false; return; } else { try { objSys.getDateForInput(txtFromDate.Text); } catch { DisplayMessage("Enter Correct From Date Format " + objSys.SetDateFormat() + ""); txtFromDate.Focus(); rbtnMonthly.Checked = false; rbtnYearly.Checked = false; return; } } if (objSys.getDateForInput(txtFromDate.Text) > objSys.getDateForInput(txtToDate.Text)) { DisplayMessage("From Date cannot be greater than To Date"); txtFromDate.Text = ""; txtToDate.Text = ""; txtFromDate.Focus(); rbtnMonthly.Checked = false; rbtnYearly.Checked = false; return; } if (txtToDate.Text == "") { DisplayMessage("Enter To Date"); txtToDate.Focus(); rbtnMonthly.Checked = false; rbtnYearly.Checked = false; return; } else { try { objSys.getDateForInput(txtToDate.Text); } catch { DisplayMessage("Enter Correct From Date Format " + objSys.SetDateFormat() + ""); txtToDate.Focus(); rbtnMonthly.Checked = false; rbtnYearly.Checked = false; return; } } if (rbtnMonthly.Checked == false && rbtnYearly.Checked == false) { DisplayMessage("Please select Monthly or Yearly"); return; } DataTable dtHoliday2 = objEmpHoliday.GetEmployeeHolidayMaster(Session["CompId"].ToString()); DateTime fromdate2 = objSys.getDateForInput(txtFromDate.Text); DateTime todate2 = objSys.getDateForInput(txtToDate.Text); while (fromdate2 <= todate2) { DataTable dtHoliday1 = new DataView(dtHoliday2, "Holiday_Date='" + fromdate2.ToString() + "' and Emp_Id='" + hdnEmpId.Value + "'", "", DataViewRowState.CurrentRows).ToTable(); if (dtHoliday1.Rows.Count > 0) { DisplayMessage("Employee has holiday on date " + fromdate2.ToString("dd-MMM-yyyy") + " so cannot apply"); rbtnMonthly.Checked = false; rbtnYearly.Checked = false; ddlLeaveType.Items.Clear(); ddlLeaveType.DataSource = null; ddlLeaveType.DataBind(); ddlLeaveType.Visible = false; txtFromDate.Text = ""; txtToDate.Text = ""; lblDays.Text = ""; txtEmpName.Text = ""; return; } fromdate2 = fromdate2.AddDays(1); } DateTime FromDate = objSys.getDateForInput(txtFromDate.Text); DateTime ToDate = objSys.getDateForInput(txtToDate.Text); int dayscount = int.Parse(lblDays.Text); string month = FromDate.Month.ToString(); DataTable dtLeaveSummary = objEmpleave.GetEmployeeLeaveTransactionDataByEmpId(hdnEmpId.Value); DataTable dtLeaveR = objleaveReq.GetLeaveRequestById(Session["CompId"].ToString(), hdnEmpId.Value); DateTime fromdate1 = objSys.getDateForInput(txtFromDate.Text); DateTime todate1 = objSys.getDateForInput(txtToDate.Text); while (fromdate1 <= todate1) { DataTable dtLeaveReq2 = new DataView(dtLeaveR, "From_Date <='" + fromdate1.ToString() + "' and To_Date>='" + fromdate1.ToString() + "' and Is_Canceled<>'True'", "", DataViewRowState.CurrentRows).ToTable(); if (dtLeaveReq2.Rows.Count > 0) { DisplayMessage("You have already apply leave between from date and to date"); rbtnMonthly.Checked = false; rbtnYearly.Checked = false; ddlLeaveType.Items.Clear(); ddlLeaveType.DataSource = null; ddlLeaveType.DataBind(); ddlLeaveType.Visible = false; txtFromDate.Text = ""; txtToDate.Text = ""; lblDays.Text = ""; txtEmpName.Text = ""; return; } fromdate1 = fromdate1.AddDays(1); } if (rbtnMonthly.Checked) { string months = string.Empty; string year = string.Empty; DateTime FromDate2 = DateTime.Now; DateTime ToDate2 = DateTime.Now.AddMonths(2); while (FromDate2 <= ToDate2) { months += FromDate2.Month.ToString() + ","; FromDate2 = FromDate2.AddMonths(1); string year1 = FromDate2.Year.ToString(); if (!year.Split(',').Contains(year1)) { year += year1 + ","; } } DataTable dt = objAppParam.GetApplicationParameterByParamName("FinancialYearStartMonth", Session["CompId"].ToString()); int FinancialYearMonth = 0; if (dt.Rows.Count > 0) { FinancialYearMonth = int.Parse(dt.Rows[0]["Param_Value"].ToString()); } DateTime FinancialYearStartDate = new DateTime(); DateTime FinancialYearEndDate = new DateTime(); if (DateTime.Now.Month < FinancialYearMonth) { FinancialYearStartDate = new DateTime(DateTime.Now.Year - 1, FinancialYearMonth, 1); FinancialYearEndDate = FinancialYearStartDate.AddYears(1).AddDays(-1); } else { FinancialYearStartDate = new DateTime(DateTime.Now.Year, FinancialYearMonth, 1); FinancialYearEndDate = FinancialYearStartDate.AddYears(1).AddDays(-1); } string year4 = string.Empty; string months4 = string.Empty; months4 = months; if (FinancialYearStartDate.Year == FinancialYearEndDate.Year) { year4 = FinancialYearStartDate.Year.ToString(); } else { year4 += FinancialYearStartDate.Year.ToString() + ","; year4 += FinancialYearEndDate.Year.ToString() + ","; } DateTime DateFrm = Convert.ToDateTime(txtFromDate.Text); if (!months4.Split(',').Contains(DateFrm.Month.ToString()) && !year4.Split(',').Contains(DateFrm.Year.ToString())) { DisplayMessage("You cannot request leave for this month"); return; } dtLeaveSummary = new DataView(dtLeaveSummary, "month in(" + month + ") and year in (" + year4 + ") ", "", DataViewRowState.CurrentRows).ToTable(); int remainingdays = 0; if (dtLeaveSummary.Rows.Count > 0) { remainingdays = int.Parse(dtLeaveSummary.Rows[0]["Remaining_Days"].ToString()); } if (dayscount > remainingdays) { DisplayMessage("Employee does not have sufficient leave"); return; } else { int b = 0; b = objleaveReq.InsertLeaveRequest(Session["CompId"].ToString(), ddlLeaveType.SelectedValue, hdnEmpId.Value, DateTime.Now.ToString(), txtFromDate.Text, txtToDate.Text, true.ToString(), false.ToString(), false.ToString(), "", "", "", "", "", "", "", true.ToString(), DateTime.Now.ToString(), true.ToString(), Session["UserId"].ToString(), DateTime.Now.ToString(), Session["UserId"].ToString(), DateTime.Now.ToString()); DataTable dtLeave = objEmpleave.GetEmployeeLeaveTransactionData(hdnEmpId.Value, ddlLeaveType.SelectedValue, FromDate.Month.ToString(), FromDate.Year.ToString()); string TransNo = string.Empty; int remain = 0; int useddays = 0; int totaldays = 0; if (dtLeave.Rows.Count > 0) { TransNo = dtLeave.Rows[0]["Trans_Id"].ToString(); remain = int.Parse(dtLeave.Rows[0]["Remaining_Days"].ToString()); totaldays = int.Parse(dtLeave.Rows[0]["Total_Days"].ToString()); } remain = remain - dayscount; useddays = totaldays - remain; try { objEmpleave.UpdateEmployeeLeaveTransactionByTransNo(TransNo, Session["CompId"].ToString(), hdnEmpId.Value, ddlLeaveType.SelectedValue, FromDate.Year.ToString(), FromDate.Month.ToString(), "0", "0", "0", useddays.ToString(), remain.ToString(), dayscount.ToString(), Session["UserId"].ToString(), DateTime.Now.ToString()); } catch { DisplayMessage("Leave type not assigned to employee"); return; } while (FromDate <= ToDate) { objleaveReq.InsertLeaveRequestChild(b.ToString(), ddlLeaveType.SelectedValue, FromDate.ToString(), true.ToString(), "1", "", "", "", "", "", false.ToString(), DateTime.Now.ToString(), true.ToString(), Session["UserId"].ToString(), DateTime.Now.ToString(), Session["UserId"].ToString(), DateTime.Now.ToString()); FromDate = FromDate.AddDays(1); } DisplayMessage("Leave submitted"); rbtnMonthly.Checked = false; rbtnYearly.Checked = false; ddlLeaveType.Items.Clear(); ddlLeaveType.DataSource = null; ddlLeaveType.DataBind(); ddlLeaveType.Visible = false; txtFromDate.Text = ""; txtToDate.Text = ""; lblDays.Text = ""; txtEmpName.Text = ""; gvLeaveSummary.DataSource = null; gvLeaveSummary.DataBind(); } } else if (rbtnYearly.Checked) { string year4 = string.Empty; DataTable dt = objAppParam.GetApplicationParameterByParamName("FinancialYearStartMonth", Session["CompId"].ToString()); int FinancialYearMonth = 0; if (dt.Rows.Count > 0) { FinancialYearMonth = int.Parse(dt.Rows[0]["Param_Value"].ToString()); } DateTime FinancialYearStartDate = new DateTime(); DateTime FinancialYearEndDate = new DateTime(); if (DateTime.Now.Month < FinancialYearMonth) { FinancialYearStartDate = new DateTime(DateTime.Now.Year - 1, FinancialYearMonth, 1); FinancialYearEndDate = FinancialYearStartDate.AddYears(1).AddDays(-1); } else { FinancialYearStartDate = new DateTime(DateTime.Now.Year, FinancialYearMonth, 1); FinancialYearEndDate = FinancialYearStartDate.AddYears(1).AddDays(-1); } if (FinancialYearStartDate.Year == FinancialYearEndDate.Year) { year4 = FinancialYearStartDate.Year.ToString(); } else { year4 = FinancialYearStartDate.Year.ToString(); } dtLeaveSummary = new DataView(dtLeaveSummary, "month='0' and Year='" + year4 + "'", "", DataViewRowState.CurrentRows).ToTable(); int remainingdays = 0; if (dtLeaveSummary.Rows.Count > 0) { remainingdays = int.Parse(dtLeaveSummary.Rows[0]["Remaining_Days"].ToString()); } if (dayscount > remainingdays) { DisplayMessage("Employee does not have sufficient leave"); return; } else { int b = 0; b = objleaveReq.InsertLeaveRequest(Session["CompId"].ToString(), ddlLeaveType.SelectedValue, hdnEmpId.Value, DateTime.Now.ToString(), txtFromDate.Text, txtToDate.Text, true.ToString(), false.ToString(), false.ToString(), "", "", "", "", "", "", "", true.ToString(), DateTime.Now.ToString(), true.ToString(), Session["UserId"].ToString(), DateTime.Now.ToString(), Session["UserId"].ToString(), DateTime.Now.ToString()); DataTable dtLeave = objEmpleave.GetEmployeeLeaveTransactionData(hdnEmpId.Value, ddlLeaveType.SelectedValue, "0", year4); string TransNo = string.Empty; int remain = 0; int useddays = 0; int totaldays = 0; if (dtLeave.Rows.Count > 0) { TransNo = dtLeave.Rows[0]["Trans_Id"].ToString(); remain = int.Parse(dtLeave.Rows[0]["Remaining_Days"].ToString()); totaldays = int.Parse(dtLeave.Rows[0]["Total_Days"].ToString()); } remain = remain - dayscount; useddays = totaldays - remain; try { objEmpleave.UpdateEmployeeLeaveTransactionByTransNo(TransNo, Session["CompId"].ToString(), hdnEmpId.Value, ddlLeaveType.SelectedValue, year4, "0", "0", "0", "0", useddays.ToString(), remain.ToString(), dayscount.ToString(), Session["UserId"].ToString(), DateTime.Now.ToString()); } catch { DisplayMessage("Leave not Assigned to employee"); } while (FromDate <= ToDate) { objleaveReq.InsertLeaveRequestChild(b.ToString(), ddlLeaveType.SelectedValue, FromDate.ToString(), true.ToString(), "1", "", "", "", "", "", false.ToString(), DateTime.Now.ToString(), true.ToString(), Session["UserId"].ToString(), DateTime.Now.ToString(), Session["UserId"].ToString(), DateTime.Now.ToString()); FromDate = FromDate.AddDays(1); } DisplayMessage("Leave submitted"); rbtnMonthly.Checked = false; rbtnYearly.Checked = false; ddlLeaveType.Items.Clear(); ddlLeaveType.DataSource = null; ddlLeaveType.DataBind(); ddlLeaveType.Visible = false; txtFromDate.Text = ""; txtToDate.Text = ""; lblDays.Text = ""; txtEmpName.Text = ""; gvLeaveSummary.DataSource = null; gvLeaveSummary.DataBind(); } } FillLeaveStatus(); }
public void GetReport() { DateTime FromDate = new DateTime(); DateTime ToDate = new DateTime(); string Emplist = string.Empty; if (Session["EmpList"] == null) { Response.Redirect("../Attendance_Report/AttendanceReport.aspx"); } else { FromDate = objSys.getDateForInput(Session["FromDate"].ToString()); ToDate = objSys.getDateForInput(Session["ToDate"].ToString()); Emplist = Session["EmpList"].ToString(); DataTable dtFilter = new DataTable(); AttendanceDataSet rptdata = new AttendanceDataSet(); rptdata.EnforceConstraints = false; AttendanceDataSetTableAdapters.sp_Att_AttendanceRegister_ReportTableAdapter adp = new AttendanceDataSetTableAdapters.sp_Att_AttendanceRegister_ReportTableAdapter(); adp.Fill(rptdata.sp_Att_AttendanceRegister_Report, Convert.ToDateTime(FromDate), Convert.ToDateTime(ToDate)); if (Emplist != "") { dtFilter = new DataView(rptdata.sp_Att_AttendanceRegister_Report, "Emp_Id in (" + Emplist.Substring(0, Emplist.Length - 1) + ") ", "", DataViewRowState.CurrentRows).ToTable(); } DataTable dtReport = dtFilter.Clone(); for (int i = 0; i < dtFilter.Rows.Count; i++) { if (dtFilter.Rows[i]["In_Time"].ToString().Contains("00:00") && dtFilter.Rows[i]["Out_Time"].ToString().Contains("00:00")) { // dtFilter.Rows[i]["Field1"] = "NA"; // dtReport.ImportRow(dtFilter.Rows[i]); } else if (!dtFilter.Rows[i]["In_Time"].ToString().Contains("00:00") && dtFilter.Rows[i]["Out_Time"].ToString().Contains("00:00")) { if (!Convert.ToBoolean(dtFilter.Rows[i]["Is_Leave"].ToString()) && !Convert.ToBoolean(dtFilter.Rows[i]["Is_Holiday"].ToString()) && !Convert.ToBoolean(dtFilter.Rows[i]["Is_Week_Off"].ToString())) { dtFilter.Rows[i]["Field1"] = "Out"; dtReport.ImportRow(dtFilter.Rows[i]); } } else if (dtFilter.Rows[i]["In_Time"].ToString().Contains("00:00") && !dtFilter.Rows[i]["Out_Time"].ToString().Contains("00:00")) { if (!Convert.ToBoolean(dtFilter.Rows[i]["Is_Leave"].ToString()) && !Convert.ToBoolean(dtFilter.Rows[i]["Is_Holiday"].ToString()) && !Convert.ToBoolean(dtFilter.Rows[i]["Is_Week_Off"].ToString())) { dtFilter.Rows[i]["Field1"] = "In"; dtReport.ImportRow(dtFilter.Rows[i]); } } } string CompanyName = ""; string CompanyAddress = ""; string Imageurl = ""; DataTable DtCompany = objComp.GetCompanyMasterById(Session["CompId"].ToString()); DataTable DtAddress = ObjAddress.GetAddressChildDataByAddTypeAndAddRefId("Company", Session["CompId"].ToString()); if (DtCompany.Rows.Count > 0) { CompanyName = DtCompany.Rows[0]["Company_Name"].ToString(); Imageurl = "~/CompanyResource/" + Session["CompId"].ToString() + "/" + DtCompany.Rows[0]["Logo_Path"].ToString(); } if (DtAddress.Rows.Count > 0) { CompanyAddress = DtAddress.Rows[0]["Address"].ToString(); } RptShift.SetImage(Imageurl); RptShift.setTitleName("In Out Exception Report" + " From " + FromDate.ToString(objSys.SetDateFormat()) + " To " + ToDate.ToString(objSys.SetDateFormat())); RptShift.setcompanyname(CompanyName); RptShift.setaddress(CompanyAddress); RptShift.DataSource = dtReport; RptShift.DataMember = "sp_Att_AttendanceRegister_Report"; rptViewer.Report = RptShift; rptToolBar.ReportViewer = rptViewer; } }
public void GetReport() { DateTime FromDate = new DateTime(); DateTime ToDate = new DateTime(); string Emplist = string.Empty; if (Session["EmpList"] == null) { Response.Redirect("../Attendance_Report/AttendanceReport.aspx"); } else { FromDate = objSys.getDateForInput(Session["FromDate"].ToString()); ToDate = objSys.getDateForInput(Session["ToDate"].ToString()); Emplist = Session["EmpList"].ToString(); DataTable dtFilter = new DataTable(); AttendanceDataSet rptdata = new AttendanceDataSet(); rptdata.EnforceConstraints = false; AttendanceDataSetTableAdapters.sp_Att_AttendanceRegister_ReportTableAdapter adp = new AttendanceDataSetTableAdapters.sp_Att_AttendanceRegister_ReportTableAdapter(); adp.Fill(rptdata.sp_Att_AttendanceRegister_Report, Convert.ToDateTime(FromDate), Convert.ToDateTime(ToDate)); if (Emplist != "") { dtFilter = new DataView(rptdata.sp_Att_AttendanceRegister_Report, "Emp_Id in (" + Emplist.Substring(0, Emplist.Length - 1) + ") ", "", DataViewRowState.CurrentRows).ToTable(); } dtFilter = new DataView(dtFilter, "OverTime_Min<>'0' or Week_Off_Min<>'0' or Holiday_Min<>'0'", "", DataViewRowState.CurrentRows).ToTable(); for (int k = 0; k < dtFilter.Rows.Count; k++) { if (dtFilter.Rows[k]["OverTime_Min"].ToString() != "0") { dtFilter.Rows[k]["Field2"] = dtFilter.Rows[k]["OverTime_Min"]; dtFilter.Rows[k]["Field3"] = "Normal"; } else if (dtFilter.Rows[k]["Week_Off_Min"].ToString() != "0") { dtFilter.Rows[k]["Field2"] = dtFilter.Rows[k]["Week_Off_Min"]; dtFilter.Rows[k]["Field3"] = "Week Off"; } else if (dtFilter.Rows[k]["Holiday_Min"].ToString() != "0") { dtFilter.Rows[k]["Field2"] = dtFilter.Rows[k]["Holiday_Min"]; dtFilter.Rows[k]["Field3"] = "Holiday"; } } string CompanyName = ""; string CompanyAddress = ""; string Imageurl = ""; DataTable DtCompany = objComp.GetCompanyMasterById(Session["CompId"].ToString()); DataTable DtAddress = ObjAddress.GetAddressChildDataByAddTypeAndAddRefId("Company", Session["CompId"].ToString()); if (DtCompany.Rows.Count > 0) { CompanyName = DtCompany.Rows[0]["Company_Name"].ToString(); Imageurl = "~/CompanyResource/" + Session["CompId"].ToString() + "/" + DtCompany.Rows[0]["Logo_Path"].ToString(); } if (DtAddress.Rows.Count > 0) { CompanyAddress = DtAddress.Rows[0]["Address"].ToString(); } RptShift.SetImage(Imageurl); RptShift.setTitleName("Over Time Report" + " From " + FromDate.ToString("dd-MMM-yyyy") + " To " + ToDate.ToString("dd-MMM-yyyy")); RptShift.setcompanyname(CompanyName); RptShift.setaddress(CompanyAddress); RptShift.DataSource = dtFilter; RptShift.DataMember = "sp_Att_AttendanceRegister_Report"; rptViewer.Report = RptShift; rptToolBar.ReportViewer = rptViewer; } }
public void GetReport() { DateTime FromDate = new DateTime(); DateTime ToDate = new DateTime(); DateTime FromDate1 = new DateTime(); string Emplist = string.Empty; if (Session["EmpList"] == null) { Response.Redirect("../Attendance_Report/AttendanceReport.aspx"); } else { FromDate = objSys.getDateForInput(Session["FromDate"].ToString()); ToDate = objSys.getDateForInput(Session["ToDate"].ToString()); FromDate1 = FromDate; Emplist = Session["EmpList"].ToString(); DataTable dtFilter = new DataTable(); AttendanceDataSet rptdata = new AttendanceDataSet(); rptdata.EnforceConstraints = false; AttendanceDataSetTableAdapters.sp_Att_AttendanceRegister_ReportTableAdapter adp = new AttendanceDataSetTableAdapters.sp_Att_AttendanceRegister_ReportTableAdapter(); adp.Fill(rptdata.sp_Att_AttendanceRegister_Report, Convert.ToDateTime(FromDate), Convert.ToDateTime(ToDate)); if (Emplist != "") { dtFilter = new DataView(rptdata.sp_Att_AttendanceRegister_Report, "Emp_Id in (" + Emplist.Substring(0, Emplist.Length - 1) + ") ", "", DataViewRowState.CurrentRows).ToTable(); } DataTable dtEmp = dtFilter.DefaultView.ToTable(true, "Emp_Id"); DataTable dtTemp = new DataTable(); DataTable dtSalary = new DataTable(); dtSalary = dtFilter.Clone(); int Total_Days = 0; int Days_In_WorkMin = 0; int Worked_Days = 0; int Week_Off_Days = 0; int Holiday_Days = 0; int Leave_Days = 0; int Absent_Days = 0; int Assigned_Worked_Min = 0; double Basic_Salary = 0; double Basic_Min_Salary = 0; double Normal_OT_Salary = 0; double Week_Off_OT_Salary = 0; double Holiday_OT_Salary = 0; double Absent_Penalty = 0; double Late_Penalty_Min = 0; double Early_Penalty_Min = 0; double Partial_Penalty_Min = 0; int Total_Worked_Min = 0; int Holiday_OT_Min = 0; int Week_Off_OT_Min = 0; int Normal_OT_Min = 0; int Late_Min = 0; int Early_Min = 0; int Partial_Min = 0; double Basic_Work_Salary = 0; double Normal_OT_Work_Salary = 0; double WeekOff_OT_Work_Salary = 0; double Holiday_OT_Work_Salary = 0; double Week_Off_Days_Salary = 0; double Holiday_Days_Salary = 0; double Leave_Days_Salary = 0; double Absent_Day_Penalty = 0; double Late_Min_Penalty = 0; double Early_Min_Penalty = 0; double Parital_Violation_Penalty = 0; bool IsEmpLate = false; bool IsEmpEarly = false; bool IsEmpPartial = false; string LateMethod = string.Empty; string EarlyMethod = string.Empty; string PartialMethod = string.Empty; int LatePenaltyDedMin = 0; int EarlyPenaltyDedMin = 0; int PartialPenaltyDedMin = 0; int PartialMin = 0; int TotalOTMin = 0; double TotalGrossSalary = 0; int j = 0; for (int i = 0; i < dtEmp.Rows.Count; i++) { FromDate = FromDate1; IsEmpLate = false; IsEmpEarly = false; IsEmpPartial = false; LateMethod = string.Empty; EarlyMethod = string.Empty; PartialMethod = string.Empty; LatePenaltyDedMin = 0; EarlyPenaltyDedMin = 0; PartialPenaltyDedMin = 0; TotalOTMin = 0; Assigned_Worked_Min = 0; Basic_Salary = 0; Basic_Min_Salary = 0; Normal_OT_Salary = 0; Week_Off_OT_Salary = 0; Holiday_OT_Salary = 0; Absent_Penalty = 0; Late_Penalty_Min = 0; Early_Penalty_Min = 0; Partial_Penalty_Min = 0; TotalGrossSalary = 0; try { IsEmpEarly = Convert.ToBoolean(objEmpParam.GetEmployeeParameterByParameterName(dtEmp.Rows[i]["Emp_Id"].ToString(), "Field2")); IsEmpLate = Convert.ToBoolean(objEmpParam.GetEmployeeParameterByParameterName(dtEmp.Rows[i]["Emp_Id"].ToString(), "Field1")); IsEmpPartial = Convert.ToBoolean(objEmpParam.GetEmployeeParameterByParameterName(dtEmp.Rows[i]["Emp_Id"].ToString(), "Is_Partial_Enable")); LateMethod = objAppParam.GetApplicationParameterValueByParamName("Is_Late_Penalty_Method", Session["CompId"].ToString()); EarlyMethod = objAppParam.GetApplicationParameterValueByParamName("Is_Early_Penalty_Method", Session["CompId"].ToString()); PartialMethod = objAppParam.GetApplicationParameterValueByParamName("Partial_Penalty_Method", Session["CompId"].ToString()); LatePenaltyDedMin = int.Parse(objAppParam.GetApplicationParameterValueByParamName("Late_Penalty_Min_Deduct", Session["CompId"].ToString())); EarlyPenaltyDedMin = int.Parse(objAppParam.GetApplicationParameterValueByParamName("Early_Penalty_Min_Deduct", Session["CompId"].ToString())); PartialPenaltyDedMin = int.Parse(objAppParam.GetApplicationParameterValueByParamName("Partial_Penalty_Min_Deduct", Session["CompId"].ToString())); Total_Days = ToDate.Subtract(FromDate).Days + 1; Days_In_WorkMin = int.Parse(objEmpParam.GetEmployeeParameterByParameterName(dtEmp.Rows[i]["Emp_Id"].ToString(), "Assign_Min")); } catch { } try { Basic_Salary = double.Parse(objEmpParam.GetEmployeeParameterByParameterName(dtEmp.Rows[i]["Emp_Id"].ToString(), "Basic_Salary")); } catch { } int assingmin = 0; try { assingmin = int.Parse(objEmpParam.GetEmployeeParameterByParameterName(dtEmp.Rows[i]["Emp_Id"].ToString(), "Assign_Min")); } catch { } Basic_Min_Salary = Basic_Salary / (Total_Days * assingmin); if (Basic_Min_Salary.ToString() == "NaN") { Basic_Min_Salary = 0; } Normal_OT_Salary = GetOTOneMinSalary(dtEmp.Rows[i]["Emp_Id"].ToString(), "Normal", Basic_Min_Salary); Week_Off_OT_Salary = GetOTOneMinSalary(dtEmp.Rows[i]["Emp_Id"].ToString(), "WeekOff", Basic_Min_Salary); Holiday_OT_Salary = GetOTOneMinSalary(dtEmp.Rows[i]["Emp_Id"].ToString(), "Holiday", Basic_Min_Salary); Absent_Penalty = OnDayAbsentSalary(Basic_Min_Salary, dtEmp.Rows[i]["Emp_Id"].ToString()); Late_Penalty_Min = OnMinuteLatePenalty(Basic_Min_Salary, dtEmp.Rows[i]["Emp_Id"].ToString()); Early_Penalty_Min = OnMinuteEarlyPenalty(Basic_Min_Salary, dtEmp.Rows[i]["Emp_Id"].ToString()); Partial_Penalty_Min = OnMinuteParialPenalty(Basic_Min_Salary, dtEmp.Rows[i]["Emp_Id"].ToString()); while (FromDate <= ToDate) { PartialMin = 0; Total_Worked_Min = 0; Holiday_OT_Min = 0; Week_Off_OT_Min = 0; Normal_OT_Min = 0; Late_Min = 0; Early_Min = 0; Partial_Min = 0; Basic_Work_Salary = 0; Normal_OT_Work_Salary = 0; WeekOff_OT_Work_Salary = 0; Holiday_OT_Work_Salary = 0; Week_Off_Days_Salary = 0; Holiday_Days_Salary = 0; Leave_Days_Salary = 0; Absent_Day_Penalty = 0; Late_Min_Penalty = 0; Early_Min_Penalty = 0; Parital_Violation_Penalty = 0; PartialMin = 0; dtTemp = dtFilter.Clone(); dtTemp = new DataView(dtFilter, "Att_Date='" + FromDate.ToString("dd-MMM-yyyy") + "' and Emp_Id='" + dtEmp.Rows[i]["Emp_Id"].ToString() + "' ", "", DataViewRowState.CurrentRows).ToTable(); if (dtTemp.Rows.Count > 0) { for (int k = 0; k < dtTemp.Rows.Count; k++) { dtSalary.ImportRow(dtTemp.Rows[k]); dtSalary.Rows[j]["Field2"] = ""; dtSalary.Rows[j]["Field3"] = ""; dtSalary.Rows[j]["Field4"] = ""; // Late_Min = int.Parse(dtTemp.Rows[k]["LateMin"].ToString()); if (IsEmpLate && LateMethod == "Min") { Late_Min = Late_Min * LatePenaltyDedMin; } Early_Min = int.Parse(dtTemp.Rows[k]["EarlyMin"].ToString()); if (IsEmpEarly && EarlyMethod == "Min") { Early_Min = Early_Min * EarlyPenaltyDedMin; } PartialMin = int.Parse(dtTemp.Rows[k]["Partial_Violation_Min"].ToString()); Total_Worked_Min = int.Parse(dtTemp.Rows[k]["TotalAssign_Min"].ToString()); Days_In_WorkMin = int.Parse(dtTemp.Rows[k]["EffectiveWork_Min"].ToString()); // Days_In_WorkMin = int.Parse(getWorkMinute(Days_In_WorkMin.ToString(),Total_Worked_Min.ToString())); Normal_OT_Min = int.Parse(dtTemp.Rows[k]["OverTime_Min"].ToString()); Week_Off_OT_Min = int.Parse(dtTemp.Rows[k]["Week_Off_Min"].ToString()); Holiday_OT_Min = int.Parse(dtTemp.Rows[k]["Holiday_Min"].ToString()); Late_Min_Penalty = Late_Min * Late_Penalty_Min; Early_Min_Penalty = Early_Penalty_Min * Early_Min; Parital_Violation_Penalty = Partial_Penalty_Min * PartialMin; Absent_Day_Penalty = Absent_Penalty * Total_Worked_Min; Basic_Work_Salary = Basic_Min_Salary * Days_In_WorkMin; Normal_OT_Work_Salary = Normal_OT_Salary * Normal_OT_Min; WeekOff_OT_Work_Salary = Week_Off_OT_Salary * Week_Off_OT_Min; Holiday_OT_Work_Salary = Holiday_OT_Salary * Holiday_OT_Min; double TotalSalary = 0; TotalOTMin += int.Parse(dtTemp.Rows[k]["OverTime_Min"].ToString()); if (Convert.ToBoolean(dtTemp.Rows[k]["Is_Week_Off"].ToString())) { dtSalary.Rows[j]["Field4"] = System.Math.Round(WeekOff_OT_Work_Salary, 2).ToString(); TotalSalary = Total_Worked_Min * Basic_Min_Salary; dtSalary.Rows[j]["OverTime_Min"] = dtTemp.Rows[k]["Week_Off_Min"]; TotalOTMin += int.Parse(dtTemp.Rows[k]["Week_Off_Min"].ToString()); } else if (Convert.ToBoolean(dtTemp.Rows[k]["Is_Holiday"].ToString())) { dtSalary.Rows[j]["Field4"] = System.Math.Round(Holiday_OT_Work_Salary, 2).ToString(); TotalSalary = Total_Worked_Min * Basic_Min_Salary; dtSalary.Rows[j]["OverTime_Min"] = dtTemp.Rows[k]["Holiday_Min"]; TotalOTMin += int.Parse(dtTemp.Rows[k]["Holiday_Min"].ToString()); } else if (Convert.ToBoolean(dtTemp.Rows[k]["Is_Leave"].ToString())) { TotalSalary = Total_Worked_Min * Basic_Min_Salary; dtSalary.Rows[j]["Field4"] = "0"; } else if (Convert.ToBoolean(dtTemp.Rows[k]["Is_Absent"].ToString())) { TotalSalary = Basic_Work_Salary - Absent_Day_Penalty; dtSalary.Rows[j]["Field4"] = "0"; } else if (Days_In_WorkMin != 0) { dtSalary.Rows[j]["Field4"] = System.Math.Round(Normal_OT_Work_Salary, 2).ToString(); } TotalSalary = Basic_Work_Salary - Late_Min_Penalty - Early_Min_Penalty - Parital_Violation_Penalty; dtSalary.Rows[j]["Field3"] = System.Math.Round(TotalSalary, 2).ToString(); dtSalary.Rows[j]["Field2"] = TotalOTMin.ToString(); try { TotalGrossSalary = TotalGrossSalary + TotalSalary + double.Parse(dtSalary.Rows[j]["Field4"].ToString()); } catch { TotalGrossSalary = TotalGrossSalary + TotalSalary; } dtSalary.Rows[j]["Field5"] = System.Math.Round(TotalGrossSalary, 2).ToString(); // j++; } } FromDate = FromDate.AddDays(1); } } string CompanyName = ""; string CompanyAddress = ""; string Imageurl = ""; DataTable DtCompany = objComp.GetCompanyMasterById(Session["CompId"].ToString()); DataTable DtAddress = ObjAddress.GetAddressChildDataByAddTypeAndAddRefId("Company", Session["CompId"].ToString()); if (DtCompany.Rows.Count > 0) { CompanyName = DtCompany.Rows[0]["Company_Name"].ToString(); Imageurl = "~/CompanyResource/" + Session["CompId"].ToString() + "/" + DtCompany.Rows[0]["Logo_Path"].ToString(); } if (DtAddress.Rows.Count > 0) { CompanyAddress = DtAddress.Rows[0]["Address"].ToString(); } RptShift.SetImage(Imageurl); RptShift.setTitleName("Daily Salary Report" + " From " + FromDate1.ToString(objSys.SetDateFormat()) + " To " + ToDate.ToString(objSys.SetDateFormat())); RptShift.setcompanyname(CompanyName); RptShift.setaddress(CompanyAddress); RptShift.DataSource = dtSalary; RptShift.DataMember = "sp_Att_AttendanceRegister_Report"; rptViewer.Report = RptShift; rptToolBar.ReportViewer = rptViewer; } }
protected void btnApply_Click(object sender, EventArgs e) { int b = 0; if (rbtnOfficial.Checked == false && rbtnPersonal.Checked == false) { DisplayMessage("Please select Personal or Official"); return; } if (txtEmpName.Text == "") { DisplayMessage("Enter Employee Name"); txtEmpName.Focus(); return; } if (txtApplyDate.Text == "") { DisplayMessage("Enter Apply Date"); txtApplyDate.Focus(); return; } else { try { objSys.getDateForInput(txtApplyDate.Text); } catch { DisplayMessage("Enter Correct Apply Date Format dd-MMM-yyyy"); txtApplyDate.Focus(); return; } } if (txtInTime.Text == "") { DisplayMessage("Enter In Time"); txtInTime.Focus(); return; } if (txtOuttime.Text == "") { DisplayMessage("Enter Out Time"); txtOuttime.Focus(); return; } if (txtDescription.Text == "") { DisplayMessage("Enter Description"); txtDescription.Focus(); return; } if (rbtnPersonal.Checked) { bool IsCompPartial = Convert.ToBoolean(objAppParam.GetApplicationParameterValueByParamName("Partial_Leave_Enable", Session["CompId"].ToString())); if (IsCompPartial) { DataTable dtEmpParam = objEmpParam.GetEmployeeParameterByEmpId(hdnEmpId.Value, Session["CompId"].ToString()); if (dtEmpParam.Rows.Count > 0) { bool IsEmpPartial = Convert.ToBoolean(dtEmpParam.Rows[0]["Is_Partial_Enable"].ToString()); if (IsEmpPartial) { int totalminutes = 0; int useinday = 0; double leaveCount = 0; totalminutes = int.Parse(dtEmpParam.Rows[0]["Partial_Leave_Mins"].ToString()); useinday = int.Parse(dtEmpParam.Rows[0]["Partial_Leave_Day"].ToString()); leaveCount = double.Parse(dtEmpParam.Rows[0]["Partial_Leave_Mins"].ToString()) / double.Parse(dtEmpParam.Rows[0]["Partial_Leave_Day"].ToString()); leaveCount = System.Math.Round(leaveCount); leaveCount = leaveCount - getCurrentMonthLeaveCount(objSys.getDateForInput(txtApplyDate.Text)); if (leaveCount > 0) { if (totalminutes > 0) { int CurrentUseMin = getCurrentMonth(objSys.getDateForInput(txtApplyDate.Text)); if (CurrentUseMin > 0) { totalminutes = totalminutes - CurrentUseMin; } int OneDayMin = getMinuteInADay(objSys.getDateForInput(txtApplyDate.Text)); if (OneDayMin >= useinday) { DisplayMessage("You cannot request more than " + useinday.ToString() + " minutes in a day"); return; } int RequestMin = GetMinuteDiff(txtOuttime.Text, txtInTime.Text); if (RequestMin <= totalminutes) { if (RequestMin > useinday) { DisplayMessage("You cannot request more than " + useinday.ToString() + " minutes in a day"); return; } else { int remainmin = totalminutes - RequestMin; if (hdnEdit.Value == "") { b = objPartial.InsertPartialLeaveRequest(Session["CompId"].ToString(), hdnEmpId.Value, "0", DateTime.Now.ToString(), objSys.getDateForInput(txtApplyDate.Text).ToString(), txtInTime.Text, txtOuttime.Text, "Pending", txtDescription.Text, "", "", "", "", "", "", true.ToString(), DateTime.Now.ToString(), true.ToString(), Session["UserId"].ToString(), DateTime.Now.ToString(), Session["UserId"].ToString(), DateTime.Now.ToString()); if (b != 0) { DisplayMessage("Partial leave submitted"); btnReset_Click(null, null); FillLeaveStatus(); } } else { b = objPartial.UpdatePartialLeaveRequest(hdnEdit.Value, Session["CompId"].ToString(), hdnEmpId.Value, "1", DateTime.Now.ToString(), objSys.getDateForInput(txtApplyDate.Text).ToString(), txtInTime.Text, txtOuttime.Text, "Pending", txtDescription.Text, "", "", "", "", "", "", true.ToString(), DateTime.Now.ToString(), true.ToString(), Session["UserId"].ToString(), DateTime.Now.ToString()); if (b != 0) { DisplayMessage("Partial leave updated"); btnCancel_Click(null, null); FillLeaveStatus(); hdnEdit.Value = ""; btnNew.Text = Resources.Attendance.New; txtEmpName.Enabled = true; } } } } else { DisplayMessage("Employee does not have sufficient balance"); return; } } else { DisplayMessage("Employee does not have sufficient balance"); return; } } else { DisplayMessage("Employee does not have sufficient balance"); return; } } else { DisplayMessage("Partial leave cannot assign to this employee"); return; } } else { DisplayMessage("Partial leave cannot assign to this employee"); return; } } else { DisplayMessage("Company does not provide partial leave"); return; } } else { bool IsCompPartial = Convert.ToBoolean(objAppParam.GetApplicationParameterValueByParamName("Partial_Leave_Enable", Session["CompId"].ToString())); if (IsCompPartial) { if (hdnEdit.Value == "") { b = objPartial.InsertPartialLeaveRequest(Session["CompId"].ToString(), hdnEmpId.Value, "1", DateTime.Now.ToString(), objSys.getDateForInput(txtApplyDate.Text).ToString(), txtInTime.Text, txtOuttime.Text, "Pending", txtDescription.Text, "", "", "", "", "", "", true.ToString(), DateTime.Now.ToString(), true.ToString(), Session["UserId"].ToString(), DateTime.Now.ToString(), Session["UserId"].ToString(), DateTime.Now.ToString()); if (b != 0) { DisplayMessage("Partial leave submitted"); btnReset_Click(null, null); FillLeaveStatus(); } } else { b = objPartial.UpdatePartialLeaveRequest(hdnEdit.Value, Session["CompId"].ToString(), hdnEmpId.Value, "1", DateTime.Now.ToString(), objSys.getDateForInput(txtApplyDate.Text).ToString(), txtInTime.Text, txtOuttime.Text, "Pending", txtDescription.Text, "", "", "", "", "", "", true.ToString(), DateTime.Now.ToString(), true.ToString(), Session["UserId"].ToString(), DateTime.Now.ToString()); if (b != 0) { DisplayMessage("Partial leave updated"); btnCancel_Click(null, null); FillLeaveStatus(); hdnEdit.Value = ""; btnNew.Text = Resources.Attendance.New; txtEmpName.Enabled = true; } } } else { DisplayMessage("Company does not provide partial leave"); return; } } }
protected void btnGenerate_Click(object sender, EventArgs e) { int b = 0; // Selected Emp Id string empidlist = lblSelectRecord.Text; try { if (txtFromDate.Text == "") { DisplayMessage("From Date Required"); txtFromDate.Focus(); return; } if (txtToDate.Text == "") { DisplayMessage("To Date Required"); txtToDate.Focus(); return; } if (objSys.getDateForInput(txtFromDate.Text.ToString()) > objSys.getDateForInput(txtToDate.Text.ToString())) { DisplayMessage("To Date should be greater"); return; } } catch (Exception) { DisplayMessage("Date not in proper format"); return; } if (rbtnEmpSal.Checked) { if (empidlist == "") { DisplayMessage("Select Atleast One Employee"); return; } } else { string GroupIds = string.Empty; string EmpIds = string.Empty; for (int i = 0; i < lbxGroupSal.Items.Count; i++) { if (lbxGroupSal.Items[i].Selected) { GroupIds += lbxGroupSal.Items[i].Value + ","; } } if (GroupIds != "") { empidlist = ""; DataTable dtEmp = objEmp.GetEmployeeMaster(Session["CompId"].ToString()); dtEmp = new DataView(dtEmp, "Brand_Id='" + Session["BrandId"].ToString() + "' and Location_Id='" + Session["LocId"].ToString() + "'", "", DataViewRowState.CurrentRows).ToTable(); DataTable dtEmpInGroup = objGroupEmp.GetGroup_EmployeeById(Session["CompId"].ToString()); dtEmpInGroup = new DataView(dtEmpInGroup, "Group_Id in(" + GroupIds.Substring(0, GroupIds.Length - 1) + ")", "", DataViewRowState.CurrentRows).ToTable(); for (int i = 0; i < dtEmpInGroup.Rows.Count; i++) { if (!EmpIds.Split(',').Contains(dtEmpInGroup.Rows[i]["Emp_Id"].ToString())) { EmpIds += dtEmpInGroup.Rows[i]["Emp_Id"].ToString() + ","; } } foreach (string str in EmpIds.Split(',')) { if (str != "") { empidlist += str + ","; } } if (empidlist == "") { DisplayMessage("Employees are not exists in selected groups"); return; } } else { DisplayMessage("Select Group First"); } } Session["EmpList"] = empidlist; Session["FromDate"] = txtFromDate.Text; Session["ToDate"] = txtToDate.Text; pnlEmpAtt.Visible = false; pnlReport.Visible = true; //for (int i = 0; i < empidlist.Split(',').Length; i++) //{ // if (empidlist.Split(',')[i] == "") // { // continue; // } //} }
public void GetReport() { DateTime FromDate = new DateTime(); DateTime ToDate = new DateTime(); string Emplist = string.Empty; if (Session["EmpList"] == null) { Response.Redirect("../Attendance_Report/AttendanceReport.aspx"); } else { FromDate = ObjSys.getDateForInput(Session["FromDate"].ToString()); ToDate = ObjSys.getDateForInput(Session["ToDate"].ToString()); Emplist = Session["EmpList"].ToString(); DataTable dtFilter = new DataTable(); AttendanceDataSet rptdata = new AttendanceDataSet(); rptdata.EnforceConstraints = false; AttendanceDataSetTableAdapters.sp_Att_Employee_Leave_Trans_ReportTableAdapter adp = new AttendanceDataSetTableAdapters.sp_Att_Employee_Leave_Trans_ReportTableAdapter(); adp.Fill(rptdata.sp_Att_Employee_Leave_Trans_Report, int.Parse(Session["CompId"].ToString())); DateTime JoiningDate = new DateTime(); int FinancialYearMonth = 0; if (Emplist != "") { dtFilter = new DataView(rptdata.sp_Att_Employee_Leave_Trans_Report, "Emp_Id in (" + Emplist.Substring(0, Emplist.Length - 1) + ") ", "Shedule_Type", DataViewRowState.CurrentRows).ToTable(); } DataTable dt = objAppParam.GetApplicationParameterByParamName("FinancialYearStartMonth", Session["CompId"].ToString()); if (dt.Rows.Count > 0) { FinancialYearMonth = int.Parse(dt.Rows[0]["Param_Value"].ToString()); } DateTime FinancialYearStartDate = new DateTime(); DateTime FinancialYearEndDate = new DateTime(); if (JoiningDate.Month > FinancialYearMonth) { FinancialYearStartDate = new DateTime(DateTime.Now.Year, FinancialYearMonth, 1); FinancialYearEndDate = FinancialYearStartDate.AddYears(1).AddDays(-1); } else { FinancialYearStartDate = new DateTime(DateTime.Now.Year, FinancialYearMonth, 1); FinancialYearEndDate = FinancialYearStartDate.AddYears(1).AddDays(-1); } DataTable dtFilter1 = new DataTable(); dtFilter1 = dtFilter; dtFilter1 = new DataView(dtFilter, "Year in('" + DateTime.Now.Year.ToString() + "','" + FinancialYearEndDate.Year.ToString() + "' ) and Month='0'", "Shedule_Type", DataViewRowState.CurrentRows).ToTable(); dtFilter = new DataView(dtFilter, "Year in('" + DateTime.Now.Year.ToString() + "','" + FinancialYearEndDate.Year.ToString() + "' ) ", "Shedule_Type", DataViewRowState.CurrentRows).ToTable(); string Months = string.Empty; DateTime ftime = DateTime.Now; while (ftime <= FinancialYearEndDate) { Months += ftime.Month + ","; ftime = ftime.AddMonths(1); } dtFilter = new DataView(dtFilter, "Month in(" + Months + ")", "Shedule_Type desc", DataViewRowState.CurrentRows).ToTable(); dtFilter.Merge(dtFilter1); dtFilter = new DataView(dtFilter, "", "Shedule_Type desc", DataViewRowState.CurrentRows).ToTable(); string CompanyName = ""; string CompanyAddress = ""; string Imageurl = ""; DataTable DtCompany = objComp.GetCompanyMasterById(Session["CompId"].ToString()); DataTable DtAddress = ObjAddress.GetAddressChildDataByAddTypeAndAddRefId("Company", Session["CompId"].ToString()); if (DtCompany.Rows.Count > 0) { CompanyName = DtCompany.Rows[0]["Company_Name"].ToString(); Imageurl = "~/CompanyResource/" + Session["CompId"].ToString() + "/" + DtCompany.Rows[0]["Logo_Path"].ToString(); } if (DtAddress.Rows.Count > 0) { CompanyAddress = DtAddress.Rows[0]["Address"].ToString(); } RptShift.SetImage(Imageurl); RptShift.setTitleName("Leave Remaining Report"); RptShift.setcompanyname(CompanyName); RptShift.setaddress(CompanyAddress); RptShift.DataSource = dtFilter; RptShift.DataMember = "sp_Att_Employee_Leave_Trans_Report"; rptViewer.Report = RptShift; rptToolBar.ReportViewer = rptViewer; } }