Пример #1
0
        public List <GridColumn> GetSecondaryGridColumns()
        {
            Allowances = DicValuesRepo.WithDetails(x => x.ValueType).Where(x => x.ValueType.ValueTypeFor == ValueTypeModules.AllowanceType).ToList();

            List <GridColumn> earningsColumns = new List <GridColumn>();

            earningsColumns.Add(new GridColumn {
                Field = "getBasicSalaries", HeaderText = "Basic Salary", TextAlign = TextAlign.Center, MinWidth = "40"
            });
            for (int i = 0; i < Allowances.Count; i++)
            {
                DictionaryValue allowance     = Allowances[i];
                string          camelCaseName = allowance.Value;
                camelCaseName = camelCaseName.Replace(" ", "");
                camelCaseName = char.ToLowerInvariant(camelCaseName[0]) + camelCaseName.Substring(1);

                earningsColumns.Add(new GridColumn()
                {
                    Field = $"{camelCaseName}_Value", HeaderText = $"{Allowances[i].Value}", TextAlign = TextAlign.Center, MinWidth = "50"
                });
            }

            List <GridColumn> deductionsColumns = new List <GridColumn>()
            {
                new GridColumn()
                {
                    Field = "gosiValue", HeaderText = "GOSI", TextAlign = TextAlign.Center, MinWidth = "50"
                },
                new GridColumn()
                {
                    Field = "loansValue", HeaderText = "Loans", TextAlign = TextAlign.Center, MinWidth = "50"
                },
                new GridColumn()
                {
                    Field = "leavesValue", HeaderText = "Leaves", TextAlign = TextAlign.Center, MinWidth = "50"
                },
            };

            List <GridColumn> gridColumns = new List <GridColumn>()
            {
                new GridColumn()
                {
                    Field = "totalEmployees", HeaderText = "Total Employees", TextAlign = TextAlign.Center, MinWidth = "50"
                },
                new GridColumn {
                    Field   = "", HeaderText = "Earnings", TextAlign = TextAlign.Center, MinWidth = "40",
                    Columns = earningsColumns
                },
                new GridColumn {
                    Field   = "", HeaderText = "Deductions", TextAlign = TextAlign.Center, MinWidth = "40",
                    Columns = deductionsColumns
                }
            };

            return(gridColumns);
        }
