public void AddCustomer(IOrderCustomerModel Customer) { if (Order != null) { Order.Customers = new List <IOrderCustomerModel>(); Customer.CustomerNum = Order.OrderNum; Customer.OrderNum = Order.OrderNum; Order.Customers.Add(Customer); } }
public async Task Create(IOrderModel order) { int CustomerNum = 0; string CustomerName = ""; string CustomerAddress = ""; string CustomerCity = ""; string CustomerState = ""; string CustomerZip = ""; if (order.Customers.Count > 0) { IOrderCustomerModel customer = order.Customers[0]; CustomerNum = customer.CustomerNum; CustomerName = customer.CustomerName; CustomerAddress = customer.CustomerAddress; CustomerCity = customer.CustomerCity; CustomerState = customer.CustomerState; CustomerZip = customer.CustomerZip; } var p = new DynamicParameters(); p.Add("OrderNum", order.OrderNum); p.Add("TimeCreated", order.TimeCreated); p.Add("LocationCreated", order.LocationCreated); p.Add("BeforeTax", order.BeforeTax); p.Add("Tax", order.Tax); p.Add("Shipping", order.Shipping); p.Add("Tip", order.Tip); p.Add("Total", order.Total); p.Add("IsTestObject", order.IsTestObject); p.Add("CustomerNum", CustomerNum); p.Add("CustomerName", CustomerName); p.Add("CustomerAddress", CustomerAddress); p.Add("CustomerCity", CustomerCity); p.Add("CustomerState", CustomerState); p.Add("CustomerZip", CustomerZip); p.Add("Id", dbType: DbType.Int32, direction: ParameterDirection.Output); await _dataAccess.SaveData("dbo.spOrder_CreateCust", p, "SQLDB"); var OrderId = p.Get <int>("Id"); //_logger.LogInformation("Save Order Return ID of {OrderId} for OrderNum of {OrderNum}", OrderId, order.OrderNum); // loop though items foreach (IOrderItemModel item in order.OrderItems) { var pi = new DynamicParameters(); pi.Add("ItemNum", item.ItemNum); pi.Add("Quantity", item.Quantity); pi.Add("CategoryNum", item.CategoryNum); pi.Add("OrderNum", item.OrderNum); pi.Add("OrderId", OrderId); pi.Add("Id", dbType: DbType.Int32, direction: ParameterDirection.Output); ; await _dataAccess.SaveData("dbo.spOrderItem_Create", pi, "SQLDB"); var Id = pi.Get <int>("Id"); //_logger.LogInformation("Save Item Return ID of {Id} for ItemNum of {ItemNum}", Id, item.ItemNum); } }