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