public static Boolean EditSertifikasi(Sertifikasi sertif)
{
try
{
Sertifikasi sertifMdl;
using (DataContext db = new DataContext())
{
sertifMdl = db.Sertifikasi.Where(d => d.id == sertif.id).First();
sertifMdl.modified_by = sertif.modified_by;
sertifMdl.modified_on = DateTime.Now;
sertifMdl.id = sertif.id;
sertifMdl.certificate_name = sertif.certificate_name;
sertifMdl.publisher = sertif.publisher;
sertifMdl.valid_start_year = sertif.valid_start_year;
sertifMdl.valid_start_month = sertif.valid_start_month;
sertifMdl.until_year = sertif.until_year;
sertifMdl.until_month = sertif.until_month;
sertifMdl.notes = sertif.notes;
db.Entry(sertifMdl).State = System.Data.Entity.EntityState.Modified;
db.SaveChanges();
}
return(true);
}
catch (Exception)
{
return(false);
}
}
public static Sertifikasi GetByID(int ID)
{
Sertifikasi sertif = new Sertifikasi();
using (DataContext db = new DataContext())
{
sertif = db.Sertifikasi.Where(d => d.id == ID).First();
return(sertif);
}
}
public ActionResult EditSimpan(Sertifikasi sertif)
{
sertif.modified_by = Convert.ToInt64(Session["foo"]);
if (SertifikasiRepo.EditSertifikasi(sertif))
{
return(Json(new { EditSimpan = "Berhasil" }, JsonRequestBehavior.AllowGet)); //return json digunakan untuk memunculkan alert
}
else
{
return(Json(new { EditSimpan = "Gagal" }, JsonRequestBehavior.AllowGet));
}
}
public ActionResult Hapus(int ID, Sertifikasi sertif)
{
sertif.deleted_by = Convert.ToInt64(Session["foo"]);
if (SertifikasiRepo.HapusSertifikasi(ID, sertif)) //non static if ( barangRepo.Deletebarang(ID))
{
return(Json(new { Hapus = "Berhasil" }, JsonRequestBehavior.AllowGet));
}
else
{
return(Json(new { Hapus = "Gagal" }, JsonRequestBehavior.AllowGet));
}
}
public ActionResult Save(Sertifikasi sertif)
{
sertif.created_by = Convert.ToInt64(Session["foo"]);
if (SertifikasiRepo.TmbhSertifikasi(sertif))
{
return(Json(new { Simpan = "Berhasil" }, JsonRequestBehavior.AllowGet));
}
else
{
return(Json(new { Simpan = "Gagal" }, JsonRequestBehavior.AllowGet));
}
}
public static bool TmbhSertifikasi(Sertifikasi sertif)
{
try
{
// Riwayat_Pendidikan pendidikanmdl = new Riwayat_Pendidikan();
using (DataContext db = new DataContext())
{
sertif.created_on = DateTime.Now;
db.Sertifikasi.Add(sertif);
db.SaveChanges();
}
return(true);
}
catch (Exception)
{
return(false);
}
}
public static Boolean HapusSertifikasi(int ID, Sertifikasi sertif)
{
try
{
Sertifikasi sert;
using (DataContext db = new DataContext())
{
sert = db.Sertifikasi.Where(d => d.id == ID).First();
sert.is_delete = true;
sert.deleted_by = sertif.deleted_by;
sert.deleted_on = DateTime.Now;
db.Entry(sert).State = System.Data.Entity.EntityState.Modified;
db.SaveChanges();
}
return(true);
}
catch (Exception)
{
return(false);
}
}
