private static DateTime GetOrderTimeLimit(int excursionId, DateTime dateFrom, ExcursionReservationLanguage lang)
{
int defStopSale = -1 * Convert.ToInt32(ConfigurationManager.AppSettings["timelimit_default_stopsale_hours"]) * 60;
DataSet dataset = null;
//exdetplan / stop SALE
if (lang != null)
dataset = DatabaseOperationProvider.Query("select [stopsale] from [dbo].[exdetplan] where excurs=@excursionId and language = @language ", "stops", new { excursionId = excursionId, language = lang.id });
else
dataset = DatabaseOperationProvider.Query("select [stopsale] from [dbo].[exdetplan] where excurs=@excursionId ", "stops", new { excursionId = excursionId });
if (dataset.Tables["stops"].Rows.Count > 0)
defStopSale = dataset.Tables["stops"].Rows[0].ReadInt("stopsale");
return dateFrom.AddMinutes(defStopSale);
}
private static DateTime GetOrderTimeLimit(int excursionId, DateTime dateFrom, ExcursionReservationLanguage lang)
{
int defStopSale = -1 * Convert.ToInt32(ConfigurationManager.AppSettings["timelimit_default_stopsale_hours"]) * 60;
DataSet dataset = null;
//exdetplan / stop SALE
if (lang != null)
{
dataset = DatabaseOperationProvider.Query("select [stopsale] from [dbo].[exdetplan] where excurs=@excursionId and language = @language ", "stops", new { excursionId = excursionId, language = lang.id });
}
else
{
dataset = DatabaseOperationProvider.Query("select [stopsale] from [dbo].[exdetplan] where excurs=@excursionId ", "stops", new { excursionId = excursionId });
}
if (dataset.Tables["stops"].Rows.Count > 0)
{
defStopSale = dataset.Tables["stops"].Rows[0].ReadInt("stopsale");
}
return(dateFrom.AddMinutes(defStopSale));
}