Ejemplo n.º 1
0
        public ActionResult DashboardofLeaveReport(int?BranchId, int?Year, int?EmployeeId)
        {
            BranchId   = BranchId == 0 ? BRANCHID : BranchId;
            EmployeeId = EmployeeId == 0 ? null : EmployeeId;
            LeaveReportVm vm = new LeaveReportVm();

            using (var dbCntx = new HrDataContext())
            {
                vm.dtAvailed  = EMPLOYEELEAVESUMMARYYTD(BranchId, Year, 0);
                vm.dtBalance  = EMPLOYEELEAVESUMMARYYTD(BranchId, Year, 1);
                vm.consReport = LEAVEREPORTYTD(BranchId, Year, EmployeeId);
            }

            //vm.dtAvailed.Columns.Add("ANNUAL LEAVE1");
            //vm.dtAvailed.Columns.Add("MATERNITY LEAVE1");
            //vm.dtAvailed.Columns.Add("MEDICAL LEAVE1");
            for (int i = 1; i < vm.dtBalance.Columns.Count; i++)
            {
                vm.dtAvailed.Columns.Add("BALANCE " + vm.dtBalance.Columns[i]);
                for (int j = 0; j < vm.dtAvailed.Rows.Count; j++)
                {
                    vm.dtAvailed.Rows[j]["BALANCE " + vm.dtBalance.Columns[i]] = vm.dtBalance.Rows[j][vm.dtBalance.Columns[i]];
                }
            }



            vm.BranchID          = BranchId;
            vm.Year              = Year;
            vm.EmployeeID        = EmployeeId;
            ViewData["RoleCode"] = ROLECODE.ToUpper();


            return(View(vm));
        }
Ejemplo n.º 2
0
        public ActionResult DashboardofSalaryReport(int?BranchId, int?Year, byte?Month, int?EmployeeId)
        {
            BranchId   = BranchId == 0 ? BRANCHID : BranchId;
            Month      = Month == 0 ? null : Month;
            EmployeeId = EmployeeId == 0 ? null : EmployeeId;
            SalaryReportVm vm = new SalaryReportVm();

            using (var dbcntx = new HrDataContext())
            {
                vm.dt = SALARYCOMPONENTEMPLOYEEYTD(BranchId, Year, Convert.ToInt32(Month), EmployeeId);
            }
            vm.BranchID          = BranchId;
            vm.Year              = Year;
            vm.Month             = Month;
            vm.EmployeeID        = EmployeeId;
            ViewData["BranchId"] = BranchId;
            ViewData["RoleCode"] = ROLECODE.ToUpper();

            if (vm.dt != null && vm.dt.Columns.Count > 0)
            {
                DataRow totalsRow = vm.dt.NewRow();
                totalsRow["EMPLOYEE NAME"] = "TOTAL";
                for (int j = 1; j < vm.dt.Columns.Count; j++)
                {
                    DataColumn col = vm.dt.Columns[j];

                    decimal colTotal = 0;
                    for (int i = 0; i < col.Table.Rows.Count; i++)
                    {
                        DataRow row = col.Table.Rows[i];
                        if (row[col] == null || row[col].ToString() == "")
                        {
                            row[col] = "0.00";
                        }
                        colTotal += Convert.ToDecimal(row[col]);
                    }
                    totalsRow[col.ColumnName] = colTotal;
                }

                vm.dt.Rows.Add(totalsRow);
            }

            return(View(vm));
        }
