本文整理汇总了C#中WingtipToys.Models.ProductContext类的典型用法代码示例。如果您正苦于以下问题:C# ProductContext类的具体用法?C# ProductContext怎么用?C# ProductContext使用的例子?那么恭喜您, 这里精选的类代码示例或许可以为您提供帮助。
ProductContext类属于WingtipToys.Models命名空间,在下文中一共展示了ProductContext类的15个代码示例,这些例子默认根据受欢迎程度排序。您可以为喜欢或者感觉有用的代码点赞,您的评价将有助于系统推荐出更棒的C#代码示例。
示例1: GetCategories
public IQueryable<Category> GetCategories()
{
//get an instance of the database
var db = new WingtipToys.Models.ProductContext();
//create and retur a queryable(as a set of data result)
IQueryable<Category> query = db.Categories;
return query;
}
示例2: GetProducts
public IQueryable<Product> GetProducts([QueryString("id")] int? categoryId, [RouteData] string categoryName)
{
var _db = new ProductContext();
IQueryable<Product> query = _db.Products;
if (categoryId.HasValue && categoryId > 0)
query = query.Where(p => p.CategoryID == categoryId);
if (!string.IsNullOrEmpty(categoryName))
query = query.Where(p => string.Compare(p.Category.CategoryName, categoryName) == 0);
return query;
}
示例3: GetProducts
public IQueryable<Product> GetProducts([QueryString("id")] int? categoryId)
{
var _db = new WingtipToys.Models.ProductContext();
IQueryable<Product> query = _db.Products;
if (categoryId.HasValue && categoryId > 0)
{
query = query.Where(p => p.CategoryID == categoryId);
}
return query;
}
示例4: GetProduct
public IQueryable<Product> GetProduct([QueryString("productID")] int? productId, [RouteData] string productName)
{
var _db = new ProductContext();
IQueryable<Product> query = _db.Products;
if (productId.HasValue && productId > 0)
query = query.Where(p => p.ProductID == productId);
else if (!string.IsNullOrEmpty(productName))
query = query.Where(p => string.Compare(p.ProductName, productName) == 0);
else
query = null;
return query;
}
示例5: GetCategories
// The return type can be changed to IEnumerable, however to support
// paging and sorting, the following parameters must be added:
// int maximumRows
// int startRowIndex
// out int totalRowCount
// string sortByExpression
public IQueryable<Category> GetCategories()
{
try
{
var _db = new WingtipToys.Models.ProductContext();
IQueryable<Category> query = _db.Categories;
return query;
}
catch(Exception exp)
{
throw;
}
}
示例6: GetProduct
public IQueryable<Product> GetProduct([QueryString("productID")]int? productId)
{
var _db = new WingtipToys.Models.ProductContext();
IQueryable<Product> query = _db.Products;
if (productId.HasValue && productId > 0)
{
query = query.Where(p => p.ProductID == productId);
}
else
{
query = null;
}
return query;
}
示例7: AddProduct
public bool AddProduct(string ProductName, string ProductDesc,
string ProductPrice, string ProductCategory, string ProductImagePath)
{
var myProduct = new Product();
myProduct.ProductName = ProductName;
myProduct.Description = ProductDesc;
myProduct.UnitPrice = Convert.ToDouble(ProductPrice);
myProduct.ImagePath = ProductImagePath;
myProduct.CategoryID = Convert.ToInt32(ProductCategory);
using (ProductContext _db = new ProductContext())
{
_db.Products.Add(myProduct);
_db.SaveChanges();
}
return true;
}
示例8: RemoveProductButton_Click
protected void RemoveProductButton_Click(object sender, EventArgs e)
{
using (var _db=new WingtipToys.Models.ProductContext())
{
int productId = Convert.ToInt16(DropDownRemoveProduct.SelectedValue);
var myItem = (from c in _db.Products where c.ProductID == productId select c).FirstOrDefault();
if (myItem != null)
{
_db.Products.Remove(myItem);
_db.SaveChanges();
// Reload the page.
string pageUrl = Request.Url.AbsoluteUri.Substring(0, Request.Url.AbsoluteUri.Count() - Request.Url.Query.Count());
Response.Redirect(pageUrl + "?ProductAction=remove");
}
else
LabelRemoveStatus.Text = "Unable to locate product.";
}
}
示例9: GetProduct
public IQueryable<Product> GetProduct(
[QueryString("ProductID")] int? productId,
[RouteData] string productName)
{
var _db = new WingtipToys.Models.ProductContext();
IQueryable<Product> query = _db.Products;
if (productId.HasValue && productId > 0)
{
query = query.Where(p => p.ProductID == productId);
}
else if (!String.IsNullOrEmpty(productName))
{
query = query.Where(p =>
String.Compare(p.ProductName, productName) == 0);
}
else
{
query = null;
}
return query;
}
示例10: DeliveryServicesSurvey
Tuple<int, int> DeliveryServicesSurvey(DateTime time)
{
int timeOut = 100;
offDeliveryService = true;
Tuple<int, int> result = null;
resultDeliveryServiceGlobal = null;
using (ProductContext _db = new ProductContext())
{
foreach (var system in _db.DeliveryServices)
{
object[] parameters = new object[] { system.ID,
system.ConnectionString,
time };
Thread thread = new Thread(DeliveryServiceSurvey);
thread.Start(parameters);
}
}
for (int i = 0; i < 20 && null == result; ++i)
{
Thread.Sleep(timeOut);
lock (lockDeliveryService)
{
result = resultDeliveryServiceGlobal;
}
}
if (null == result)
{
if (offDeliveryService)
{
throw new ExceptionDeliveryServiceOff();
}
else
{
throw new ExceptionDeliveryServiceWrongTime();
}
}
Console.WriteLine(" resultDeliveryService={0}:{1}", result.Item1, result.Item2);
return result;
}
示例11: Page_Load
protected void Page_Load(object sender, EventArgs e)
{
if(!IsPostBack)
{
NVPAPICaller payPalCAller = new NVPAPICaller();
string retMsg = "";
string token = "";
string PayerID = "";
NVPCodec decoder = new NVPCodec();
token = Session["token"].ToString();
bool ret = payPalCAller.GetCheckoutDetails( token, ref PayerID, ref decoder, ref retMsg );
if(ret)
{
Session["payerId"] = PayerID;
var myOrder = new Order();
myOrder.OrderDate = Convert.ToDateTime(decoder["TIMESTAMP"].ToString());
myOrder.Uername = User.Identity.Name;
myOrder.FirstName = decoder["FIRSTNAME"].ToString();
myOrder.LastName = decoder["LASTNAME"].ToString();
myOrder.Address = decoder["SHIPTOSTREET"].ToString();
myOrder.City = decoder["SHIPTOCITY"].ToString();
myOrder.State = decoder["SHIPTOSTATE"].ToString();
myOrder.PostalCode = decoder["SHIPTOZIP"].ToString();
myOrder.Country = decoder["SHIPTOCOUNTRYCODE"].ToString();
myOrder.Email = decoder["EMAIL"].ToString();
myOrder.Total = Convert.ToDecimal( decoder["AMT"].ToString() );
//verify total payment amount as set on checkout start.aspx.
try
{
decimal paymentAmountOnCheckout = Convert.ToDecimal( Session["payment_amt"].ToString() );
decimal paymentAmountFromPayPal = Convert.ToDecimal( decoder["AMT"].ToString() );
if (paymentAmountOnCheckout != paymentAmountFromPayPal)
{
Response.Redirect( "CheckoutError.aspx?" + "Desc=Amount%20total%20mismatch." );
}
}
catch (Exception)
{
Response.Redirect("CheckoutError.aspx?" + "Desc=Amount%20total%20mismatch.");
}
//get db context
ProductContext _db = new ProductContext();
//add order to db
_db.Orders.Add(myOrder);
_db.SaveChanges();
//Get the shopping cart items and process them
using (WingtipToys.Logic.ShoppingCartActions usersShoppingCart = new WingtipToys.Logic.ShoppingCartActions())
{
List<CartItem> myOrderList = usersShoppingCart.GetCartItems();
//add oderdetail info to the db for each product purchased
for (int i= 0; i < myOrderList.Count; i++)
{
//create new order detail object
var myOrderDetail = new OrderDetail();
myOrderDetail.OrderId = myOrder.OrderId;
myOrderDetail.Username = User.Identity.Name;
myOrderDetail.ProductId = myOrderList[i] .ProductId;
myOrderDetail.Quantity = myOrderList[i] .Quantity;
myOrderDetail.UnitPrice = myOrderList[i] .Product.UnitPrice;
// add orderdetail to db
_db.OrderDetails.Add(myOrderDetail);
_db.SaveChanges();
}
// set order id
Session["currentOrderId"] = myOrder.OrderId;
//displayorder info
List<Order> orderList = new List<Order>();
orderList.Add(myOrder);
ShipInfo.DataSource = orderList;
ShipInfo.DataBind();
//display order detail
OrderItemList.DataSource = myOrderList;
OrderItemList.DataBind();
}
}
else
{
Response.Redirect("CheckoutError.aspx?" + retMsg);
}
}
}
示例12: UpdateItem
public void UpdateItem(string updateCartID, int updateProductID, int quantity)
{
using (var _db = new WingtipToys.Models.ProductContext())
{
try
{
var myItem = (from c in _db.ShoppingCartItems where c.CartId == updateCartID && c.Product.ProductID == updateProductID select c).FirstOrDefault();
if (myItem != null)
{
myItem.Quantity = quantity;
_db.SaveChanges();
}
}
catch (Exception exp)
{
throw new Exception("ERROR: Unable to Update Cart Item - " + exp.Message.ToString(), exp);
}
}
}
示例13: SupplierSystemsSurvey
Tuple<int, int> SupplierSystemsSurvey(Good[] itemIDAndCount)
{
int timeOut = 100;
offSupplierSystem = true;
Tuple<int, int> result = null;
resultSupplierSystemGlobal = null;
using (ProductContext _db = new ProductContext())
{
foreach (var system in _db.SupplierSystems)
{
object[] parameters = new object[] { system.ID,
system.ConnectionString,
itemIDAndCount };
Thread thread = new Thread(SupplierSystemSurvey);
thread.Start(parameters);
}
}
for (int i = 0; i < 20 && null == result; ++i)
{
Thread.Sleep(timeOut);
lock (lockSupplierSystem)
{
result = resultSupplierSystemGlobal;
}
}
if (null == result)
{
if (offSupplierSystem)
{
throw new ExceptionSupplierSystemOff();
}
else
{
throw new ExceptionSupplierSystemNotGood();
}
}
Console.WriteLine(" resultSupplierSystem={0}:{1}", result.Item1, result.Item2);
return result;
}
示例14: UpdateShoppingCartDatabase
public void UpdateShoppingCartDatabase(String cartId, ShoppingCartUpdates[] CartItemUpdates)
{
using (var db = new WingtipToys.Models.ProductContext()) ;
{
try
{
int CartItemCount = CartItemUpdates.Count();
List<CartItem> myCart = GetCartItems();
foreach (var cartItem in myCart)
{
// Iterate through allrows within shopping cart list
for (int i = 0; i < CartItemCount; i++)
{
if (cartItem.Product.ProductID == CartItemUpdates[i].ProductId)
{
if (CartItemUpdates[i].PurchaseQuantity < 1 || CartItemUpdates[i].RemoveItem == true)
{
RemoveItem(cartId, cartItem.ProductId);
}
else
{
UpdateItem(cartId, cartItem.ProductId, CartItemUpdates[i].PurchaseQuantity);
}
}
}
}
}
catch (Exception exp)
{
throw new Exception("ERROR: Unable to update cart database - " + exp.Message.ToString(), exp);
}
}
}
示例15: RemoveItem
public void RemoveItem(string removeCartID, int removeProductID)
{
using (var _db = new WingtipToys.Models.ProductContext())
{
try
{
var myItem = (from c in _db.ShoppingCartItems where c.CartId == removeCartID && c.Product.ProductID == removeProductID select c).FirstOrDefault();
if (myItem != null)
{
// Remove Item
_db.ShoppingCartItems.Remove(myItem);
_db.SaveChanges();
}
}
catch (Exception exp)
{
throw new Exception("ERROR: Unable to remove cart item - " + exp.Message.ToString(), exp);
}
}
}