// GET: OverallPayrollSheet
public ActionResult Index()
{
int EmpCode = Convert.ToInt32(Session["Empcode"]);
int fyid = Convert.ToInt32(Request["fyId"]);
int officeId = Convert.ToInt32(Request["officeId"]);
if (fyid == 0)
{
fyid = _fiscalService.GetCurrentFyId();
}
if (officeId == 0)
{
officeId = Convert.ToInt32(Session["OfficeId"]);
}
ViewBag.fsId = fyid;
ViewBag.officeId = officeId;
IEnumerable <PayrollSalaryViewModel> ViewList = _PayrollGenerationService.GetYearlyPayrollSalaryTable(fyid, officeId);
ViewBag.FiscalsDropdown = _fiscalService.GetFiscalDropDown();
ViewBag.OfficeList = _officeService.GetClildOfficeListByEmpCode(EmpCode);
return(View(ViewList));
}
// GET: AttendancyEntireYear
public ActionResult Index()
{
int EmpCode = Convert.ToInt32(Session["EmpCode"]);
int FiscalYear = Convert.ToInt32(Request["fyId"]);
if (FiscalYear == 0)
{
FiscalYear = _fiscalService.GetCurrentFyId();
}
ViewBag.fsId = FiscalYear;
ViewBag.FiscalsDropdown = _fiscalService.GetFiscalDropDown();
EmployeeEditViewModel EmpDetails = _employeeServices.GetEmployeeByID(EmpCode);
ViewBag.EmpDetails = EmpDetails;
AttendanceEntireYearViewModel record = _reportServices.AttendanceEntireYearReport(EmpCode, FiscalYear, 4);
ViewBag.FirstMonthSummary = _reportServices.AttendanceEntireYearReportSummary(EmpCode, FiscalYear, 4);
ViewBag.SecondMonth = _reportServices.AttendanceEntireYearReport(EmpCode, FiscalYear, 5);
ViewBag.SecondMonthSummary = _reportServices.AttendanceEntireYearReportSummary(EmpCode, FiscalYear, 5);
ViewBag.ThirdMonth = _reportServices.AttendanceEntireYearReport(EmpCode, FiscalYear, 6);
ViewBag.ThirdMonthSummary = _reportServices.AttendanceEntireYearReportSummary(EmpCode, FiscalYear, 6);
ViewBag.FourthMonth = _reportServices.AttendanceEntireYearReport(EmpCode, FiscalYear, 7);
ViewBag.FourthMonthSummary = _reportServices.AttendanceEntireYearReportSummary(EmpCode, FiscalYear, 7);
ViewBag.FivethMonth = _reportServices.AttendanceEntireYearReport(EmpCode, FiscalYear, 8);
ViewBag.FivethMonthSummary = _reportServices.AttendanceEntireYearReportSummary(EmpCode, FiscalYear, 8);
ViewBag.SixthMonth = _reportServices.AttendanceEntireYearReport(EmpCode, FiscalYear, 9);
ViewBag.SisthMonthSummary = _reportServices.AttendanceEntireYearReportSummary(EmpCode, FiscalYear, 9);
ViewBag.SeventhMonth = _reportServices.AttendanceEntireYearReport(EmpCode, FiscalYear, 10);
ViewBag.SeventhMonthSummary = _reportServices.AttendanceEntireYearReportSummary(EmpCode, FiscalYear, 10);
ViewBag.EightthMonth = _reportServices.AttendanceEntireYearReport(EmpCode, FiscalYear, 11);
ViewBag.EightthMonthSummary = _reportServices.AttendanceEntireYearReportSummary(EmpCode, FiscalYear, 11);
ViewBag.NinethMonth = _reportServices.AttendanceEntireYearReport(EmpCode, FiscalYear, 12);
ViewBag.NinethMonthSummary = _reportServices.AttendanceEntireYearReportSummary(EmpCode, FiscalYear, 12);
ViewBag.TenthMonth = _reportServices.AttendanceEntireYearReport(EmpCode, FiscalYear, 1);
ViewBag.TenthMonthSummary = _reportServices.AttendanceEntireYearReportSummary(EmpCode, FiscalYear, 1);
ViewBag.EleventhMonth = _reportServices.AttendanceEntireYearReport(EmpCode, FiscalYear, 2);
ViewBag.EleventMonthSummary = _reportServices.AttendanceEntireYearReportSummary(EmpCode, FiscalYear, 2);
ViewBag.TwelevethMonth = _reportServices.AttendanceEntireYearReport(EmpCode, FiscalYear, 3);
ViewBag.TwelevethMonthSummary = _reportServices.AttendanceEntireYearReportSummary(EmpCode, FiscalYear, 3);
return(View("../AttendanceReport/MyYearlyAttendance", record));
}
public ActionResult Index()
{
decimal totalRankandGradesalary = 0;
decimal totalRankAllowances = 0;
decimal totalAllowances = 0;
decimal totalGrossSalary = 0;
decimal totalpfcompany = 0;
decimal totalpfself = 0;
decimal totalpfExtra = 0;
decimal totalpf = 0;
decimal totalcit = 0;
decimal totaltax = 0;
decimal totalcashinhand = 0;
ViewBag.FiscalsDropdown = _fiscalService.GetFiscalDropDown();
int EmpCode = Convert.ToInt32(Session["Empcode"]);
int fyid = Convert.ToInt32(Request["fyId"]);
int officeId = Convert.ToInt32(Session["OfficeId"]);
if (fyid == 0)
{
fyid = _fiscalService.GetCurrentFyId();
}
if (officeId == 0)
{
officeId = Convert.ToInt32(Session["OfficeId"]);
}
ViewBag.fsId = fyid;
ViewBag.officeId = officeId;
List <MyPayrollSalaryTableDTO> MyPayroll = new List <MyPayrollSalaryTableDTO>();
IEnumerable <PayrollSalaryTableDTO> ViewList = _PayrollGenerationService.GetMyPayrollSalaryTable(fyid, officeId).Where(a => a.SalaryConfirmed == true).ToList();
foreach (var data in ViewList)
{
IEnumerable <PayrollSalaryMasterSheetDTO> view = _PayrollGenerationService.GetPayrollSalaryMasterSheet(data.Id);
PayrollSalaryMasterSheetDTO singledata = view.Where(a => a.EmployeeCode == EmpCode).FirstOrDefault();
if (singledata != null)
{
MyPayrollSalaryTableDTO singles = new MyPayrollSalaryTableDTO()
{
Id = singledata.Id,
PayrollMonth = data.PayrollMonthDescription.MonthNameNepali,
FyId = data.Fiscal.FyName,
PfSelf = singledata.PfSelf,
PfCompany = singledata.PfCompany,
PfExtra = singledata.PfExtra,
PF = singledata.PfSelf + singledata.PfCompany + singledata.PfExtra,
CIT = singledata.CitAmount,
Tax = singledata.TaxAmount,
GrossSalary = singledata.GrossSalary,
CashInHand = singledata.SalaryAfterTaxDeduction,
RankAndGradeSalary = singledata.RankAndGradeSalary,
RankAllowances = singledata.RankOtherAllowances,
TotalAllowances = singledata.TotalRankAllowances,
};
totalRankandGradesalary += singledata.RankAndGradeSalary;
totalRankAllowances += singledata.RankOtherAllowances;
totalAllowances += singledata.TotalRankAllowances;
totalpfself += singledata.PfSelf;
totalpfcompany += singledata.PfCompany;
totalpfExtra += singledata.PfExtra;
totalpf += singles.PF;
totalcit = singledata.CitAmount;
totaltax += singledata.TaxAmount;
totalGrossSalary += singledata.GrossSalary;
totalcashinhand += singledata.SalaryAfterTaxDeduction;
MyPayroll.Add(singles);
}
}
ViewBag.TotalRankAndGradeSalary = totalRankandGradesalary.ToString("0.00");
ViewBag.TotalRankAllowances = totalRankAllowances.ToString("0.00");
ViewBag.TotalAllowances = totalAllowances.ToString("0.00");
ViewBag.TotalPFSelf = totalpfself.ToString("0.00");
ViewBag.TotalPFCompany = totalpfcompany.ToString("0.00");
ViewBag.TotalPfExtra = totalpfExtra.ToString("0.00");
ViewBag.TotalPf = totalpf.ToString("0.00");
ViewBag.TotalCit = totalcit.ToString("0.00");
ViewBag.TotalTax = totaltax.ToString("0.00");
ViewBag.TotalGrossSalary = totalGrossSalary.ToString("0.00");
ViewBag.TotalCashInHand = totalcashinhand.ToString("0.00");
return(View("../Payroll/MyPayroll/Index", MyPayroll));
}