Exemplo n.º 1
0
    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());
     }
 }
Exemplo n.º 3
0
 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";
     }
 }
Exemplo n.º 4
0
    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();
 }
Exemplo n.º 6
0
 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()));
    }
Exemplo n.º 8
0
 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();
    }
Exemplo n.º 10
0
    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;
        }
    }