public static Keahlian GetByID(int ID) { Keahlian keahlian = new Keahlian(); using (DataContext db = new DataContext()) { keahlian = db.Keahlian.Where(d => d.id == ID).First(); return(keahlian); } }
public ActionResult EditSimpan(Keahlian keahlian) { keahlian.modified_by = Convert.ToInt64(Session["foo"]); if (KeahlianRepo.Editkeahlian(keahlian)) { return(Json(new { EditSimpan = "Berhasil" }, JsonRequestBehavior.AllowGet)); //return json digunakan untuk memunculkan alert } else { return(Json(new { EditSimpan = "Gagal" }, JsonRequestBehavior.AllowGet)); } }
public ActionResult Delete(int ID, Keahlian keahlianmdl) { keahlianmdl.deleted_by = Convert.ToInt64(Session["foo"]); if (KeahlianRepo.Deletekeahlian(ID, keahlianmdl)) //non static if ( KeahlianRepo.Deletekeahlian(ID)) { return(Json(new { Hapus = "Berhasil" }, JsonRequestBehavior.AllowGet)); } else { return(Json(new { Hapus = "Gagal" }, JsonRequestBehavior.AllowGet)); } }
public ActionResult Save(Keahlian keahlian) { keahlian.created_by = Convert.ToInt64(Session["foo"]); if (KeahlianRepo.Createkeahlian(keahlian)) { return(Json(new { Simpan = "Berhasil" }, JsonRequestBehavior.AllowGet)); } else { return(Json(new { Simpan = "Gagal" }, JsonRequestBehavior.AllowGet)); } }
public static Boolean Deletekeahlian(int ID, Keahlian keahlianmdl) { try { Keahlian dep; using (DataContext db = new DataContext()) { dep = db.Keahlian.Where(d => d.id == ID).First(); dep.is_delete = true; dep.deleted_by = keahlianmdl.deleted_by; dep.deleted_on = DateTime.Now.Date; db.Entry(dep).State = System.Data.Entity.EntityState.Modified; db.SaveChanges(); } return(true); } catch (Exception) { return(false); } }
public static Boolean Createkeahlian(Keahlian keahlianmdl) { try { Keahlian keahlian = new Keahlian(); using (DataContext db = new DataContext()) { keahlian.biodata_id = 1; keahlian.created_by = keahlianmdl.created_by; keahlian.created_on = DateTime.Now.Date; keahlian.skill_name = keahlianmdl.skill_name; keahlian.skill_level_id = keahlianmdl.skill_level_id; keahlian.notes = keahlianmdl.notes; db.Keahlian.Add(keahlian); db.SaveChanges(); } return(true); } catch (Exception) { return(false); } }
public static Boolean Editkeahlian(Keahlian keahlian) { try { Keahlian dep; using (DataContext db = new DataContext()) { dep = db.Keahlian.Where(d => d.id == keahlian.id).First(); dep.modified_by = keahlian.modified_by; dep.modified_on = DateTime.Now.Date; dep.notes = keahlian.notes; dep.skill_level_id = keahlian.skill_level_id; dep.skill_name = keahlian.skill_name; db.Entry(dep).State = System.Data.Entity.EntityState.Modified; db.SaveChanges(); } return(true); } catch (Exception) { return(false); } }