Пример #2
0
        public IActionResult OnGet()
        {
            EOSBAllowances = DicValuesRepo.Where(x => x.ValueType.ValueTypeFor == ValueTypeModules.AllowanceType && x.Dimension_1_Value.ToUpper() == "TRUE").ToList();

            payrun = ObjectMapper.Map <Payrun, Payrun_Dto>(PayrunAppService.Repository.WithDetails().SingleOrDefault(x => x.Id == payrunId));
            Payrun_Dto payrunLast = ObjectMapper.Map <Payrun, Payrun_Dto>(PayrunAppService.Repository.WithDetails().SingleOrDefault(x => x.Month == payrun.Month - 1 && x.Year == payrun.Year));

            if (payrun != null)
            {
                List <PayrunDetail_Dto> payrunDetails = payrun.PayrunDetails.ToList();
                List <dynamic>          dynamicDS     = new List <dynamic>();

                for (int i = 0; i < payrunDetails.Count; i++)
                {
                    PayrunDetail_Dto curDetail = payrunDetails[i];
                    if (curDetail.Employee.IndemnityType == null || curDetail.Employee.IndemnityType.Value != "Eligible")
                    {
                        continue;
                    }
                    PayrunDetailIndemnity_Dto employeeIndemnity = null;
                    if (curDetail.Indemnity != null)
                    {
                        employeeIndemnity = curDetail.Indemnity;
                    }
                    else
                    {
                        employeeIndemnity = curDetail.GetIndemnity();
                    }

                    PayrunDetail_Dto          curDetailLast         = payrunLast == null ? null : payrunLast.PayrunDetails.FirstOrDefault(x => x.EmployeeId == curDetail.EmployeeId);
                    PayrunDetailIndemnity_Dto employeeIndemnityLast = curDetailLast != null?curDetailLast.GetIndemnity() : null;

                    if (employeeIndemnityLast != null)
                    {
                        employeeIndemnity.LastMonthEOSB = employeeIndemnityLast.TotalEOSB;
                        employeeIndemnity.Difference    = employeeIndemnity.LastMonthEOSB - employeeIndemnity.TotalEOSB;
                    }

                    dynamic indemnityDSRow = new ExpandoObject();
                    indemnityDSRow.payrunId         = payrunId;
                    indemnityDSRow.sNo              = i + 1;
                    indemnityDSRow.Id               = employeeIndemnity.Id;
                    indemnityDSRow.EmployeeId       = employeeIndemnity.EmployeeId;
                    indemnityDSRow.getEmpRefCode    = employeeIndemnity.Employee.GetReferenceId;
                    indemnityDSRow.getEmpName       = employeeIndemnity.Employee.Name;
                    indemnityDSRow.getEmpDepartment = employeeIndemnity.Employee.Department.Name;
                    indemnityDSRow.getEmpDOJ        = employeeIndemnity.Employee.JoiningDate;
                    indemnityDSRow.BasicSalary      = "" + employeeIndemnity.BasicSalary.ToString("N2");

                    foreach (PayrunAllowanceSummary_Dto eosbAllowance in employeeIndemnity.PayrunEOSBAllowancesSummaries)
                    {
                        DynamicHelper.AddProperty(indemnityDSRow, $"{eosbAllowance.AllowanceType.Value}_Value", "" + eosbAllowance.Value.ToString("N2"));
                    }

                    indemnityDSRow.GrossSalary              = "" + employeeIndemnity.GrossSalary.ToString("N2");
                    indemnityDSRow.TotalEmploymentDays      = employeeIndemnity.TotalEmploymentDays;
                    indemnityDSRow.TotalPre5EmploymentDays  = employeeIndemnity.TotalPre5EmploymentDays;
                    indemnityDSRow.TotalPost5EmploymentDays = employeeIndemnity.TotalPost5EmploymentDays;
                    indemnityDSRow.TotalEOSB           = "" + employeeIndemnity.TotalEOSB.ToString("N2");
                    indemnityDSRow.LastMonthEOSB       = "" + employeeIndemnity.LastMonthEOSB.ToString("N2");
                    indemnityDSRow.ActuarialEvaluation = "" + employeeIndemnity.ActuarialEvaluation.ToString("N2");
                    indemnityDSRow.Difference          = "" + employeeIndemnity.Difference.ToString("N2");
                    indemnityDSRow.PayrunDetailId      = curDetail.Id;

                    indemnityDSRow.month = curDetail.Month;
                    indemnityDSRow.year  = curDetail.Year;

                    dynamicDS.Add(indemnityDSRow);
                }

                //JsonResult eosbDSJson = new JsonResult(dynamicDS);

                _dynamicDS          = new ExpandoObject();
                _dynamicDS.EOSBDS   = JsonSerializer.Serialize(dynamicDS);
                _dynamicDS.month    = payrun.Month;
                _dynamicDS.year     = payrun.Year;
                _dynamicDS.isPosted = payrun.IsIndemnityPosted;
            }
            return(Page());
        }
