public ActionResult GenerateBankPay(SetupEmployeeMasterModel model) { SetupEmployeeMasterProviders prop = new SetupEmployeeMasterProviders(); if (string.IsNullOrEmpty(model.YearId.ToString())) { model.YearId = 0; } if (string.IsNullOrEmpty(model.MonthId.ToString())) { model.MonthId = 0; } model.SetupEmployeeMasterModelList = prop.GetDetailOfSalaryPayable(model.YearId, model.MonthId, model.EmployeeMasterId); int i = 0; if (model.SetupEmployeeMasterModelList.Count > 0) { i = prop.CreateSalaryPaidJv(model); if (i > 0) { return(RedirectToAction("ShowJournalVoucher", "JVMaster", new { id = i })); } else { return(View(model)); } } return(View(model)); }
public ActionResult EmployeePayrollMaster(int id) { SetupEmployeeMasterProviders prov = new SetupEmployeeMasterProviders(); SetupEmployeeMasterModel model = new SetupEmployeeMasterModel(); if (GetPayrollCount(id) == false) { return(RedirectToAction("Index", new { string.Empty, message = "Employee Payroll Already Created. Please Edit Payroll !!" })); } int designation = HospitalManagementSystem.Utility.GetDesignationOfEmployeeByID(id); model.SetupEmployeeMasterModelList = prov.GetDesignationDetail(designation); foreach (var item in model.SetupEmployeeMasterModelList) { model.BasicSalary = item.BasicSalary; model.GradeRate = item.GradeRate; model.CITAmount = item.CITAmount; model.CITPercentage = item.CITPercentage; } model.SetupEmployeeMasterModelList = prov.GetDesignationDetail(designation); foreach (var item in model.SetupEmployeeMasterModelList) { model.BasicSalary = item.BasicSalary; model.GradeRate = item.GradeRate; model.CITAmount = item.CITAmount; model.CITPercentage = item.CITPercentage; } model.EmployeeMasterId = id; return(View("EmployeePayrollMaster", model)); }
public ActionResult ResignationDetail(int id) { SetupEmployeeMasterModel model = new SetupEmployeeMasterModel(); model.EmployeeMasterId = id; return(View("ResignationDetail", model)); }
public ActionResult FundDeductionEdit(int id) { SetupEmployeeMasterModel model = new SetupEmployeeMasterModel(); SetupEmployeeMasterProviders SEMPro = new SetupEmployeeMasterProviders(); model = SEMPro.GetEmployeeFundDeductionSetup().Where(x => x.id == id).FirstOrDefault(); return(View(model)); }
public ActionResult Edit(int id) { SetupEmployeeMasterModel model = new SetupEmployeeMasterModel(); SetupEmployeeMasterProviders SEMPro = new SetupEmployeeMasterProviders(); model = SEMPro.GetList().Where(x => x.EmployeeMasterId == id).FirstOrDefault(); model.EmployeeEducationInfoList = SEMPro.GetEmployeeEducationInfo().Where(x => x.EmployeeMasterId == id).ToList(); model.EmployeeTrainingInfoList = SEMPro.GetEmployeeTrainingInfo().Where(x => x.EmployeeMasterId == id).ToList(); model.EmployeeMasterId = id; return(View(model)); }
public ActionResult EditEmployeePayrollMaster(int id, SetupEmployeeMasterModel model) { SetupEmployeeMasterProviders SEMPro = new SetupEmployeeMasterProviders(); int i = SEMPro.UpdatePayroll(model); if (i != 0) { TempData["success"] = UtilityMessage.edit; return(RedirectToAction("Index")); } return(View(model)); }
public ActionResult ResignationDetail(SetupEmployeeMasterModel model) { SetupEmployeeMasterProviders SEMPro = new SetupEmployeeMasterProviders(); int i = SEMPro.InsertResignationDetail(model); if (i != 0) { return(RedirectToAction("Index")); } else { return(RedirectToAction("Index")); } }
public ActionResult EditEmployeePayrollMaster(int id) { SetupEmployeeMasterModel model = new SetupEmployeeMasterModel(); SetupEmployeeMasterProviders SEMPro = new SetupEmployeeMasterProviders(); if (GetPayrollCount(id) == true) { return(RedirectToAction("Index", new { string.Empty, message = "Employee Payroll Not Created. Please Create Payroll First!!" })); } model = SEMPro.GetEmployeePayrollMaster().Where(x => x.EmployeeMasterId == id).FirstOrDefault(); model.EmployeeAllowanceSetupModelList = SEMPro.GetEmployeeAllowanceInfo().Where(x => x.EmployeeMasterId == id).ToList(); model.EmployeeDeductionSetupModelList = SEMPro.GetEmployeeDeductionInfo().Where(x => x.EmployeeMasterId == id).ToList(); model.EmployeeMasterId = id; return(View(model)); }
public ActionResult EmployeePayrollMaster(SetupEmployeeMasterModel model) { SetupEmployeeMasterProviders SEMPro = new SetupEmployeeMasterProviders(); int i = SEMPro.InsertPayroll(model); if (i != 0) { TempData["success"] = HospitalManagementSystem.UtilityMessage.save; return(RedirectToAction("Index")); } else { TempData["success"] = HospitalManagementSystem.UtilityMessage.savefailed; return(RedirectToAction("Index")); } }
public ActionResult FundDeductionEdit(SetupEmployeeMasterModel model) { SetupEmployeeMasterProviders SEMPro = new SetupEmployeeMasterProviders(); int i = SEMPro.UpdateFundDeductionSetup(model); if (i != 0) { TempData["success"] = HospitalManagementSystem.UtilityMessage.save; return(RedirectToAction("FundDeductionIndex")); } else { TempData["success"] = HospitalManagementSystem.UtilityMessage.savefailed; return(RedirectToAction("FundDeductionIndex")); } }
public ActionResult Edit(int id, SetupEmployeeMasterModel model) { SetupEmployeeMasterProviders SEMPro = new SetupEmployeeMasterProviders(); if (ModelState.IsValid) { int i = SEMPro.Update(model); if (i != 0) { TempData["success"] = UtilityMessage.edit; return(RedirectToAction("Index")); } else { TempData["success"] = UtilityMessage.edit; return(RedirectToAction("Index")); } } return(View(model)); }
public ActionResult Create(SetupEmployeeMasterModel model) { SetupEmployeeMasterProviders SEMPro = new SetupEmployeeMasterProviders(); if (ModelState.IsValid) { int i = SEMPro.Insert(model); if (i != 0) { TempData["success"] = HospitalManagementSystem.UtilityMessage.save; return(RedirectToAction("Index")); } else { TempData["success"] = HospitalManagementSystem.UtilityMessage.savefailed; return(RedirectToAction("Index")); } } return(View()); }
public ActionResult FundDeductionIndex(string searchString, string message) { string searchWords = searchString; if (message != null) { ViewBag.SaruMessage = message; } else { ViewBag.SaruMessage = ""; } SetupEmployeeMasterModel model = new SetupEmployeeMasterModel(); SetupEmployeeMasterProviders SEMPro = new SetupEmployeeMasterProviders(); model.SetupEmployeeMasterModelList = SEMPro.GetFundDeductionList(); if (!String.IsNullOrEmpty(searchWords)) { model.SetupEmployeeMasterModelList = SEMPro.GetFundDeductionListBySearchWord(searchWords); } return(View(model)); }
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)); }
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)); } }
public ActionResult Create() { SetupEmployeeMasterModel model = new SetupEmployeeMasterModel(); return(View(model)); }
public ActionResult FundDeductionSetup() { SetupEmployeeMasterModel model = new SetupEmployeeMasterModel(); return(View(model)); }
public ActionResult GenerateSalarySheet() { SetupEmployeeMasterModel model = new SetupEmployeeMasterModel(); return(View(model)); }
public ActionResult BankSalaryReport() { SetupEmployeeMasterModel model = new SetupEmployeeMasterModel(); return(View(model)); }
public ActionResult BankSalaryReport(SetupEmployeeMasterModel model) { SetupEmployeeMasterProviders SProv = new SetupEmployeeMasterProviders(); return(PartialView("_BankSalaryReport", model)); }