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