public static HourDTO GetHourDTO(Hour Hour)
{
HourDTO HourDTO = new HourDTO();
// HourDTO.Id = Hour.Id;
HourDTO.TeacherId = Hour.TeacherId;
HourDTO.Date = Hour.Date;
HourDTO.Starttime = Hour.Starttime.ToString();
// HourDTO.Endtime = Hour.Endtime;
return(HourDTO);
}
public IHttpActionResult AddLesson(HourDTO lesson)
{
try
{
BL.HourBL.AddLesson(lesson);
return(Ok());
}
catch (Exception)
{
return(BadRequest());
}
}
public List <HourDTO> addHour(VenueDTO v)
{
HourDTO h = new HourDTO();
h = v.hours.Last();
using (var db = new GG.Models.GGModelContainer())
{
Hours HourTbl = new Hours();
HourDTO newHour = new HourDTO();
HourTbl = new Hours
{
Text = h.hourText,
VenueId = (int)v.id
};
db.Hours.Add(HourTbl);
db.SaveChanges();
newHour = h;
newHour.id = HourTbl.Id;
var existingHour = (from x in db.Hours where x.Id == newHour.id select x).FirstOrDefault();
var existingVenue = (from x in db.Venues where x.Id == v.id select x).FirstOrDefault();
existingVenue.Hours.Add(existingHour);
db.SaveChanges();
var l = (from x in existingVenue.Hours
.Select(b => new HourDTO
{
id = b.Id,
hourText = b.Text
})
select x).ToList();
return(l);
}
}
public List <HourDTO> removeHour(VenueDTO v)
{
HourDTO h = new HourDTO();
h = v.hours.Last();
using (var db = new GG.Models.GGModelContainer())
{
Venue VenueTbl = new Venue();
var existingHour = (from x in db.Hours where x.Id == h.id select x).FirstOrDefault();
var existingVenue = (from x in db.Venues where x.Id == v.id select x).FirstOrDefault();
db.Hours.Remove(existingHour);
existingVenue.Hours.Remove(existingHour);
db.SaveChanges();
var l = (from x in existingVenue.Hours
.Select(b => new HourDTO
{
id = b.Id,
hourText = b.Text
})
select x).ToList();
return(l);
}
}
public static void AddLesson(HourDTO lesson)
{
DAL.HourDAL.AddLesson(Converters.HourConvert.GetHour(lesson));
}
