public ActionResult DeleteTrainer(TechnologyTrainerViewModel model)
{
ResponseResult result = TechnologyRepo.DeleteTrainer(model);
return(Json(new
{
success = result.Success,
message = result.ErrorMessage,
entity = result.Entity
}, JsonRequestBehavior.AllowGet));
}
public static ResponseResult DeleteTrainer(TechnologyTrainerViewModel entity)
{
ResponseResult result = new ResponseResult();
try
{
using (var db = new XBC_Context())
{
t_technology_trainer ttr = db.t_technology_trainer
.Where(t => t.id == entity.id)
.FirstOrDefault();
if (ttr != null)
{
object data = new
{
ttr.id,
ttr.trainer_id,
ttr.technology_id
};
var json = new JavaScriptSerializer().Serialize(data);
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.t_technology_trainer.Remove(ttr);
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 TechnologyTrainerViewModel TrainerById(long id)
{
TechnologyTrainerViewModel result = new TechnologyTrainerViewModel();
using (var db = new XBC_Context())
{
result = (from ttr in db.t_technology_trainer
join tra in db.t_trainer on ttr.trainer_id equals tra.id
where ttr.id == id && tra.is_delete == false
select new TechnologyTrainerViewModel
{
id = ttr.id,
trainer_id = tra.id,
}).FirstOrDefault();
if (result == null)
{
result = new TechnologyTrainerViewModel();
}
return(result);
}
}