Пример #1
0
        // GET: /OrderDetail/Delete/<id>
        public ActionResult Delete(
            Int32?OrderDetailId
            )
        {
            if (
                OrderDetailId == null
                )
            {
                return(new HttpStatusCodeResult(HttpStatusCode.BadRequest));
            }

            dtOrderHeader = OrderDetail_OrderHeaderData.SelectAll();
            dtCatalogItem = OrderDetail_CatalogItemData.SelectAll();

            OrderDetail OrderDetail = new OrderDetail();

            OrderDetail.OrderDetailId = System.Convert.ToInt32(OrderDetailId);
            OrderDetail             = OrderDetailData.Select_Record(OrderDetail);
            OrderDetail.OrderHeader = new OrderHeader()
            {
                OrderId = (Int32)OrderDetail.OrderId
            };
            OrderDetail.CatalogItem = new CatalogItem()
            {
                CatalogItemId = (Int32)OrderDetail.CatalogItemId
            };

            if (OrderDetail == null)
            {
                return(HttpNotFound());
            }
            return(View(OrderDetail));
        }
Пример #2
0
        public ActionResult Edit([Bind(Include =
                                           " OrderDetailId"
                                           + ",OrderId"
                                           + ",Quantity"
                                           + ",CatalogItemId"
                                           + ",Price"
                                           + ",SpecialInstructions"
                                           + ",DiscountPercent"
                                       )] OrderDetail OrderDetail)
        {
            OrderDetail oOrderDetail = new OrderDetail();

            oOrderDetail.OrderDetailId = System.Convert.ToInt32(OrderDetail.OrderDetailId);
            oOrderDetail = OrderDetailData.Select_Record(OrderDetail);

            if (ModelState.IsValid)
            {
                bool bSucess = false;
                bSucess = OrderDetailData.Update(oOrderDetail, OrderDetail);
                if (bSucess == true)
                {
                    return(RedirectToAction("Index"));
                }
                else
                {
                    ModelState.AddModelError("", "Can Not Update");
                }
            }
            // ComboBox
            ViewData["OrderId"]       = new SelectList(OrderDetail_OrderHeaderData.List(), "OrderId", "OrderId", OrderDetail.OrderId);
            ViewData["CatalogItemId"] = new SelectList(OrderDetail_CatalogItemData.List(), "CatalogItemId", "CatalogItemId", OrderDetail.CatalogItemId);

            return(View(OrderDetail));
        }
Пример #3
0
        // GET: /OrderDetail/Edit/<id>
        public ActionResult Edit(
            Int32?OrderDetailId
            )
        {
            if (
                OrderDetailId == null
                )
            {
                return(new HttpStatusCodeResult(HttpStatusCode.BadRequest));
            }

            OrderDetail OrderDetail = new OrderDetail();

            OrderDetail.OrderDetailId = System.Convert.ToInt32(OrderDetailId);
            OrderDetail = OrderDetailData.Select_Record(OrderDetail);

            if (OrderDetail == null)
            {
                return(HttpNotFound());
            }
            // ComboBox
            ViewData["OrderId"]       = new SelectList(OrderDetail_OrderHeaderData.List(), "OrderId", "OrderId", OrderDetail.OrderId);
            ViewData["CatalogItemId"] = new SelectList(OrderDetail_CatalogItemData.List(), "CatalogItemId", "CatalogItemId", OrderDetail.CatalogItemId);

            return(View(OrderDetail));
        }
Пример #4
0
        public ActionResult Create([Bind(Include =
                                             "OrderId"
                                             + "," + "Quantity"
                                             + "," + "CatalogItemId"
                                             + "," + "Price"
                                             + "," + "SpecialInstructions"
                                             + "," + "DiscountPercent"
                                         )] OrderDetail OrderDetail)
        {
            if (ModelState.IsValid)
            {
                bool bSucess = false;
                bSucess = OrderDetailData.Add(OrderDetail);
                if (bSucess == true)
                {
                    return(RedirectToAction("Index"));
                }
                else
                {
                    ModelState.AddModelError("", "Can Not Insert");
                }
            }
            // ComboBox
            ViewData["OrderId"]       = new SelectList(OrderDetail_OrderHeaderData.List(), "OrderId", "OrderId", OrderDetail.OrderId);
            ViewData["CatalogItemId"] = new SelectList(OrderDetail_CatalogItemData.List(), "CatalogItemId", "CatalogItemId", OrderDetail.CatalogItemId);

            return(View(OrderDetail));
        }
