public override OpeningHours[] GetOpeningHours()
{
SqlDataReader reader = Query("SELECT * FROM OpeningHours");
List <OpeningHours> openingHours = new List <OpeningHours>();
if (reader.HasRows)
{
while (reader.Read())
{
byte dayNum = reader.GetByte(0);
TimeSpan startTime = reader.IsDBNull(1) == false?reader.GetTimeSpan(1) : TimeSpan.MinValue;
TimeSpan endTime = reader.IsDBNull(2) == false?reader.GetTimeSpan(2) : TimeSpan.MinValue;
OpeningHours day = new OpeningHours(dayNum, startTime, endTime);
openingHours.Add(day);
}
}
reader.Close();
return(openingHours.ToArray());
}
public override OpeningHours GetOpeningHour(int dayNumber)
{
SqlDataReader reader = Query("SELECT * FROM OpeningHours WHERE DayNum=" + dayNumber);
if (reader.HasRows)
{
while (reader.Read())
{
byte dayNum = reader.GetByte(0);
TimeSpan startTime = reader.IsDBNull(1) == false?reader.GetTimeSpan(1) : TimeSpan.MinValue;
TimeSpan endTime = reader.IsDBNull(2) == false?reader.GetTimeSpan(2) : TimeSpan.MinValue;
OpeningHours day = new OpeningHours(dayNum, startTime, endTime);
reader.Close();
return(day);
}
}
reader.Close();
return(null);
}
public override void ChangeOpeningHours(OpeningHours hours)
{
Query("UPDATE OpeningHours Set StartTime='" + hours.From.ToString() + "', EndTime='" + hours.To.ToString() + "' WHERE DayNum=" + hours.Day);
}
public override void SetOpeningHours(OpeningHours hours)
{
throw new NotImplementedException();
}
public abstract void SetOpeningHours(OpeningHours hours);
public abstract void ChangeOpeningHours(OpeningHours hours);
public static void ChangeOpeningHours(OpeningHours hours)
{
adapter.ChangeOpeningHours(hours);
}
