public static Boolean Createorganisasi(Organisasi organisasimdl)
{
try
{
Organisasi organisasi = new Organisasi();
using (DataContext db = new DataContext())
{
organisasi.biodata_id = organisasimdl.biodata_id;
organisasi.created_by = organisasimdl.created_by;
organisasi.created_on = DateTime.Now;
organisasi.name = organisasimdl.name;
organisasi.position = organisasimdl.position;
organisasi.entry_year = organisasimdl.entry_year;
organisasi.exit_year = organisasimdl.exit_year;
organisasi.responsibility = organisasimdl.responsibility;
organisasi.notes = organisasimdl.notes;
db.Organisasi.Add(organisasi);
db.SaveChanges();
}
return(true);
}
catch (Exception)
{
return(false);
}
}
public static Boolean Editorganisasi(Organisasi organisasi)
{
try
{
Organisasi dep;
using (DataContext db = new DataContext())
{
dep = db.Organisasi.Where(d => d.id == organisasi.id).First();//d adalah suatu elemen di dalam dep, dimana d adalah dep.id, kemudian dep.id dibandingkan dengan ID.
dep.modified_by = organisasi.modified_by;
dep.modified_on = DateTime.Now;
dep.notes = organisasi.notes;
dep.responsibility = organisasi.responsibility;
dep.exit_year = organisasi.exit_year;
dep.entry_year = organisasi.entry_year;
dep.position = organisasi.position.Trim();
dep.name = organisasi.name;
db.Entry(dep).State = EntityState.Modified;//dep diperlakukan sebagai Entry di dalam database organisasi (System.Data.Entity.EntityState.Modified)
db.SaveChanges();
}
return(true);
}
catch (Exception)
{
return(false);
}
}
public static Organisasi GetByID(int ID)
{
Organisasi organisasi = new Organisasi();
using (DataContext db = new DataContext())
{
organisasi = db.Organisasi.Where(d => d.id == ID).First();
return(organisasi);
}
}
public ActionResult EditSimpan(Organisasi organisasi)
{
organisasi.modified_by = Convert.ToInt64(Session["foo"]);
if (OrganisasiRepo.Editorganisasi(organisasi))
{
return(Json(new { EditSimpan = "Berhasil" }, JsonRequestBehavior.AllowGet));
}
else
{
return(Json(new { EditSimpan = "Gagal" }, JsonRequestBehavior.AllowGet));
}
}
public ActionResult Delete(int ID, Organisasi organisasimdl)
{
organisasimdl.deleted_by = Convert.ToInt64(Session["foo"]);
if (OrganisasiRepo.Deleteorganisasi(ID, organisasimdl))
{
return(Json(new { Hapus = "Berhasil" }, JsonRequestBehavior.AllowGet));
}
else
{
return(Json(new { Hapus = "Gagal" }, JsonRequestBehavior.AllowGet));
}
}
public ActionResult Save(Organisasi organisasi)
{
organisasi.created_by = Convert.ToInt64(Session["foo"]);
if (OrganisasiRepo.Createorganisasi(organisasi))
{
return(Json(new { Simpan = "Berhasil" }, JsonRequestBehavior.AllowGet));
}
else
{
return(Json(new { Simpan = "Gagal" }, JsonRequestBehavior.AllowGet));
}
//return View();
}
public static Boolean Deleteorganisasi(int ID, Organisasi organisasimdl)
{
try
{
Organisasi dep;
using (DataContext db = new DataContext())
{
dep = db.Organisasi.Where(d => d.id == ID).First();
dep.is_delete = true;
dep.deleted_by = organisasimdl.deleted_by;
dep.deleted_on = DateTime.Now;
db.Entry(dep).State = System.Data.Entity.EntityState.Modified;
db.SaveChanges();
}
return(true);
}
catch (Exception)
{
return(false);
}
}
