EchoTex_Payroll/HRM.Report/Class/rptAllMedicalClaim.cs

//using System;
//using System.Collections.Generic;
//using System.Linq;
//using System.Text;
//using System.Windows.Forms;
//using Payroll.BO;
//using Ease.CoreV35.Model;
//using System.ComponentModel;
//using System.Data;
//using System.Drawing;

//namespace Payroll.Report
//{
//    public class rptAllMedicalClaim
//    {
//        public rptAllMedicalClaim() { }
//        public void ShowAllGRRegisterData()
//        {
//            fReportViewer form = new fReportViewer();
//            ObjectsTemplate<HRRequest> oHRRequests = new ObjectsTemplate<HRRequest>();
//            ObjectsTemplate<Employee> oEmployees = new ObjectsTemplate<Employee>();
//            ObjectsTemplate<Designation> oDesignations = new ObjectsTemplate<Designation>();
//            ObjectsTemplate<Grade> oGrades = new ObjectsTemplate<Grade>();

//            oHRRequests = HRRequest.GetHRRequetByWFStatus(enumwfStatus.End);
//            oEmployees = Employee.GetAllEmps();
//            oDesignations = Designation.Get(EnumStatus.Active);
//            oGrades = Grade.Get(EnumStatus.Active);



//            PayrollDataSet.PayrollDataSet.AllMedicalClaimDataTable medicalClaimDataTable = new Payroll.Report.PayrollDataSet.PayrollDataSet.AllMedicalClaimDataTable();
//            DataRow dtRow;
//            Employee emp = null;
//            Grade grd = null;
//            Designation des = null;
//            foreach (var item in oHRRequests)
//            {
//                if ( item.RequestType == EnumRequestType.MedicalClaim)
//                {

//                    dtRow = medicalClaimDataTable.NewRow();
//                    emp = oEmployees.Where(x => x.ID == item.EmployeeID).SingleOrDefault();
//                    if (emp != null)
//                    {
//                        grd = oGrades.FirstOrDefault(o => o.ID == emp.GradeID);
//                        des = oDesignations.FirstOrDefault(o => o.ID == emp.DesignationID);
//                        dtRow["ClaimDate"] = item.RequestDate.ToString("dd-MMM-yyyy");
//                        dtRow["EmpNo"] = emp.EmployeeNo;
//                        dtRow["EmpName"] = emp.Name;
//                        dtRow["Designation"] = des != null ? des.Name : "";
//                        dtRow["Grade"] = grd != null ? grd.Name : "";
//                        dtRow["Amount"] = item.Amount.ToString("#,###");
//                    }

//                    medicalClaimDataTable.Rows.Add(dtRow);
//                }
//            }

//            if (medicalClaimDataTable.Rows.Count > 0)
//            {
//                DataTable dt = medicalClaimDataTable.AsEnumerable().OrderBy(x => Convert.ToDateTime(x["ClaimDate"])).CopyToDataTable();
//                form.ShowAllMedicalClaim(dt);
//            }
//            else
//            {
//                MessageBox.Show("No Data Found!!!");
//            }
//        }

//        public void ShowAllrecognitionData()
//        {
//            fReportViewer form = new fReportViewer();
//            ObjectsTemplate<HRRequest> oHRRequests = new ObjectsTemplate<HRRequest>();
//            ObjectsTemplate<Employee> oEmployees = new ObjectsTemplate<Employee>();
//            ObjectsTemplate<Designation> oDesignations = new ObjectsTemplate<Designation>();
//            ObjectsTemplate<Grade> oGrades = new ObjectsTemplate<Grade>();

//            oHRRequests = HRRequest.GetHRRequetByWFStatus(enumwfStatus.End);
//            oEmployees = Employee.GetAllEmps();
//            oDesignations = Designation.Get(EnumStatus.Active);
//            oGrades = Grade.Get(EnumStatus.Active);



//            PayrollDataSet.PayrollDataSet.AllMedicalClaimDataTable medicalClaimDataTable = new Payroll.Report.PayrollDataSet.PayrollDataSet.AllMedicalClaimDataTable();
//            DataRow dtRow;
//            Employee emp = null;
//            Grade grd = null;
//            Designation des = null;
//            foreach (var item in oHRRequests)
//            {
//                if (item.RequestType == EnumRequestType.Recognition)
//                {

//                    dtRow = medicalClaimDataTable.NewRow();
//                    emp = oEmployees.Where(x => x.ID == item.EmployeeID).SingleOrDefault();
//                    if (emp != null)
//                    {
//                        grd = oGrades.FirstOrDefault(o => o.ID == emp.GradeID);
//                        des = oDesignations.FirstOrDefault(o => o.ID == emp.DesignationID);
//                        dtRow["ClaimDate"] = item.RequestDate.ToString("dd-MMM-yyyy");
//                        dtRow["EmpNo"] = emp.EmployeeNo;
//                        dtRow["EmpName"] = emp.Name;
//                        dtRow["Designation"] = des != null ? des.Name : "";
//                        dtRow["Grade"] = grd != null ? grd.Name : "";
//                        dtRow["Amount"] = item.Amount.ToString("#,###");
//                    }

//                    medicalClaimDataTable.Rows.Add(dtRow);
//                }
//            }

//            if (medicalClaimDataTable.Rows.Count > 0)
//            {
//                DataTable dt = medicalClaimDataTable.AsEnumerable().OrderBy(x => Convert.ToDateTime(x["ClaimDate"])).CopyToDataTable();
//                form.ShowAllMedicalClaim(dt);
//            }
//            else
//            {
//                MessageBox.Show("No Data Found!!!");
//            }
//        }
//    }
//}