protected void Page_Load(object sender, EventArgs e) { if (Session["UserId"] == null) { Response.Redirect("~/ERPLogin.aspx"); } Session["AccordianId"] = "6"; Session["HeaderText"] = "Attendance Reports"; Page.Title = objSys.GetSysTitle(); if (!IsPostBack) { pnlEmpAtt.Visible = true; FillGrid(); rbtnEmpSal.Checked = true; rbtnGroupSal.Checked = false; EmpGroupSal_CheckedChanged(null, null); pnlReport.Visible = false; if (Session["EmpList"] != null) { pnlEmpAtt.Visible = false; pnlReport.Visible = true; } } txtFrom_CalendarExtender.Format = objSys.SetDateFormat(); CalendarExtender1.Format = objSys.SetDateFormat(); }
private void xrTableCell6_BeforePrint(object sender, System.Drawing.Printing.PrintEventArgs e) { if (xrTableCell6.Text != "") { xrTableCell6.Text = Convert.ToDateTime(xrTableCell6.Text).ToString(objSys.SetDateFormat()); } }
private void xrTableCell11_BeforePrint(object sender, System.Drawing.Printing.PrintEventArgs e) { if (xrTableCell11.Text != "") { xrTableCell11.Text = Convert.ToDateTime(xrTableCell11.Text).ToString(objSys.SetDateFormat() + " HH:mm"); } if (xrTableCell11.Text == "01-Jan-1900") { xrTableCell11.Text = "NA"; } }
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; } }
protected void Page_Load(object sender, EventArgs e) { if (Session["UserId"] == null) { Response.Redirect("~/ERPLogin.aspx"); } Page.Title = objSys.GetSysTitle(); if (!IsPostBack) { pnlList.Visible = true; pnlNew.Visible = false; FillLeaveStatus(); btnList_Click(null, null); } Session["AccordianId"] = "9"; Session["HeaderText"] = "Attendance Setup"; CalendarExtender2.Format = objSys.SetDateFormat(); }
private void xrTableCell8_BeforePrint(object sender, System.Drawing.Printing.PrintEventArgs e) { try { xrTableCell8.Text = Convert.ToDateTime(xrTableCell8.Text).ToString(objSys.SetDateFormat()); } catch { } }
public string GetDate(object obj) { DateTime Date = new DateTime(); Date = Convert.ToDateTime(obj.ToString()); return(Date.ToString(objSys.SetDateFormat())); }
protected void Page_Load(object sender, EventArgs e) { if (Session["UserId"] == null) { Response.Redirect("~/ERPLogin.aspx"); } Page.Title = objSys.GetSysTitle(); if (!IsPostBack) { pnlAttList.Visible = true; pnlEmpAtt.Visible = false; FillGrid(); btnList_Click(null, null); rbtnByManual.Checked = true; rbtnByTour.Checked = false; } Session["AccordianId"] = "9"; Session["HeaderText"] = "Attendance Setup"; CalendarExtender1.Format = objSys.SetDateFormat(); CalendarExtender2.Format = objSys.SetDateFormat(); txtFrom_CalendarExtender.Format = objSys.SetDateFormat(); }
protected void Page_Load(object sender, EventArgs e) { Session["BrandId"] = "1"; if (Session["UserId"] == null) { Response.Redirect("~/ERPLogin.aspx"); } AllPageCode(); if (!IsPostBack) { txtValue.Focus(); FillGridBin(); FillGrid(); btnList_Click(null, null); pnlHolidayGroup.Visible = false; } CalendarExtender1.Format = objSys.SetDateFormat(); CalendarExtender2.Format = objSys.SetDateFormat(); }
protected void Page_Load(object sender, EventArgs e) { if (!IsPostBack) { FillLeaveStatus(); ddlLeaveType.Visible = false; } Session["AccordianId"] = "9"; Session["HeaderText"] = "Attendance Setup"; CalendarExtender1.Format = objSys.SetDateFormat(); CalendarExtender2.Format = objSys.SetDateFormat(); }
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(); 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; } }