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