public ActionResult Index(int content)
{
var menuTimes = Helpers.MenuContentHelper.menuTimes(content);
if (menuTimes.success)
{
MenuTimeModel menuTime = menuTimes.menuTime;
ViewData["MondayOpen"] = menuTime.MondayOpen;
ViewData["TuesdayOpen"] = menuTime.TuesdayOpen;
ViewData["WednesdayOpen"] = menuTime.WednesdayOpen;
ViewData["ThursdayOpen"] = menuTime.ThursdayOpen;
ViewData["FridayOpen"] = menuTime.FridayOpen;
ViewData["SaturdayOpen"] = menuTime.SaturdayOpen;
ViewData["SundayOpen"] = menuTime.SundayOpen;
ViewData["MondayClose"] = menuTime.MondayClose;
ViewData["TuesdayClose"] = menuTime.TuesdayClose;
ViewData["WednesdayClose"] = menuTime.WednesdayClose;
ViewData["ThursdayClose"] = menuTime.ThursdayClose;
ViewData["FridayClose"] = menuTime.FridayClose;
ViewData["SaturdayClose"] = menuTime.SaturdayClose;
ViewData["SundayClose"] = menuTime.SundayClose;
}
ViewData["menuID"] = content;
return(View());
}
/// <summary>
/// Gets open times of a menu
/// </summary>
/// <returns>returns open time object and whether or not the menu is currently open</returns>
internal static (bool success, MenuTimeModel menuTime, bool isOpen) menuTimes(int menuID)
{
MySqlConnection connection = new MySqlConnection(Helpers.ConfigHelper.connectionString);
try
{
connection.Open();
string query = "CALL getOpenTimes(@menuID)";
MySqlCommand command = new MySqlCommand(query, connection);
command.Parameters.AddWithValue("@menuID", menuID);
MySqlDataReader reader = command.ExecuteReader();
MenuTimeModel menuTime = new MenuTimeModel();
while (reader.Read())
{
menuTime.MondayOpen = TimeSpan.Parse(Convert.ToString(reader["MondayOpen"]));
menuTime.TuesdayOpen = TimeSpan.Parse(Convert.ToString(reader["TuesdayOpen"]));
menuTime.WednesdayOpen = TimeSpan.Parse(Convert.ToString(reader["WednesdayOpen"]));
menuTime.ThursdayOpen = TimeSpan.Parse(Convert.ToString(reader["ThursdayOpen"]));
menuTime.FridayOpen = TimeSpan.Parse(Convert.ToString(reader["FridayOpen"]));
menuTime.SaturdayOpen = TimeSpan.Parse(Convert.ToString(reader["SaturdayOpen"]));
menuTime.SundayOpen = TimeSpan.Parse(Convert.ToString(reader["SundayOpen"]));
menuTime.MondayClose = TimeSpan.Parse(Convert.ToString(reader["MondayClose"]));
menuTime.TuesdayClose = TimeSpan.Parse(Convert.ToString(reader["TuesdayClose"]));
menuTime.WednesdayClose = TimeSpan.Parse(Convert.ToString(reader["WednesdayClose"]));
menuTime.ThursdayClose = TimeSpan.Parse(Convert.ToString(reader["ThursdayClose"]));
menuTime.FridayClose = TimeSpan.Parse(Convert.ToString(reader["FridayClose"]));
menuTime.SaturdayClose = TimeSpan.Parse(Convert.ToString(reader["SaturdayClose"]));
menuTime.SundayClose = TimeSpan.Parse(Convert.ToString(reader["SundayClose"]));
}
connection.Close();
//is menu open
bool isOpen = false;
DateTime now = DateTime.Now;
TimeSpan nowTimeSpan = new TimeSpan(DateTime.Now.Hour, DateTime.Now.Minute, 0);
if (now.DayOfWeek == DayOfWeek.Monday)
{
if (menuTime.MondayOpen < nowTimeSpan && menuTime.MondayClose > nowTimeSpan)
{
isOpen = true;
}
}
else if (now.DayOfWeek == DayOfWeek.Tuesday)
{
if (menuTime.TuesdayOpen < nowTimeSpan && menuTime.TuesdayClose > nowTimeSpan)
{
isOpen = true;
}
}
else if (now.DayOfWeek == DayOfWeek.Wednesday)
{
if (menuTime.WednesdayOpen < nowTimeSpan && menuTime.WednesdayClose > nowTimeSpan)
{
isOpen = true;
}
}
else if (now.DayOfWeek == DayOfWeek.Thursday)
{
if (menuTime.ThursdayOpen < nowTimeSpan && menuTime.ThursdayClose > nowTimeSpan)
{
isOpen = true;
}
}
else if (now.DayOfWeek == DayOfWeek.Friday)
{
if (menuTime.FridayOpen < nowTimeSpan && menuTime.FridayClose > nowTimeSpan)
{
isOpen = true;
}
}
else if (now.DayOfWeek == DayOfWeek.Saturday)
{
if (menuTime.SaturdayOpen < nowTimeSpan && menuTime.SaturdayClose > nowTimeSpan)
{
isOpen = true;
}
}
else if (now.DayOfWeek == DayOfWeek.Sunday)
{
if (menuTime.SundayOpen < nowTimeSpan && menuTime.SundayClose > nowTimeSpan)
{
isOpen = true;
}
}
return(true, menuTime, isOpen);
}
catch (MySqlException ex)
{
connection.Close();
return(false, null, false);
}
}
