//
// GET: /Checkout/
public ActionResult Index(string cartCode, decimal cartTotal)
{
if (ModelState.IsValid)
{
//if user not logged in, ask them to log in to place an order
//if (!Request.IsAuthenticated)
//{
// return RedirectToAction("Login", "Account");
//}
//using (var context = new ShoppingCartContext())
//{
// context.Carts.Where(c => c.Code == HttpContext.Session["CartCode"] as string).ForEach(cart => cart.Code = HttpContext.User.Identity.Name);
// context.SaveChanges();
// //update the cart code session
// HttpContext.Session["CartCode"] = HttpContext.User.Identity.Name;
//}
var user = new ApplicationUser();
using (IdentityContext _idDb = new IdentityContext())
{
var _currentUserId = User.Identity.GetUserId();
user = _idDb.Users.FirstOrDefault(x => x.Id == _currentUserId);
}
var addresses = new List <Address>();
if (user != null)
{
addresses = AddressFlow.GetAccountAddresses(user.UserName);
}
var checkoutModel = new CheckoutViewModel()
{
CartTotal = cartTotal,
PaymentAmount = cartTotal,
PaymentTransaction = new PaymentTransaction()
{
//todo return billing address from account
PaymentType = null
},
//PaymentTypes = new List<PaymentType>(),
//todo: return shipping address from account
ShippingAddress = addresses.SingleOrDefault(a => a.Primary),
//Name = user.LastName + " " + user.FirstName,
//Email = user.Email,
//Phone = user.PhoneNumber
};
if (user != null)
{
checkoutModel.Name = user.LastName + " " + user.FirstName;
checkoutModel.Email = user.Email;
checkoutModel.Phone = user.PhoneNumber;
}
TempData["CheckoutInfo"] = checkoutModel;
//using (var context = new ShoppingCartContext())
//{
// checkoutModel.PaymentTypes.AddRange(context.PaymentTypes.ToList());
//}
//checkoutModel.PaymentTypesList = new SelectList(checkoutModel.PaymentTypes, "Code", "Description");
return(View(checkoutModel));
}
return(View());
}
protected override void Seed(DbContext context)
{
using (var idc = new IdentityContext())
{
var userStore = new UserStore <ApplicationUser>(idc);
var userManager = new UserManager <ApplicationUser>(userStore);
var userToInsert = new ApplicationUser
{
Email = "*****@*****.**",
UserName = "******",
FirstName = "Jason",
LastName = "Nguyen",
ProfilePicture = ImageToByteArray(Image.FromFile(HostingEnvironment.MapPath(@"~/Content/Images/Profile1.jpg"))),
};
userManager.Create(userToInsert, "vt1989");
userToInsert = new ApplicationUser
{
Email = "*****@*****.**",
UserName = "******",
FirstName = "Amy",
LastName = "Vo",
ProfilePicture = ImageToByteArray(Image.FromFile(HostingEnvironment.MapPath(@"~/Content/Images/Profile2.jpg"))),
};
userManager.Create(userToInsert, "vt1989");
}
//set up products
using (var cContext = new ShoppingCartContext())
{
//set up account address
AddressFlow.AddNewAddress("*****@*****.**", new Address()
{
AddressType = new AddressType()
{
Code = "Primary", Description = "Primary address"
},
Code = Guid.NewGuid().ToString(),
Line1 = "1508 duong 30 thang 4",
Line2 = "F12, Tp Vung tau",
Line3 = "Viet Nam",
Primary = true
});
AddressFlow.AddNewAddress("*****@*****.**", new Address()
{
AddressType = new AddressType()
{
Code = "Alternative", Description = "Alternative address"
},
Code = Guid.NewGuid().ToString(),
Line1 = "17000 duong Phan Chau Trinh",
Line2 = "F11, Tp Vung tau",
Line3 = "Viet Nam",
Primary = false
});
var sequences = new List <Sequence>
{
new Sequence()
{
Code = "Order", StartValue = 1000, CurrentValue = 1000
}
};
cContext.Sequences.AddRange(sequences);
cContext.SaveChanges();
cContext.Categories.AddRange(new List <Category>
{
new Category {
Code = "1001", Description = "Female-Winter-Collection"
},
new Category {
Code = "1002", Description = "Female-Casual-Collection"
},
});
cContext.SaveChanges();
var products = new List <Product>
{
new Product
{
Id = 1,
Code = "1001",
Description = "Heathered Knit Drawstring Jumpsuit",
Image =
ImageToByteArray(Image.FromFile(HostingEnvironment.MapPath(@"~/Content/Images/Image1.jpg"))),
FeatureProduct = true,
Weight = 1,
QuantityOnHand = 29,
Categories = new List <Category>()
{
cContext.Categories.SingleOrDefault(c => c.Code == "1002")
}
},
new Product
{
Id = 2,
Code = "1002",
Description = "Two-pocket Gingham Shirt",
Image =
ImageToByteArray(Image.FromFile(HostingEnvironment.MapPath(@"~/Content/Images/Image2.jpg"))),
FeatureProduct = true,
Weight = 0.5m,
QuantityOnHand = 22,
Categories = new List <Category>()
{
cContext.Categories.SingleOrDefault(c => c.Code == "1001")
}
},
new Product
{
Id = 3,
Code = "1003",
Description = "Upside-Down Eiffei Tower Tee",
Image =
ImageToByteArray(Image.FromFile(HostingEnvironment.MapPath(@"~/Content/Images/Image3.jpg"))),
FeatureProduct = true,
Weight = 0.25m,
QuantityOnHand = 40,
Categories = new List <Category>()
{
cContext.Categories.SingleOrDefault(c => c.Code == "1002")
}
},
new Product
{
Id = 4,
Code = "1004",
Description = "Perforated Faux Leather Loafers",
Image =
ImageToByteArray(Image.FromFile(HostingEnvironment.MapPath(@"~/Content/Images/Image4.jpg"))),
FeatureProduct = true,
Weight = .125m,
QuantityOnHand = 15,
Categories = new List <Category>()
{
cContext.Categories.SingleOrDefault(c => c.Code == "1001")
}
},
new Product
{
Id = 5,
Code = "1005",
Description = "Faux Leather Skinny Pants",
Image =
ImageToByteArray(Image.FromFile(HostingEnvironment.MapPath(@"~/Content/Images/Image5.jpg"))),
FeatureProduct = false,
Weight = 1m,
QuantityOnHand = 20,
Categories = new List <Category>()
{
cContext.Categories.SingleOrDefault(c => c.Code == "1002")
}
}
};
products.ForEach(s => cContext.Products.Add(s));
cContext.SaveChanges();
cContext.PriceTypes.AddRange(new List <PriceType>()
{
new PriceType()
{
Code = "R",
Description = "Retail",
},
new PriceType()
{
Code = "W",
Description = "Whole Sale",
}
});
cContext.SaveChanges();
cContext.ProductOffers.AddRange(new List <ProductOffer>()
{
new ProductOffer()
{
Code = "1001-R",
Product = cContext.Products.Single(p => p.Code == "1001"),
Price = 15m,
Discountable = true,
PriceType = cContext.PriceTypes.Single(t => t.Code == "R"),
},
new ProductOffer()
{
Code = "1001-W",
Product = cContext.Products.Single(p => p.Code == "1001"),
Price = 12m,
Discountable = true,
PriceType = cContext.PriceTypes.Single(t => t.Code == "W"),
},
new ProductOffer()
{
Code = "1002-R",
Product = cContext.Products.Single(p => p.Code == "1002"),
Price = 20m,
Discountable = true,
PriceType = cContext.PriceTypes.Single(t => t.Code == "R"),
},
new ProductOffer()
{
Code = "1002-W",
Product = cContext.Products.Single(p => p.Code == "1002"),
Price = 18m,
Discountable = true,
PriceType = cContext.PriceTypes.Single(t => t.Code == "W"),
},
new ProductOffer()
{
Code = "1003-R",
Product = cContext.Products.Single(p => p.Code == "1003"),
Price = 31m,
Discountable = true,
PriceType = cContext.PriceTypes.Single(t => t.Code == "R"),
},
new ProductOffer()
{
Code = "1003-W",
Product = cContext.Products.Single(p => p.Code == "1003"),
Price = 21m,
Discountable = true,
PriceType = cContext.PriceTypes.Single(t => t.Code == "W"),
},
new ProductOffer()
{
Code = "1004-R",
Product = cContext.Products.Single(p => p.Code == "1004"),
Price = 11m,
Discountable = true,
PriceType = cContext.PriceTypes.Single(t => t.Code == "R"),
},
new ProductOffer()
{
Code = "1004-W",
Product = cContext.Products.Single(p => p.Code == "1004"),
Price = 10m,
Discountable = true,
PriceType = cContext.PriceTypes.Single(t => t.Code == "W"),
},
new ProductOffer()
{
Code = "1005-R",
Product = cContext.Products.Single(p => p.Code == "1005"),
Price = 40m,
Discountable = true,
PriceType = cContext.PriceTypes.Single(t => t.Code == "R"),
},
new ProductOffer()
{
Code = "1005-W",
Product = cContext.Products.Single(p => p.Code == "1005"),
Price = 32m,
Discountable = true,
PriceType = cContext.PriceTypes.Single(t => t.Code == "W"),
},
});
cContext.SaveChanges();
//promotion
cContext.Promotions.AddRange(new List <Promotion>()
{
new Promotion()
{
Code = "Christmas discount",
PromotionLineItems = new List <PromotionLineItem>()
{
new PromotionLineItem()
{
Code = "15PercentOff_1001",
Description = "15 percent off Female-Winter-Collection",
Active = true,
StartDate = DateTime.Now,
EndDate = DateTime.Now.AddDays(2),
PromotionLineItemExpression = "Category=1001;PriceType=R;PercentDiscount=0.15"
},
new PromotionLineItem()
{
Code = "1.5offFemale-Casual-Collection",
Description = "1.5 off Female-Casual-Collection",
Active = true,
StartDate = DateTime.Now,
EndDate = DateTime.Now.AddDays(2),
PromotionLineItemExpression = "Category=1002;PriceType=R;AmountDiscount=1.5"
},
new PromotionLineItem()
{
Code = "25_percent_off_item_1004",
Description = "25 percent off item 1004",
Active = true,
StartDate = DateTime.Now,
EndDate = DateTime.Now.AddDays(2),
PromotionLineItemExpression = "ItemCode=1004;PriceType=R;PercentDiscount=0.25"
},
new PromotionLineItem()
{
Code = "5.25_off_item_item_1005",
Description = "5.25 off item item 1005",
Active = true,
StartDate = DateTime.Now,
EndDate = DateTime.Now.AddDays(2),
PromotionLineItemExpression = "ItemCode=1005;PriceType=R;AmountDiscount=5.25"
},
new PromotionLineItem()
{
Code = "Buy_5_1004_get_1_item_1004_free",
Description = "Buy 5 item 1004 get 1 item 1004 free",
Active = true,
StartDate = DateTime.Now,
EndDate = DateTime.Now.AddDays(2),
PromotionLineItemExpression = "PriceType=R;BuyItemCode=1004;BuyItemCount=5;GetItemCode=1004;GetItemCount=1"
},
new PromotionLineItem()
{
Code = "Buy_5_item_1004_get_2_item_1001_free",
Description = "Buy 5 item 1004 get 2 item 1001 free",
Active = true,
StartDate = DateTime.Now,
EndDate = DateTime.Now.AddDays(2),
PromotionLineItemExpression = "PriceType=R;BuyItemCode=1004;BuyItemCount=5;GetItemCode=1001;GetItemCount=2"
},
}
},
});
cContext.SaveChanges();
//cContext.CartLineItems.AddRange(new List<CartLineItem>
//{
// new CartLineItem()
// {
// Code = Guid.NewGuid().ToString(),
// DiscountAmount = 0m,
// Quantity = 5,
// OriginalPrice = 0m,
// ShippingCost = 0m,
// DiscountedPrice = 0m,
// ProductCode = "1001",
// PriceType = "R",
// DateCreated = DateTime.Now
// },
// new CartLineItem()
// {
// Code = Guid.NewGuid().ToString(),
// DiscountAmount = 0m,
// Quantity = 5,
// OriginalPrice = 0m,
// ShippingCost = 0m,
// DiscountedPrice = 0m,
// ProductCode = "1002",
// PriceType = "W",
// DateCreated = DateTime.Now
// },
//});
//cContext.SaveChanges();
var paymentStatuses = new List <PaymentStatus>
{
new PaymentStatus()
{
Code = "Hold", Description = "On Hold"
},
new PaymentStatus()
{
Code = "Processing", Description = "Processing"
},
new PaymentStatus()
{
Code = "Processed", Description = "Processed"
},
new PaymentStatus()
{
Code = "Completed", Description = "Completed"
}
};
cContext.PaymentStatuses.AddRange(paymentStatuses);
cContext.SaveChanges();
cContext.PaymentTypes.AddRange(new List <PaymentType>
{
new PaymentType()
{
Code = "Cash", Description = "Cash"
},
new PaymentType()
{
Code = "PayPal", Description = "PayPal"
}
});
cContext.SaveChanges();
cContext.PaymentTransactions.AddRange(new List <PaymentTransaction>
{
new PaymentTransaction()
{
Code = Guid.NewGuid().ToString(),
Amount = 6.66m,
PartialPayment = true,
PaymentStatus = cContext.PaymentStatuses.Single(ps => ps.Code == "Completed"),
PaymentTypeId = 1,
//PostedAmount = 6.66m,
}
});
var paymentTransactionId = cContext.SaveChanges();
cContext.Carts.AddRange(new List <Cart>
{
new Cart()
{
Product = cContext.Products.Single(p => p.Code == "1003"),
Code = Guid.NewGuid().ToString(),
Quantity = 1,
DateCreated = DateTime.Now,
}
});
cContext.Orders.AddRange(new List <Order>
{
new Order()
{
OrderNumber = SeqHelper.Next("Order"),
UserName = "******",
FullName = "Jason Nguyen",
Phone = "503-111-4444",
OrderDate = DateTime.Now,
ShippingAddressId = 1,
PaymentTransactionId = paymentTransactionId,
Email = "*****@*****.**",
OrderDetails = new List <LineOrderDetail>()
{
new LineOrderDetail
{
ProductId = 1,
UnitPrice = 9.99m,
Quantity = 1
}
}
}
});
cContext.SaveChanges();
}
}
protected override void Seed(MyProject.DAL.ShoppingCartContext cContext)
{
if (true)
{
//set up account address
AddressFlow.AddNewAddress("*****@*****.**", new Address()
{
AddressType = new AddressType()
{
Code = "Primary", Description = "Primary address"
},
Code = Guid.NewGuid().ToString(),
Line1 = "1508 duong 30 thang 4",
Line2 = "F12, Tp Vung tau",
Line3 = "Viet Nam",
Primary = true
});
AddressFlow.AddNewAddress("*****@*****.**", new Address()
{
AddressType = new AddressType()
{
Code = "Alternative", Description = "Alternative address"
},
Code = Guid.NewGuid().ToString(),
Line1 = "17000 duong Phan Chau Trinh",
Line2 = "F11, Tp Vung tau",
Line3 = "Viet Nam",
Primary = false
});
AddressFlow.AddNewAddress("*****@*****.**", new Address()
{
AddressType = new AddressType()
{
Code = "Alternative", Description = "Alternative address"
},
Code = Guid.NewGuid().ToString(),
Line1 = "1234 SE Morrison",
Line2 = "Suite 456",
Line3 = "Portland, OR",
Primary = false
});
var sequences = new List <Sequence>
{
new Sequence()
{
Code = "Order", StartValue = 10000, CurrentValue = 10000
},
new Sequence()
{
Code = "Item", StartValue = 20000, CurrentValue = 20004
},
new Sequence()
{
Code = "Category", StartValue = 30000, CurrentValue = 30001
}
};
cContext.Sequences.AddRange(sequences);
cContext.SaveChanges();
cContext.Categories.AddRange(new List <Category>
{
new Category {
Code = "30000", Description = "Female-Winter-Collection"
},
new Category {
Code = "30001", Description = "Female-Casual-Collection"
},
});
cContext.SaveChanges();
var products = new List <Product>
{
new Product
{
Id = 1,
Code = "20000",
BuyInPrice = 150000,
Description = "Heathered Knit Drawstring Jumpsuit",
//Image =
// ImageToByteArray(Image.FromFile(HostingEnvironment.MapPath(@"~/Content/Images/Image1.jpg"))),
FeatureProduct = true,
Weight = 1,
QuantityOnHand = 29,
DetailDescription = "this is a good product , Heathered Knit Drawstring Jumpsuit. Ship from USA.",
Categories = new List <Category>()
{
cContext.Categories.SingleOrDefault(c => c.Code == "30000")
},
//ProductOffers = new List<ProductOffer>()
//{
// new ProductOffer()
// {
// Code = "1001-R",
// Product = cContext.Products.Single(p=> p.Code == "1001"),
// Price = 15m,
// Discountable = true,
// PriceType = cContext.PriceTypes.Single(t=>t.Code == "R"),
// },
// new ProductOffer()
// {
// Code = "1001-W",
// Product = cContext.Products.Single(p=> p.Code == "1001"),
// Price = 12m,
// Discountable = true,
// PriceType = cContext.PriceTypes.Single(t=>t.Code == "W"),
// }
//}
},
new Product
{
Id = 2,
Code = "20001",
BuyInPrice = 150000,
Description = "Two-pocket Gingham Shirt",
//Image =
// ImageToByteArray(Image.FromFile(HostingEnvironment.MapPath(@"~/Content/Images/Image2.jpg"))),
FeatureProduct = true,
Weight = 0.5m,
QuantityOnHand = 22,
DetailDescription = "this is a good product , Heathered Knit Drawstring Jumpsuit. Ship from USA.",
Categories = new List <Category>()
{
cContext.Categories.SingleOrDefault(c => c.Code == "30000")
},
//ProductOffers = new List<ProductOffer>()
//{
// new ProductOffer()
// {
// Code = "1002-R",
// Product = cContext.Products.Single(p=> p.Code == "1002"),
// Price = 12.5m,
// Discountable = true,
// PriceType = cContext.PriceTypes.Single(t=>t.Code == "R"),
// },
// new ProductOffer()
// {
// Code = "1002-W",
// Product = cContext.Products.Single(p=> p.Code == "1002"),
// Price = 10.5m,
// Discountable = true,
// PriceType = cContext.PriceTypes.Single(t=>t.Code == "W"),
// }
//}
},
new Product
{
Id = 3,
Code = "20002",
BuyInPrice = 150000,
Description = "Upside-Down Eiffei Tower Tee",
//Image =
// ImageToByteArray(Image.FromFile(HostingEnvironment.MapPath(@"~/Content/Images/Image3.jpg"))),
FeatureProduct = true,
Weight = 0.25m,
QuantityOnHand = 40,
DetailDescription = "this is a good product , Heathered Knit Drawstring Jumpsuit. Ship from USA.",
Categories = new List <Category>()
{
cContext.Categories.SingleOrDefault(c => c.Code == "30001")
},
//ProductOffers = new List<ProductOffer>()
//{
// new ProductOffer()
// {
// Code = "1003-R",
// Product = cContext.Products.Single(p=> p.Code == "1003"),
// Price = 6.5m,
// Discountable = true,
// PriceType = cContext.PriceTypes.Single(t=>t.Code == "R"),
// },
// new ProductOffer()
// {
// Code = "1003-W",
// Product = cContext.Products.Single(p=> p.Code == "1003"),
// Price = 5.5m,
// Discountable = true,
// PriceType = cContext.PriceTypes.Single(t=>t.Code == "W"),
// }
//}
},
new Product
{
Id = 4,
Code = "20003",
BuyInPrice = 150000,
Description = "Perforated Faux Leather Loafers",
DetailDescription = "this is a good product , Heathered Knit Drawstring Jumpsuit. Ship from USA.",
//Image =
// ImageToByteArray(Image.FromFile(HostingEnvironment.MapPath(@"~/Content/Images/Image4.jpg"))),
FeatureProduct = true,
Weight = .125m,
QuantityOnHand = 15,
Categories = new List <Category>()
{
cContext.Categories.SingleOrDefault(c => c.Code == "30001")
},
//ProductOffers = new List<ProductOffer>()
//{
// new ProductOffer()
// {
// Code = "1004-R",
// Product = cContext.Products.Single(p=> p.Code == "1004"),
// Price = 8.5m,
// Discountable = true,
// PriceType = cContext.PriceTypes.Single(t=>t.Code == "R"),
// },
// new ProductOffer()
// {
// Code = "1004-W",
// Product = cContext.Products.Single(p=> p.Code == "1004"),
// Price = 7.25m,
// Discountable = true,
// PriceType = cContext.PriceTypes.Single(t=>t.Code == "W"),
// }
//}
},
new Product
{
Id = 5,
Code = "20004",
BuyInPrice = 150000,
Description = "Faux Leather Skinny Pants",
DetailDescription = "this is a good product , Heathered Knit Drawstring Jumpsuit. Ship from USA.",
//Image =
// ImageToByteArray(Image.FromFile(HostingEnvironment.MapPath(@"~/Content/Images/Image5.jpg"))),
FeatureProduct = false,
Weight = 1m,
QuantityOnHand = 20,
Categories = new List <Category>()
{
cContext.Categories.SingleOrDefault(c => c.Code == "30001")
},
//ProductOffers = new List<ProductOffer>()
//{
// new ProductOffer()
// {
// Code = "1005-R",
// Product = cContext.Products.Single(p=> p.Code == "1005"),
// Price = 10m,
// Discountable = true,
// PriceType = cContext.PriceTypes.Single(t=>t.Code == "R"),
// },
// new ProductOffer()
// {
// Code = "1005-W",
// Product = cContext.Products.Single(p=> p.Code == "1005"),
// Price = 9m,
// Discountable = true,
// PriceType = cContext.PriceTypes.Single(t=>t.Code == "W"),
// }
//}
}
};
products.ForEach(s => cContext.Products.Add(s));
cContext.SaveChanges();
cContext.PriceTypes.AddRange(new List <PriceType>()
{
new PriceType()
{
Code = "R",
Description = "Retail",
},
new PriceType()
{
Code = "W",
Description = "Whole Sale",
}
});
cContext.SaveChanges();
cContext.ProductOffers.AddRange(new List <ProductOffer>()
{
new ProductOffer()
{
Code = "20000-R",
Product = cContext.Products.Single(p => p.Code == "20000"),
Price = 300000m,
Discountable = true,
PriceType = cContext.PriceTypes.Single(t => t.Code == "R"),
},
new ProductOffer()
{
Code = "20000-W",
Product = cContext.Products.Single(p => p.Code == "20000"),
Price = 240000m,
Discountable = true,
PriceType = cContext.PriceTypes.Single(t => t.Code == "W"),
},
new ProductOffer()
{
Code = "20001-R",
Product = cContext.Products.Single(p => p.Code == "20001"),
Price = 200000m,
Discountable = true,
PriceType = cContext.PriceTypes.Single(t => t.Code == "R"),
},
new ProductOffer()
{
Code = "20001-W",
Product = cContext.Products.Single(p => p.Code == "20001"),
Price = 180000m,
Discountable = true,
PriceType = cContext.PriceTypes.Single(t => t.Code == "W"),
},
new ProductOffer()
{
Code = "20002-R",
Product = cContext.Products.Single(p => p.Code == "20002"),
Price = 310000m,
Discountable = true,
PriceType = cContext.PriceTypes.Single(t => t.Code == "R"),
},
new ProductOffer()
{
Code = "20002-W",
Product = cContext.Products.Single(p => p.Code == "20002"),
Price = 280000m,
Discountable = true,
PriceType = cContext.PriceTypes.Single(t => t.Code == "W"),
},
new ProductOffer()
{
Code = "20003-R",
Product = cContext.Products.Single(p => p.Code == "20003"),
Price = 500000m,
Discountable = true,
PriceType = cContext.PriceTypes.Single(t => t.Code == "R"),
},
new ProductOffer()
{
Code = "20003-W",
Product = cContext.Products.Single(p => p.Code == "20003"),
Price = 450000m,
Discountable = true,
PriceType = cContext.PriceTypes.Single(t => t.Code == "W"),
},
new ProductOffer()
{
Code = "20004-R",
Product = cContext.Products.Single(p => p.Code == "20004"),
Price = 430000m,
Discountable = true,
PriceType = cContext.PriceTypes.Single(t => t.Code == "R"),
},
new ProductOffer()
{
Code = "20004-W",
Product = cContext.Products.Single(p => p.Code == "20004"),
Price = 400000m,
Discountable = true,
PriceType = cContext.PriceTypes.Single(t => t.Code == "W"),
},
});
cContext.SaveChanges();
//promotion
cContext.Promotions.AddRange(new List <Promotion>()
{
new Promotion()
{
Code = "Christmas discount",
PromotionLineItems = new List <PromotionLineItem>()
{
new PromotionLineItem()
{
Code = "15PercentOff_1001",
Description = "15 percent off Female-Winter-Collection",
Active = false,
StartDate = DateTime.Now,
EndDate = DateTime.Now.AddDays(2),
PromotionLineItemExpression = "Category=1001;PriceType=R;PercentDiscount=0.15"
},
new PromotionLineItem()
{
Code = "15offFemale-Casual-Collection",
Description = "15d off Female-Casual-Collection",
Active = false,
StartDate = DateTime.Now,
EndDate = DateTime.Now.AddDays(2),
PromotionLineItemExpression = "Category=1002;PriceType=R;AmountDiscount=15000"
},
new PromotionLineItem()
{
Code = "25_percent_off_item_1004",
Description = "25 percent off item 1004",
Active = false,
StartDate = DateTime.Now,
EndDate = DateTime.Now.AddDays(2),
PromotionLineItemExpression = "ItemCode=1004;PriceType=R;PercentDiscount=0.25"
},
new PromotionLineItem()
{
Code = "25_off_item_item_1005",
Description = "25 off item item 1005",
Active = false,
StartDate = DateTime.Now,
EndDate = DateTime.Now.AddDays(2),
PromotionLineItemExpression = "ItemCode=1005;PriceType=R;AmountDiscount=25000"
},
new PromotionLineItem()
{
Code = "Buy_5_1004_get_1_item_1004_free",
Description = "Buy 5 item 1004 get 1 item 1004 free",
Active = false,
StartDate = DateTime.Now,
EndDate = DateTime.Now.AddDays(2),
PromotionLineItemExpression = "PriceType=R;BuyItemCode=1004;BuyItemCount=5;GetItemCode=1004;GetItemCount=1"
},
new PromotionLineItem()
{
Code = "Buy_5_item_1004_get_2_item_1001_free",
Description = "Buy 5 item 1004 get 2 item 1001 free",
Active = false,
StartDate = DateTime.Now,
EndDate = DateTime.Now.AddDays(2),
PromotionLineItemExpression = "PriceType=R;BuyItemCode=1004;BuyItemCount=5;GetItemCode=1001;GetItemCount=2"
},
}
},
});
cContext.SaveChanges();
//cContext.CartLineItems.AddRange(new List<CartLineItem>
//{
// new CartLineItem()
// {
// Code = Guid.NewGuid().ToString(),
// DiscountAmount = 0m,
// Quantity = 5,
// OriginalPrice = 0m,
// ShippingCost = 0m,
// DiscountedPrice = 0m,
// ProductCode = "1001",
// PriceType = "R",
// DateCreated = DateTime.Now
// },
// new CartLineItem()
// {
// Code = Guid.NewGuid().ToString(),
// DiscountAmount = 0m,
// Quantity = 5,
// OriginalPrice = 0m,
// ShippingCost = 0m,
// DiscountedPrice = 0m,
// ProductCode = "1002",
// PriceType = "W",
// DateCreated = DateTime.Now
// },
//});
//cContext.SaveChanges();
var paymentStatuses = new List <PaymentStatus>
{
new PaymentStatus()
{
Code = "Hold", Description = "On Hold"
},
new PaymentStatus()
{
Code = "Processing", Description = "Processing"
},
new PaymentStatus()
{
Code = "Processed", Description = "Processed"
},
new PaymentStatus()
{
Code = "Completed", Description = "Completed"
},
new PaymentStatus()
{
Code = "NotPaid", Description = "Not yet paid"
}
};
cContext.PaymentStatuses.AddRange(paymentStatuses);
cContext.SaveChanges();
cContext.PaymentTypes.AddRange(new List <PaymentType>
{
new PaymentType()
{
Code = "Bank", Description = "Bank transfer"
},
new PaymentType()
{
Code = "Cash", Description = "Cash"
},
new PaymentType()
{
Code = "PayLater", Description = "Pay Later"
}
});
cContext.SaveChanges();
cContext.PaymentTransactions.AddRange(new List <PaymentTransaction>
{
new PaymentTransaction()
{
Code = Guid.NewGuid().ToString(),
Amount = 6.66m,
PartialPayment = true,
PaymentStatus = cContext.PaymentStatuses.Single(ps => ps.Code == "Completed"),
PaymentTypeId = 1,
//PostedAmount = 6.66m,
}
});
var paymentTransactionId = cContext.SaveChanges();
cContext.Carts.AddRange(new List <Cart>
{
new Cart()
{
Product = cContext.Products.Single(p => p.Code == "20003"),
Code = Guid.NewGuid().ToString(),
Quantity = 1,
DateCreated = DateTime.Now,
}
});
cContext.Orders.AddRange(new List <Order>
{
new Order()
{
OrderNumber = SeqHelper.Next("Order"),
UserName = "******",
FullName = "Jason Nguyen",
Phone = "503-111-4444",
OrderDate = DateTime.Now,
ShippingAddressId = 1,
PaymentTransactionId = paymentTransactionId,
Email = "*****@*****.**",
OrderDetails = new List <LineOrderDetail>()
{
new LineOrderDetail
{
ProductId = 1,
UnitPrice = 9.99m,
Quantity = 1
}
}
}
});
cContext.AppSettings.AddRange(new List <AppSetting>
{
new AppSetting()
{
Code = "ShippingRate",
Description = "Shipping Rate per lb",
Value = "100000",
ValueType = "decimal"
},
new AppSetting()
{
Code = "NotificationEmails",
Description = "Emails to send notification to",
Value = "*****@*****.**",
ValueType = "string"
},
new AppSetting()
{
Code = "NotificationEmail1",
Description = "Send order notification to email 1",
Value = "*****@*****.**",
ValueType = "string"
},
new AppSetting()
{
Code = "NotificationEmail2",
Description = "Send order notification to email 2",
Value = "*****@*****.**",
ValueType = "string"
},
new AppSetting()
{
Code = "EmailFrom_EmailAddress",
Description = "Email address to send email from",
Value = "*****@*****.**",
ValueType = "string"
},
new AppSetting()
{
Code = "EmailFrom_UserName",
Description = "UserName of Email address to send email from",
Value = "jashopvn.2016",
ValueType = "string"
},
new AppSetting()
{
Code = "EmailFrom_Password",
Description = "Password of Email address to send email from",
Value = "vungtau1989",
ValueType = "string"
},
new AppSetting()
{
Code = "EmailFrom_Host",
Description = "Host of Email address to send email from",
Value = "email-smtp.us-west-2.amazonaws.com",
ValueType = "string"
}
});
cContext.SaveChanges();
}
}