Пример #5
0
        // GET: /OrderDetail/Create
        public ActionResult Create()
        {
            // ComboBox
            ViewData["OrderId"]       = new SelectList(OrderDetail_OrderHeaderData.List(), "OrderId", "OrderId");
            ViewData["CatalogItemId"] = new SelectList(OrderDetail_CatalogItemData.List(), "CatalogItemId", "CatalogItemId");

            return(View());
        }
Пример #6
0
        // GET: /OrderDetail/
        public ActionResult Index(string sortOrder,
                                  String SearchField,
                                  String SearchCondition,
                                  String SearchText,
                                  String Export,
                                  int?PageSize,
                                  int?page,
                                  string command)
        {
            if (command == "Show All")
            {
                SearchField                = null;
                SearchCondition            = null;
                SearchText                 = null;
                Session["SearchField"]     = null;
                Session["SearchCondition"] = null;
                Session["SearchText"]      = null;
            }
            else if (command == "Add New Record")
            {
                return(RedirectToAction("Create"));
            }
            else if (command == "Export")
            {
                Session["Export"] = Export;
            }
            else if (command == "Search" | command == "Page Size")
            {
                if (!string.IsNullOrEmpty(SearchText))
                {
                    Session["SearchField"]     = SearchField;
                    Session["SearchCondition"] = SearchCondition;
                    Session["SearchText"]      = SearchText;
                }
            }
            if (command == "Page Size")
            {
                Session["PageSize"] = PageSize;
            }

            ViewData["SearchFields"]     = GetFields((Session["SearchField"] == null ? "Order Detail Id" : Convert.ToString(Session["SearchField"])));
            ViewData["SearchConditions"] = Library.GetConditions((Session["SearchCondition"] == null ? "Contains" : Convert.ToString(Session["SearchCondition"])));
            ViewData["SearchText"]       = Session["SearchText"];
            ViewData["Exports"]          = Library.GetExports((Session["Export"] == null ? "Pdf" : Convert.ToString(Session["Export"])));
            ViewData["PageSizes"]        = Library.GetPageSizes();

            ViewData["CurrentSort"]                 = sortOrder;
            ViewData["OrderDetailIdSortParm"]       = sortOrder == "OrderDetailId_asc" ? "OrderDetailId_desc" : "OrderDetailId_asc";
            ViewData["OrderIdSortParm"]             = sortOrder == "OrderId_asc" ? "OrderId_desc" : "OrderId_asc";
            ViewData["QuantitySortParm"]            = sortOrder == "Quantity_asc" ? "Quantity_desc" : "Quantity_asc";
            ViewData["CatalogItemIdSortParm"]       = sortOrder == "CatalogItemId_asc" ? "CatalogItemId_desc" : "CatalogItemId_asc";
            ViewData["PriceSortParm"]               = sortOrder == "Price_asc" ? "Price_desc" : "Price_asc";
            ViewData["SpecialInstructionsSortParm"] = sortOrder == "SpecialInstructions_asc" ? "SpecialInstructions_desc" : "SpecialInstructions_asc";
            ViewData["DiscountPercentSortParm"]     = sortOrder == "DiscountPercent_asc" ? "DiscountPercent_desc" : "DiscountPercent_asc";

            dtOrderDetail = OrderDetailData.SelectAll();
            dtOrderHeader = OrderDetail_OrderHeaderData.SelectAll();
            dtCatalogItem = OrderDetail_CatalogItemData.SelectAll();

            try
            {
                if (!string.IsNullOrEmpty(Convert.ToString(Session["SearchField"])) & !string.IsNullOrEmpty(Convert.ToString(Session["SearchCondition"])) & !string.IsNullOrEmpty(Convert.ToString(Session["SearchText"])))
                {
                    dtOrderDetail = OrderDetailData.Search(Convert.ToString(Session["SearchField"]), Convert.ToString(Session["SearchCondition"]), Convert.ToString(Session["SearchText"]));
                }
            }
            catch { }

            var Query = from rowOrderDetail in dtOrderDetail.AsEnumerable()
                        join rowOrderHeader in dtOrderHeader.AsEnumerable() on rowOrderDetail.Field <Int32>("OrderId") equals rowOrderHeader.Field <Int32>("OrderId")
                        join rowCatalogItem in dtCatalogItem.AsEnumerable() on rowOrderDetail.Field <Int32>("CatalogItemId") equals rowCatalogItem.Field <Int32>("CatalogItemId")
                        select new OrderDetail()
            {
                OrderDetailId = rowOrderDetail.Field <Int32>("OrderDetailId")
                ,
                OrderHeader = new OrderHeader()
                {
                    OrderId = rowOrderHeader.Field <Int32>("OrderId")
                }
                , Quantity = rowOrderDetail.Field <Decimal>("Quantity")
                ,
                CatalogItem = new CatalogItem()
                {
                    CatalogItemId = rowCatalogItem.Field <Int32>("CatalogItemId")
                }
                , Price = rowOrderDetail.Field <Decimal>("Price")
                , SpecialInstructions = rowOrderDetail.Field <String>("SpecialInstructions")
                , DiscountPercent     = rowOrderDetail.Field <Byte>("DiscountPercent")
            };

            switch (sortOrder)
            {
            case "OrderDetailId_desc":
                Query = Query.OrderByDescending(s => s.OrderDetailId);
                break;

            case "OrderDetailId_asc":
                Query = Query.OrderBy(s => s.OrderDetailId);
                break;

            case "OrderId_desc":
                Query = Query.OrderByDescending(s => s.OrderHeader.OrderId);
                break;

            case "OrderId_asc":
                Query = Query.OrderBy(s => s.OrderHeader.OrderId);
                break;

            case "Quantity_desc":
                Query = Query.OrderByDescending(s => s.Quantity);
                break;

            case "Quantity_asc":
                Query = Query.OrderBy(s => s.Quantity);
                break;

            case "CatalogItemId_desc":
                Query = Query.OrderByDescending(s => s.CatalogItem.CatalogItemId);
                break;

            case "CatalogItemId_asc":
                Query = Query.OrderBy(s => s.CatalogItem.CatalogItemId);
                break;

            case "Price_desc":
                Query = Query.OrderByDescending(s => s.Price);
                break;

            case "Price_asc":
                Query = Query.OrderBy(s => s.Price);
                break;

            case "SpecialInstructions_desc":
                Query = Query.OrderByDescending(s => s.SpecialInstructions);
                break;

            case "SpecialInstructions_asc":
                Query = Query.OrderBy(s => s.SpecialInstructions);
                break;

            case "DiscountPercent_desc":
                Query = Query.OrderByDescending(s => s.DiscountPercent);
                break;

            case "DiscountPercent_asc":
                Query = Query.OrderBy(s => s.DiscountPercent);
                break;

            default:      // Name ascending
                Query = Query.OrderBy(s => s.OrderDetailId);
                break;
            }

            if (command == "Export")
            {
                GridView  gv = new GridView();
                DataTable dt = new DataTable();
                dt.Columns.Add("Order Detail Id", typeof(string));
                dt.Columns.Add("Order Id", typeof(string));
                dt.Columns.Add("Quantity", typeof(string));
                dt.Columns.Add("Catalog Item Id", typeof(string));
                dt.Columns.Add("Price", typeof(string));
                dt.Columns.Add("Special Instructions", typeof(string));
                dt.Columns.Add("Discount Percent", typeof(string));
                foreach (var item in Query)
                {
                    dt.Rows.Add(
                        item.OrderDetailId
                        , item.OrderHeader.OrderId
                        , item.Quantity
                        , item.CatalogItem.CatalogItemId
                        , item.Price
                        , item.SpecialInstructions
                        , item.DiscountPercent
                        );
                }
                gv.DataSource = dt;
                gv.DataBind();
                ExportData(Export, gv, dt);
            }

            int pageNumber = (page ?? 1);
            int?pageSZ     = (Convert.ToInt32(Session["PageSize"]) == 0 ? 5 : Convert.ToInt32(Session["PageSize"]));

            return(View(Query.ToPagedList(pageNumber, (pageSZ ?? 5))));
        }