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