Ejemplo n.º 3
0
        public ActionResult DashboardofSalaryData(int?BranchId, int?Year, byte?Month, int?EmployeeId)
        {
            BranchId   = BranchId == 0 ? BRANCHID : BranchId;
            Month      = Month == 0 ? null : Month;
            EmployeeId = EmployeeId == 0 ? null : EmployeeId;
            ClaimsReportVm vm = new ClaimsReportVm();

            vm.TravelClaimReport    = new List <USP_TRAVELCLAIMREPORT_Result>();
            vm.TravelClaimReportYTD = new List <USP_TRAVELCLAIMREPORTYTD_Result>();
            using (var dbCntx = new HrDataContext())
            {
                vm.TravelClaimReport    = dbCntx.USP_TRAVELCLAIMREPORT(BranchId, Year, Month, EmployeeId).ToList();
                vm.TravelClaimReportYTD = dbCntx.USP_TRAVELCLAIMREPORTYTD(BranchId, Year, EmployeeId).ToList();
                vm.dt = TRAVELCLAIMEMPLOYEEYTD(BranchId, Year, Month, EmployeeId);
            }
            vm.BranchID          = BranchId;
            vm.Year              = Year;
            vm.Month             = Month;
            vm.EmployeeID        = EmployeeId;
            ViewData["RoleCode"] = ROLECODE.ToUpper();

            foreach (var item in vm.TravelClaimReport)
            {
                if (item.ClaimCategory == "TAXILOCAL")
                {
                    item.ClaimCategory = "TAXI LOCAL";
                }
                else if (item.ClaimCategory == "TAXIOVERSEAS")
                {
                    item.ClaimCategory = "TAXI OVERSEAS";
                }
                else if (item.ClaimCategory == "FOODBILLSLOCAL")
                {
                    item.ClaimCategory = "FOOD BILLS LOCAL";
                }
                else if (item.ClaimCategory == "FOODBILLSOVERSEAS")
                {
                    item.ClaimCategory = "FOOD BILLS OVERSEAS";
                }
                else if (item.ClaimCategory == "OTHEREXPENSES")
                {
                    item.ClaimCategory = "OTHER EXPENSES";
                }
            }

            if (vm.dt != null && vm.dt.Columns.Count > 0)
            {
                DataRow totalsRow = vm.dt.NewRow();
                totalsRow["EMPLOYEE NAME"] = "TOTAL";
                for (int j = 1; j < vm.dt.Columns.Count; j++)
                {
                    DataColumn col = vm.dt.Columns[j];

                    decimal colTotal = 0;
                    for (int i = 0; i < col.Table.Rows.Count; i++)
                    {
                        DataRow row = col.Table.Rows[i];
                        if (row[col] == null || row[col].ToString() == "")
                        {
                            row[col] = "0.00";
                        }
                        colTotal += Convert.ToDecimal(row[col]);
                    }
                    //col.Table.Rows[j]. = Color.Red;
                    totalsRow[col.ColumnName] = colTotal;
                    if (col.ColumnName == "TAXILOCAL")
                    {
                        vm.dt.Columns[j].ColumnName = "TAXI LOCAL";
                    }
                    if (col.ColumnName == "TAXIOVERSEAS")
                    {
                        vm.dt.Columns[j].ColumnName = "TAXI OVERSEAS";
                    }
                    if (col.ColumnName == "FOODBILLSLOCAL")
                    {
                        vm.dt.Columns[j].ColumnName = "FOOD BILLS LOCAL";
                    }
                    if (col.ColumnName == "FOODBILLSOVERSEAS")
                    {
                        vm.dt.Columns[j].ColumnName = "FOOD BILLS OVERSEAS";
                    }
                    if (col.ColumnName == "OTHEREXPENSES")
                    {
                        vm.dt.Columns[j].ColumnName = "OTHER EXPENSES";
                    }
                }

                vm.dt.Rows.Add(totalsRow);
            }

            return(View(vm));
        }
