public static List <MealItemReportItem> GetMenuItemsByDateRange(DateTime startDate, DateTime endDate, Boolean includeAlaCarte = true) { try { List <MealItemReportItem> retVals = new List <MealItemReportItem>(); using (TransactionScope scope = new TransactionScope()) { using (SqlConnection conn = new SqlConnection(WebConfigurationManager.ConnectionStrings["WebModules"].ConnectionString)) { using (SqlCommand cmd = new SqlCommand("hcc_MenuItemsByDateRange", conn)) { conn.Open(); SqlParameter prm1 = new SqlParameter("@start", SqlDbType.DateTime); prm1.Value = startDate; SqlParameter prm2 = new SqlParameter("@end", SqlDbType.DateTime); prm2.Value = endDate; SqlParameter prm3 = new SqlParameter("@includeAlaCarte", SqlDbType.Bit); prm3.Value = includeAlaCarte; cmd.CommandType = CommandType.StoredProcedure; cmd.Parameters.Add(prm1); cmd.Parameters.Add(prm2); cmd.Parameters.Add(prm3); SqlDataReader t = cmd.ExecuteReader(); if (t != null) { // get from reader retVals = MealItemReportItem.GetFromReader(t); } else { retVals = null; } cmd.Dispose(); conn.Close(); conn.Dispose(); } } scope.Complete(); } if (retVals != null) { return(retVals); } else { throw new Exception("GetMenuItemsByDateRange could not be returned."); } } catch { throw; } }
public static List <MealItemReportItem> GetMenuItemsByOrderNumber(string orderNumber, DateTime deliveryDate) { try { List <MealItemReportItem> retVals = null; using (TransactionScope scope = new TransactionScope()) { using (SqlConnection conn = new SqlConnection(WebConfigurationManager.ConnectionStrings["WebModules"].ConnectionString)) { using (SqlCommand cmd = new SqlCommand("hcc_MenuItemsByOrderNumber", conn)) { conn.Open(); SqlParameter prm1 = new SqlParameter("@orderNumber", SqlDbType.VarChar); prm1.Value = orderNumber; SqlParameter prm2 = new SqlParameter("@deliveryDate", SqlDbType.DateTime); prm2.Value = deliveryDate; cmd.CommandType = CommandType.StoredProcedure; cmd.Parameters.Add(prm1); cmd.Parameters.Add(prm2); SqlDataReader t = cmd.ExecuteReader(); if (t != null) { // get from reader retVals = MealItemReportItem.GetFromReader(t); } else { retVals = null; } cmd.Dispose(); conn.Close(); conn.Dispose(); } } scope.Complete(); } if (retVals != null) { return(retVals); } else { throw new Exception("GetMenuItemsByDateRange could not be returned."); } } catch { throw; } }
private static CustCalDay AgregateByDay(CustCalDay ccd, MealItemReportItem reportItem, bool init) { switch ((Enums.MealTypes)reportItem.MealTypeId) { case Enums.MealTypes.BreakfastEntree: ccd.Breakfast += AddAsEntree(reportItem); break; case Enums.MealTypes.BreakfastSide: ccd.Breakfast += AddAsSide(reportItem); break; case Enums.MealTypes.Snack: ccd.Snack += AddAsEntree(reportItem); break; case Enums.MealTypes.Dessert: ccd.Dessert += AddAsEntree(reportItem); break; case Enums.MealTypes.DinnerEntree: ccd.Dinner += AddAsEntree(reportItem); break; case Enums.MealTypes.DinnerSide: ccd.Dinner += AddAsSide(reportItem); break; case Enums.MealTypes.LunchEntree: ccd.Lunch += AddAsEntree(reportItem); break; case Enums.MealTypes.LunchSide: ccd.Lunch += AddAsSide(reportItem); break; case Enums.MealTypes.OtherEntree: case Enums.MealTypes.ChildEntree: case Enums.MealTypes.Beverage: case Enums.MealTypes.Salad: case Enums.MealTypes.Soup: case Enums.MealTypes.Supplement: case Enums.MealTypes.Goods: case Enums.MealTypes.Miscellaneous: ccd.Other += AddAsEntree(reportItem); break; case Enums.MealTypes.OtherSide: case Enums.MealTypes.ChildSide: ccd.Other += AddAsSide(reportItem); break; } return(ccd); }
private static string AddAsSide(MealItemReportItem reportItem) { var itemName = ServedWith /*link Sides to Entree*/ + reportItem.ItemName; if (!string.IsNullOrWhiteSpace(reportItem.Prefs)) { itemName += " - " + reportItem.Prefs; } return(itemName); }
private static string AddAsEntree(MealItemReportItem reportItem) { var itemName = MealDelimiter /*support several items per day*/ + reportItem.ItemName; if (!string.IsNullOrWhiteSpace(reportItem.Prefs)) { itemName += " - " + reportItem.Prefs; } return(itemName); }
public static List <MealItemReportItem> GetFromReader(SqlDataReader reader) { try { List <MealItemReportItem> retVals = new List <MealItemReportItem>(); if (reader.HasRows) { while (reader.Read()) { MealItemReportItem retVal = new MealItemReportItem(); retVal.OrderNumber = reader["OrderNumber"].ToString(); retVal.ItemName = reader["ItemName"].ToString(); retVal.MealTypeName = reader["MealTypeName"].ToString(); retVal.MealSizeName = reader["MealSizeName"].ToString(); retVal.Quantity = int.Parse(reader["Quantity"].ToString()); retVal.DayNum = int.Parse(reader["DayNum"].ToString()); retVal.Prefs = reader["Prefs"].ToString(); retVal.ParentType = reader["ParentType"].ToString(); retVal.ParentTypeId = int.Parse(reader["ParentTypeId"].ToString()); retVal.ParentId = int.Parse(reader["ParentId"].ToString()); retVal.MealTypeId = int.Parse(reader["MealTypeId"].ToString()); retVal.MenuItemId = int.Parse(reader["MenuItemId"].ToString()); retVal.MealSizeId = int.Parse(reader["MealSizeId"].ToString()); retVal.DeliveryDate = DateTime.Parse(reader["DeliveryDate"].ToString()); retVal.CartItemId = int.Parse(reader["CartItemId"].ToString()); retVal.UserProfileId = int.Parse(reader["UserProfileId"].ToString()); retVal.PlanId = int.Parse(reader["PlanId"].ToString()); retVal.PlanName = reader["PlanName"].ToString(); retVal.RowId = int.Parse(reader["RowId"].ToString()); retVal.CartId = int.Parse(reader["CartId"].ToString()); if (reader["IsFamilyStyle"].ToString() != "") { retVal.IsFamilyStyle = Convert.ToBoolean(reader["IsFamilyStyle"].ToString()); } else { retVal.IsFamilyStyle = false; } retVals.Add(retVal); } reader.Close(); } return(retVals); } catch (Exception) { throw; } }