public void save(TimeAlert dbitem, int id)
{
if (dbitem.Id == 0) //create
{
context.TimeAlert.Add(dbitem);
var query = "INSERT INTO dbo.\"TimeAlert\" (\"idProses\", \"keteranganBagian\", status, \"over\", \"overSatuan\", \"idUserAlert\", \"AlertPopup\", \"AlertSound\", \"AlertEmail\", " +
"\"rowColor\") VALUES ( " + dbitem.idProses + ", " + dbitem.keteranganBagian + ", " + dbitem.status + ", " + dbitem.over + ", " + dbitem.overSatuan + ", " + dbitem.idUserAlert + ", " +
dbitem.AlertPopup + ", " + dbitem.AlertSound + ", " + dbitem.AlertEmail + ", " + dbitem.rowColor + ");";
var auditrail = new Auditrail {
Actionnya = "Add", EventDate = DateTime.Now, Modulenya = "Time Alert", QueryDetail = query, RemoteAddress = AppHelper.GetIPAddress(), IdUser = id
};
context.Auditrail.Add(auditrail);
}
else //edit
{
context.TimeAlert.Attach(dbitem);
var query = "UPDATE dbo.\"TimeAlert\" SET \"idProses\" = " + dbitem.idProses + ", \"keteranganBagian\" = " + dbitem.keteranganBagian + ", status = " + dbitem.status +
", \"over\" = " + dbitem.over + ", \"overSatuan\" = " + dbitem.overSatuan + ", \"idUserAlert\" = " + dbitem.idUserAlert + ", \"AlertPopup\" = " + dbitem.AlertPopup +
", \"AlertSound\" = " + dbitem.AlertSound + ", \"AlertEmail\" = " + dbitem.AlertEmail + ", \"rowColor\" = " + dbitem.rowColor + " WHERE \"Id\" = " + dbitem.Id + ";";
var auditrail = new Auditrail {
Actionnya = "Edit", EventDate = DateTime.Now, Modulenya = "Time Alert", QueryDetail = query, RemoteAddress = AppHelper.GetIPAddress(), IdUser = id
};
context.Auditrail.Add(auditrail);
var entry = context.Entry(dbitem);
entry.State = EntityState.Modified;
}
context.SaveChanges();
}
public void delete(TimeAlert dbitem, int id)
{
context.TimeAlert.Remove(dbitem);
var query = "DELETE FROM dbo.\"TimeAlert\" WHERE \"Id\" = " + dbitem.Id + ";";
var auditrail = new Auditrail {
Actionnya = "Delete", EventDate = DateTime.Now, Modulenya = "Time Alert", QueryDetail = query, RemoteAddress = AppHelper.GetIPAddress(), IdUser = id
};
context.Auditrail.Add(auditrail);
context.SaveChanges();
}
public JsonResult SaveTimeAlert(TimeAlert model)
{
Context.TimeAlert dbitem = new Context.TimeAlert();
if (model.Id != 0)
{
dbitem = RepoTimeAlert.FindByPK(model.Id);
}
model.setDb(dbitem);
RepoTimeAlert.save(dbitem, UserPrincipal.id);
ResponeModel response = new ResponeModel(true);
return(Json(response));
}
