public static List <MOTCartItem> Search_MealOrderTicketForMOT(DateTime?startDate, DateTime?endDate)
        {
            try
            {
                using (var cont = new healthychefEntities())
                {
                    List <MOTCartItem> motItems = new List <MOTCartItem>();

                    List <hccCartItem> alcgc = cont.hcc_OrderFulfillSearch_ALCnGC_ByRange(startDate, endDate).Select(x => new hccCartItem
                    {
                        CartItemID              = Convert.ToInt32(x.CartItemID),
                        CartID                  = Convert.ToInt32(x.CartID),
                        UserProfileID           = Convert.ToInt32(x.UserProfileID),
                        ItemTypeID              = Convert.ToInt32(x.ItemTypeID),
                        ItemName                = x.ItemName,
                        ItemDesc                = x.ItemDesc,
                        ItemPrice               = Convert.ToDecimal(x.ItemPrice),
                        Quantity                = Convert.ToInt32(x.Quantity),
                        IsTaxable               = Convert.ToBoolean(x.IsTaxable),
                        OrderNumber             = x.OrderNumber,
                        DeliveryDate            = Convert.ToDateTime(x.DeliveryDate),
                        Gift_RedeemCode         = x.Gift_RedeemCode,
                        Gift_IssuedTo           = x.Gift_IssuedTo,
                        Gift_IssuedDate         = x.Gift_IssuedDate,
                        Gift_RedeemedBy         = x.Gift_RedeemedBy,
                        Gift_RedeemedDate       = x.Gift_RedeemedDate,
                        Gift_RecipientAddressId = x.Gift_RecipientAddressId,
                        Gift_RecipientEmail     = x.Gift_RecipientEmail,
                        Gift_RecipientMessage   = x.Gift_RecipientMessage,
                        Meal_MenuItemID         = x.Meal_MenuItemID,
                        Meal_MealSizeID         = x.Meal_MealSizeID,
                        Meal_ShippingCost       = x.Meal_ShippingCost,
                        Plan_PlanID             = x.Plan_PlanID,
                        Plan_ProgramOptionID    = x.Plan_ProgramOptionID,
                        Plan_IsAutoRenew        = x.Plan_IsAutoRenew,
                        CreatedBy               = x.CreatedBy,
                        CreatedDate             = Convert.ToDateTime(x.CreatedDate),
                        IsCompleted             = Convert.ToBoolean(x.IsCompleted),
                        IsCancelled             = Convert.ToBoolean(x.IsCancelled),
                        IsFulfilled             = Convert.ToBoolean(x.IsFulfilled),
                        DiscountPerEach         = Convert.ToDecimal(x.DiscountPerEach),
                        DiscountAdjPrice        = Convert.ToDecimal(x.DiscountAdjPrice),
                        SnapBillAddrId          = x.SnapBillAddrId,
                        SnapShipAddrId          = x.SnapShipAddrId,
                        TaxRate                 = x.TaxRate,
                        TaxableAmount           = x.TaxableAmount,
                        DiscretionaryTaxAmount  = x.DiscretionaryTaxAmount,
                        TaxRateAssigned         = x.TaxRateAssigned
                    }).ToList();

                    motItems.AddRange(MOTCartItem.GetFromRange(alcgc));

                    var progs = cont.hcc_OrderFulfillSearch_Programs_ByRange(startDate, endDate).ToList();
                    motItems.AddRange(MOTCartItem.GetFromRangeForMOT(progs));

                    return(motItems.OrderBy(a => a.DeliveryDate)
                           .ThenBy(a => a.ItemName).ThenBy(a => a.OrderNumber.Contains("ALC")).ThenBy(a => a.CustomerName).ToList());
                }
            }
            catch (Exception ex)
            {
                throw ex;
            }
        }