public static IWorkbook GetReport(int bulan, int tahun)
{
IWorkbook workbook = new XSSFWorkbook();
List <BonusSambilanDetailModel> printData
= BonusSambilanDetailModel.GetBonusSambilanDetailData(bulan, tahun);
ISheet sheet1 = workbook.CreateSheet("Sheet 1");
int currentRow;
currentRow = SetBonusSambilanTitle(workbook, sheet1, printData, 0);
currentRow = SetBonusSambilanHeader(workbook, sheet1, printData, currentRow);
currentRow = SetBonusSambilanBody(workbook, sheet1, printData, currentRow);
return(workbook);
}
public ActionResult BonusSambilanDetail(string month, string year, ManageMessageId?message)
{
ViewBag.StatusMessage =
message == ManageMessageId.Tambah ? "Data Telah Berjaya Disimpan."
: message == ManageMessageId.Muktamad ? "Data Anda Telah Muktamad."
: message == ManageMessageId.Kemaskini ? "Data Telah Berjaya Dikemaskini."
: message == ManageMessageId.Error ? "Gagal Kemaskini/Tambah Data."
: "";
ViewBag.MinBulan = 0;
ViewBag.MaxBulan = 0;
ViewBag.MaxTahun = 0;
ViewBag.BulanBonus = 0;
List <BonusSambilanDetailModel> list = new List <BonusSambilanDetailModel>();
try
{
int monthInt = Convert.ToInt32(month);
int yearInt = Convert.ToInt32(year);
list = BonusSambilanDetailModel.GetBonusSambilanDetailData(monthInt, yearInt);
bool isMuktamad = list.Select(m => m.IsMuktamad).FirstOrDefault();
if (isMuktamad)
{
ViewBag.IsMuktamad = "true";
}
else
{
ViewBag.IsMuktamad = string.Empty;
}
ViewBag.MinBulan = list.Select(x => x.MinBulan).Min();
ViewBag.MaxBulan = monthInt;
ViewBag.MaxTahun = yearInt;
ViewBag.BulanBonus = monthInt;
}
catch
{
}
return(View(list));
}
public ActionResult TambahBonus(string tahunDibayar, string month = "1", string year = "0",
string isTemp = "")
{
List <BonusSambilanDetailModel> bonus = new List <BonusSambilanDetailModel>();
if (isTemp != "yes")
{
return(View(bonus));
}
else
{
int monthInt = Convert.ToInt32(month);
int yearInt = Convert.ToInt32(year);
bonus = BonusSambilanDetailModel.GetBonusSambilanDetailData(monthInt, yearInt);
int startMonth = bonus.Select(x => x.MinBulan).FirstOrDefault();
int endMonth = bonus.Select(x => x.MaxBulan).FirstOrDefault();
ViewBag.MinBulan = startMonth;
ViewBag.MaxBulan = endMonth;
ViewBag.MaxTahun = yearInt;
return(View(bonus));
}
}
