public static void UpdateMuktamad(int month, int year, string noPekerja)
{
ApplicationDbContext db = new ApplicationDbContext();
if (string.IsNullOrEmpty(noPekerja))
{
List <HR_BONUS_SAMBILAN_DETAIL> listd;
listd = db.HR_BONUS_SAMBILAN_DETAIL
.Where(x => x.HR_BULAN_BONUS == month &&
x.HR_TAHUN_BONUS == year).ToList();
foreach (HR_BONUS_SAMBILAN_DETAIL det in listd)
{
det.HR_MUKTAMAD = 1;
db.Entry(det).State = EntityState.Modified;
db.SaveChanges();
}
}
else
{
HR_BONUS_SAMBILAN_DETAIL det = db.HR_BONUS_SAMBILAN_DETAIL
.Where(x => x.HR_BULAN_BONUS == month &&
x.HR_TAHUN_BONUS == year &&
x.HR_NO_PEKERJA == noPekerja).FirstOrDefault();
det.HR_MUKTAMAD = 1;
db.Entry(det).State = EntityState.Modified;
db.SaveChanges();
}
}
public static void TestInsert()
{
ApplicationDbContext db = new ApplicationDbContext();
HR_BONUS_SAMBILAN_DETAIL det = new HR_BONUS_SAMBILAN_DETAIL();
det.HR_NO_PEKERJA = "01410";
det.HR_NO_KPBARU = "800615085334";
det.HR_BULAN_BONUS = 1;
det.HR_TAHUN_BONUS = 2018;
det.HR_JANUARI = 10;
det.HR_FEBRUARI = 20;
det.HR_MAC = 30;
det.HR_APRIL = 40;
det.HR_MEI = 50;
det.HR_JUN = 60;
det.HR_JULAI = 70;
det.HR_OGOS = 0;
det.HR_SEPTEMBER = 0;
det.HR_OKTOBER = 0;
det.HR_NOVEMBER = 0;
det.HR_DISEMBER = 0;
det.HR_CATATAN = string.Empty;
det.HR_MUKTAMAD = 0;
db.HR_BONUS_SAMBILAN_DETAIL.Add(det);
db.SaveChanges();
}
public static List <BonusSambilanDetailModel> GetBonusSambilanDetailData(int month, int year)
{
ApplicationDbContext db = new ApplicationDbContext();
List <HR_BONUS_SAMBILAN_DETAIL> tableList = HR_BONUS_SAMBILAN_DETAIL.GetBonusSambilanDetailData(month, year);
List <BonusSambilanDetailModel> outputList = new List <BonusSambilanDetailModel>();
foreach (HR_BONUS_SAMBILAN_DETAIL y in tableList)
{
BonusSambilanDetailModel d = new BonusSambilanDetailModel();
HR_MAKLUMAT_PERIBADI maklumat = db.HR_MAKLUMAT_PERIBADI
.Where(m => m.HR_NO_PEKERJA == y.HR_NO_PEKERJA).FirstOrDefault();
HR_MAKLUMAT_PEKERJAAN kerja = db.HR_MAKLUMAT_PEKERJAAN
.Where(m => m.HR_NO_PEKERJA == y.HR_NO_PEKERJA).FirstOrDefault();
d.BulanBonus = y.HR_BULAN_BONUS;
d.TahunBonus = y.HR_TAHUN_BONUS;
d.Nama = maklumat.HR_NAMA_PEKERJA;
d.NoPekerja = y.HR_NO_PEKERJA;
d.NoKadPengenalan = y.HR_NO_KPBARU;
d.NoAkaunBank = kerja.HR_NO_AKAUN_BANK;
d.NoKWSP = kerja.HR_NO_KWSP;
d.TarikhLantikan = kerja.HR_TARIKH_LANTIKAN;
d.Jan = y.HR_JANUARI;
d.Feb = y.HR_FEBRUARI;
d.Mac = y.HR_MAC;
d.April = y.HR_APRIL;
d.Mei = y.HR_MEI;
d.Jun = y.HR_JUN;
d.Julai = y.HR_JULAI;
d.Ogos = y.HR_OGOS;
d.September = y.HR_SEPTEMBER;
d.Oktober = y.HR_OKTOBER;
d.November = y.HR_NOVEMBER;
d.Disember = y.HR_DISEMBER;
d.JumlahGaji = y.HR_JUMLAH_GAJI;
d.GajiPurata = y.HR_GAJI_PURATA;
d.BonusDiterima = y.HR_BONUS_DITERIMA;
d.BonusLayak = y.HR_BONUS_LAYAK;
d.Catatan = y.HR_CATATAN;
d.MinBulan = y.HR_BULAN_START;
d.MaxBulan = y.HR_BULAN_END;
if (y.HR_MUKTAMAD > 0)
{
d.IsMuktamad = true;
}
else
{
d.IsMuktamad = false;
}
outputList.Add(d);
}
//sort by nama
outputList = outputList.OrderBy(x => x.Nama).ToList();
return(outputList);
}
public static void TestDelete()
{
ApplicationDbContext db = new ApplicationDbContext();
HR_BONUS_SAMBILAN_DETAIL det = db.HR_BONUS_SAMBILAN_DETAIL
.Where(x => x.HR_NO_PEKERJA == "01410" &&
x.HR_BULAN_BONUS == 1 &&
x.HR_TAHUN_BONUS == 2018).FirstOrDefault();
if (det != null)
{
db.Entry(det).State = EntityState.Deleted;
db.SaveChanges();
}
}
public static void UpdateCatatan(int month, int year, string noPekerja, string catatan)
{
ApplicationDbContext db = new ApplicationDbContext();
HR_BONUS_SAMBILAN_DETAIL det = db.HR_BONUS_SAMBILAN_DETAIL
.Where(x => x.HR_BULAN_BONUS == month &&
x.HR_TAHUN_BONUS == year &&
x.HR_NO_PEKERJA == noPekerja).FirstOrDefault();
if (det != null)
{
det.HR_CATATAN = catatan;
db.Entry(det).State = EntityState.Modified;
db.SaveChanges();
}
}
public static void UpdateBonusDiterima(int month, int year, string noPekerja, decimal bonus)
{
ApplicationDbContext db = new ApplicationDbContext();
HR_BONUS_SAMBILAN_DETAIL det = db.HR_BONUS_SAMBILAN_DETAIL
.Where(x => x.HR_BULAN_BONUS == month &&
x.HR_TAHUN_BONUS == year &&
x.HR_NO_PEKERJA == noPekerja).FirstOrDefault();
if (det != null)
{
det.HR_BONUS_DITERIMA = bonus;
db.Entry(det).State = EntityState.Modified;
db.SaveChanges();
}
}
public static void TestingUpdate()
{
ApplicationDbContext db = new ApplicationDbContext();
HR_BONUS_SAMBILAN_DETAIL det = db.HR_BONUS_SAMBILAN_DETAIL
.Where(x => x.HR_NO_PEKERJA == "01410" &&
x.HR_BULAN_BONUS == 1 &&
x.HR_TAHUN_BONUS == 2018).FirstOrDefault();
if (det != null)
{
det.HR_JUMLAH_GAJI = det.HR_JANUARI + det.HR_FEBRUARI + det.HR_MAC + det.HR_APRIL + det.HR_MEI + det.HR_JUN
+ det.HR_JULAI + det.HR_OGOS + det.HR_SEPTEMBER + det.HR_OKTOBER + det.HR_NOVEMBER + det.HR_DISEMBER;
det.HR_GAJI_PURATA = Decimal.Round((decimal)det.HR_JUMLAH_GAJI / 12, 3);
det.HR_CATATAN = "Ini Kiraan Yang Tepat";
det.HR_BONUS_DITERIMA = (decimal)12.00;
db.Entry(det).State = EntityState.Modified;
db.SaveChanges();
}
}
public static void InsertTambahBonus(List <BonusSambilanDetailModel> listBonus)
{
ApplicationDbContext db = new ApplicationDbContext();
foreach (BonusSambilanDetailModel bonus in listBonus)
{
string noPekerja = bonus.NoPekerja;
HR_BONUS_SAMBILAN_DETAIL det = db.HR_BONUS_SAMBILAN_DETAIL
.Where(x => x.HR_BULAN_BONUS == bonus.BulanBonus &&
x.HR_TAHUN_BONUS == bonus.TahunBonus &&
x.HR_NO_PEKERJA == bonus.NoPekerja).FirstOrDefault();
if (det == null)
{
det = new HR_BONUS_SAMBILAN_DETAIL
{
HR_NO_PEKERJA = bonus.NoPekerja,
HR_NO_KPBARU = bonus.NoKadPengenalan,
HR_TAHUN_BONUS = bonus.TahunBonus,
HR_BULAN_BONUS = bonus.BulanBonus,
HR_JANUARI = bonus.Jan,
HR_FEBRUARI = bonus.Feb,
HR_MAC = bonus.Mac,
HR_APRIL = bonus.April,
HR_MEI = bonus.Mei,
HR_JUN = bonus.Jun,
HR_JULAI = bonus.Julai,
HR_OGOS = bonus.Ogos,
HR_SEPTEMBER = bonus.September,
HR_OKTOBER = bonus.Oktober,
HR_NOVEMBER = bonus.November,
HR_DISEMBER = bonus.Disember,
HR_JUMLAH_GAJI = bonus.JumlahGaji,
HR_GAJI_PURATA = bonus.GajiPurata,
HR_BONUS_DITERIMA = bonus.BonusDiterima,
HR_CATATAN = bonus.Catatan,
HR_BULAN_START = bonus.MinBulan,
HR_BULAN_END = bonus.MaxBulan,
HR_MUKTAMAD = 0, //set tu belum muktamad
HR_STATUS = 0 //Not yet confirmed
};
db.HR_BONUS_SAMBILAN_DETAIL.Add(det);
db.SaveChanges();
}
else
{
det.HR_NO_PEKERJA = bonus.NoPekerja;
det.HR_NO_KPBARU = bonus.NoKadPengenalan;
det.HR_TAHUN_BONUS = bonus.TahunBonus;
det.HR_BULAN_BONUS = bonus.BulanBonus;
det.HR_JANUARI = bonus.Jan;
det.HR_FEBRUARI = bonus.Feb;
det.HR_MAC = bonus.Mac;
det.HR_APRIL = bonus.April;
det.HR_MEI = bonus.Mei;
det.HR_JUN = bonus.Jun;
det.HR_JULAI = bonus.Julai;
det.HR_OGOS = bonus.Ogos;
det.HR_SEPTEMBER = bonus.September;
det.HR_OKTOBER = bonus.Oktober;
det.HR_NOVEMBER = bonus.November;
det.HR_DISEMBER = bonus.Disember;
det.HR_JUMLAH_GAJI = bonus.JumlahGaji;
det.HR_GAJI_PURATA = bonus.GajiPurata;
det.HR_BONUS_DITERIMA = bonus.BonusDiterima;
det.HR_CATATAN = bonus.Catatan;
det.HR_BULAN_START = bonus.MinBulan;
det.HR_BULAN_END = bonus.MaxBulan;
det.HR_MUKTAMAD = 0; //set tu belum muktamad
det.HR_STATUS = 0; //Not yet confirmed
db.Entry(det).State = EntityState.Modified;
db.SaveChanges();
}
}
}
