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;
}
