public List <List <TD> > GetDateReservation(DateTime date) { List <List <TD> > table = new List <List <TD> >(); db = new Entities(); for (int i = 9; i <= 21; i++) { List <TD> row = new List <TD>(); TD first = new TD(); first.ReservationId = -2; first.Purpose = i.ToString(); row.Add(first); int roomNumber = 0; foreach (Auditorium auditory in db.Auditorium) { Reservation reserv = GetAuditoriumReservation(auditory.AuditoriumId, new DateTime(date.Year, date.Month, date.Day, i, 0, 0)); TD td = new TD(); if (reserv == null) { td.ReservationId = -1; td.StartDate = new DateTime(date.Year, date.Month, date.Day, i, 0, 0); td.TargetAuditorium = auditory.AuditoriumId; } else { td = ConvertToTD(reserv); } td.Hour = i; td.Placement = "right"; if (roomNumber >= 8) { td.Placement = "left"; } if (i == 9) { td.Placement = "bottom"; } else if (i == 20 || i == 21) { td.Placement = "top"; } roomNumber++; row.Add(td); } table.Add(row); } return(table); }
public List <List <TD> > GetWeekReservation(DateTime date, string auditoriumName) { List <List <TD> > table = new List <List <TD> >(); DayOfWeek dayOfWeek = date.DayOfWeek; DateTime startdate = date; IQueryable <Auditorium> auditorium = db.Auditorium .Where(auditor => auditor.AuditoriumName.Equals(auditoriumName)); for (int i = 9; i <= 21; i++) { startdate = date; startdate = startdate.Subtract(new TimeSpan((int)dayOfWeek - 1, 0, 0, 0)); List <TD> row = new List <TD>(); TD first = new TD(); first.ReservationId = -2; first.Purpose = i.ToString(); row.Add(first); int roomNumber = 0; for (int day = 0; day < 7; day++) { foreach (Auditorium auditory in auditorium) { Reservation reserv = GetAuditoriumReservation(auditory.AuditoriumId, new DateTime(startdate.Year, startdate.Month, startdate.Day, i, 0, 0)); TD td = new TD(); if (reserv == null) { td.ReservationId = -1; td.StartDate = new DateTime(startdate.Year, startdate.Month, startdate.Day, i, 0, 0); td.TargetAuditorium = auditory.AuditoriumId; } else { td = ConvertToTD(reserv); } td.Hour = i; td.Placement = "right"; if (roomNumber >= 5) { td.Placement = "left"; } if (i == 9) { td.Placement = "bottom"; } else if (i == 20 || i == 21) { td.Placement = "top"; } row.Add(td); } roomNumber++; startdate = startdate.AddDays(1); } table.Add(row); } return(table); }
public List<List<TD>> GetDateReservation(DateTime date) { List<List<TD>> table = new List<List<TD>>(); db = new Entities(); for (int i = 9; i <= 21; i++) { List<TD> row = new List<TD>(); TD first = new TD(); first.ReservationId = -2; first.Purpose = i.ToString(); row.Add(first); int roomNumber = 0; foreach (Auditorium auditory in db.Auditorium) { Reservation reserv = GetAuditoriumReservation(auditory.AuditoriumId, new DateTime(date.Year, date.Month, date.Day, i, 0, 0)); TD td = new TD(); if (reserv == null) { td.ReservationId = -1; td.StartDate = new DateTime(date.Year, date.Month, date.Day, i, 0, 0); td.TargetAuditorium = auditory.AuditoriumId; } else { td = ConvertToTD(reserv); } td.Hour = i; td.Placement = "right"; if (roomNumber >= 8) { td.Placement = "left"; } if (i == 9) { td.Placement = "bottom"; } else if (i == 20 || i == 21) { td.Placement = "top"; } roomNumber++; row.Add(td); } table.Add(row); } return table; }
private TD ConvertToTD(Reservation reservation) { TD td = new TD(); td.User = reservation.User; td.ReservationId = reservation.ReservationId; td.Auditorium = reservation.Auditorium; td.CreatedBy = reservation.CreatedBy; td.FinishDate = reservation.FinishDate; td.StartDate = reservation.StartDate; td.TargetAuditorium = reservation.TargetAuditorium; td.Type = reservation.Type; td.Purpose = reservation.Purpose; return td; }
public List<List<TD>> GetWeekReservation(DateTime date, string auditoriumName) { List<List<TD>> table = new List<List<TD>>(); DayOfWeek dayOfWeek = date.DayOfWeek; DateTime startdate = date; IQueryable<Auditorium> auditorium = db.Auditorium .Where(auditor => auditor.AuditoriumName.Equals(auditoriumName)); for (int i = 9; i <= 21; i++) { startdate = date; startdate = startdate.Subtract(new TimeSpan((int)dayOfWeek - 1, 0, 0, 0)); List<TD> row = new List<TD>(); TD first = new TD(); first.ReservationId = -2; first.Purpose = i.ToString(); row.Add(first); int roomNumber = 0; for (int day = 0; day < 7; day++) { foreach (Auditorium auditory in auditorium) { Reservation reserv = GetAuditoriumReservation(auditory.AuditoriumId, new DateTime(startdate.Year, startdate.Month, startdate.Day, i, 0, 0)); TD td = new TD(); if (reserv == null) { td.ReservationId = -1; td.StartDate = new DateTime(startdate.Year, startdate.Month, startdate.Day, i, 0, 0); td.TargetAuditorium = auditory.AuditoriumId; } else { td = ConvertToTD(reserv); } td.Hour = i; td.Placement = "right"; if (roomNumber >= 5) { td.Placement = "left"; } if (i == 9) { td.Placement = "bottom"; } else if (i == 20 || i == 21) { td.Placement = "top"; } row.Add(td); } roomNumber++; startdate = startdate.AddDays(1); } table.Add(row); } return table; }
public List<List<TD>> GetDayRoomReservation(DateTime date, string auditoriumName) { IQueryable < Auditorium > auditorium = db.Auditorium .Where(auditor => auditor.AuditoriumName.Equals(auditoriumName)); for (int i = 9; i <= 21; i++) { List<TD> row = new List<TD>(); TD first = new TD(); first.ReservationId = -2; first.Purpose = i.ToString(); row.Add(first); int roomNumber = 0; foreach (Auditorium auditory in auditorium) { Reservation reserv = GetAuditoriumReservation(auditory.AuditoriumId, new DateTime(date.Year, date.Month, date.Day, i, 0, 0)); TD td = new TD(); if (reserv == null) { td.ReservationId = -1; td.StartDate = new DateTime(date.Year, date.Month, date.Day, i, 0, 0); td.TargetAuditorium = auditory.AuditoriumId; } else { td = ConvertToTD(reserv); } td.Hour = i; td.Placement = "bottom"; if (i == 17 || i == 18 || i == 19 || i == 20 || i == 21) { td.Placement = "top"; } roomNumber++; row.Add(td); } table.Add(row); } return table; }