public static ResponseResult Delete(TrainerViewModel entity)
{
ResponseResult result = new ResponseResult();
try
{
using (var db = new XBC_Context())
{
t_trainer tra = db.t_trainer
.Where(t => t.id == entity.id)
.FirstOrDefault();
if (tra != null)
{
object data = new
{
tra.id,
tra.name,
tra.notes,
tra.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;
tra.is_delete = true;
tra.deleted_by = entity.UserId;
tra.deleted_on = DateTime.Now;
object data2 = new
{
tra.id,
tra.name,
tra.notes,
tra.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 = "Trainer Not Found";
}
}
}
catch (Exception ex)
{
result.Success = false;
result.ErrorMessage = ex.Message;
}
return(result);
}
public static ResponResultViewModel Update2(TrainerViewModel entity)
{
//untuk create dan edit
ResponResultViewModel result = new ResponResultViewModel();
try
{
using (var db = new MinProContext())
{
if (entity.id == 0)
{
t_trainer trainer = new t_trainer();
trainer.name = entity.name;
trainer.notes = entity.notes;
trainer.active = entity.active;
trainer.created_by = 1;
trainer.created_on = DateTime.Now;
db.t_trainer.Add(trainer);
db.SaveChanges();
result.Entity = trainer;
}
else
{
t_trainer trainer = db.t_trainer.Where(o => o.id == entity.id).FirstOrDefault();
if (trainer != null)
{
trainer.name = entity.name;
trainer.notes = entity.notes;
trainer.active = false;
trainer.created_by = 1;
trainer.created_on = DateTime.Now;
db.SaveChanges();
result.Entity = entity;
}
else
{
result.Success = false;
result.Message = "trainer not found!";
}
}
}
}
catch (Exception e)
{
result.Success = false;
result.Message = e.Message;
}
return(result);
}
