public static ResponseResult Delete(Document_TestViewModel entity) { ResponseResult result = new ResponseResult(); try { using (var db = new XBC_Context()) { t_document_test doct = db.t_document_test.Where(o => o.id == entity.id).FirstOrDefault(); if (doct != null) { var Serial = new JavaScriptSerializer(); object data = new { doct.id, doct.test_id, doct.test_type_id, doct.token, doct.version, doct.is_delete, doct.deleted_by, doct.deleted_on }; var json = Serial.Serialize(data); doct.is_delete = true; doct.deleted_by = entity.UserId; doct.deleted_on = DateTime.Now; object data2 = new { doct.id, doct.test_id, doct.test_type_id, doct.token, doct.version, doct.is_delete, doct.deleted_by, doct.deleted_on }; t_audit_log log = new t_audit_log(); log.type = "Modify"; log.json_before = json; json = Serial.Serialize(data2); log.json_after = 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 ResponseResult CopyDocument(Document_TestViewModel entity) { { ResponseResult result = new ResponseResult(); try { //entity.TestType = GetTestType(id); //entity.version = GetNewVersion(entity.test_type_id); //entity.token = RandomString(); using (var db = new XBC_Context()) { //create if (entity.id == 0) { t_document_test doct = new t_document_test(); doct.version = entity.version; doct.token = entity.token; doct.test_type_id = entity.test_type_id; doct.test_id = entity.test_id; doct.created_by = entity.UserId; doct.created_on = DateTime.Now; db.t_document_test.Add(doct); db.SaveChanges(); var json = new JavaScriptSerializer().Serialize(doct); 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 = doct.id; result.Entity = entity; } else //edit { t_document_test doct = db.t_document_test.Where(o => o.id == entity.id).FirstOrDefault(); if (doct != null) { t_document_test doct1 = new t_document_test(); doct1.test_id = entity.test_id; doct1.test_type_id = entity.test_type_id; doct1.version = entity.version; doct1.token = entity.token; doct1.created_by = entity.UserId; doct1.created_on = DateTime.Now; db.t_document_test.Add(doct1); db.SaveChanges(); var Serial = new JavaScriptSerializer(); object data2 = new { doct1.id, doct1.created_by, doct1.created_on, doct1.deleted_by, doct1.deleted_on, doct1.is_delete, doct1.modified_by, doct1.modified_on, doct1.test_id, doct1.test_type_id, doct1.token, doct.version }; t_audit_log log = new t_audit_log(); var json = Serial.Serialize(data2); 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(); //var json = new JavaScriptSerializer().Serialize(doct1); //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(); List <t_document_test_detail> results = (from dtd in db.t_document_test_detail where dtd.document_test_id == entity.id select dtd).ToList(); foreach (t_document_test_detail dtd in results) { t_document_test_detail od = new t_document_test_detail(); od.question_id = dtd.question_id; od.document_test_id = doct1.id; od.created_by = entity.UserId; od.created_on = DateTime.Now; db.t_document_test_detail.Add(od); db.SaveChanges(); Serial = new JavaScriptSerializer(); object data = new { od.id, od.document_test_id, od.question_id }; var json2 = Serial.Serialize(data); log.type = "Insert"; log.json_insert = json2; log.created_by = entity.UserId; log.created_on = DateTime.Now; db.t_audit_log.Add(log); db.SaveChanges(); } entity.id = doct1.id; result.Entity = entity; } else { result.Success = false; result.ErrorMessage = "Document Test Not Found"; } } } } catch (Exception ex) { result.Success = false; result.ErrorMessage = ex.Message; } return(result); } }
public static ResponseResult Update(Document_TestViewModel entity /*, long id*/) { ResponseResult result = new ResponseResult(); try { //entity.TestType = GetTestType(id); //entity.version = GetNewVersion(entity.test_type_id); if (entity.token == null) { entity.token = RandomString(); } using (var db = new XBC_Context()) { //create if (entity.id == 0) { t_document_test doct = new t_document_test(); doct.version = entity.version; doct.token = entity.token; doct.test_type_id = entity.test_type_id; doct.test_id = entity.test_id; doct.created_by = entity.UserId; doct.created_on = DateTime.Now; db.t_document_test.Add(doct); db.SaveChanges(); var json = new JavaScriptSerializer().Serialize(doct); 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 = doct.id; result.Entity = entity; } else //edit { t_document_test doct = db.t_document_test.Where(o => o.id == entity.id).FirstOrDefault(); if (doct != null) { var Serial = new JavaScriptSerializer(); object data = new { doct.created_by, doct.created_on, doct.is_delete, doct.id, doct.modified_by, doct.modified_on, doct.test_id, doct.test_type_id, doct.token, doct.version }; var json = Serial.Serialize(data); if (doct.test_type_id != entity.test_type_id) { doct.version = GetNewVersion(entity.test_type_id); } doct.test_id = entity.test_id; doct.test_type_id = entity.test_type_id; doct.token = entity.token; doct.modified_by = entity.UserId; doct.modified_on = DateTime.Now; object data2 = new { doct.created_by, doct.created_on, doct.is_delete, doct.id, doct.modified_by, doct.modified_on, doct.test_id, doct.test_type_id, doct.token, doct.version }; t_audit_log log = new t_audit_log(); log.type = "Modify"; log.json_before = json; json = Serial.Serialize(data2); log.json_after = json; log.created_by = entity.UserId; log.created_on = DateTime.Now; db.t_audit_log.Add(log); db.SaveChanges(); result.Entity = entity; db.SaveChanges(); //var json2 = new JavaScriptSerializer().Serialize(doct); //log.json_after = json2; //db.t_audit_log.Add(log); result.Entity = entity; //string b = data2.ToString(); // string a = data.ToString(); // b = b + a; // object data3 = new // { // doct.created_by, // b // }; // json = Serial.Serialize(b); } else { result.Success = false; result.ErrorMessage = "Category Not Found"; } } } } catch (Exception ex) { result.Success = false; result.ErrorMessage = ex.Message; } return(result); }