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