Пример #3
0
        public IActionResult OnGet(int P1Year, int P1Month, int P2Year, int P2Month, bool isAjax)
        {
            bool isOnGet = P1Year != 0 && P2Year != 0;

            if (!isOnGet)
            {
                return(Page());
            }

            try
            {
                bool isPeriodValid = true;

                Payrun_Dto fromPayrun = null;
                Payrun_Dto toPayrun   = null;

                fromPayrun = ObjectMapper.Map <Payrun, Payrun_Dto>(PayrunAppService.Repository.WithDetails().SingleOrDefault(x => x.Year == P1Year && x.Month == P1Month));
                toPayrun   = ObjectMapper.Map <Payrun, Payrun_Dto>(PayrunAppService.Repository.WithDetails().SingleOrDefault(x => x.Year == P2Year && x.Month == P2Month));

                if (fromPayrun == null || toPayrun == null)
                {
                    isPeriodValid = false;
                }

                if (!isPeriodValid)
                {
                    return(BadRequest(new { type = "period" }));
                }


                List <dynamic> payrunReconSummaryDynamicDS = new List <dynamic>();

                if (fromPayrun != null && toPayrun != null)
                {
                    Allowances = DicValuesRepo.WithDetails(x => x.ValueType).Where(x => x.ValueType.ValueTypeFor == ValueTypeModules.AllowanceType).ToList();

                    List <PayrunDetail_Dto> fromPDetails = fromPayrun.PayrunDetails.ToList();
                    List <PayrunDetail_Dto> toPDetails   = toPayrun.PayrunDetails.ToList();

                    List <(PayrunDetail_Dto fromPDetail, PayrunDetail_Dto toPDetail)> payrunReconDetails = new List <(PayrunDetail_Dto fromPDetail, PayrunDetail_Dto toPDetail)>();

                    var toExplicits = toPDetails.Where(x => !fromPDetails.Any(x1 => x1.EmployeeId == x.EmployeeId))
                                      .Select(x => { return((PayrunDetail_Dto)null, x); });

                    payrunReconDetails.AddRange(toExplicits);
                    payrunReconDetails.AddRange(fromPDetails.Select(x =>
                    {
                        if (toPDetails.Exists(x1 => x1.EmployeeId == x.EmployeeId))
                        {
                            return(x, toPDetails.Single(x1 => x1.EmployeeId == x.EmployeeId));
                        }
                        else
                        {
                            return(x, null);
                        }
                    }));

                    for (int i = 0; i < payrunReconDetails.Count; i++)
                    {
                        var reconDetail = payrunReconDetails[i];

                        PayrunDetail_Dto fromD = reconDetail.fromPDetail;
                        PayrunDetail_Dto toD   = reconDetail.toPDetail;

                        dynamic payrunReconEmpDDSRow = new ExpandoObject();

                        if (fromD != null || toD != null)
                        {
                            bool isFromD = fromD != null;
                            bool isToD   = toD != null;
                            bool both    = isToD && isFromD;

                            Employee_Dto emp = isFromD ? fromD.Employee : toD.Employee;

                            payrunReconEmpDDSRow.getCompanyName            = emp.Department.Company.CompanyName;
                            payrunReconEmpDDSRow.getCompanyAddress         = emp.Department.Company.CompanyLocations[0].Location.LocationName;
                            payrunReconEmpDDSRow.getEmployeeReferenceId    = emp.GetReferenceId;
                            payrunReconEmpDDSRow.getEmployeeName           = emp.Name;
                            payrunReconEmpDDSRow.getEmployeeDepartmentName = emp.Department.Name;
                            payrunReconEmpDDSRow.getEmployeePositionTitle  = emp.Position.Title;

                            if (both)
                            {
                                List <(PayrunAllowanceSummary_Dto fromAllowance, PayrunAllowanceSummary_Dto toAllowance)> allowancesReconDetails = new List <(PayrunAllowanceSummary_Dto fromAllowance, PayrunAllowanceSummary_Dto toAllowance)>();

                                var toAllowancesExplicits = toD.PayrunAllowancesSummaries.Where(x => !fromD.PayrunAllowancesSummaries.Any(x1 => x1.AllowanceTypeId == x.AllowanceTypeId))
                                                            .Select(x => { return((PayrunAllowanceSummary_Dto)null, x); });

                                allowancesReconDetails.AddRange(toAllowancesExplicits);
                                allowancesReconDetails.AddRange(fromD.PayrunAllowancesSummaries.Select(x =>
                                {
                                    if (toD.PayrunAllowancesSummaries.Any(x1 => x1.AllowanceTypeId == x.AllowanceTypeId))
                                    {
                                        return(x, toD.PayrunAllowancesSummaries.First(x1 => x1.AllowanceTypeId == x.AllowanceTypeId));
                                    }
                                    else
                                    {
                                        return(x, null);
                                    }
                                }));

                                decimal bsDiffValue = (toD.BasicSalary - fromD.BasicSalary);
                                string  bsDiff      = bsDiffValue < 0? $"({Math.Abs(bsDiffValue).ToString("N2")})" : bsDiffValue.ToString("N2");
                                DynamicHelper.AddProperty(payrunReconEmpDDSRow, $"basicSalary", bsDiff);

                                if (bsDiffValue > 0)
                                {
                                    payrunReconEmpDDSRow.category = "Increment";
                                    var cloned = JsonConvert.DeserializeObject <dynamic>(JsonConvert.SerializeObject(payrunReconEmpDDSRow));
                                    payrunReconSummaryDynamicDS.Add(cloned);;
                                    payrunReconEmpDDSRow.category = "⁠";
                                }
                                else if (bsDiffValue < 0)
                                {
                                    payrunReconEmpDDSRow.category = "Deduction";
                                    var cloned = JsonConvert.DeserializeObject <dynamic>(JsonConvert.SerializeObject(payrunReconEmpDDSRow));
                                    payrunReconSummaryDynamicDS.Add(cloned);
                                    payrunReconEmpDDSRow.category = "⁠";
                                }
                                payrunReconEmpDDSRow.basicSalary = "⁠—";

                                for (int j = 0; j < allowancesReconDetails.Count; j++)
                                {
                                    PayrunAllowanceSummary_Dto fromAllowance = allowancesReconDetails[j].fromAllowance;
                                    PayrunAllowanceSummary_Dto toAllowance   = allowancesReconDetails[j].toAllowance;

                                    bool isFromDAllowance = fromAllowance != null;
                                    bool isToDAllowance   = toAllowance != null;
                                    bool bothAllowance    = isFromDAllowance && isToDAllowance;

                                    if (bothAllowance)
                                    {
                                        DictionaryValue_Dto allowance = fromAllowance.AllowanceType;
                                        string camelCaseName          = allowance.Value;
                                        camelCaseName = camelCaseName.Replace(" ", "");
                                        camelCaseName = char.ToLowerInvariant(camelCaseName[0]) + camelCaseName.Substring(1);

                                        double difference = (double)(toAllowance.Value - fromAllowance.Value);
                                        string difValue   = difference >= 0 ? difference.ToString("N2") : $"({Math.Abs(difference).ToString("N2")})";

                                        DynamicHelper.AddProperty(payrunReconEmpDDSRow, $"{camelCaseName}_Value", difValue);

                                        if (difference > 0)
                                        {
                                            payrunReconEmpDDSRow.category = $"{allowance.Value} Increased";
                                            var cloned = JsonConvert.DeserializeObject <dynamic>(JsonConvert.SerializeObject(payrunReconEmpDDSRow));
                                            payrunReconSummaryDynamicDS.Add(cloned);
                                            DynamicHelper.RemoveProperty(payrunReconEmpDDSRow, $"{camelCaseName}_Value");
                                            payrunReconEmpDDSRow.category = "⁠";
                                        }
                                        else if (difference < 0)
                                        {
                                            payrunReconEmpDDSRow.category = $"{allowance.Value} Decreased";
                                            var cloned = JsonConvert.DeserializeObject <dynamic>(JsonConvert.SerializeObject(payrunReconEmpDDSRow));
                                            payrunReconSummaryDynamicDS.Add(cloned);
                                            DynamicHelper.RemoveProperty(payrunReconEmpDDSRow, $"{camelCaseName}_Value");
                                            payrunReconEmpDDSRow.category = "⁠";
                                        }
                                    }
                                    else
                                    {
                                        if (isFromDAllowance)
                                        {
                                            DictionaryValue_Dto allowance = fromAllowance.AllowanceType;
                                            string camelCaseName          = allowance.Value;
                                            camelCaseName = camelCaseName.Replace(" ", "");
                                            camelCaseName = char.ToLowerInvariant(camelCaseName[0]) + camelCaseName.Substring(1);

                                            double allowanceValue = (double)fromAllowance.Value;
                                            string value          = $"({allowanceValue.ToString("N2")})";

                                            DynamicHelper.AddProperty(payrunReconEmpDDSRow, $"{camelCaseName}_Value", value);
                                            payrunReconEmpDDSRow.category = $"{allowance.Value} Removed";
                                            var cloned = JsonConvert.DeserializeObject <dynamic>(JsonConvert.SerializeObject(payrunReconEmpDDSRow));
                                            payrunReconSummaryDynamicDS.Add(cloned);
                                            DynamicHelper.RemoveProperty(payrunReconEmpDDSRow, $"{camelCaseName}_Value");
                                            payrunReconEmpDDSRow.category = "⁠";
                                        }
                                        else if (isToDAllowance)
                                        {
                                            DictionaryValue_Dto allowance = toAllowance.AllowanceType;
                                            string camelCaseName          = allowance.Value;
                                            camelCaseName = camelCaseName.Replace(" ", "");
                                            camelCaseName = char.ToLowerInvariant(camelCaseName[0]) + camelCaseName.Substring(1);

                                            double allowanceValue = (double)toAllowance.Value;
                                            string value          = allowanceValue >= 0 ? allowanceValue.ToString("N2") : $"({allowanceValue.ToString("N2")})";

                                            DynamicHelper.AddProperty(payrunReconEmpDDSRow, $"{camelCaseName}_Value", value);
                                            payrunReconEmpDDSRow.category = $"{allowance.Value} Added";
                                            var cloned = JsonConvert.DeserializeObject <dynamic>(JsonConvert.SerializeObject(payrunReconEmpDDSRow));
                                            payrunReconSummaryDynamicDS.Add(cloned);
                                            DynamicHelper.RemoveProperty(payrunReconEmpDDSRow, $"{camelCaseName}_Value");
                                            payrunReconEmpDDSRow.category = "⁠";
                                        }
                                    }
                                }
                                payrunReconEmpDDSRow.grossEarnings = toD.GrossEarnings - fromD.GrossEarnings;

                                decimal gosiDiffValue = (toD.GOSIAmount - fromD.GOSIAmount);
                                payrunReconEmpDDSRow.gosiValue = gosiDiffValue > 0? gosiDiffValue.ToString("N2") : $"({Math.Abs(gosiDiffValue).ToString("N2")})";
                                if (gosiDiffValue != 0)
                                {
                                    payrunReconEmpDDSRow.category = gosiDiffValue > 0? "GOSI Increased" : "GOSI Decreased";
                                    var cloned = JsonConvert.DeserializeObject <dynamic>(JsonConvert.SerializeObject(payrunReconEmpDDSRow));
                                    payrunReconSummaryDynamicDS.Add(cloned);
                                    payrunReconEmpDDSRow.gosiValue = "—";
                                    payrunReconEmpDDSRow.category  = "⁠";
                                }

                                decimal loansDiffValue = (toD.Loan - fromD.Loan);
                                payrunReconEmpDDSRow.loansValue = loansDiffValue > 0? loansDiffValue.ToString("N2") : $"({Math.Abs(loansDiffValue).ToString("N2")})";
                                if (loansDiffValue != 0)
                                {
                                    payrunReconEmpDDSRow.category = loansDiffValue > 0? "Loans Increased" : "Loans Decreased";
                                    var cloned = JsonConvert.DeserializeObject <dynamic>(JsonConvert.SerializeObject(payrunReconEmpDDSRow));
                                    payrunReconSummaryDynamicDS.Add(cloned);
                                    payrunReconEmpDDSRow.gosiValue = "—";
                                    payrunReconEmpDDSRow.category  = "⁠";
                                }
                                decimal leavesDiffValue = (toD.Leaves - fromD.Leaves);
                                payrunReconEmpDDSRow.leavesValue = leavesDiffValue > 0? leavesDiffValue.ToString("N2") : $"({Math.Abs(leavesDiffValue).ToString("N2")})";
                                if (loansDiffValue != 0)
                                {
                                    payrunReconEmpDDSRow.category = leavesDiffValue > 0? "Leaves Increased" : "Leaves Decreased";
                                    var cloned = JsonConvert.DeserializeObject <dynamic>(JsonConvert.SerializeObject(payrunReconEmpDDSRow));
                                    payrunReconSummaryDynamicDS.Add(cloned);
                                    payrunReconEmpDDSRow.gosiValue = "—";
                                    payrunReconEmpDDSRow.category  = "⁠";
                                }

                                payrunReconEmpDDSRow.grossDeduction = toD.GrossDeductions - fromD.GrossDeductions;

                                payrunReconEmpDDSRow.netAmount = (payrunReconEmpDDSRow.grossEarnings - payrunReconEmpDDSRow.grossDeduction).ToString("N2");
                            }
                            else
                            {
                                if (isFromD)
                                {
                                    string bs = fromD.BasicSalary.ToString("N2");
                                    DynamicHelper.AddProperty(payrunReconEmpDDSRow, $"basicSalary", bs);
                                    var fromAllowances = fromD.PayrunAllowancesSummaries.ToList();
                                    for (int j = 0; j < fromAllowances.Count; j++)
                                    {
                                        PayrunAllowanceSummary_Dto fromAllowance = fromAllowances[i];

                                        DictionaryValue_Dto allowance = fromAllowance.AllowanceType;
                                        string camelCaseName          = allowance.Value;
                                        camelCaseName = camelCaseName.Replace(" ", "");
                                        camelCaseName = char.ToLowerInvariant(camelCaseName[0]) + camelCaseName.Substring(1);

                                        double allowanceValue = (double)fromAllowance.Value;
                                        string value          = allowanceValue > 0 ? allowanceValue.ToString("N2") : $"({allowanceValue.ToString("N2")})";

                                        DynamicHelper.AddProperty(payrunReconEmpDDSRow, $"{camelCaseName}_Value", value);
                                    }
                                    payrunReconEmpDDSRow.grossEarnings = fromD.GrossEarnings;

                                    payrunReconEmpDDSRow.gosiValue   = fromD.GOSIAmount;
                                    payrunReconEmpDDSRow.loansValue  = fromD.Loan;
                                    payrunReconEmpDDSRow.leavesValue = fromD.Leaves;

                                    payrunReconEmpDDSRow.grossDeduction = fromD.GrossDeductions;

                                    payrunReconEmpDDSRow.netAmount = (payrunReconEmpDDSRow.grossEarnings - payrunReconEmpDDSRow.grossDeduction).ToString("N2");

                                    payrunReconEmpDDSRow.category = "Left";
                                    payrunReconSummaryDynamicDS.Add(payrunReconEmpDDSRow);
                                    payrunReconEmpDDSRow.category = "⁠";
                                }
                                else if (isToD)
                                {
                                    string bs = toD.BasicSalary.ToString("N2");
                                    DynamicHelper.AddProperty(payrunReconEmpDDSRow, $"basicSalary", bs);
                                    var toAllowances = toD.PayrunAllowancesSummaries.ToList();
                                    for (int j = 0; j < toAllowances.Count; j++)
                                    {
                                        PayrunAllowanceSummary_Dto toAllowance = toAllowances[i];

                                        DictionaryValue_Dto allowance = toAllowance.AllowanceType;
                                        string camelCaseName          = allowance.Value;
                                        camelCaseName = camelCaseName.Replace(" ", "");
                                        camelCaseName = char.ToLowerInvariant(camelCaseName[0]) + camelCaseName.Substring(1);

                                        double allowanceValue = (double)toAllowance.Value;
                                        string value          = allowanceValue > 0 ? allowanceValue.ToString("N2") : $"({allowanceValue.ToString("N2")})";

                                        DynamicHelper.AddProperty(payrunReconEmpDDSRow, $"{camelCaseName}_Value", value);
                                    }
                                    payrunReconEmpDDSRow.grossEarnings = toD.GrossEarnings;

                                    payrunReconEmpDDSRow.gosiValue   = toD.GOSIAmount;
                                    payrunReconEmpDDSRow.loansValue  = toD.Loan;
                                    payrunReconEmpDDSRow.leavesValue = toD.Leaves;

                                    payrunReconEmpDDSRow.grossDeduction = toD.GrossDeductions;

                                    payrunReconEmpDDSRow.netAmount = (payrunReconEmpDDSRow.grossEarnings - payrunReconEmpDDSRow.grossDeduction).ToString("N2");

                                    payrunReconEmpDDSRow.category = "New Employee";
                                    payrunReconSummaryDynamicDS.Add(payrunReconEmpDDSRow);
                                    payrunReconEmpDDSRow.category = "⁠";
                                }
                            }
                        }

                        //if(payrunReconEmpDDSRow.netAmount != "0.00")
                        //    payrunReconSummaryDynamicDS.Add(payrunReconEmpDDSRow);
                    }

                    if (!isAjax)
                    {
                        ViewData["Payruns_DS"] = JsonSerializer.Serialize(payrunReconSummaryDynamicDS);
                        return(Page());
                    }
                    else
                    {
                        return(new JsonResult(payrunReconSummaryDynamicDS));
                    }
                }
                else
                {
                    return(BadRequest(new { type = "payrun" }));
                }
            }
            catch (Exception ex)
            {
                return(BadRequest(new { type = "exception" }));
            }
        }
