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 ResponseResult Update(FeedbackViewModel entity)
{
ResponseResult result = new ResponseResult();
try
{
using (var db = new XBC_Context())
{
//create
if (entity.id == 0)
{
t_feedback fed = new t_feedback();
t_document_test_detail dtd = new t_document_test_detail();
fed.test_id = entity.test_id;
fed.document_test_id = entity.document_test_id;
var Serial = new JavaScriptSerializer();
object data = new
{
fed.test_id,
fed.document_test_id,
entity.Feedback
};
var json = Serial.Serialize(data);
//string a = data.ToString();
//string b;
//foreach (var item in FeedbackRepo.ListDTD(entity.document_test_id))
//{
// //dtd.question_id = entity.question_id;
// //answer = entity.answer;
// object data2 = new
// {
// //dtd.question_id,
// //answer
// };
// b = data2.ToString();
// a = a + b;
// json = Serial.Serialize(b);
//}
fed.json_feedback = json;
fed.created_by = entity.UserId;
fed.created_on = DateTime.Now;
db.t_feedback.Add(fed);
db.SaveChanges();
var json1 = new JavaScriptSerializer().Serialize(fed);
t_audit_log log = new t_audit_log();
log.type = "Insert";
log.json_insert = json1;
log.created_by = entity.UserId;
log.created_on = DateTime.Now;
db.t_audit_log.Add(log);
db.SaveChanges();
//t_audit_log log = new t_audit_log();
//log.type = "Insert";
//log.json_insert = json;
//log.created_by = 1;
//log.created_on = DateTime.Now;
//db.t_audit_log.Add(log);
//db.SaveChanges();
entity.id = fed.id;
result.Entity = entity;
}
else //edit
{
t_feedback fed = new t_feedback();
t_document_test_detail dtd = new t_document_test_detail();
fed.test_id = entity.test_id;
fed.document_test_id = entity.id;
var Serial = new JavaScriptSerializer();
object data = new
{
fed.test_id,
fed.document_test_id
};
var json = Serial.Serialize("");
string a = data.ToString();
string b;
foreach (var item in FeedbackRepo.ListDTD(entity.id))
{
//dtd.question_id = entity.question_id;
//answer = entity.answer;
object data2 = new
{
//dtd.question_id,
//answer
};
b = data2.ToString();
a = a + b;
json = Serial.Serialize(b);
}
fed.json_feedback = json;
fed.created_by = entity.UserId;
fed.created_on = DateTime.Now;
db.t_feedback.Add(fed);
db.SaveChanges();
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 = fed.id;
result.Entity = entity;
//}
}
}
}
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_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);
}
