private void GetCustomerIdForOrderHead(OrderHead orderhead)
{
var existingCustomer = DoesCustomerExist();
if (existingCustomer)
{
orderhead.CustomerID = GetCustomerIdByEmail();
}
else
{
var cust = new Customer()
{
FirstName = tbFirstName.Text,
LastName = tbLastname.Text,
SSN = ValidSsn,
Street = tbStreet.Text,
Zip = tbZip.Text.Replace(" ", ""),
City = tbCity.Text,
Country = ddlCountry.SelectedValue,
Email = tbEmail.Text,
Phone = tbPhone.Text,
};
db.Customers.InsertOnSubmit(cust);
db.SubmitChanges();
orderhead.CustomerID = cust.CustomerID;
}
}
private void SaveOrderToDb()
{
var orderhead = new OrderHead();
GetCustomerIdForOrderHead(orderhead);
orderhead.UniqueOrderID = GetUniqueOrderId();
GetCustomerInfoForOrderhead(orderhead);
GetOrderInfoForOrderhead(orderhead);
db.OrderHeads.InsertOnSubmit(orderhead);
db.SubmitChanges();
GetAndAddOrderrowsToOrderhead(orderhead);
}
private void GetOrderInfoForOrderhead(OrderHead orderhead)
{
orderhead.TotalCost = decimal.Parse(CartTotalCost, CultureInfo.InvariantCulture);
orderhead.SubTotal = SubTotal;
orderhead.TotalAmountOfProducts = int.Parse(CartTotalItems);
orderhead.IsOrderValid = ValidOrder;
orderhead.OrderDate = DateTime.Now;
}
private void GetCustomerInfoForOrderhead(OrderHead orderhead)
{
orderhead.FirstName = tbFirstName.Text;
orderhead.LastName = tbLastname.Text;
orderhead.SSN = ValidSsn;
orderhead.Street = tbStreet.Text;
orderhead.Zip = tbZip.Text;
orderhead.City = tbCity.Text;
orderhead.Country = ddlCountry.SelectedValue;
orderhead.Email = tbEmail.Text;
orderhead.Phone = tbPhone.Text;
}
private void GetAndAddOrderrowsToOrderhead(OrderHead orderhead)
{
var sessionOrderrow = CartManger.Items;
foreach (var cartItem in sessionOrderrow)
{
var orderrow = new OrderRow();
orderrow.OrderHeadID = orderhead.OrderHeadID;
orderrow.ProductID = cartItem.ProductID;
orderrow.Quantity = cartItem.Quantity;
orderrow.ProductName = cartItem.ProductName;
orderrow.ProductNumber = (db.Products
.Where(p => p.ProductID == cartItem.ProductID)
.Select(p => p.ProductNumber)).FirstOrDefault();
orderrow.ProductPrice = cartItem.ProductPrice;
db.OrderRows.InsertOnSubmit(orderrow);
db.SubmitChanges();
}
}
private void detach_OrderHeads(OrderHead entity)
{
this.SendPropertyChanging();
entity.Customer = null;
}
partial void DeleteOrderHead(OrderHead instance);
partial void UpdateOrderHead(OrderHead instance);
partial void InsertOrderHead(OrderHead instance);