Пример #4
0
        public List <GridColumn> GetPrimaryGridColumns()
        {
            Allowances = DicValuesRepo.WithDetails(x => x.ValueType).Where(x => x.ValueType.ValueTypeFor == ValueTypeModules.AllowanceType).ToList();

            List <GridColumn> earningsColumns = new List <GridColumn>();

            earningsColumns.Add(new GridColumn()
            {
                Field = $"basicSalary", HeaderText = "Basic Salary", TextAlign = TextAlign.Center, MinWidth = "50"
            });
            for (int i = 0; i < Allowances.Count; i++)
            {
                DictionaryValue allowance     = Allowances[i];
                string          camelCaseName = allowance.Value;
                camelCaseName = camelCaseName.Replace(" ", "");
                camelCaseName = char.ToLowerInvariant(camelCaseName[0]) + camelCaseName.Substring(1);

                earningsColumns.Add(new GridColumn()
                {
                    Field = $"{camelCaseName}_Value", HeaderText = $"{Allowances[i].Value}", TextAlign = TextAlign.Center, MinWidth = "50"
                });
            }
            //earningsColumns.Add(new GridColumn() { Field = $"grossEarnings", HeaderText = "Total", TextAlign = TextAlign.Center, MinWidth = "50" });

            List <GridColumn> gridColumns = new List <GridColumn>()
            {
                new GridColumn {
                    Field = "getEmployeeReferenceId", HeaderText = "Emp Id", TextAlign = TextAlign.Center, MinWidth = "40"
                },
                new GridColumn {
                    Field = "getEmployeeName", HeaderText = "Employee", TextAlign = TextAlign.Center, MinWidth = "40"
                },
                new GridColumn {
                    Field = "getEmployeeDepartmentName", HeaderText = "Department", TextAlign = TextAlign.Center, MinWidth = "50"
                },
                new GridColumn {
                    Field = "getEmployeePositionTitle", HeaderText = "Position", TextAlign = TextAlign.Center, MinWidth = "50"
                }
            };

            gridColumns.Add(new GridColumn
            {
                Field      = "",
                HeaderText = "Earnings",
                TextAlign  = TextAlign.Center,
                MinWidth   = "50",
                Columns    = earningsColumns
            });
            gridColumns.Add(new GridColumn
            {
                Field      = "",
                HeaderText = "Deductions",
                TextAlign  = TextAlign.Center,
                MinWidth   = "50",
                Columns    = new List <GridColumn>()
                {
                    new GridColumn()
                    {
                        Field = "gosiValue", HeaderText = "GOSI", TextAlign = TextAlign.Center, MinWidth = "50"
                    },
                    new GridColumn()
                    {
                        Field = "loansValue", HeaderText = "Loans", TextAlign = TextAlign.Center, MinWidth = "50"
                    },
                    new GridColumn()
                    {
                        Field = "leavesValue", HeaderText = "Leaves", TextAlign = TextAlign.Center, MinWidth = "50"
                    },
                    //new GridColumn() { Field = "grossDeductions", HeaderText = "Total", TextAlign = TextAlign.Center, MinWidth = "50" },
                }
            });

            //gridColumns.Add(new GridColumn { Field = "netAmount", HeaderText = "Net Amount", TextAlign = TextAlign.Center, MinWidth = "50" });
            gridColumns.Add(new GridColumn {
                Field = "category", HeaderText = "Category", TextAlign = TextAlign.Center, MinWidth = "50"
            });

            gridColumns.AddRange(GetCommandsColumns());

            return(gridColumns);
        }
