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