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)); } }