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