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 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 DeleteFundDeductionSetup(int id)
{
SetupEmployeeMasterProviders SEMPro = new SetupEmployeeMasterProviders();
int i = SEMPro.DeleteFundDeduction(id);
if (i != 0)
{
TempData["success"] = UtilityMessage.delete;
}
else
{
TempData["success"] = UtilityMessage.deletefailed;
}
return(RedirectToAction("FundDeductionIndex"));
}
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 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 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 BankSalaryReport(SetupEmployeeMasterModel model)
{
SetupEmployeeMasterProviders SProv = new SetupEmployeeMasterProviders();
return(PartialView("_BankSalaryReport", model));
}