public static Boolean Editproyek(Riwayat_Proyek proyek) { try { Riwayat_Proyek dep; using (DataContext db = new DataContext()) { dep = db.Riwayat_Proyek.Where(d => d.id == proyek.id).First(); dep.modified_by = proyek.modified_by; dep.modified_on = DateTime.Now; dep.start_month = proyek.start_month; dep.start_year = proyek.start_year; dep.project_name = proyek.project_name; dep.project_duration = proyek.project_duration; dep.time_period_id = proyek.time_period_id; dep.client = proyek.client; dep.project_position = proyek.project_position; dep.description = proyek.description; db.Entry(dep).State = System.Data.Entity.EntityState.Modified; db.SaveChanges(); } return(true); } catch (Exception) { return(false); } }
public static Riwayat_Proyek GetByID(int ID) { Riwayat_Proyek proyek = new Riwayat_Proyek(); using (DataContext db = new DataContext()) { proyek = db.Riwayat_Proyek.Where(d => d.id == ID).First(); return(proyek); } }
public ActionResult Save(Riwayat_Proyek proyek) { proyek.created_by = Convert.ToInt64(Session["foo"]); if (ProyekRepo.Createproyek(proyek)) { return(Json(new { Simpan = "Berhasil" }, JsonRequestBehavior.AllowGet)); } else { return(Json(new { Simpan = "Gagal" }, JsonRequestBehavior.AllowGet)); } }
public ActionResult Delete(int ID, Riwayat_Proyek proyekmdl) { proyekmdl.deleted_by = Convert.ToInt64(Session["foo"]); if (ProyekRepo.Deleteproyek(ID, proyekmdl)) //non static if ( KeahlianRepo.Deletekeahlian(ID)) { return(Json(new { Hapus = "Berhasil" }, JsonRequestBehavior.AllowGet)); } else { return(Json(new { Hapus = "Gagal" }, JsonRequestBehavior.AllowGet)); } }
public ActionResult EditSimpan(Riwayat_Proyek proyek) { proyek.modified_by = Convert.ToInt64(Session["foo"]); if (ProyekRepo.Editproyek(proyek)) { return(Json(new { EditSimpan = "Berhasil" }, JsonRequestBehavior.AllowGet)); //return json digunakan untuk memunculkan alert } else { return(Json(new { EditSimpan = "Gagal" }, JsonRequestBehavior.AllowGet)); } }
public static Boolean Createproyek(Riwayat_Proyek proyekmdl) { try { using (DataContext db = new DataContext()) { proyekmdl.created_by = proyekmdl.created_by; proyekmdl.created_on = DateTime.Now; db.Riwayat_Proyek.Add(proyekmdl); db.SaveChanges(); } return(true); } catch (Exception) { return(false); } }
public static Boolean Deleteproyek(int ID, Riwayat_Proyek proyekmdl) { try { Riwayat_Proyek dep; using (DataContext db = new DataContext()) { dep = db.Riwayat_Proyek.Where(d => d.id == ID).First(); dep.is_delete = true; dep.deleted_by = proyekmdl.deleted_by; dep.deleted_on = DateTime.Now; db.Entry(dep).State = System.Data.Entity.EntityState.Modified; db.SaveChanges(); } return(true); } catch (Exception) { return(false); } }