Beispiel #1
0
        public ActionResult GenerateSalarySheet(SetupEmployeeMasterModel model)
        {
            SetupEmployeeMasterProviders SProv = new SetupEmployeeMasterProviders();

            if (model.EmployeeMasterId == 0)
            {
                model.SetupEmployeeMasterModelList    = SProv.GetEmployeePayrollMaster().ToList();
                model.EmployeeAllowanceSetupModelList = SProv.GetEmployeeAllowanceInfo().ToList();
                model.EmployeeDeductionSetupModelList = SProv.GetEmployeeDeductionInfo().ToList();
            }
            else
            {
                model.SetupEmployeeMasterModelList    = SProv.GetEmployeePayrollMaster().Where(x => x.EmployeeMasterId == model.EmployeeMasterId).ToList();
                model.EmployeeAllowanceSetupModelList = SProv.GetEmployeeAllowanceInfo().Where(x => x.EmployeeMasterId == model.EmployeeMasterId).ToList();
                model.EmployeeDeductionSetupModelList = SProv.GetEmployeeDeductionInfo().Where(x => x.EmployeeMasterId == model.EmployeeMasterId).ToList();
            }
            int i = SProv.GeneratePayroll(model);

            if (i != 0)
            {
                return(PartialView("_ViewSalarySheet", model));
            }
            return(View(model));
        }
