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