public IEnumerable<Training> Get()
{
using (TrainingDBEntities entities = new TrainingDBEntities())
{
return entities.Trainings.ToList();
}
}
public Training Get(int trainingID)
{
using (TrainingDBEntities entities = new TrainingDBEntities())
{
return entities.Trainings.FirstOrDefault(e => e.TrainingID == trainingID);
}
}
public Training Get(int id)
{
using (TrainingDBEntities entities = new TrainingDBEntities())
{
return(entities.Trainings.FirstOrDefault(e => e.id == id));
}
}
public void Post([FromBody] Training training)
{
using (TrainingDBEntities entities = new TrainingDBEntities())
{
var maxItem = entities.Trainings.OrderByDescending(i => i.TrainingID).FirstOrDefault();
var newID = maxItem == null ? 1 : maxItem.TrainingID + 1;
training.TrainingID = newID;
entities.Trainings.Add(training);
entities.SaveChanges();
}
}
public HttpResponseMessage Post([FromBody] TrainingModel TM)
{
try
{
TrainingInfo otInfo = new TrainingInfo();
otInfo.TrainingName = TM.sTrainingName;
otInfo.StartDate = TM.stDate;
otInfo.EndDate = TM.endDate;
TrainingDBEntities oDBContext = new TrainingDBEntities();
oDBContext.TrainingInfoes.Add(otInfo);
oDBContext.SaveChanges();
TimeSpan t = TM.endDate - TM.stDate;
TM.NumberofDays = t.TotalDays.ToString();
return(Request.CreateResponse(HttpStatusCode.Created, TM));
}
catch (Exception ex)
{
return(Request.CreateResponse(HttpStatusCode.BadRequest, ex));
}
}