Beispiel #2
0
        public ActionResult FinalisePayroll(SetupEmployeeMasterModel model)
        {
            SetupEmployeeMasterProviders pro = new SetupEmployeeMasterProviders();
            int     i = 0;
            decimal SalaryExpenses = 0, PfDR = 0, Festival = 0, Dress = 0, Dearness = 0, OtherAllowance = 0, InsuranceDr = 0;
            decimal SalaryPayable = 0, InsuranceCR = 0, Advance = 0, PfCR = 0, CIT = 0, Fund = 0, SST = 0, Tax = 0, LoanDeduct = 0, LoanInterest = 0, LeaveDeduct = 0, TotalDeduct = 0;
            decimal TotalDebit = 0, TotalCredit = 0;

            model.SetupEmployeeMasterModelList       = pro.GeneratePayroll(model.MonthId, model.YearId);
            model.ObjAddMoreParticularsEmployeeModel = new AddMoreParticularsEmployeeModel();
            foreach (var item in model.SetupEmployeeMasterModelList)
            {
                #region DR
                if (item.TotalDebit > 0)
                {
                    TotalDebit += item.TotalDebit;
                }
                if (item.BasicSalary > 0)
                {
                    SalaryExpenses += item.BasicSalary;
                }
                if (item.GradeAmount > 0)
                {
                    SalaryExpenses += item.GradeAmount;
                }
                if (item.OverTimeAmount > 0)
                {
                    SalaryExpenses += item.OverTimeAmount;
                }
                if (item.PFAmount > 0)
                {
                    PfDR += item.PFAmount;
                }
                if (item.FestivalAmount > 0)
                {
                    Festival += item.FestivalAmount;
                }
                if (item.DressAllowance > 0)
                {
                    Dress += item.DressAllowance;
                }
                if (item.DearnessAllowance > 0)
                {
                    Dearness += item.DearnessAllowance;
                }
                if (item.TotalAllowance > 0)
                {
                    OtherAllowance += item.TotalAllowance;
                }
                if (item.InsuranceAmount > 0)
                {
                    InsuranceDr += item.InsuranceAmount;
                }
                #endregion
                #region CR
                if (item.CITAmount > 0)
                {
                    CIT += item.CITAmount;
                }
                if (item.AdvanceDeduction > 0)
                {
                    Advance += item.AdvanceDeduction;
                }
                if (item.InsuranceDeductAmount > 0)
                {
                    InsuranceCR += item.InsuranceDeductAmount;
                }
                if (item.PFDeductAmount > 0)
                {
                    PfCR += item.PFDeductAmount;
                }
                if (item.FundAmount > 0)
                {
                    Fund += item.FundAmount;
                }
                if (item.SSTAmount > 0)
                {
                    SST += item.SSTAmount;
                }
                if (item.TaxAmount > 0)
                {
                    Tax += item.TaxAmount;
                }
                if (item.LoanDeduction > 0)
                {
                    LoanDeduct += item.LoanDeduction;
                }
                if (item.LoanInterest > 0)
                {
                    LoanInterest += item.LoanInterest;
                }
                if (item.LeaveDeduction > 0)
                {
                    LeaveDeduct += item.LeaveDeduction;
                }
                if (item.TotalDeduction > 0)
                {
                    TotalDeduct += item.TotalDeduction;
                }
                if (item.TotalCredit > 0)
                {
                    TotalCredit += item.TotalCredit;
                }
                if (item.SalaryPayable > 0)
                {
                    SalaryPayable += item.SalaryPayable;
                }
                #endregion
            }
            model.ObjAddMoreParticularsEmployeeModel.DrAmountTotal = TotalDebit;
            model.ObjAddMoreParticularsEmployeeModel.CrAmountTotal = TotalCredit;
            model.ObjAddMoreParticularsEmployeeModel.AddMoreParticularsEmployeeModelList = new List <AddMoreParticularsEmployeeModel>();
            #region AssignToListDR
            if (SalaryExpenses > 0)
            {
                var ObjModel = new AddMoreParticularsEmployeeModel()
                {
                    CrAmount       = 0,
                    DrAmountTotal  = TotalDebit,
                    CrAmountTotal  = TotalCredit,
                    DrAmount       = SalaryExpenses,
                    DrOrCr         = 1,
                    JvType         = "JV",
                    Narration      = "",
                    Particulars    = Utility.GetAccHeadIDFromDescription("Salary Expenses"),
                    SubParticulars = 0,
                    DrOrCrName     = ""
                };
                model.ObjAddMoreParticularsEmployeeModel.AddMoreParticularsEmployeeModelList.Add(ObjModel);
            }
            if (PfDR > 0)
            {
                var ObjModel = new AddMoreParticularsEmployeeModel()
                {
                    CrAmount       = 0,
                    DrAmountTotal  = TotalDebit,
                    CrAmountTotal  = TotalCredit,
                    DrAmount       = PfDR,
                    DrOrCr         = 1,
                    JvType         = "JV",
                    Narration      = "",
                    Particulars    = Utility.GetAccHeadIDFromDescription("PFAddition"),
                    SubParticulars = 0,
                    DrOrCrName     = ""
                };
                model.ObjAddMoreParticularsEmployeeModel.AddMoreParticularsEmployeeModelList.Add(ObjModel);
            }
            if (Festival > 0)
            {
                var ObjModel = new AddMoreParticularsEmployeeModel()
                {
                    CrAmount       = 0,
                    DrAmountTotal  = TotalDebit,
                    CrAmountTotal  = TotalCredit,
                    DrAmount       = Festival,
                    DrOrCr         = 1,
                    JvType         = "JV",
                    Narration      = "",
                    Particulars    = Utility.GetAccHeadIDFromDescription("FestivalAmount"),
                    SubParticulars = 0,
                    DrOrCrName     = ""
                };
                model.ObjAddMoreParticularsEmployeeModel.AddMoreParticularsEmployeeModelList.Add(ObjModel);
            }
            if (Dress > 0)
            {
                var ObjModel = new AddMoreParticularsEmployeeModel()
                {
                    CrAmount       = 0,
                    DrAmountTotal  = TotalDebit,
                    CrAmountTotal  = TotalCredit,
                    DrAmount       = Dress,
                    DrOrCr         = 1,
                    JvType         = "JV",
                    Narration      = "",
                    Particulars    = Utility.GetAccHeadIDFromDescription("Dress Allowance"),
                    SubParticulars = 0,
                    DrOrCrName     = ""
                };
                model.ObjAddMoreParticularsEmployeeModel.AddMoreParticularsEmployeeModelList.Add(ObjModel);
            }
            if (Dearness > 0)
            {
                var ObjModel = new AddMoreParticularsEmployeeModel()
                {
                    CrAmount       = 0,
                    DrAmountTotal  = TotalDebit,
                    CrAmountTotal  = TotalCredit,
                    DrAmount       = Dearness,
                    DrOrCr         = 1,
                    JvType         = "JV",
                    Narration      = "",
                    Particulars    = Utility.GetAccHeadIDFromDescription("Dearness Allowance"),
                    SubParticulars = 0,
                    DrOrCrName     = ""
                };
                model.ObjAddMoreParticularsEmployeeModel.AddMoreParticularsEmployeeModelList.Add(ObjModel);
            }
            if (InsuranceDr > 0)
            {
                var ObjModel = new AddMoreParticularsEmployeeModel()
                {
                    CrAmount       = 0,
                    DrAmountTotal  = TotalDebit,
                    CrAmountTotal  = TotalCredit,
                    DrAmount       = InsuranceDr,
                    DrOrCr         = 1,
                    JvType         = "JV",
                    Narration      = "",
                    Particulars    = Utility.GetAccHeadIDFromDescription("InsuranceDR"),
                    SubParticulars = 0,
                    DrOrCrName     = ""
                };
                model.ObjAddMoreParticularsEmployeeModel.AddMoreParticularsEmployeeModelList.Add(ObjModel);
            }
            #endregion
            #region AssignToListCR
            if (SalaryPayable > 0)
            {
                var ObjModel = new AddMoreParticularsEmployeeModel()
                {
                    DrAmount       = 0,
                    DrAmountTotal  = TotalDebit,
                    CrAmountTotal  = TotalCredit,
                    CrAmount       = SalaryPayable,
                    DrOrCr         = 0,
                    JvType         = "JV",
                    Narration      = "",
                    Particulars    = model.BankAccHeadID,
                    SubParticulars = model.BankSubAccHeadID,
                    DrOrCrName     = ""
                };
                model.ObjAddMoreParticularsEmployeeModel.AddMoreParticularsEmployeeModelList.Add(ObjModel);
            }
            if (Advance > 0)
            {
                var ObjModel = new AddMoreParticularsEmployeeModel()
                {
                    DrAmount      = 0,
                    DrAmountTotal = TotalDebit,
                    CrAmountTotal = TotalCredit,
                    CrAmount      = Advance,
                    DrOrCr        = 0,
                    JvType        = "JV",
                    Narration     = "",
                    Particulars   = Utility.GetAccHeadIDFromDescription("Staff Advance"),
                    DrOrCrName    = ""
                };
                model.ObjAddMoreParticularsEmployeeModel.AddMoreParticularsEmployeeModelList.Add(ObjModel);
            }
            if (InsuranceCR > 0)
            {
                var ObjModel = new AddMoreParticularsEmployeeModel()
                {
                    DrAmount       = 0,
                    DrAmountTotal  = TotalDebit,
                    CrAmountTotal  = TotalCredit,
                    CrAmount       = InsuranceCR,
                    DrOrCr         = 0,
                    JvType         = "JV",
                    Narration      = "",
                    Particulars    = Utility.GetAccHeadIDFromDescription("InsuranceCR"),
                    SubParticulars = 0,
                    DrOrCrName     = ""
                };
                model.ObjAddMoreParticularsEmployeeModel.AddMoreParticularsEmployeeModelList.Add(ObjModel);
            }
            if (PfCR > 0)
            {
                var ObjModel = new AddMoreParticularsEmployeeModel()
                {
                    DrAmount       = 0,
                    DrAmountTotal  = TotalDebit,
                    CrAmountTotal  = TotalCredit,
                    CrAmount       = PfCR,
                    DrOrCr         = 0,
                    JvType         = "JV",
                    Narration      = "",
                    Particulars    = Utility.GetAccHeadIDFromDescription("PFDeduction"),
                    SubParticulars = 0,
                    DrOrCrName     = ""
                };
                model.ObjAddMoreParticularsEmployeeModel.AddMoreParticularsEmployeeModelList.Add(ObjModel);
            }
            if (CIT > 0)
            {
                var ObjModel = new AddMoreParticularsEmployeeModel()
                {
                    DrAmount       = 0,
                    DrAmountTotal  = TotalDebit,
                    CrAmountTotal  = TotalCredit,
                    CrAmount       = CIT,
                    DrOrCr         = 0,
                    JvType         = "JV",
                    Narration      = "",
                    Particulars    = Utility.GetAccHeadIDFromDescription("CIT"),
                    SubParticulars = 0,
                    DrOrCrName     = ""
                };
                model.ObjAddMoreParticularsEmployeeModel.AddMoreParticularsEmployeeModelList.Add(ObjModel);
            }
            if (Fund > 0)
            {
                var ObjModel = new AddMoreParticularsEmployeeModel()
                {
                    DrAmount       = 0,
                    DrAmountTotal  = TotalDebit,
                    CrAmountTotal  = TotalCredit,
                    CrAmount       = Fund,
                    DrOrCr         = 0,
                    JvType         = "JV",
                    Narration      = "",
                    Particulars    = Utility.GetAccHeadIDFromDescription("Proverty Alivation Fund"),
                    SubParticulars = 0,
                    DrOrCrName     = ""
                };
                model.ObjAddMoreParticularsEmployeeModel.AddMoreParticularsEmployeeModelList.Add(ObjModel);
            }
            if (SST > 0)
            {
                var ObjModel = new AddMoreParticularsEmployeeModel()
                {
                    DrAmount       = 0,
                    DrAmountTotal  = TotalDebit,
                    CrAmountTotal  = TotalCredit,
                    CrAmount       = SST,
                    DrOrCr         = 0,
                    JvType         = "JV",
                    Narration      = "",
                    Particulars    = Utility.GetAccHeadIDFromDescription("SST"),
                    SubParticulars = 0,
                    DrOrCrName     = ""
                };
                model.ObjAddMoreParticularsEmployeeModel.AddMoreParticularsEmployeeModelList.Add(ObjModel);
            }
            if (Tax > 0)
            {
                var ObjModel = new AddMoreParticularsEmployeeModel()
                {
                    DrAmount       = 0,
                    DrAmountTotal  = TotalDebit,
                    CrAmountTotal  = TotalCredit,
                    CrAmount       = Tax,
                    DrOrCr         = 0,
                    JvType         = "JV",
                    Narration      = "",
                    Particulars    = Utility.GetAccHeadIDFromDescription("Tax"),
                    SubParticulars = 0,
                    DrOrCrName     = ""
                };
                model.ObjAddMoreParticularsEmployeeModel.AddMoreParticularsEmployeeModelList.Add(ObjModel);
            }
            if (LoanDeduct > 0)
            {
                var ObjModel = new AddMoreParticularsEmployeeModel()
                {
                    DrAmount       = 0,
                    DrAmountTotal  = TotalDebit,
                    CrAmountTotal  = TotalCredit,
                    CrAmount       = LoanDeduct,
                    DrOrCr         = 0,
                    JvType         = "JV",
                    Narration      = "",
                    Particulars    = Utility.GetAccHeadIDFromDescription("LoanDeduction"),
                    SubParticulars = 0,
                    DrOrCrName     = ""
                };
                model.ObjAddMoreParticularsEmployeeModel.AddMoreParticularsEmployeeModelList.Add(ObjModel);
            }
            if (LoanInterest > 0)
            {
                var ObjModel = new AddMoreParticularsEmployeeModel()
                {
                    DrAmount       = 0,
                    DrAmountTotal  = TotalDebit,
                    CrAmountTotal  = TotalCredit,
                    CrAmount       = LoanInterest,
                    DrOrCr         = 0,
                    JvType         = "JV",
                    Narration      = "",
                    Particulars    = Utility.GetAccHeadIDFromDescription("LoanInterest"),
                    SubParticulars = 0,
                    DrOrCrName     = ""
                };
                model.ObjAddMoreParticularsEmployeeModel.AddMoreParticularsEmployeeModelList.Add(ObjModel);
            }
            if (LeaveDeduct > 0)
            {
                var ObjModel = new AddMoreParticularsEmployeeModel()
                {
                    DrAmount       = 0,
                    DrAmountTotal  = TotalDebit,
                    CrAmountTotal  = TotalCredit,
                    CrAmount       = LeaveDeduct,
                    DrOrCr         = 0,
                    JvType         = "JV",
                    Narration      = "",
                    Particulars    = Utility.GetAccHeadIDFromDescription("LeaveDeduction"),
                    SubParticulars = 0,
                    DrOrCrName     = ""
                };
                model.ObjAddMoreParticularsEmployeeModel.AddMoreParticularsEmployeeModelList.Add(ObjModel);
            }
            #endregion
            if (model.ObjAddMoreParticularsEmployeeModel.DrAmountTotal != 0)
            {
                if (model.ObjAddMoreParticularsEmployeeModel.DrAmountTotal == model.ObjAddMoreParticularsEmployeeModel.CrAmountTotal)
                {
                    i = pro.CreateNewJv(model);
                    return(RedirectToAction("ShowJournalVoucher", "JVMaster", new { id = i }));
                }
                else
                {
                    return(View(model));
                }
            }
            else
            {
                return(View(model));
            }
        }