// 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));
}
protected void btnAdd_Click(object sender, EventArgs e)
{
string _ErrorStr = "Connection not openned";
OrderTbl _OrderTbl = new OrderTbl();
OrderHeaderData _OrderHeaderData = Get_dvOrderHeaderData(false);
OrderTblData _OrderData = new OrderTblData();
// first summary data
_OrderData.CustomerId = _OrderHeaderData.CustomerID;
_OrderData.OrderDate = _OrderHeaderData.OrderDate;
_OrderData.RoastDate = _OrderHeaderData.RoastDate;
_OrderData.RequiredByDate = _OrderHeaderData.RequiredByDate;
_OrderData.ToBeDeliveredBy = Convert.ToInt32(_OrderHeaderData.ToBeDeliveredBy);
_OrderData.PurchaseOrder = _OrderHeaderData.PurchaseOrder;
_OrderData.Confirmed = _OrderHeaderData.Confirmed;
_OrderData.InvoiceDone = _OrderHeaderData.InvoiceDone;
_OrderData.Done = _OrderHeaderData.Done;
_OrderData.PurchaseOrder = _OrderHeaderData.PurchaseOrder;
_OrderData.Notes = _OrderHeaderData.Notes;
// Now line data
TrackerTools _TT = new TrackerTools();
_OrderData.ItemTypeID = Convert.ToInt32(ddlNewItemDesc.SelectedValue);
_OrderData.ItemTypeID = _TT.ChangeItemIfGroupToNextItemInGroup(_OrderData.CustomerId, _OrderData.ItemTypeID, _OrderData.RequiredByDate);
_OrderData.QuantityOrdered = Convert.ToDouble(tbxNewQuantityOrdered.Text);
_OrderData.PackagingID = Convert.ToInt32(ddlNewPackaging.SelectedValue);
_ErrorStr = _OrderTbl.InsertNewOrderLine(_OrderData);
ltrlStatus.Text = (String.IsNullOrWhiteSpace(_ErrorStr) ? "Item Added" : "Error adding item: " + _ErrorStr);
HideNewOrderItemPanel();
}
private OrderHeaderData Get_dvOrderHeaderData(bool pInEditMode)
{
TrackerDotNet.control.OrderHeaderData _OrderHeader = new OrderHeaderData();
_OrderHeader.CustomerID = Convert.ToInt64(dvOrderHeaderGetDDLControlSelectedValue("ddlContacts"));
_OrderHeader.ToBeDeliveredBy = Convert.ToInt64(dvOrderHeaderGetDDLControlSelectedValue("ddlToBeDeliveredBy"));
_OrderHeader.Confirmed = dvOrderHeaderGetCheckBoxValue("cbxConfirmed");
_OrderHeader.Done = dvOrderHeaderGetCheckBoxValue("cbxDone");
string _RequiredByDate = string.Empty;
string _OrderDate = string.Empty;
string _RoastDate = string.Empty;
if (pInEditMode)
{
_OrderDate = dvOrderHeaderGetTextBoxValue("tbxOrderDate");
_RoastDate = dvOrderHeaderGetTextBoxValue("tbxRoastDate");
_RequiredByDate = dvOrderHeaderGetTextBoxValue("tbxRequiredByDate");
_OrderHeader.Notes = dvOrderHeaderGetTextBoxValue("tbxNotes");
}
else
{
_RequiredByDate = dvOrderHeaderGetLabelValue("lblRequiredByDate");
_OrderDate = dvOrderHeaderGetLabelValue("lblOrderDate");
_RoastDate = dvOrderHeaderGetLabelValue("lblRoastDate");
_OrderHeader.Notes = dvOrderHeaderGetLabelValue("lblNotes");
}
_OrderHeader.RequiredByDate = (string.IsNullOrEmpty(_RequiredByDate) ? DateTime.MinValue : Convert.ToDateTime(_RequiredByDate).Date);
_OrderHeader.OrderDate = (string.IsNullOrEmpty(_OrderDate) ? DateTime.MinValue : Convert.ToDateTime(_OrderDate).Date);
_OrderHeader.RoastDate = (string.IsNullOrEmpty(_RoastDate) ? DateTime.MinValue : Convert.ToDateTime(_RoastDate).Date);
return(_OrderHeader);
}
/// <summary>
/// Something in the header data has changed so do a generic update
/// </summary>
protected void DoHeaderUpdate()
{
List <string> _OrderIds = (List <string>)Session[CONST_ORDERLINEIDS];
//List<string> _OrderIds = new List<string>();
//DataTable _dtOrders = gvOrderLines.DataSource as DataTable;
//foreach (GridViewRow gvr in _dtOrders.Rows)
//{
// Label myOrderIDLablel = (Label)gvr.FindControl("lblOrderID"); //find contol since it is a template field
// _OrderIds.Add(myOrderIDLablel.Text);
//}
if (_OrderIds.Count > 0)
{
OrderDBAgent _myDB = new OrderDBAgent();
OrderHeaderData _OrderHeader = new OrderHeaderData();
_OrderHeader.CustomerID = Convert.ToInt64(ddlContacts.SelectedValue);
_OrderHeader.OrderDate = Convert.ToDateTime(tbxOrderDate.Text);
_OrderHeader.RoastDate = Convert.ToDateTime(tbxRoastDate.Text);
_OrderHeader.ToBeDeliveredBy = Convert.ToInt64(ddlToBeDeliveredBy.SelectedValue);
_OrderHeader.RequiredByDate = Convert.ToDateTime(tbxRequiredByDate.Text);
_OrderHeader.Confirmed = cbxConfirmed.Checked;
_OrderHeader.Done = cbxDone.Checked;
_OrderHeader.Notes = tbxNotes.Text;
_myDB.UpdateOrderHeader(_OrderHeader, _OrderIds);
}
BindRowQueryParameters();
}
// 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));
}
/// <summary>
/// From the client selected create a temporary table from the items in the order
/// Then diosplay another for for the user to select how to close the order
/// </summary>
/// <param name="sender"></param>
/// <param name="e"></param>
protected void btnOrderDelivered_Click(object sender, EventArgs e)
{
// General VARs
OrderHeaderData _OrderHeaderData = Get_dvOrderHeaderData(false);
TempOrdersData _TempOrdersData = new TempOrdersData();
TempOrdersDAL _TempOrdersDAL = new TempOrdersDAL();
// DELETE data from TempOrdersHeaderTblData
if (!_TempOrdersDAL.KillTempOrdersData())
{
ltrlStatus.Text = "Error deleting Temp Table";
}
// add parameters in the order they appear in the update command
// first summary / header data
_TempOrdersData.HeaderData.CustomerID = _OrderHeaderData.CustomerID;
_TempOrdersData.HeaderData.OrderDate = _OrderHeaderData.OrderDate;
_TempOrdersData.HeaderData.RoastDate = _OrderHeaderData.RoastDate;
_TempOrdersData.HeaderData.RequiredByDate = _OrderHeaderData.RequiredByDate;
_TempOrdersData.HeaderData.ToBeDeliveredByID = Convert.ToInt32(_OrderHeaderData.ToBeDeliveredBy);
_TempOrdersData.HeaderData.Confirmed = _OrderHeaderData.Confirmed;
_TempOrdersData.HeaderData.Done = _OrderHeaderData.Done;
_TempOrdersData.HeaderData.Notes = _OrderHeaderData.Notes;
//_TempOrdersData.HeaderData.CustomerID = Convert.ToInt32(dvOrderHeaderGetDDLControlSelectedValue("ddlContacts"));
//_TempOrdersData.HeaderData.OrderDate = Convert.ToDateTime(dvOrderHeaderGetLabelValue("lblOrderDate"));
//_TempOrdersData.HeaderData.RoastDate = Convert.ToDateTime(dvOrderHeaderGetLabelValue("lblRoastDate"));
//_TempOrdersData.HeaderData.RequiredByDate = Convert.ToDateTime(dvOrderHeaderGetLabelValue("lblRequiredByDate"));
//_TempOrdersData.HeaderData.ToBeDeliveredByID = Convert.ToInt32(dvOrderHeaderGetDDLControlSelectedValue("ddlToBeDeliveredBy"));
//_TempOrdersData.HeaderData.Confirmed = dvOrderHeaderGetCheckBoxValue("cbxConfirmed");
//_TempOrdersData.HeaderData.Done = dvOrderHeaderGetCheckBoxValue("cbxDone");
//_TempOrdersData.HeaderData.Notes = dvOrderHeaderGetLabelValue("lblNotes");
// now the line data (the TO header is set when we add both using the one class TempOrders
ItemTypeTbl _ItemType = new ItemTypeTbl();
foreach (GridViewRow _gv in gvOrderLines.Rows)
{
TempOrdersLinesTbl _LineData = new TempOrdersLinesTbl();
DropDownList _gvItemDesc = (DropDownList)_gv.FindControl("ddlItemDesc");
Label _gvItemQty = (Label)_gv.FindControl("lblQuantityOrdered");
DropDownList _gvItemPackaging = (DropDownList)_gv.FindControl("ddlPackaging");
Label _gvOrderID = (Label)_gv.FindControl("lblOrderID");
_LineData.ItemID = Convert.ToInt32(_gvItemDesc.SelectedValue);
_LineData.Qty = Convert.ToDouble(_gvItemQty.Text);
_LineData.PackagingID = Convert.ToInt32(_gvItemPackaging.SelectedValue);
_LineData.ServiceTypeID = _ItemType.GetServiceID(_LineData.ItemID);
_LineData.OriginalOrderID = Convert.ToInt64(_gvOrderID.Text);
_TempOrdersData.OrdersLines.Add(_LineData);
}
// now add all the data to the database
_TempOrdersDAL.Insert(_TempOrdersData);
// open new form with database, p
Response.Redirect("OrderDone.aspx");
}
public IEnumerable <OrderItemData> GetAll(OrderHeaderData order)
{
Log.Info("Accessing OrderItemRepo GetAll by InvoiceData function");
var pcol = new List <SqlParameter>()
{
Mapper.BuildParam("@order_key", order.OrderKey)
};
using (entity_context)
{
return(MapRows(entity_context.ExecuteProcedureAsSqlDataReader("usp_order_item_all", pcol)));
}
}
public void GetOrderByCodeTest()
{
//Arrange
var test_order = new Order()
{
OrderKey = 1, AccountKey = 1, OrderNumber = "TSTORDER0001"
};
test_order.OrderItems.Add(new OrderItem()
{
OrderItemKey = 1, OrderKey = 1, OrderItemQuantity = 1, OrderItemLineSum = 30M
});
var test_order_data = new OrderHeaderData()
{
OrderKey = 1, AccountKey = 1, OrderNum = "TSTORDER0001"
};
var test_order_item_data = new OrderItemData()
{
OrderKey = 1, OrderItemLineSum = 30M, OrderItemPricePer = 30M, OrderItemQuantity = 1
};
Mock <IOrderHeaderRepository> order_repo = new Mock <IOrderHeaderRepository>();
Mock <IOrderItemRepository> order_item_repo = new Mock <IOrderItemRepository>();
Mock <IOrderEntityService> order_es = new Mock <IOrderEntityService>();
Mock <IOrderBusinessEngine> order_be = new Mock <IOrderBusinessEngine>();
Mock <IDataRepositoryFactory> repo_factory = new Mock <IDataRepositoryFactory>();
Mock <IBusinessEngineFactory> be_factory = new Mock <IBusinessEngineFactory>();
Mock <IEntityServiceFactory> es_factory = new Mock <IEntityServiceFactory>();
Mock <IEmployeeBusinessEngine> emp_be = new Mock <IEmployeeBusinessEngine>();
Mock <IOrderStatusBusinessEngine> ord_status_be = new Mock <IOrderStatusBusinessEngine>();
order_repo.Setup(mock => mock.GetByCode(It.IsAny <string>(), It.IsAny <string>())).Returns(test_order_data);
order_be.Setup(mock => mock.GetOrderByCode(It.IsAny <string>(), It.IsAny <string>())).Returns(test_order);
order_es.Setup(mock => mock.Map(It.IsAny <OrderHeaderData>())).Returns(test_order);
//order_es.Setup(mock => mock.Map(It.IsAny<OrderItem>())).Returns(test_order_item_data);
repo_factory.Setup(mock => mock.GetDataRepository <IOrderHeaderRepository>()).Returns(order_repo.Object);
repo_factory.Setup(mock => mock.GetDataRepository <IOrderItemRepository>()).Returns(order_item_repo.Object);
be_factory.Setup(mock => mock.GetBusinessEngine <IOrderBusinessEngine>()).Returns(order_be.Object);
be_factory.Setup(mock => mock.GetBusinessEngine <IEmployeeBusinessEngine>()).Returns(emp_be.Object);
be_factory.Setup(mock => mock.GetBusinessEngine <IOrderStatusBusinessEngine>()).Returns(ord_status_be.Object);
es_factory.Setup(mock => mock.GetEntityService <IOrderEntityService>()).Returns(order_es.Object);
OrderBusinessEngine order_business_engine = new OrderBusinessEngine(repo_factory.Object, be_factory.Object, es_factory.Object);
//Act
Order ret_val = order_business_engine.GetOrderByCode("TSTORDER0001", "TEST");
//Assert
Assert.IsTrue(ret_val.OrderNumber == test_order.OrderNumber);
}
public void OrderSaveTest()
{
//Arrange
var test_order = new Order()
{
OrderKey = 1, AccountKey = 1, OrderNumber = "TSTORDER0001"
};
test_order.OrderItems.Add(new OrderItem()
{
OrderItemKey = 1, OrderKey = 1, OrderItemQuantity = 1, OrderItemLineSum = 30M
});
var test_order_data = new OrderHeaderData()
{
OrderKey = 1, AccountKey = 1, OrderNum = "TSTORDER0001"
};
var test_order_item_data = new OrderItemData()
{
OrderKey = 1, OrderItemLineSum = 30M, OrderItemPricePer = 30M, OrderItemQuantity = 1
};
var order_repo = new Mock <IOrderHeaderRepository>();
var order_item_repo = new Mock <IOrderItemRepository>();
var order_es = new Mock <IOrderEntityService>();
var order_item_es = new Mock <IOrderItemEntityService>();
var comment_be = new Mock <ICommentBusinessEngine>();
var order_be = new Mock <IOrderBusinessEngine>();
var repo_factory = new Mock <IDataRepositoryFactory>();
var be_factory = new Mock <IBusinessEngineFactory>();
var es_factory = new Mock <IEntityServiceFactory>();
order_repo.Setup(mock => mock.Save(It.IsAny <OrderHeaderData>())).Returns(1);
order_be.Setup(mock => mock.OrderSave(It.IsAny <Order>())).Returns(1);
order_es.Setup(mock => mock.Map(It.IsAny <Order>())).Returns(test_order_data);
order_es.Setup(mock => mock.Map(It.IsAny <Order>())).Returns(test_order_data);
order_item_es.Setup(mock => mock.Map(It.IsAny <OrderItem>())).Returns(test_order_item_data);
repo_factory.Setup(mock => mock.GetDataRepository <IOrderHeaderRepository>()).Returns(order_repo.Object);
repo_factory.Setup(mock => mock.GetDataRepository <IOrderItemRepository>()).Returns(order_item_repo.Object);
be_factory.Setup(mock => mock.GetBusinessEngine <IOrderBusinessEngine>()).Returns(order_be.Object);
be_factory.Setup(mock => mock.GetBusinessEngine <ICommentBusinessEngine>()).Returns(comment_be.Object);
es_factory.Setup(mock => mock.GetEntityService <IOrderEntityService>()).Returns(order_es.Object);
es_factory.Setup(mock => mock.GetEntityService <IOrderItemEntityService>()).Returns(order_item_es.Object);
OrderBusinessEngine account_business_engine = new OrderBusinessEngine(repo_factory.Object, be_factory.Object, es_factory.Object);
//Act
int ret_val = account_business_engine.OrderSave(test_order);
//Assert
Assert.IsTrue(ret_val == 1);
}
private Order Map(OrderHeaderData order_data)
{
return(ExecuteFaultHandledOperation(() =>
{
Log.Debug($"MapOrderHeaderDataToOrder AccountContactKey: {order_data.AccountContactKey}");
var order = _order_se.Map(order_data);
order.OrderStatusData = _order_status_be.GetStatusByID(order_data.OrderStatusKey);
order.AccountRep = _employee_be.GetAccountRepByKey(order_data.AccountRepKey);
order.SalesRep = _employee_be.GetSalesRepByKey(order_data.SalesRepKey);
order.OrderAccountContact = //new PersonBase()
_employee_be.GetEmployeeByID(order_data.AccountContactKey) == null ? new PersonBase() :
_employee_be.GetEmployeeByID(order_data.AccountContactKey);
return order;
}));
}
/// <summary>
/// Something in the header data has changed so do a generic update
/// </summary>
protected void DoHeaderUpdate()
{
List <string> _OrderIds = (List <string>)Session[CONST_ORDERLINEIDS];
List <int> _OrderItemIds = (List <int>)Session[CONST_ORDERLINEITEMIDS];
if (_OrderIds.Count > 0)
{
OrderDataControl _myDB = new OrderDataControl();
OrderHeaderData _OrderHeader = new OrderHeaderData();
_OrderHeader.CustomerID = Convert.ToInt64(ddlContacts.SelectedValue);
_OrderHeader.OrderDate = Convert.ToDateTime(tbxOrderDate.Text);
_OrderHeader.RoastDate = Convert.ToDateTime(tbxRoastDate.Text);
_OrderHeader.ToBeDeliveredBy = Convert.ToInt64(ddlToBeDeliveredBy.SelectedValue);
_OrderHeader.RequiredByDate = Convert.ToDateTime(tbxRequiredByDate.Text);
_OrderHeader.Confirmed = cbxConfirmed.Checked;
_OrderHeader.Done = cbxDone.Checked;
_OrderHeader.InvoiceDone = cbxInvoiceDone.Checked;
_OrderHeader.PurchaseOrder = tbxPurchaseOrder.Text;
_OrderHeader.Notes = tbxNotes.Text;
_myDB.UpdateOrderHeader(_OrderHeader, _OrderIds);
// if date has changed since item added then see if one of the items was a group item and change that date too
DateTime _OldRequiredByDate = _OrderHeader.RequiredByDate;
if (Session[OrderHeaderData.CONST_BOUNDOLDDELIVERYDATE] != null)
{
_OldRequiredByDate = ((DateTime)Session[OrderHeaderData.CONST_BOUNDOLDDELIVERYDATE]).Date;
}
if (!_OldRequiredByDate.Equals(_OrderHeader.RequiredByDate))
{
UsedItemGroupTbl _UsedItems = new UsedItemGroupTbl();
foreach (int _OrderItemId in _OrderItemIds)
{
_UsedItems.UpdateIfGroupItem(_OrderHeader.CustomerID, _OrderItemId, _OldRequiredByDate, _OrderHeader.RequiredByDate);
}
Session[OrderHeaderData.CONST_BOUNDOLDDELIVERYDATE] = _OrderHeader.RequiredByDate.Date;
}
}
BindRowQueryParameters();
}
} // Map function closer
public List <SqlParameter> MapParamsForUpsert(OrderHeaderData entity)
{
var sql_params = new List <SqlParameter>();
sql_params.Add(new SqlParameter("@order_key", entity.OrderKey));
sql_params.Add(new SqlParameter("@account_key", entity.AccountKey));
sql_params.Add(new SqlParameter("@account_contact_key", entity.AccountContactKey));
sql_params.Add(new SqlParameter("@order_num", entity.OrderNum));
sql_params.Add(new SqlParameter("@order_entry_date", entity.OrderEntryDate));
sql_params.Add(new SqlParameter("@order_status_key", entity.OrderStatusKey));
sql_params.Add(new SqlParameter("@order_status_date", entity.OrderStatusDate));
sql_params.Add(new SqlParameter("@order_ship_date", entity.OrderShipDate));
sql_params.Add(new SqlParameter("@account_rep_key", entity.AccountRepKey));
sql_params.Add(new SqlParameter("@order_complete_date", entity.OrderCompleteDate));
sql_params.Add(new SqlParameter("@order_value_sum", entity.OrderValueSum));
sql_params.Add(new SqlParameter("@order_item_count", entity.OrderItemCount));
sql_params.Add(new SqlParameter("@deliver_by_date", entity.DeliverByDate));
sql_params.Add(new SqlParameter("@sales_rep_key", entity.SalesRepKey));
sql_params.Add(GetOutParam());
return(sql_params);
}
public Order(OrderHeaderData orderData)
{
OrderKey = orderData.OrderKey;
OrderEntryDate = orderData.OrderEntryDate;
AccountKey = orderData.AccountKey;
AccountContactKey = orderData.AccountContactKey;
OrderNumber = orderData.OrderNum;
OrderCompleteDate = orderData.OrderCompleteDate;
OrderItemCount = orderData.OrderItemCount;
OrderValueSum = orderData.OrderValueSum;
OrderStatusDate = orderData.OrderStatusDate;
OrderShipDate = orderData.OrderShipDate;
OrderStatus = (QIQOOrderStatus)orderData.OrderStatusKey;
DeliverByDate = orderData.DeliverByDate;
AccountRepKey = orderData.AccountRepKey;
SalesRepKey = orderData.SalesRepKey;
AddedUserID = orderData.AuditAddUserId;
AddedDateTime = orderData.AuditAddDatetime;
UpdateUserID = orderData.AuditUpdateUserId;
UpdateDateTime = orderData.AuditUpdateDatetime;
}
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));
}
public ActionResult DeleteConfirmed(
Int32?OrderId
)
{
OrderHeader OrderHeader = new OrderHeader();
OrderHeader.OrderId = System.Convert.ToInt32(OrderId);
OrderHeader = OrderHeaderData.Select_Record(OrderHeader);
bool bSucess = false;
bSucess = OrderHeaderData.Delete(OrderHeader);
if (bSucess == true)
{
return(RedirectToAction("Index"));
}
else
{
ModelState.AddModelError("", "Can Not Delete");
}
return(null);
}
private List <OrderItem> GetOrderItemsByOrder(Order order)
{
if (order == null)
{
throw new ArgumentNullException(nameof(order));
}
var order_items = new List <OrderItem>();
var order_hdr_data = new OrderHeaderData();
order_hdr_data.OrderKey = order.OrderKey;
return(ExecuteFaultHandledOperation(() =>
{
var order_item_data = _order_item_repo.GetAll(order_hdr_data);
foreach (OrderItemData ord_item_data in order_item_data)
{
order_items.Add(MapOrderItemDataToOrderItem(ord_item_data));
}
return order_items;
}));
}
public Order Map(OrderHeaderData order_data)
{
return(new Order()
{
OrderKey = order_data.OrderKey,
OrderEntryDate = order_data.OrderEntryDate,
AccountKey = order_data.AccountKey,
AccountContactKey = order_data.AccountContactKey,
OrderNumber = order_data.OrderNum,
OrderCompleteDate = order_data.OrderCompleteDate,
OrderItemCount = order_data.OrderItemCount,
OrderValueSum = order_data.OrderValueSum,
OrderStatusDate = order_data.OrderStatusDate,
OrderShipDate = order_data.OrderShipDate,
AddedUserID = order_data.AuditAddUserId,
AddedDateTime = order_data.AuditAddDatetime,
UpdateUserID = order_data.AuditUpdateUserId,
UpdateDateTime = order_data.AuditUpdateDatetime,
OrderStatus = (QIQOOrderStatus)order_data.OrderStatusKey,
DeliverByDate = order_data.DeliverByDate,
AccountRepKey = order_data.AccountRepKey,
SalesRepKey = order_data.SalesRepKey
});
}
public Order Map(OrderHeaderData ent) => new Order(ent);
public List <SqlParameter> MapParamsForDelete(OrderHeaderData entity)
{
return(MapParamsForDelete(entity.OrderKey));
}
// 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))));
}
