public ActionResult DeleteQuestion(Document_Test_DetailViewModel model) { ResponseResult result = Document_Test_DetailRepo.DeleteQuestion(model); return(Json(new { success = result.Success, message = result.ErrorMessage, entity = result.Entity }, JsonRequestBehavior.AllowGet)); }
public ActionResult AddQuestion(Document_Test_DetailViewModel model) { ResponseResult result = Document_Test_DetailRepo.Update(model /*, model.test_type_id*/); return(Json(new { success = result.Success, message = result.ErrorMessage, entity = result.Entity }, JsonRequestBehavior.AllowGet)); }
public static Document_Test_DetailViewModel ByQuestion(long id) { Document_Test_DetailViewModel result = new Document_Test_DetailViewModel(); using (var db = new XBC_Context()) { result = (from q in db.t_question where q.id == id select new Document_Test_DetailViewModel { question_id = q.id, question = q.question }).FirstOrDefault(); return(result != null ? result : new Document_Test_DetailViewModel()); } }
public static Document_Test_DetailViewModel By(long id) { Document_Test_DetailViewModel result = new Document_Test_DetailViewModel(); using (var db = new XBC_Context()) { result = (from c in db.t_document_test_detail select new Document_Test_DetailViewModel { document_test_id = id }).FirstOrDefault(); if (result == null) { result = new Document_Test_DetailViewModel(); } } return(result); }
public static ResponseResult DeleteQuestion(Document_Test_DetailViewModel entity) { ResponseResult result = new ResponseResult(); try { using (var db = new XBC_Context()) { t_document_test_detail cat = db.t_document_test_detail.Where(o => o.id == entity.id).FirstOrDefault(); if (cat != null) { db.t_document_test_detail.Remove(cat); db.SaveChanges(); var json = new JavaScriptSerializer().Serialize(cat); t_audit_log log = new t_audit_log(); log.type = "Delete"; log.json_delete = json; log.created_by = entity.UserId; log.created_on = DateTime.Now; db.t_audit_log.Add(log); db.SaveChanges(); result.Entity = entity; } else { result.Success = false; result.ErrorMessage = "Category Not Found!"; } } } catch (Exception ex) { result.Success = false; result.ErrorMessage = ex.Message; } return(result); }
public static Document_Test_DetailViewModel Byiddtd(long id) { Document_Test_DetailViewModel result = new Document_Test_DetailViewModel(); using (var db = new XBC_Context()) { result = (from c in db.t_document_test_detail where c.id == id select new Document_Test_DetailViewModel { id = c.id, document_test_id = c.document_test_id, question_id = c.question_id }).FirstOrDefault(); if (result == null) { result = new Document_Test_DetailViewModel(); } } return(result); }
public static ResponseResult Update(Document_Test_DetailViewModel entity) { ResponseResult result = new ResponseResult(); try { using (var db = new XBC_Context()) { //create if (entity.id == 0) { t_document_test_detail dtd = new t_document_test_detail(); dtd.question_id = entity.question_id; dtd.document_test_id = entity.document_test_id; dtd.created_by = entity.UserId; dtd.created_on = DateTime.Now; db.t_document_test_detail.Add(dtd); db.SaveChanges(); var json = new JavaScriptSerializer().Serialize(dtd); t_audit_log log = new t_audit_log(); log.type = "Insert"; log.json_insert = json; log.created_by = entity.UserId; log.created_on = DateTime.Now; db.t_audit_log.Add(log); db.SaveChanges(); entity.id = dtd.id; result.Entity = entity; } /*else*/ //edit //{ // t_category cat = db.t_category.Where(o => o.id == entity.id).FirstOrDefault(); // if (cat != null) // { // var json = new JavaScriptSerializer().Serialize(cat); // t_audit_log log = new t_audit_log(); // log.type = "Modify"; // log.json_before = json; // log.created_by = 1; // log.created_on = DateTime.Now; // cat.name = entity.name; // cat.description = entity.description; // cat.modified_by = 1; // cat.modified_on = DateTime.Now; // var json2 = new JavaScriptSerializer().Serialize(cat); // log.json_after = json2; // db.t_audit_log.Add(log); // db.SaveChanges(); // result.Entity = entity; // } // else // { // result.Success = false; // result.ErrorMessage = "Category Not Found"; // } //} } } catch (Exception ex) { result.Success = false; result.ErrorMessage = ex.Message; } return(result); }