void BindReport() { Page.Validate("MealOrderGroup"); if (Page.IsValid) { DateTime startDate; bool tryStart = DateTime.TryParse(txtStartDate.Text.Trim(), out startDate); DateTime endDate; bool tryEnd = DateTime.TryParse(txtEndDate.Text.Trim(), out endDate); DateTime?searchStart = null; DateTime?searchEnd = null; if (tryStart) { searchStart = startDate; } if (tryEnd) { searchEnd = endDate.AddDays(1); } List <MOTCartItem> motItems = hccCartItem.Search_MealOrderTicketForMOT(searchStart, searchEnd) .Where(a => a.MealType == ((Enums.MealTypes)Enum.Parse(typeof(Enums.MealTypes), ddlMealTypes.SelectedValue))) .OrderBy(a => a.CartItem.ItemType).ThenBy(a => a.ItemName).ThenBy(a => a.CustomerName).ToList(); //List<MOTCartItem> motItems = Search_MealOrderTicketForMOT2(searchStart, searchEnd) // .Where(a => a.MealType == ((Enums.MealTypes)Enum.Parse(typeof(Enums.MealTypes), ddlMealTypes.SelectedValue))) // .OrderBy(a => a.CartItem.ItemType).ThenBy(a => a.ItemName).ThenBy(a => a.CustomerName).ToList(); Tuple <List <MOTCartItem>, List <MOTCartItem> > sortItems = MOTCartItem.SortOddEven(motItems); ReportViewer1.LocalReport.DataSources.Clear(); ReportViewer1.LocalReport.ReportPath = Server.MapPath("~/WebModules/Reports/MealLabels1.rdlc"); ReportDataSource rdsO = new ReportDataSource("MOT7Odds", sortItems.Item1); ReportViewer1.LocalReport.DataSources.Add(rdsO); ReportDataSource rdsE = new ReportDataSource("MOT7Evens", sortItems.Item2); ReportViewer1.LocalReport.DataSources.Add(rdsE); this.ReportViewer1.LocalReport.Refresh(); } }
public static MOTCartItem PrepareMOTCartItem(IDataReader t) { MOTCartItem _MOTCartItem = new MOTCartItem(); try { _MOTCartItem.CartItemId = Convert.ToInt32(t["CartItemID"]); _MOTCartItem.DeliveryDate = Convert.ToDateTime(t["DeliveryDate"]); _MOTCartItem.OrderNumber = string.Format("{0}-ALC", t["OrderNumber"]); _MOTCartItem.Servings = Convert.ToString(t["Quantity"]); _MOTCartItem.Quantity = Convert.ToInt32(t["Quantity"]); if (t["MEAL_MEALSIZEID"] != DBNull.Value) { int _mealSizeID = Convert.ToInt32(t["MEAL_MEALSIZEID"]); Enums.CartItemSize size = (Enums.CartItemSize)_mealSizeID; if (size == Enums.CartItemSize.NoSize) { size = Enums.CartItemSize.RegularSize; } _MOTCartItem.PortionSize = Enums.GetEnumDescription(size); } _MOTCartItem.CustomerName = Convert.ToString(t["CUSTOMERNAME"]); _MOTCartItem.ProfileName = Convert.ToString(t["ProfileName"]); _MOTCartItem.ItemName = Convert.ToString(t["NAME"]); if (t["MealTypeID"] != DBNull.Value) { int _mealTypeID = Convert.ToInt32(t["MealTypeID"]); _MOTCartItem.MealType = (Enums.MealTypes)_mealTypeID; } if (t["DefaultShippingTypeID"] != DBNull.Value) { int _delMethodID = Convert.ToInt32(t["DefaultShippingTypeID"]); _MOTCartItem.DeliveryMethod = ((Enums.DeliveryTypes)_delMethodID).ToString(); } //preferences _MOTCartItem.Preferences = hccCartItemMealPreference.GetPrefsBy(_MOTCartItem.CartItemId) .Select(a => a.Name).DefaultIfEmpty("None").Aggregate((c, d) => c + ", " + d); var CartItemID = Convert.ToInt32(t["ItemTypeID"]); _MOTCartItem.CartItem = new hccCartItem() { CartItemID = _MOTCartItem.CartItemId, ItemTypeID = CartItemID, Meal_MealSizeID = Convert.ToInt32(t["MEAL_MEALSIZEID"]) }; //sides _MOTCartItem.Sides = "None"; if (hccMenuItem.EntreeMealTypes.Contains(_MOTCartItem.MealType) && _MOTCartItem.CartItem.MealSideMenuItems.Count > 0) { _MOTCartItem.Sides = _MOTCartItem.CartItem.GetMealSideMenuItemsAsSectionString(", "); } } catch (Exception E) { } return(_MOTCartItem); }