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