// GET: /OrderHeader/Delete/<id>
public ActionResult Delete(
Int32?OrderId
)
{
if (
OrderId == null
)
{
return(new HttpStatusCodeResult(HttpStatusCode.BadRequest));
}
dtOurCustomer = OrderHeader_OurCustomerData.SelectAll();
dtCustomer = OrderHeader_CustomerData.SelectAll();
OrderHeader OrderHeader = new OrderHeader();
OrderHeader.OrderId = System.Convert.ToInt32(OrderId);
OrderHeader = OrderHeaderData.Select_Record(OrderHeader);
OrderHeader.OurCustomer = new OurCustomer()
{
UserId = (Int32)OrderHeader.UserId
};
OrderHeader.Customer = new Customer()
{
CustomerId = (Int32)OrderHeader.CustomerId
};
if (OrderHeader == null)
{
return(HttpNotFound());
}
return(View(OrderHeader));
}
// GET: /OrderHeader/Edit/<id>
public ActionResult Edit(
Int32?OrderId
)
{
if (
OrderId == null
)
{
return(new HttpStatusCodeResult(HttpStatusCode.BadRequest));
}
OrderHeader OrderHeader = new OrderHeader();
OrderHeader.OrderId = System.Convert.ToInt32(OrderId);
OrderHeader = OrderHeaderData.Select_Record(OrderHeader);
if (OrderHeader == null)
{
return(HttpNotFound());
}
// ComboBox
ViewData["UserId"] = new SelectList(OrderHeader_OurCustomerData.List(), "UserId", "UserId", OrderHeader.UserId);
ViewData["CustomerId"] = new SelectList(OrderHeader_CustomerData.List(), "CustomerId", "CustomerId", OrderHeader.CustomerId);
return(View(OrderHeader));
}
public ActionResult Create([Bind(Include =
"UserId"
+ "," + "OrderDate"
+ "," + "CustomerId"
+ "," + "OrderTotal"
+ "," + "SalesTax"
+ "," + "SalesTaxCode"
+ "," + "ShippingCharge"
+ "," + "QbUpdated"
+ "," + "SalesTaxAmt"
+ "," + "DiscountAmount"
+ "," + "Status"
+ "," + "bTestOrder"
)] OrderHeader OrderHeader)
{
if (ModelState.IsValid)
{
bool bSucess = false;
bSucess = OrderHeaderData.Add(OrderHeader);
if (bSucess == true)
{
return(RedirectToAction("Index"));
}
else
{
ModelState.AddModelError("", "Can Not Insert");
}
}
// ComboBox
ViewData["UserId"] = new SelectList(OrderHeader_OurCustomerData.List(), "UserId", "UserId", OrderHeader.UserId);
ViewData["CustomerId"] = new SelectList(OrderHeader_CustomerData.List(), "CustomerId", "CustomerId", OrderHeader.CustomerId);
return(View(OrderHeader));
}
// GET: /OrderHeader/Create
public ActionResult Create()
{
// ComboBox
ViewData["UserId"] = new SelectList(OrderHeader_OurCustomerData.List(), "UserId", "UserId");
ViewData["CustomerId"] = new SelectList(OrderHeader_CustomerData.List(), "CustomerId", "CustomerId");
return(View());
}
public ActionResult Edit([Bind(Include =
" OrderId"
+ ",UserId"
+ ",OrderDate"
+ ",CustomerId"
+ ",OrderTotal"
+ ",SalesTax"
+ ",SalesTaxCode"
+ ",ShippingCharge"
+ ",QbUpdated"
+ ",SalesTaxAmt"
+ ",DiscountAmount"
+ ",Status"
+ ",bTestOrder"
)] OrderHeader OrderHeader)
{
OrderHeader oOrderHeader = new OrderHeader();
oOrderHeader.OrderId = System.Convert.ToInt32(OrderHeader.OrderId);
oOrderHeader = OrderHeaderData.Select_Record(OrderHeader);
if (ModelState.IsValid)
{
bool bSucess = false;
bSucess = OrderHeaderData.Update(oOrderHeader, OrderHeader);
if (bSucess == true)
{
return(RedirectToAction("Index"));
}
else
{
ModelState.AddModelError("", "Can Not Update");
}
}
// ComboBox
ViewData["UserId"] = new SelectList(OrderHeader_OurCustomerData.List(), "UserId", "UserId", OrderHeader.UserId);
ViewData["CustomerId"] = new SelectList(OrderHeader_CustomerData.List(), "CustomerId", "CustomerId", OrderHeader.CustomerId);
return(View(OrderHeader));
}
// GET: /OrderHeader/
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 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["OrderIdSortParm"] = sortOrder == "OrderId_asc" ? "OrderId_desc" : "OrderId_asc";
ViewData["UserIdSortParm"] = sortOrder == "UserId_asc" ? "UserId_desc" : "UserId_asc";
ViewData["OrderDateSortParm"] = sortOrder == "OrderDate_asc" ? "OrderDate_desc" : "OrderDate_asc";
ViewData["CustomerIdSortParm"] = sortOrder == "CustomerId_asc" ? "CustomerId_desc" : "CustomerId_asc";
ViewData["OrderTotalSortParm"] = sortOrder == "OrderTotal_asc" ? "OrderTotal_desc" : "OrderTotal_asc";
ViewData["SalesTaxSortParm"] = sortOrder == "SalesTax_asc" ? "SalesTax_desc" : "SalesTax_asc";
ViewData["SalesTaxCodeSortParm"] = sortOrder == "SalesTaxCode_asc" ? "SalesTaxCode_desc" : "SalesTaxCode_asc";
ViewData["ShippingChargeSortParm"] = sortOrder == "ShippingCharge_asc" ? "ShippingCharge_desc" : "ShippingCharge_asc";
ViewData["QbUpdatedSortParm"] = sortOrder == "QbUpdated_asc" ? "QbUpdated_desc" : "QbUpdated_asc";
ViewData["SalesTaxAmtSortParm"] = sortOrder == "SalesTaxAmt_asc" ? "SalesTaxAmt_desc" : "SalesTaxAmt_asc";
ViewData["DiscountAmountSortParm"] = sortOrder == "DiscountAmount_asc" ? "DiscountAmount_desc" : "DiscountAmount_asc";
ViewData["StatusSortParm"] = sortOrder == "Status_asc" ? "Status_desc" : "Status_asc";
ViewData["bTestOrderSortParm"] = sortOrder == "bTestOrder_asc" ? "bTestOrder_desc" : "bTestOrder_asc";
dtOrderHeader = OrderHeaderData.SelectAll();
dtOurCustomer = OrderHeader_OurCustomerData.SelectAll();
dtCustomer = OrderHeader_CustomerData.SelectAll();
try
{
if (!string.IsNullOrEmpty(Convert.ToString(Session["SearchField"])) & !string.IsNullOrEmpty(Convert.ToString(Session["SearchCondition"])) & !string.IsNullOrEmpty(Convert.ToString(Session["SearchText"])))
{
dtOrderHeader = OrderHeaderData.Search(Convert.ToString(Session["SearchField"]), Convert.ToString(Session["SearchCondition"]), Convert.ToString(Session["SearchText"]));
}
}
catch { }
var Query = from rowOrderHeader in dtOrderHeader.AsEnumerable()
join rowOurCustomer in dtOurCustomer.AsEnumerable() on rowOrderHeader.Field <Int32>("UserId") equals rowOurCustomer.Field <Int32>("UserId")
join rowCustomer in dtCustomer.AsEnumerable() on rowOrderHeader.Field <Int32?>("CustomerId") equals rowCustomer.Field <Int32>("CustomerId")
select new OrderHeader()
{
OrderId = rowOrderHeader.Field <Int32>("OrderId")
,
OurCustomer = new OurCustomer()
{
UserId = rowOurCustomer.Field <Int32>("UserId")
}
, OrderDate = rowOrderHeader.Field <DateTime>("OrderDate")
,
Customer = new Customer()
{
CustomerId = rowCustomer.Field <Int32>("CustomerId")
}
, OrderTotal = rowOrderHeader.Field <Decimal>("OrderTotal")
, SalesTax = rowOrderHeader.Field <Decimal>("SalesTax")
, SalesTaxCode = rowOrderHeader.Field <Int32?>("SalesTaxCode")
, ShippingCharge = rowOrderHeader.Field <Decimal>("ShippingCharge")
, QbUpdated = rowOrderHeader.Field <Boolean>("QbUpdated")
, SalesTaxAmt = rowOrderHeader.Field <Decimal?>("SalesTaxAmt")
, DiscountAmount = rowOrderHeader.Field <Decimal?>("DiscountAmount")
, Status = rowOrderHeader.Field <Byte?>("Status")
, bTestOrder = rowOrderHeader.Field <Boolean?>("bTestOrder")
};
switch (sortOrder)
{
case "OrderId_desc":
Query = Query.OrderByDescending(s => s.OrderId);
break;
case "OrderId_asc":
Query = Query.OrderBy(s => s.OrderId);
break;
case "UserId_desc":
Query = Query.OrderByDescending(s => s.OurCustomer.UserId);
break;
case "UserId_asc":
Query = Query.OrderBy(s => s.OurCustomer.UserId);
break;
case "OrderDate_desc":
Query = Query.OrderByDescending(s => s.OrderDate);
break;
case "OrderDate_asc":
Query = Query.OrderBy(s => s.OrderDate);
break;
case "CustomerId_desc":
Query = Query.OrderByDescending(s => s.Customer.CustomerId);
break;
case "CustomerId_asc":
Query = Query.OrderBy(s => s.Customer.CustomerId);
break;
case "OrderTotal_desc":
Query = Query.OrderByDescending(s => s.OrderTotal);
break;
case "OrderTotal_asc":
Query = Query.OrderBy(s => s.OrderTotal);
break;
case "SalesTax_desc":
Query = Query.OrderByDescending(s => s.SalesTax);
break;
case "SalesTax_asc":
Query = Query.OrderBy(s => s.SalesTax);
break;
case "SalesTaxCode_desc":
Query = Query.OrderByDescending(s => s.SalesTaxCode);
break;
case "SalesTaxCode_asc":
Query = Query.OrderBy(s => s.SalesTaxCode);
break;
case "ShippingCharge_desc":
Query = Query.OrderByDescending(s => s.ShippingCharge);
break;
case "ShippingCharge_asc":
Query = Query.OrderBy(s => s.ShippingCharge);
break;
case "QbUpdated_desc":
Query = Query.OrderByDescending(s => s.QbUpdated);
break;
case "QbUpdated_asc":
Query = Query.OrderBy(s => s.QbUpdated);
break;
case "SalesTaxAmt_desc":
Query = Query.OrderByDescending(s => s.SalesTaxAmt);
break;
case "SalesTaxAmt_asc":
Query = Query.OrderBy(s => s.SalesTaxAmt);
break;
case "DiscountAmount_desc":
Query = Query.OrderByDescending(s => s.DiscountAmount);
break;
case "DiscountAmount_asc":
Query = Query.OrderBy(s => s.DiscountAmount);
break;
case "Status_desc":
Query = Query.OrderByDescending(s => s.Status);
break;
case "Status_asc":
Query = Query.OrderBy(s => s.Status);
break;
case "bTestOrder_desc":
Query = Query.OrderByDescending(s => s.bTestOrder);
break;
case "bTestOrder_asc":
Query = Query.OrderBy(s => s.bTestOrder);
break;
default: // Name ascending
Query = Query.OrderBy(s => s.OrderId);
break;
}
if (command == "Export")
{
GridView gv = new GridView();
DataTable dt = new DataTable();
dt.Columns.Add("Order Id", typeof(string));
dt.Columns.Add("User Id", typeof(string));
dt.Columns.Add("Order Date", typeof(string));
dt.Columns.Add("Customer Id", typeof(string));
dt.Columns.Add("Order Total", typeof(string));
dt.Columns.Add("Sales Tax", typeof(string));
dt.Columns.Add("Sales Tax Code", typeof(string));
dt.Columns.Add("Shipping Charge", typeof(string));
dt.Columns.Add("Qb Updated", typeof(string));
dt.Columns.Add("Sales Tax Amt", typeof(string));
dt.Columns.Add("Discount Amount", typeof(string));
dt.Columns.Add("Status", typeof(string));
dt.Columns.Add("B Test Order", typeof(string));
foreach (var item in Query)
{
dt.Rows.Add(
item.OrderId
, item.OurCustomer.UserId
, item.OrderDate
, item.Customer.CustomerId
, item.OrderTotal
, item.SalesTax
, item.SalesTaxCode
, item.ShippingCharge
, item.QbUpdated
, item.SalesTaxAmt
, item.DiscountAmount
, item.Status
, item.bTestOrder
);
}
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))));
}
