public void save(TrainingSetting dbitem, int id)
{
var query = "";
if (dbitem.Id == 0) //create
{
context.TrainingSetting.Add(dbitem);
query += "INSERT INTO dbo.\"TrainingSetting\" (\"Nama\", \"Interval\") VALUES (" + dbitem.Nama + ", " + dbitem.Interval + ");";
}
else //edit
{
context.TrainingSetting.Attach(dbitem);
query += "UPDATE dbo.\"TrainingSetting\" SET \"Nama\" = " + dbitem.Nama + ", \"Interval\" = " + dbitem.Interval + " WHERE \"Id\" = " + dbitem.Id + ";";
query += "DELETE FROM dbo.\"TrainingSettingDetail\" WHERE \"TrainingSettingId\" = " + dbitem.Id + ";";
var entry = context.Entry(dbitem);
entry.State = EntityState.Modified;
}
context.SaveChanges();
foreach (Context.TrainingSettingDetail tsd in dbitem.TrainingSettingDetail)
{
query += "INSERT INTO dbo.\"TrainingSettingDetail\" (\"TrainingSettingId\", \"Materi\", \"NilaiMinimum\") VALUES (" + tsd.TrainingSettingId + ", " + tsd.Materi + ", " + tsd.NilaiMinimum + ");";
}
var auditrail = new Auditrail {
Actionnya = dbitem.Id == 0 ? "Add" : "Edit", EventDate = DateTime.Now, Modulenya = "Training", QueryDetail = query, RemoteAddress = AppHelper.GetIPAddress(),
IdUser = id
};
context.Auditrail.Add(auditrail);
context.SaveChanges();
}
public ActionResult Edit(int id)
{
Context.TrainingSetting dbitem = RepoTrainingSetting.FindByPK(id);
TrainingSetting model = new TrainingSetting(dbitem);
ViewBag.name = model.Nama;
return(View("Form", model));
}
public void delete(TrainingSetting dbitem, int id)
{
context.TrainingSetting.Remove(dbitem);
var query = "DELETE FROM dbo.\"TrainingSetting\" WHERE \"Id\" = " + dbitem.Id + ";";
var auditrail = new Auditrail {
Actionnya = "Delete", EventDate = DateTime.Now, Modulenya = "Training Setting", QueryDetail = query, RemoteAddress = AppHelper.GetIPAddress(), IdUser = id
};
context.Auditrail.Add(auditrail);
context.SaveChanges();
}
public ActionResult Edit(TrainingSetting model)
{
if (ModelState.IsValid)
{
Context.TrainingSetting dbitem = RepoTrainingSetting.FindByPK(model.Id);
model.setDb(dbitem);
RepoTrainingSetting.save(dbitem, UserPrincipal.id);
return(RedirectToAction("Index"));
}
return(View("Form", model));
}
public ActionResult Add()
{
TrainingSetting model = new TrainingSetting();
return(View("Form", model));
}
