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