public int Create(Person person)
{
using (var context = new AWContext())
{
BusinessEntity bs = new BusinessEntity {
rowguid = Guid.NewGuid(),
ModifiedDate = DateTime.Now
};
context.BusinessEntity.Add(bs);
context.SaveChanges();
bs.Person = new Person
{
BusinessEntityID = bs.BusinessEntityID,
PersonType = person.PersonType,
FirstName = person.FirstName,
LastName = person.LastName,
ModifiedDate = DateTime.Now,
rowguid = Guid.NewGuid()
};
int id = bs.BusinessEntityID;
context.SaveChanges();
return(id);
}
}
private void InsertAddress(ShoppingDetails shoppingDetails, int businessEntityID)
{
ShoppingAddress shoppingAddress = new ShoppingAddress();
ShoppingDetails details = shoppingAddress.Get(businessEntityID);
if (!details.Equals(shoppingDetails))
{
using (var context = new AWContext())
{
var customerAddress = new Address()
{
AddressLine1 = shoppingDetails.Address, City = shoppingDetails.City,
StateProvinceID = shoppingAddress.GetStateProvince(shoppingDetails.City, shoppingDetails.Country),
PostalCode = shoppingDetails.PostalCode, ModifiedDate = DateTime.Now,
rowguid = Guid.NewGuid()
};
if (details.Address != null) //update
{
var addressID = context.BusinessEntityAddress.SingleOrDefault(x => x.BusinessEntityID == businessEntityID).AddressID;
var result = context.Address.SingleOrDefault(x => x.AddressID == addressID);
result.AddressLine1 = customerAddress.AddressLine1;
result.City = customerAddress.City;
result.StateProvinceID = customerAddress.StateProvinceID;
result.PostalCode = customerAddress.PostalCode;
result.ModifiedDate = customerAddress.ModifiedDate;
result.rowguid = customerAddress.rowguid;
context.SaveChanges();
}
else // insert
{
var businessEntity = new BusinessEntityAddress()
{
BusinessEntityID = businessEntityID,
AddressTypeID = 1,
ModifiedDate = DateTime.Now,
rowguid = Guid.NewGuid()
};
context.Address.Add(customerAddress);
context.SaveChanges();
businessEntity.AddressID = customerAddress.AddressID;
context.BusinessEntityAddress.Add(businessEntity);
context.SaveChanges();
}
}
}
}
public ActionResult Create([Bind(Include = "ProductID,Name,ProductNumber,Color,StandardCost,ListPrice,Size,Weight,CategoryID,ProductModelID,SellStartDate,SellEndDate,DiscontinuedDate,ThumbNailPhoto,ThumbnailPhotoFileName,rowguid,ModifiedDate")] Product product)
{
if (ModelState.IsValid)
{
db.Products.Add(product);
db.SaveChanges();
return(RedirectToAction("Index"));
}
var categories = from cat in db.ProductCategories
where cat.CategoryID > 4
select cat;
ViewBag.CategoryID = new SelectList(categories, "CategoryID", "Name", product.CategoryID);
ViewBag.ProductModelID = new SelectList(db.ProductModels, "ProductModelID", "Name", product.ProductModelID);
return(View(product));
}
private void UpdateSalesData(decimal saleSum, int purchaseID)
{
using (var context = new AWContext())
{
var employeeID = context.PurchaseOrderHeader.Where(x => x.PurchaseOrderID == purchaseID).Select(x => x.EmployeeID).FirstOrDefault();
var result = context.SalesPerson.Where(x => x.BusinessEntityID == employeeID).FirstOrDefault();
result.SalesYTD += saleSum;
context.SaveChanges();
}
}
public void UpdateStatus(int orderID, int workerID, byte status = 2)
{
using (AWContext context = new AWContext())
{
var result = context.PurchaseOrderHeader.SingleOrDefault(o => o.PurchaseOrderID == orderID);
if (workerID != 0)
{
result.EmployeeID = workerID;
}
result.Status = status;
result.ModifiedDate = DateTime.Now;
context.SaveChanges();
}
}
private void UpdateOrder(List <PurchaseOrderDetailXML> details, int purchaseID)
{
using (var context = new AWContext())
{
foreach (var detail in details)
{
var result = context.ProductInventory.Where(x => x.ProductID == detail.ProductID).OrderByDescending(x => x.Quantity).FirstOrDefault();
result.Quantity -= detail.Quantity;
}
OrderProcessor order = new OrderProcessor();
order.UpdateStatus(purchaseID, workerID: 0, status: 3);
context.SaveChanges();
}
}
private int InsertPurchaseOrderHeader(ShopCartItem cart, int businessEntityID, string country)
{
decimal totalPrice = 0;
PurchaseOrderDetail orderDetails = new PurchaseOrderDetail();
var orderHeader = new PurchaseOrderHeader()
{
RevisionNumber = 1, Status = 1,
ShipMethodID = 1, OrderDate = DateTime.Now,
ModifiedDate = DateTime.Now, BusinessEntityID = businessEntityID
};
foreach (var items in cart.Lines)
{
decimal subtotal = items.Product.ListPrice * items.Quantity;
totalPrice += subtotal;
orderDetails = new PurchaseOrderDetail
{
DueDate = DateTime.Now.AddDays(3), OrderQty = (short)items.Quantity,
ProductID = items.Product.ProductID, UnitPrice = items.Product.ListPrice,
LineTotal = subtotal, ReceivedQty = items.Quantity,
RejectedQty = 0, StockedQty = items.Quantity,
ModifiedDate = DateTime.Now
};
orderHeader.PurchaseOrderDetails.Add(orderDetails);
}
orderHeader.SubTotal = totalPrice;
orderHeader.TaxAmt = GetTaxRate(country) / 100 * totalPrice;
orderHeader.Freight = ShipBaseRate() / 100 * totalPrice;
orderHeader.TotalDue = totalPrice + orderHeader.Freight + orderHeader.TaxAmt;
using (var context = new AWContext())
{
context.PurchaseOrderHeader.Add(orderHeader);
context.SaveChanges();
}
return(orderHeader.PurchaseOrderID);
}
public void Save()
{
context.SaveChanges();
}