public ActionResult DeleteConfirmed(HR_JADUAL_GAJI jadual)
{
jadual = db.HR_JADUAL_GAJI.SingleOrDefault(s => s.HR_SISTEM_SARAAN == jadual.HR_SISTEM_SARAAN && s.HR_GRED_GAJI == jadual.HR_GRED_GAJI && s.HR_PERINGKAT == jadual.HR_PERINGKAT);
db.HR_JADUAL_GAJI.Remove(jadual);
db.SaveChanges();
return(RedirectToAction("SenaraiGaji"));
}
public ActionResult EditJadual([Bind(Include = "HR_SISTEM_SARAAN, HR_GRED_GAJI, HR_PERINGKAT, HR_GAJI_POKOK, HR_GAJI_MIN, HR_GAJI_MAX, HR_RM_KENAIKAN, HR_PERATUS_KENAIKAN, HR_KOD_GAJI, HR_AKTIF_IND, HR_KANAN_IND")] HR_JADUAL_GAJI jadual)
{
if (ModelState.IsValid)
{
db.Entry(jadual).State = EntityState.Modified;
db.SaveChanges();
return(RedirectToAction("SenaraiGaji"));
}
return(View(jadual));
}
public JsonResult CariMatrik(string peringkat, string gred)
{
db.Configuration.ProxyCreationEnabled = false;
HR_JADUAL_GAJI item = db.HR_JADUAL_GAJI.SingleOrDefault(s => s.HR_GRED_GAJI == gred && s.HR_PERINGKAT == "P" + peringkat);
if (item == null)
{
item = new HR_JADUAL_GAJI();
}
return(Json(item, JsonRequestBehavior.AllowGet));
}
public ActionResult TambahJadual([Bind(Include = "HR_SISTEM_SARAAN, HR_GRED_GAJI, HR_PERINGKAT, HR_GAJI_POKOK, HR_GAJI_MIN, HR_GAJI_MAX, HR_RM_KENAIKAN, HR_PERATUS_KENAIKAN, HR_KOD_GAJI, HR_AKTIF_IND, HR_KANAN_IND")] HR_JADUAL_GAJI jadual)
{
if (ModelState.IsValid)
{
List <HR_JADUAL_GAJI> selectJadual = db.HR_JADUAL_GAJI.Where(s => s.HR_SISTEM_SARAAN == jadual.HR_SISTEM_SARAAN && s.HR_GRED_GAJI == jadual.HR_GRED_GAJI && s.HR_PERINGKAT == jadual.HR_PERINGKAT).ToList();
if (selectJadual.Count() <= 0)
{
db.HR_JADUAL_GAJI.Add(jadual);
db.SaveChanges();
}
ViewBag.HR_GRED_GAJI = new SelectList(db2.GE_PARAMTABLE.Where(s => s.GROUPID == 109), "SHORT_DESCRIPTION", "SHORT_DESCRIPTION");
return(RedirectToAction("Index"));
}
return(View());
}
public ActionResult PadamJadual(string saraan, string gaji, string peringkat)
{
if (saraan == null || gaji == null || peringkat == null)
{
return(new HttpStatusCodeResult(HttpStatusCode.BadRequest));
}
HR_JADUAL_GAJI jadual = db.HR_JADUAL_GAJI.SingleOrDefault(s => s.HR_SISTEM_SARAAN == saraan && s.HR_GRED_GAJI == gaji && s.HR_PERINGKAT == peringkat);
if (jadual == null)
{
return(HttpNotFound());
}
ViewBag.HR_PERINGKAT = new SelectList(db.HR_JADUAL_GAJI.GroupBy(c => c.HR_PERINGKAT).Select(c => c.FirstOrDefault()).OrderBy(c => c.HR_PERINGKAT), "HR_GRED_GAJI", "HR_PERINGKAT");
ViewBag.HR_GRED_GAJI = new SelectList(db2.GE_PARAMTABLE.Where(s => s.GROUPID == 109 && s.STRING_PARAM == "SSM"), "ORDINAL", "SHORT_DESCRIPTION");
return(PartialView("_PadamJadual", jadual));
}
public ActionResult TambahJadual([Bind(Include = "HR_SISTEM_SARAAN, HR_GRED_GAJI, HR_PERINGKAT, HR_GAJI_POKOK, HR_GAJI_MIN, HR_GAJI_MAX, HR_RM_KENAIKAN, HR_PERATUS_KENAIKAN, HR_KOD_GAJI, HR_AKTIF_IND, HR_KANAN_IND")] HR_JADUAL_GAJI jadual)
{
if (ModelState.IsValid)
{
var selectJadual = db.HR_JADUAL_GAJI.Where(s => s.HR_GRED_GAJI == jadual.HR_GRED_GAJI).Count(); //selectandgroupby
//var SelectLastID = db.HR_JADUAL_GAJI.GroupBy(s=> s.HR_PERINGKAT ).Select(c => c.FirstOrDefault()).Count();
var Increment = selectJadual + 1;
jadual.HR_PERINGKAT = "P" + Increment;
db.HR_JADUAL_GAJI.Add(jadual);
db.SaveChanges();
return(RedirectToAction("SenaraiGaji"));
}
ViewBag.HR_GRED_GAJI = new SelectList(db2.GE_PARAMTABLE.Where(s => s.GROUPID == 109), "SHORT_DESCRIPTION", "SHORT_DESCRIPTION");
return(View());
}
