public void CreateProfile()
{
Stopwatch watch = Stopwatch.StartNew();
var profile = new Profile();
profile.Username = NAME;
profile.ApplicationName = "PetShop..Businesss";
profile.IsAnonymous = false;
profile.LastActivityDate = DateTime.Now;
profile.LastUpdatedDate = DateTime.Now;
try
{
using (var context = new PetshopDataContext())
{
context.Profile.InsertOnSubmit(profile);
context.SubmitChanges();
}
}
catch (Exception ex)
{
Assert.Fail(ex.Message);
}
Assert.IsTrue(true);
Console.WriteLine("Time: {0} ms", watch.ElapsedMilliseconds);
}
/// <summary>
/// Update profile
/// </summary>
protected void btnSubmit_Click(object sender, EventArgs e)
{
using (var context = new PetshopDataContext())
{
/*var options = new DataLoadOptions();
options.LoadWith<Profile>(p => p.AccountList);
context.LoadOptions = options;*/
var profile = context.Profile.GetProfile(User.Identity.Name);
if (!string.IsNullOrEmpty(profile.Username) && AddressForm.IsValid)
{
if (profile.AccountList.Count > 0)
{
Account account = profile.AccountList[0];
UpdateAccount(ref account, AddressForm.Address);
}
else
{
var account = new Account();
profile.AccountList.Add(account);
account.Profile = profile;
UpdateAccount(ref account, AddressForm.Address);
}
context.SubmitChanges();
}
}
lblMessage.Text = "Your profile information has been successfully updated.<br> ";
}
public static void ClearCart(List<Cart> items)
{
using (var context = new PetshopDataContext())
{
context.Cart.AttachAll(items);
context.Cart.DeleteAllOnSubmit(items);
context.SubmitChanges();
}
}
public static void SetQuantity(List<Cart> items, string itemId, int quantity)
{
var item = items.FirstOrDefault(i => i.ItemId == itemId);
using (var context = new PetshopDataContext())
{
context.Cart.Attach(item);
item.Quantity = quantity;
context.SubmitChanges();
}
}
protected void CreateUserWizard1_CreatedUser(object sender, EventArgs e)
{
using (var context = new PetshopDataContext())
{
string userName = ((System.Web.UI.WebControls.CreateUserWizard)sender).UserName;
var profile = context.Profile.GetProfile(userName);
if (null == profile)
{
profile = new Profile();
profile.Username = userName;
profile.ApplicationName = ".NET Pet Shop 4.0";
profile.IsAnonymous = false;
profile.LastActivityDate = DateTime.Now;
profile.LastUpdatedDate = DateTime.Now;
context.Profile.InsertOnSubmit(profile);
context.SubmitChanges();
}
}
}
public static void Add(List<Cart> items, string itemId, int uniqueId, bool isShoppingCart)
{
int index = 0;
bool found = false;
using (var context = new PetshopDataContext())
{
/*var options = new DataLoadOptions();
options.LoadWith<Item>(i => i.Product);*/
var item = items.FirstOrDefault(i => i.ItemId == itemId);
if (item != null)
{
context.Cart.Attach(item);
item.Quantity++;
}
else
{
var cartItem = context.Item
.ByItemId(itemId)
.Fetch(i => i.Product)
.FirstOrDefault();
var profile = context.Profile.GetByKey(uniqueId);
var cart = new Cart();
cart.Profile = profile;
cart.ItemId = itemId;
cart.Name = cartItem.Name;
cart.ProductId = cartItem.Product.ProductId; // HERE
cart.IsShoppingCart = isShoppingCart;
cart.Price = cartItem.ListPrice ?? cartItem.UnitCost ?? 0;
cart.Type = cartItem.Product.Name;
cart.CategoryId = cartItem.Product.Category.CategoryId; // HERE
cart.Quantity = 1;
items.Add(cart);
context.Cart.InsertOnSubmit(cart);
}
context.SubmitChanges();
}
}
public void UpdateSupplier()
{
Stopwatch watch = Stopwatch.StartNew();
Supplier supplier = null;
using (var context = new PetshopDataContext())
{
supplier = context.Supplier.GetByKey(_supplierId);
context.Supplier.Detach(supplier);
}
using (var context = new PetshopDataContext())
{
context.Supplier.Attach(supplier);
supplier.Phone = "111-111-1111";
context.SubmitChanges();
}
using (var context = new PetshopDataContext())
{
Assert.IsTrue(context.Supplier.GetByKey(_supplierId).Phone == "111-111-1111");
}
Console.WriteLine("Time: {0} ms", watch.ElapsedMilliseconds);
}
public void CreateSupplier()
{
Stopwatch watch = Stopwatch.StartNew();
var supplier = new Supplier();
supplier.Name = NAME;
supplier.Status = "AB";
supplier.Addr1 = "One Way";
supplier.Addr2 = "Two Way";
supplier.City = "Dallas";
supplier.State = "TX";
supplier.Zip = "90210";
supplier.Phone = "555-555-5555";
try
{
using (var context = new PetshopDataContext())
{
context.Supplier.InsertOnSubmit(supplier);
context.SubmitChanges();
context.Supplier.Detach(supplier);
_supplierId = supplier.SuppId;
}
}
catch (Exception ex)
{
Assert.Fail(ex.Message);
}
Assert.IsTrue(true);
Console.WriteLine("Time: {0} ms", watch.ElapsedMilliseconds);
}
public void UpdateProduct()
{
Stopwatch watch = Stopwatch.StartNew();
Product product = null;
using (var context = new PetshopDataContext())
{
product = context.Product.GetByKey(ID);
context.Product.Detach(product);
}
using (var context = new PetshopDataContext())
{
context.Product.Attach(product);
product.Description = "This is a ";
context.SubmitChanges();
}
using (var context = new PetshopDataContext())
{
Assert.IsTrue(context.Product.GetByKey(ID).Description == "This is a ");
}
Console.WriteLine("Time: {0} ms", watch.ElapsedMilliseconds);
}
public void UpdateInventory()
{
Stopwatch watch = Stopwatch.StartNew();
Inventory inventory = null;
using (var context = new PetshopDataContext())
{
inventory = context.Inventory.GetByKey(ID);
context.Inventory.Detach(inventory);
}
using (var context = new PetshopDataContext())
{
context.Inventory.Attach(inventory);
inventory.Qty = 100;
context.SubmitChanges();
}
using (var context = new PetshopDataContext())
{
Assert.IsTrue(context.Inventory.GetByKey(ID).Qty == 100);
}
Console.WriteLine("Time: {0} ms", watch.ElapsedMilliseconds);
}
/// <summary>
/// Bind controls to profile
/// </summary>
private void BindUser()
{
using (var context = new PetshopDataContext())
{
var profile = context.Profile.GetProfile(User.Identity.Name);
if (string.IsNullOrEmpty(profile.Username))
{
profile = new Profile();
profile.Username = User.Identity.Name;
profile.ApplicationName = ".NET Pet Shop 4.0";
profile.IsAnonymous = !User.Identity.IsAuthenticated;
profile.LastActivityDate = DateTime.Now;
profile.LastUpdatedDate = DateTime.Now;
context.Profile.InsertOnSubmit(profile);
context.SubmitChanges();
}
AddressForm.Address = new Address(profile);
}
}
public void CreateCategory()
{
Stopwatch watch = Stopwatch.StartNew();
var category = new Category();
category.CategoryId = ID;
category.Name = "";
category.Description = "";
try
{
using (var context = new PetshopDataContext())
{
context.Category.InsertOnSubmit(category);
context.SubmitChanges();
}
}
catch (Exception ex)
{
Assert.Fail(ex.Message);
}
Assert.IsTrue(true);
Console.WriteLine("Time: {0} ms", watch.ElapsedMilliseconds);
}
public static void MoveToCart(Profile profile, string itemId)
{
var item = profile.WishList.FirstOrDefault(i => i.ItemId == itemId);
using (var context = new PetshopDataContext())
{
context.Cart.Attach(item);
item.IsShoppingCart = true;
context.SubmitChanges();
}
profile.WishList.Remove(item);
profile.ShoppingCart.Add(item);
}
public static void SaveOrderLineItems(List<Cart> cart, int orderId)
{
int lineNum = 0;
using (var context = new PetshopDataContext())
{
var order = context.Order.GetByKey(orderId);
foreach (var item in cart)
{
var lineItem = new LineItem
{
Order = order,
ItemId = item.ItemId,
LineNum = ++lineNum,
Quantity = item.Quantity,
UnitPrice = item.Price,
};
context.LineItem.InsertOnSubmit(lineItem);
}
context.SubmitChanges();
}
}
public static void Remove(List<Cart> items, string itemId)
{
var item = items.FirstOrDefault(i => i.ItemId == itemId);
using (var context = new PetshopDataContext())
{
var cart = context.Cart.GetByKey(item.CartId);
context.Cart.DeleteOnSubmit(cart);
context.SubmitChanges();
//context.Cart.Delete(item.CartId);
}
items.Remove(item);
}
public void UpdateItem()
{
Stopwatch watch = Stopwatch.StartNew();
Item item = null;
using (var context = new PetshopDataContext())
{
item = context.Item.GetByKey(ID);
context.Item.Detach(item);
}
using (var context = new PetshopDataContext())
{
context.Item.Attach(item);
item.ListPrice = 111;
context.SubmitChanges();
}
using (var context = new PetshopDataContext())
{
Assert.IsTrue(context.Item.GetByKey(ID).ListPrice == 111);
}
Console.WriteLine("Time: {0} ms", watch.ElapsedMilliseconds);
}
public void UpdateProfile()
{
Stopwatch watch = Stopwatch.StartNew();
Profile profile = null;
using (var context = new PetshopDataContext())
{
profile = context.Profile.GetProfile(NAME);
context.Profile.Detach(profile);
}
using (var context = new PetshopDataContext())
{
context.Profile.Attach(profile);
profile.IsAnonymous = true;
context.SubmitChanges();
}
using (var context = new PetshopDataContext())
{
Assert.IsTrue(context.Profile.GetProfile(NAME).IsAnonymous.Value);
}
Console.WriteLine("Time: {0} ms", watch.ElapsedMilliseconds);
}
public void UpdateCategory()
{
Stopwatch watch = Stopwatch.StartNew();
Category category = null;
using (var context = new PetshopDataContext())
{
category = context.Category.GetByKey(ID);
context.Category.Detach(category);
}
using (var context = new PetshopDataContext())
{
context.Category.Attach(category);
category.Description = "This is a .";
context.SubmitChanges();
}
using (var context = new PetshopDataContext())
{
Assert.IsTrue(context.Category.GetByKey(ID).Description == "This is a .");
}
Console.WriteLine("Time: {0} ms", watch.ElapsedMilliseconds);
}
/// <summary>
/// Process the order
/// </summary>
protected void wzdCheckOut_FinishButtonClick(object sender, WizardNavigationEventArgs e)
{
using (var context = new PetshopDataContext())
{
var profile = context.Profile.GetProfile(User.Identity.Name);
if (profile.ShoppingCart.Count > 0)
{
// display ordered items
CartListOrdered.Bind(profile.ShoppingCart);
// display total and credit card information
ltlTotalComplete.Text = ltlTotal.Text;
ltlCreditCardComplete.Text = ltlCreditCard.Text;
#region Create Order
var order = new Order();
order.UserId = profile.UniqueID.ToString();
order.OrderDate = DateTime.Now;
order.CreditCard = GetCreditCard();
order.Courier = order.CreditCard.CardType;
order.TotalPrice = CartHelper.GetTotal(profile.ShoppingCart);
order.AuthorizationNumber = 0;
order.Locale = "en-us";
#region Shipping Information
order.ShipAddr1 = billingForm.Address.Address1;
order.ShipAddr2 = billingForm.Address.Address2;
order.ShipCity = billingForm.Address.City;
order.ShipState = billingForm.Address.State;
order.ShipZip = billingForm.Address.Zip;
order.ShipCountry = billingForm.Address.Country;
order.ShipToFirstName = billingForm.Address.FirstName;
order.ShipToLastName = billingForm.Address.LastName;
#endregion
#region Billing Information
order.BillAddr1 = shippingForm.Address.Address1;
order.BillAddr2 = shippingForm.Address.Address2;
order.BillCity = shippingForm.Address.City;
order.BillState = shippingForm.Address.State;
order.BillZip = shippingForm.Address.Zip;
order.BillCountry = shippingForm.Address.Country;
order.BillToFirstName = shippingForm.Address.FirstName;
order.BillToLastName = shippingForm.Address.LastName;
#endregion
context.Order.InsertOnSubmit(order);
context.SubmitChanges();
#endregion
int itemsOnBackOrder = 0;
//Decrement and check the Inventory.
foreach (Cart cart in profile.ShoppingCart)
{
var inventory = context.Inventory.GetByKey(cart.ItemId);
if (cart.Quantity > inventory.Qty)
{
itemsOnBackOrder += cart.Quantity - inventory.Qty;
}
inventory.Qty -= cart.Quantity;
context.SubmitChanges();
}
if (itemsOnBackOrder > 0)
{
ItemsOnBackOrder.Text = string.Format("<br /><p style=\"color:red;\"><b>Backorder ALERT:</b> {0} items are on backorder.</p>", itemsOnBackOrder);
}
CartHelper.SaveOrderLineItems(profile.ShoppingCart, order.OrderId);
// destroy cart
CartHelper.ClearCart(profile.ShoppingCart);
}
else
{
lblMsg.Text =
"<p><br>Can not process the order. Your cart is empty.</p><p class=SignUpLabel><a class=linkNewUser href=Default.aspx>Continue shopping</a></p>";
wzdCheckOut.Visible = false;
}
}
}
public void CreateInventory()
{
Stopwatch watch = Stopwatch.StartNew();
var inventory = new Inventory();
inventory.ItemId = ID;
inventory.Qty = 10;
try
{
using (var context = new PetshopDataContext())
{
context.Inventory.InsertOnSubmit(inventory);
context.SubmitChanges();
}
}
catch (Exception ex)
{
Assert.Fail(ex.Message);
}
Assert.IsTrue(true);
Console.WriteLine("Time: {0} ms", watch.ElapsedMilliseconds);
}