Пример #5
0
        public void OnGet()
        {
            Allowances = DicValuesRepo.Where(x => x.ValueType.ValueTypeFor == ValueTypeModules.AllowanceType).ToList();
            List <Payrun_Dto> payruns = ObjectMapper.Map <List <Payrun>, List <Payrun_Dto> >(PayrunAppService.Repository.WithDetails().ToList());

            ViewData["Payruns_DS"] = JsonSerializer.Serialize(payruns);

            List <dynamic> payrunSummaryDynamicDS = new List <dynamic>();

            for (int i = 0; i < payruns.Count; i++)
            {
                dynamic payrunSummaryDDSRow = new ExpandoObject();
                payrunSummaryDDSRow.id = payruns[i].Id;

                List <PayrunDetail_Dto> payrunDetails = payruns[i].PayrunDetails.ToList();

                payrunSummaryDDSRow.totalEmployees = payrunDetails.Count;

                payrunSummaryDDSRow.getBasicSalaries = payrunDetails.Sum(x => x.BasicSalary);
                foreach (PayrunAllowanceSummary_Dto allowanceSummary in payrunDetails[0].PayrunAllowancesSummaries)
                {
                    DictionaryValue_Dto allowance = allowanceSummary.AllowanceType;
                    string camelCaseName          = allowance.Value;
                    camelCaseName = camelCaseName.Replace(" ", "");
                    camelCaseName = char.ToLowerInvariant(camelCaseName[0]) + camelCaseName.Substring(1);

                    DynamicHelper.AddProperty(payrunSummaryDDSRow, $"{camelCaseName}_Value", payrunDetails.Sum(x => x.PayrunAllowancesSummaries.Sum(x1 => x1.Value)));
                }

                payrunSummaryDDSRow.gosiValue       = payrunDetails.Sum(x => x.GOSIAmount);
                payrunSummaryDDSRow.loansValue      = payrunDetails.Sum(x => x.Loan);
                payrunSummaryDDSRow.leavesValue     = payrunDetails.Sum(x => x.Leaves);
                payrunSummaryDDSRow.grossDeductions = payrunDetails.Sum(x => x.GrossDeductions);

                payrunSummaryDynamicDS.Add(payrunSummaryDDSRow);
            }
            SecondaryDetailsGrid = new Grid()
            {
                DataSource    = payrunSummaryDynamicDS,
                QueryCellInfo = "QueryCellInfo",
                QueryString   = "id",
                EditSettings  = new Syncfusion.EJ2.Grids.GridEditSettings()
                {
                },
                AllowExcelExport = true,
                //AllowGrouping = true,
                AllowPdfExport     = true,
                HierarchyPrintMode = HierarchyGridPrintMode.All,
                AllowSelection     = true,
                AllowFiltering     = false,
                AllowSorting       = true,
                AllowMultiSorting  = true,
                AllowResizing      = true,
                GridLines          = GridLine.Both,
                SearchSettings     = new GridSearchSettings()
                {
                },
                //Toolbar = new List<object>() { "ExcelExport", "CsvExport", "Print", "Search",new { text = "Copy", tooltipText = "Copy", prefixIcon = "e-copy", id = "copy" }, new { text = "Copy With Header", tooltipText = "Copy With Header", prefixIcon = "e-copy", id = "copyHeader" } },
                Columns = GetSecondaryGridColumns()
            };
        }
