public static List <OpeningTime> GetHolidayOpeningTimesByLocationID(long locationID) { DateTime holidayStartDate; DateTime?altOpenTime = null, altCloseTime = null; bool closed; try { List <OpeningTime> openingTimes = new List <OpeningTime>(); OpeningTime openingTime; using (SqlConnection myConnection = new SqlConnection(Variables.CONNSTRING)) { myConnection.Open(); using (SqlCommand myCommand = new SqlCommand("SELECT_HolidayOpeningTimesByLocation", myConnection)) { myCommand.CommandType = CommandType.StoredProcedure; myCommand.Parameters.Add("@LocationID", SqlDbType.VarChar).Value = locationID; SqlDataReader myReader = null; myReader = myCommand.ExecuteReader(); while (myReader.Read()) { //locationID = (long)myReader["LocationID"]; holidayStartDate = (DateTime)myReader["HolidayStartDate"]; altOpenTime = Variables.GetNullableDateTime(myReader, "AltOpenTime"); altCloseTime = Variables.GetNullableDateTime(myReader, "AltCloseTime"); //sqlDateTime = myReader["AltOpenTime"]; //altOpenTime = (sqlDateTime == System.DBNull.Value) // ? (DateTime?)null // : Convert.ToDateTime(sqlDateTime); //sqlDateTime = myReader["AltCloseTime"]; //altCloseTime = (sqlDateTime == System.DBNull.Value) // ? (DateTime?)null // : Convert.ToDateTime(sqlDateTime); closed = (bool)myReader["Closed"]; openingTime = new OpeningTime(locationID, holidayStartDate, altOpenTime, altCloseTime, closed); openingTimes.Add(openingTime); } return(openingTimes); } } } catch (Exception ex) { throw new ApplicationException(ex.Message); } }
public static List <OpeningTime> GetHolidayOpeningTimes() { long locationID; DateTime holidayStartDate; DateTime?altOpenTime = null, altCloseTime = null; bool closed; try { List <OpeningTime> openingTimes = new List <OpeningTime>(); OpeningTime openingTime; using (SqlConnection myConnection = new SqlConnection(Variables.CONNSTRING)) { myConnection.Open(); SqlDataReader myReader = null; SqlCommand myCommand = new SqlCommand("SELECT * FROM HolidayOpeningTimes", myConnection); myReader = myCommand.ExecuteReader(); while (myReader.Read()) { locationID = (long)myReader["LocationID"]; holidayStartDate = (DateTime)myReader["HolidayStartDate"]; altOpenTime = Variables.GetNullableDateTime(myReader, "AltOpenTime"); altCloseTime = Variables.GetNullableDateTime(myReader, "AltCloseTime"); //if (myReader["AltOpenTime"] != null) //{ // altOpenTime = (DateTime?)myReader["AltOpenTime"]; //} //if (myReader["AltCloseTime"] != null) //{ // altCloseTime = (DateTime?)myReader["AltCloseTime"]; //} closed = (bool)myReader["Closed"]; openingTime = new OpeningTime(locationID, holidayStartDate, altOpenTime, altCloseTime, closed); openingTimes.Add(openingTime); } return(openingTimes); } } catch (Exception ex) { throw new ApplicationException(ex.Message); } }
public static List <OpeningTime> GetOpeningTimesByLocationID(long locationID) { DateTime openTime, closeTime; int dayOfWeek; bool closed; try { List <OpeningTime> openingTimes = new List <OpeningTime>(); OpeningTime openingTime; using (SqlConnection myConnection = new SqlConnection(Variables.CONNSTRING)) { myConnection.Open(); using (SqlCommand myCommand = new SqlCommand("SELECT_OpeningTimesByLocation", myConnection)) { myCommand.CommandType = CommandType.StoredProcedure; myCommand.Parameters.Add("@LocationID", SqlDbType.VarChar).Value = locationID; SqlDataReader myReader = null; myReader = myCommand.ExecuteReader(); while (myReader.Read()) { dayOfWeek = (int)myReader["DayOfTheWeek"]; openTime = (DateTime)myReader["OpenTime"]; closeTime = (DateTime)myReader["CloseTime"]; closed = (bool)myReader["Closed"]; openingTime = new OpeningTime(locationID, dayOfWeek, openTime, closeTime, closed); openingTimes.Add(openingTime); } return(openingTimes); } } } catch (Exception ex) { throw new ApplicationException(ex.Message); } }
public static List <OpeningTime> GetOpeningTimes() { long locationID; DateTime openTime, closeTime; int dayOfWeek; bool closed; try { List <OpeningTime> openingTimes = new List <OpeningTime>(); OpeningTime openingTime; using (SqlConnection myConnection = new SqlConnection(Variables.CONNSTRING)) { myConnection.Open(); SqlDataReader myReader = null; SqlCommand myCommand = new SqlCommand("SELECT * FROM OpeningTimes", myConnection); myReader = myCommand.ExecuteReader(); while (myReader.Read()) { locationID = (long)myReader["LocationID"]; dayOfWeek = (int)myReader["DayOfTheWeek"]; openTime = (DateTime)myReader["OpenTime"]; closeTime = (DateTime)myReader["CloseTime"]; closed = (bool)myReader["Closed"]; openingTime = new OpeningTime(locationID, dayOfWeek, openTime, closeTime, closed); openingTimes.Add(openingTime); } return(openingTimes); } } catch (Exception ex) { throw new ApplicationException(ex.Message); } }