public static ResponseResult Delete(TestimonyViewModel entity) { ResponseResult result = new ResponseResult(); try { using (var db = new XBC_Context()) { t_testimony tes = db.t_testimony .Where(t => t.id == entity.id) .FirstOrDefault(); if (tes != null) { object data = new { tes.id, tes.title, tes.content, tes.is_delete }; var json = new JavaScriptSerializer().Serialize(data); t_audit_log log = new t_audit_log(); log.type = "Modify"; log.json_before = json; log.created_by = entity.UserId; log.created_on = DateTime.Now; tes.is_delete = true; tes.deleted_by = entity.UserId; tes.deleted_on = DateTime.Now; object data2 = new { tes.id, tes.title, tes.content, tes.is_delete }; var json2 = new JavaScriptSerializer().Serialize(data2); log.json_after = json2; db.t_audit_log.Add(log); db.SaveChanges(); result.Entity = entity; } else { result.Success = false; result.ErrorMessage = "Testimony Not Found"; } } } catch (Exception ex) { result.Success = false; result.ErrorMessage = ex.Message; } return(result); }
// GET: Testimony/Create public IActionResult Testimonials() { var model = new TestimonyViewModel(); model.TestimonyModels = _context.Testimonials.Where(t => t.Publish == true).AsQueryable().ToList(); return(View(model)); }
public ActionResult Delete(TestimonyViewModel model) { ResponseResult result = TestimonyRepo.Delete(model); return(Json(new { success = result.Success, message = result.ErrorMessage, entity = result.Entity }, JsonRequestBehavior.AllowGet)); }
public static ResponResultViewModel Update2(TestimonyViewModel entity) { //untuk create dan edit ResponResultViewModel result = new ResponResultViewModel(); try { using (var db = new MinProContext()) { if (entity.id == 0) { t_testimony testimony = new t_testimony(); testimony.title = entity.title; testimony.content = entity.content; testimony.is_delete = entity.is_delete; testimony.created_by = 1; testimony.created_on = DateTime.Now; db.t_testimony.Add(testimony); db.SaveChanges(); result.Entity = testimony; } else { t_testimony testimony = db.t_testimony.Where(o => o.id == entity.id).FirstOrDefault(); if (testimony != null) { testimony.title = entity.title; testimony.content = entity.content; testimony.is_delete = true; testimony.created_by = 1; testimony.created_on = DateTime.Now; db.SaveChanges(); result.Entity = entity; } else { result.Success = false; result.Message = "testimony not found!"; } } } } catch (Exception e) { result.Success = false; result.Message = e.Message; } return(result); }
public ActionResult Edit(TestimonyViewModel model) { ResponResultViewModel result = TestimonyRepo.Update(model); return(Json(new { success = result.Success, message = result.Message, entity = result.Entity }, JsonRequestBehavior.AllowGet)); }
//GetById public static TestimonyViewModel ById(long id) { TestimonyViewModel result = new TestimonyViewModel(); using (var db = new XBC_Context()) { result = (from tes in db.t_testimony where tes.id == id && tes.is_delete == false select new TestimonyViewModel { id = tes.id, title = tes.title, content = tes.content, is_delete = tes.is_delete }).FirstOrDefault(); if (result == null) { result = new TestimonyViewModel(); } return(result); } }
public static TestimonyViewModel GetTestimony(long id) { TestimonyViewModel result = new TestimonyViewModel(); using (var db = new MinProContext()) { result = (from ts in db.t_testimony where ts.id == id select new TestimonyViewModel { id = ts.id, title = ts.title, content = ts.content, is_delete = ts.is_delete }).FirstOrDefault(); if (result == null) { result = new TestimonyViewModel(); } } return(result); }