Пример #6
0
        public IActionResult OnGet()
        {
            SIAllowances = DicValuesRepo.Where(x => x.ValueType.ValueTypeFor == ValueTypeModules.AllowanceType && x.Dimension_2_Value.ToUpper() == "TRUE").ToList();

            payrun = ObjectMapper.Map <Payrun, Payrun_Dto>(PayrunAppService.Repository.WithDetails().SingleOrDefault(x => x.Id == payrunId));
            SIContributionCategories = ObjectMapper.Map <List <SIContributionCategory>, List <SIContributionCategory_Dto> >(SocialInsuranceAppService.Repository.WithDetails().First().ContributionCategories.ToList());
            if (payrun != null)
            {
                List <PayrunDetail_Dto> payrunDetails = payrun.PayrunDetails.ToList();
                List <dynamic>          dynamicDS     = new List <dynamic>();

                for (int i = 0; i < payrunDetails.Count; i++)
                {
                    PayrunDetail_Dto curDetail = payrunDetails[i];

                    if (curDetail.Employee.SIType == null || curDetail.Employee.SIType.Value != "Eligible")
                    {
                        continue;
                    }
                    SocialInsuranceReport_Dto employeeSIReport = GetSIReport(curDetail);

                    dynamic siDSRow = new ExpandoObject();
                    siDSRow.payrunId             = employeeSIReport.PayrunId;
                    siDSRow.sNo                  = i + 1;
                    siDSRow.getEmpName           = employeeSIReport.Employee.Name;
                    siDSRow.getEmpIdentityNumber = employeeSIReport.EmpID;
                    siDSRow.getEmpNationality    = employeeSIReport.Employee.Nationality.Value;
                    siDSRow.getEmpSIID           = employeeSIReport.EmpSIId;
                    siDSRow.getBasicSalary       = "" + employeeSIReport.BasicSalary.ToString("N2");

                    foreach (PayrunAllowanceSummary_Dto siAllowance in employeeSIReport.PayrunSIAllowancesSummaries)
                    {
                        DynamicHelper.AddProperty(siDSRow, $"{siAllowance.AllowanceType.Value}_Value", "" + siAllowance.Value.ToString("N2"));
                    }

                    double totalSISalary = employeeSIReport.TotalSISalary;
                    siDSRow.getEmpTotalSalaryForSI = "" + totalSISalary.ToString("N2");

                    List <(string title, double value)> Contributions = new List <(string title, double value)>();
                    foreach (SIContributionCategory_Dto SIC in SIContributionCategories)
                    {
                        foreach (SIContribution_Dto SICC in SIC.SIContributions)
                        {
                            double SICCCV       = SICC.IsPercentage ? totalSISalary * (SICC.Value / 100) : SICC.Value;
                            int    contribIndex = Contributions.FindIndex(x => x.title == SICC.Title);
                            if (contribIndex != -1)
                            {
                                Contributions[contribIndex] = (SICC.Title, Contributions[contribIndex].value + SICCCV);
                            }
                            else
                            {
                                Contributions.Add((SICC.Title, SICCCV));
                            }
                            DynamicHelper.AddProperty(siDSRow, $"{SIC.Title}_{SICC.Title}_Value", $"{SICCCV.ToString("N2")}");
                        }
                    }

                    foreach ((string title, double value)SICC in Contributions)
                    {
                        List <SIContribution_Dto> sIContributions = SIContributionCategories.SelectMany(x => x.SIContributions).ToList();
                        DynamicHelper.AddProperty(siDSRow, $"Overall_{SICC.title}_Value", $"{SICC.value.ToString("N2")}");
                    }

                    siDSRow.month = curDetail.Month;
                    siDSRow.year  = curDetail.Year;

                    dynamicDS.Add(siDSRow);
                }

                //JsonResult eosbDSJson = new JsonResult(dynamicDS);

                _dynamicDS          = new ExpandoObject();
                _dynamicDS.SIDS     = JsonSerializer.Serialize(dynamicDS);
                _dynamicDS.month    = payrun.Month;
                _dynamicDS.year     = payrun.Year;
                _dynamicDS.isPosted = payrun.IsSIPosted;
            }
            return(Page());
        }