public static string GetBulanData(BonusSambilanDetailModel data, int currentMonth) { string retString = string.Empty; switch (currentMonth) { case (1): retString = data.Jan.ToString(); break; case (2): retString = data.Feb.ToString(); break; case (3): retString = data.Mac.ToString(); break; case (4): retString = data.April.ToString(); break; case (5): retString = data.Mei.ToString(); break; case (6): retString = data.Jun.ToString(); break; case (7): retString = data.Julai.ToString(); break; case (8): retString = data.Ogos.ToString(); break; case (9): retString = data.September.ToString(); break; case (10): retString = data.Oktober.ToString(); break; case (11): retString = data.November.ToString(); break; case (12): retString = data.Disember.ToString(); break; default: retString = string.Empty; break; } return(retString); }
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 TambahBonus(string bulanBekerja, string bulanDibayar, string tahunDibayar, string bulanBekerjaHingga, string Command) { if (Command == "Tambah") { //TODO add to HR_BONUS_SAMBILAN_DETAIL ManageMessageId outputMsg = ManageMessageId.Tambah; HR_BONUS_SAMBILAN_DETAIL.UpdateTambahBonus(); return(RedirectToAction("UrusBonus", "PengurusanKakitanganSambilan", new { month = bulanDibayar, tahunbekerja = tahunDibayar, message = outputMsg })); } else if (Command == "Batal") { HR_BONUS_SAMBILAN_DETAIL.DeleteTambahBonus(); return(RedirectToAction("TambahBonus", new { month = bulanDibayar, year = tahunDibayar })); } else //preview ("Pratonton") { List <BonusSambilanDetailModel> bonus = new List <BonusSambilanDetailModel>(); ViewBag.MinBulan = 0; ViewBag.MaxBulan = 0; ViewBag.MaxTahun = 0; ViewBag.BulanBonus = 0; try { int startMonth = Convert.ToInt32(bulanBekerja); int endMonth = Convert.ToInt32(bulanBekerjaHingga); int month = Convert.ToInt32(bulanDibayar); int year = Convert.ToInt32(tahunDibayar); ViewBag.MinBulan = startMonth; ViewBag.MaxBulan = endMonth; ViewBag.BulanBonus = month; ViewBag.MaxTahun = year; bonus = BonusSambilanDetailModel.GetDetailsFromTransaksi(startMonth, month, year, endMonth); if (bonus.Count() > 0) { HR_BONUS_SAMBILAN_DETAIL.InsertTambahBonus(bonus); //add to database } } catch (Exception ex) { Console.Write(ex.ToString()); } return(View(bonus)); } }
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)); } }
private static void BindData(IWorkbook workbook, ISheet sheet1, BonusSambilanDetailModel data, int startrow, int monthStart, int monthDiff) { int columnStart = 0; ICellStyle alignCenter = BorderAlignCenter(workbook); IRow nRow = sheet1.CreateRow(startrow); for (int col = columnStart; col <= columnStart + 5; col++) { ICell nCell = nRow.CreateCell(col); nCell.CellStyle = alignCenter; if (col == columnStart) { nCell.SetCellValue(data.Nama); } else if (col == columnStart + 1) { nCell.SetCellValue(data.NoPekerja); } else if (col == columnStart + 2) { nCell.SetCellValue(data.NoKadPengenalan); } else if (col == columnStart + 3) { nCell.SetCellValue(data.NoAkaunBank); } else if (col == columnStart + 4) { nCell.SetCellValue(data.NoKWSP); } else if (col == columnStart + 5) { nCell.SetCellValue(data.TarikhLantikanString); } sheet1.AutoSizeColumn(col); } int currentMonth = monthStart; for (int jcol = columnStart + 6; jcol <= columnStart + 6 + monthDiff; jcol++) { ICell nCell = nRow.CreateCell(jcol); nCell.CellStyle = alignCenter; string bulanString = GetBulanData(data, currentMonth); nCell.SetCellValue(bulanString); currentMonth++; sheet1.AutoSizeColumn(jcol); } int colStart_monthDiff = columnStart + 6 + monthDiff; for (int kcol = colStart_monthDiff; kcol <= colStart_monthDiff + 3; kcol++) { ICell nCell = nRow.CreateCell(kcol); nCell.CellStyle = alignCenter; if (kcol == colStart_monthDiff) { nCell.SetCellValue(data.JumlahGaji.ToString()); } else if (kcol == colStart_monthDiff + 1) { nCell.SetCellValue(data.GajiPurata.ToString()); } else if (kcol == colStart_monthDiff + 2) { try { if (data.BonusDiterima != null) { //always show 2 dec places nCell.SetCellValue(data.BonusDiterima.Value.ToString("0.00")); } } catch { nCell.SetCellValue("0.00"); } } else if (kcol == colStart_monthDiff + 3) { nCell.SetCellValue(data.Catatan); } sheet1.AutoSizeColumn(kcol); } }