Ejemplo n.º 4
0
        public ActionResult DashboardofSalaryComponents(int?BranchId, int?Year, byte?Month, int?EmployeeId)
        {
            BranchId   = BranchId == 0 ? BRANCHID : BranchId;
            Month      = Month == 0 ? null : Month;
            EmployeeId = EmployeeId == 0 ? null : EmployeeId;
            SalaryComponantReportVm vm = new SalaryComponantReportVm();

            vm.SalaryComponantReport    = new List <Salarycomponentreport>();
            vm.SalaryComponantReportYTD = new List <Salarycomponentreportytd>();

            using (var dbCntx = new HrDataContext())
            {
                List <Salarycomponentreportytd> salarycomponentreportytd = new List <Salarycomponentreportytd>();
                List <Salarycomponentreport>    salarycomponentreport    = new List <Salarycomponentreport>();
                if (BranchId == -1 || BranchId == null)
                {
                    var countryList = SelectListItemHelper.ActiveCountryList();
                    foreach (var item in countryList)
                    {
                        var list = dbCntx.USP_SALARYCOMPONENTREPORTYTD(Convert.ToInt32(item.Value), Year, EmployeeId).ToList();
                        if (list.Sum(x => x.TotalSalary) > 0)
                        {
                            foreach (var info in list)
                            {
                                Salarycomponentreportytd countryItem = new Salarycomponentreportytd();
                                countryItem.BranchID    = Convert.ToInt32(item.Value);
                                countryItem.BranchName  = item.Text;
                                countryItem.YTDMonth    = info.YTDMonth;
                                countryItem.TotalSalary = info.TotalSalary;
                                salarycomponentreportytd.Add(countryItem);
                            }
                        }

                        var SalaryComponantReport = dbCntx.USP_SALARYCOMPONENTREPORT(Convert.ToInt32(item.Value), Year, Month, EmployeeId).ToList();
                        foreach (var info in SalaryComponantReport)
                        {
                            Salarycomponentreport countryItem = new Salarycomponentreport();
                            countryItem.BranchID      = Convert.ToInt32(item.Value);
                            countryItem.BranchName    = item.Text;
                            countryItem.ComponentName = info.ComponentName;
                            countryItem.Amount        = info.Amount;
                            salarycomponentreport.Add(countryItem);
                        }
                    }
                    vm.SalaryComponantReportYTD = salarycomponentreportytd;
                    vm.SalaryComponantReport    = salarycomponentreport.ToList();
                }
                else
                {
                    var SalaryComponantReport = dbCntx.USP_SALARYCOMPONENTREPORT(BranchId, Year, Month, EmployeeId).ToList();
                    foreach (var info in SalaryComponantReport)
                    {
                        Salarycomponentreport countryItem = new Salarycomponentreport();
                        countryItem.BranchID      = BranchId.Value;
                        countryItem.ComponentName = info.ComponentName;
                        countryItem.Amount        = info.Amount;
                        salarycomponentreport.Add(countryItem);
                    }
                    vm.SalaryComponantReport = salarycomponentreport.ToList();

                    var list = dbCntx.USP_SALARYCOMPONENTREPORTYTD(BranchId, Year, EmployeeId).ToList();
                    foreach (var info in list)
                    {
                        Salarycomponentreportytd countryItem = new Salarycomponentreportytd();
                        countryItem.BranchID    = BranchId.Value;
                        countryItem.YTDMonth    = info.YTDMonth;
                        countryItem.TotalSalary = info.TotalSalary;
                        salarycomponentreportytd.Add(countryItem);
                    }
                    vm.SalaryComponantReportYTD = salarycomponentreportytd.ToList();

                    vm.dt = SALARYCOMPONENTEMPLOYEEYTD(BranchId, Year, Convert.ToInt32(Month), EmployeeId);
                }
            }
            vm.BranchID          = BranchId == null ? -1 : BranchId;
            vm.Year              = Year;
            vm.Month             = Month;
            vm.EmployeeID        = EmployeeId;
            ViewData["RoleCode"] = ROLECODE.ToUpper();

            if (vm.dt != null && vm.dt.Columns.Count > 0)
            {
                DataRow totalsRow = vm.dt.NewRow();
                totalsRow["EMPLOYEE NAME"] = "TOTAL";
                for (int j = 1; j < vm.dt.Columns.Count; j++)
                {
                    DataColumn col = vm.dt.Columns[j];

                    decimal colTotal = 0;
                    for (int i = 0; i < col.Table.Rows.Count; i++)
                    {
                        DataRow row = col.Table.Rows[i];
                        if (row[col] == null || row[col].ToString() == "")
                        {
                            row[col] = "0.00";
                        }
                        colTotal += Convert.ToDecimal(row[col]);
                    }
                    //col.Table.Rows[j]. = Color.Red;
                    totalsRow[col.ColumnName] = colTotal;
                }

                vm.dt.Rows.Add(totalsRow);
            }

            return(View(vm));
        }