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