public void Can_Connect_To_DataBase_By_ProductContext_Whitch_Inherits_From_DbContextBase() { using (var context = new ProductContext()) { Assert.IsNotNull(context); } }
protected override void DoEnd () { base.DoEnd (); ClearProducts(); context.Close(); context = null; }
public void Created_ProductContext_Is_Valid_Type() { using (var context = new ProductContext()) { Assert.AreSame(typeof(ProductContext), context.GetType()); } }
public void Should_Get_Product_By_Id_With_Given_Context() { var context = new ProductContext(); var repo = new ProductRepository(context); var product = repo.Get(1); Assert.IsNotNull(product); Assert.AreEqual(1,product.ProductId); }
public void Dispose() { if (_db != null) { _db.Dispose(); _db = null; } }
// // GET: /Home/ public ViewResult Index() { //return View(db.Products.ToList()); using (var db = new ProductContext()) { return View(db.Products.ToList());//does it } }
public void Should_Geted_Product_By_Same_Id_With_And_Without_Given_Context_Be_Equal() { var context = new ProductContext(); var repo = new ProductRepository(context); var product1 = repo.Get(1); var product2 = repo.Get(1); Assert.AreSame(product1,product2); }
public static DbContext GetContext(DBKey index) { string key = GetKey(index); DbContext dc = (ProductContext)HttpContext.Current.Items[key]; if(dc==null){ dc = new ProductContext(); HttpContext.Current.Items.Add(key,dc); } return dc; }
public void Should_Get_Product_By_Id() { var context = new ProductContext(); var repo = new ProductRepository(context); var logger = new EntLibLogger(null); //Assert.IsNotNull(product); //Assert.AreEqual(1,product.ProductId); var service = new ProductService(repo,logger); var product = service.GetProduct(316); Assert.IsNotNull(product); Assert.AreEqual("Blade", product.Name); }
public void Can_ReadWrite_Data_From_ProductTable_In_DataBase() { using (var context = new ProductContext()) { context.Products.Add(new Product()); var list = context.Products.ToList(); //var items = context.Products.Find() var item = context.Products.Find(316); Assert.AreEqual("Blade",item.Name); Assert.IsNotEmpty(list); Assert.IsNotNull(context); } }
public bool StartWork(System.Func<object> backgroundProc) { if (null == backgroundProc) { return false; } context = new ProductContext(backgroundProc); if (!base.StartWork(BkgProc, context)) { context = null; return false; } return true; }
public override void Up() { AddColumn("Products", "SupplierCode", c => c.String(maxLength: 128)); AddForeignKey("Products", "SupplierCode", "Suppliers", "SupplierCode"); CreateIndex("Products", "SupplierCode"); using (var db = new ProductContext()) { db.Suppliers.AddOrUpdate( s => s.SupplierCode, new Supplier { SupplierCode = "UNKNOWN", Name = "Unknown Supplier" } ); } Sql("UPDATE Products SET SupplierCode = 'UNKNOWN' WHERE SupplierCode is NULL"); }
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()) { // Add product to DB. _db.Products.Add(myProduct); _db.SaveChanges(); } // Success. return true; }
/// <summary> /// 载入数据 /// </summary> /// <param name="info">BEProductDataInfo结构</param> private void LoadProductData(ProductData data) { this.m_id = data.id; this.HuoHao = data.huohao; this.DengJi_Id = data.dengji_id; this.MadePlace_Id = data.madeplace_id; this.PartName_Id = data.partname_id; this.SafeData_Id = data.safedata_id; this.StandardData_Id = data.standarddata_id; this.m_price = data.price; this.m_memo = data.memo; this.m_pwash = data.pwash == 1 ? true : false; this.m_tag_id = data.tag_id; this.m_wash_id = data.wash_id; this.m_lastamp = data.lastamp; this.m_pbad = data.pbad == 1 ? true : false; this.m_ptemplate = data.ptemplate == 1 ? true : false; this.m_wash_u = data.wash_u; this.m_template_data = data.template_data; this.Color_Id = (int)data.color_id; this.m_gyear = data.gyear; this.m_gmonth = data.gmonth; //加载EAN13信息 using (ProductContext ctx = new ProductContext()) { var ean13_data = from mater in ctx.BarcodeInfo where mater.product_id == this.m_id orderby mater.size_name select mater; foreach(var obj in ean13_data) { EAN13DataInfo info = new EAN13DataInfo(); info.Id = obj.id; info.SizeName = obj.size_name; info.BarcodeType = obj.barcode; info.Memo = obj.memo; this.m_ean13_data_list.Add(info); } } using (ProductContext ctx = new ProductContext()) { //洗唛宽度 this.m_wash_size = (from product in ctx.ProductData where product.id == this.m_id select product.WashPrintTemplate.daxiao).FirstOrDefault(); //处理成份信息 var materialData_entity = from mater in ctx.MaterialData where mater.product_id == this.m_id orderby mater.order_index select mater; foreach(var obj in materialData_entity) { MaterialDataInfo info = new MaterialDataInfo(); info.Id = obj.id; info.Type = obj.type; info.Sel = obj.sel; info.Memo = obj.memo; this.m_material_data_list.Add(info); } /*******************************************************/ //处理填充信息 var fill_entity = from fill in ctx.MaterialFill where fill.product_id == this.m_id orderby fill.size_name select fill; foreach(var obj in fill_entity) { UpdataMaterialFillList(obj.size_name, obj.fill); } this.MaterialFillInfo.material_type = (from fill in ctx.MaterialFill where fill.product_id == this.m_id select fill.type).FirstOrDefault(); //处理打印模板信息 } this.m_tagCODE93_filename = string.Format("{0}\\{1}", ConfigurationManager.AppSettings["Template"], GetTagFileName()); //this.m_wash_filename = string.Format("{0}\\{1}", ConfigurationManager.AppSettings["Template"], GetWashFileName()); this.m_wash_filename = string.Format("{0}\\{1}", ConfigurationManager.AppSettings["Template"],GetWashFileNameById(this.Wash_Id)); this.m_tagEAN13_filename = string.Format("{0}\\13{1}", ConfigurationManager.AppSettings["Template"], GetTagFileName()); }
/// <summary> /// 以产品货号构造 /// </summary> /// <param name="huohao">产品货号</param> public ProductObject(string huohao) { using (ProductContext ctx = new ProductContext()) { ProductData data = (from product in ctx.ProductData where product.huohao == huohao select product).FirstOrDefault(); if (data == null) this.HuoHao = huohao; else LoadProductData(data); } }
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.Username = 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 CheckoutStart.aspx. try { decimal paymentAmountOnCheckout = Convert.ToDecimal(Session["payment_amt"].ToString()); decimal paymentAmoutFromPayPal = Convert.ToDecimal(decoder["AMT"].ToString()); if (paymentAmountOnCheckout != paymentAmoutFromPayPal) { 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 OrderDetail information to the DB for each product purchased. for (int i = 0; i < myOrderList.Count; i++) { // Create a new OrderDetail 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 OrderId. Session["currentOrderId"] = myOrder.OrderId; // Display Order information. List<Order> orderList = new List<Order>(); orderList.Add(myOrder); ShipInfo.DataSource = orderList; ShipInfo.DataBind(); // Display OrderDetails. OrderItemList.DataSource = myOrderList; OrderItemList.DataBind(); } } else { Response.Redirect("CheckoutError.aspx?" + retMsg); } } }
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.Username = 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 CheckoutStart.aspx. try { decimal paymentAmountOnCheckout = Convert.ToDecimal(Session["payment_amt"].ToString()); decimal paymentAmoutFromPayPal = Convert.ToDecimal(decoder["AMT"].ToString()); if (paymentAmountOnCheckout != paymentAmoutFromPayPal) { 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 (YogaEssentials1.Logic.ShoppingCartActions usersShoppingCart = new YogaEssentials1.Logic.ShoppingCartActions()) { List <CartItem> myOrderList = usersShoppingCart.GetCartItems(); // Add OrderDetail information to the DB for each product purchased. for (int i = 0; i < myOrderList.Count; i++) { // Create a new OrderDetail 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 OrderId. Session["currentOrderId"] = myOrder.OrderId; // Display Order information. List <Order> orderList = new List <Order>(); orderList.Add(myOrder); ShipInfo.DataSource = orderList; ShipInfo.DataBind(); // Display OrderDetails. OrderItemList.DataSource = myOrderList; OrderItemList.DataBind(); } } else { Response.Redirect("CheckoutError.aspx?" + retMsg); } } }
public ProductsController(ProductContext context, IDistributedCache cache) { _context = context; _cache = cache; }
public void UpdateShoppingCartDatabase(String cartId, ShoppingCartUpdates[] CartItemUpdates) { using (var db = new ProductContext()) { try { int CartItemCount = CartItemUpdates.Count(); List<CartItem> myCart = GetCartItems(); foreach (var cartItem in myCart) { // Iterate through all rows 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); } } }
public int GetWashFileNameId() { string file = this.GetWashFileName(); using (ProductContext ctx = new ProductContext()) { return (from wash in ctx.WashPrintTemplate where wash.file_name == file select wash.id).FirstOrDefault(); } }
public UsersController(ProductContext context) { _context = context; }
public ProductsController(ProductContext context) { _context = context; }
public PostProductCommandHandler(ProductContext context) { _context = context; }
public ProductRespositoryImpl(ProductContext _productContext) { productContext = _productContext; }
// GET: /<controller>/ public IActionResult Index() { ProductContext context = HttpContext.RequestServices.GetService(typeof(Test_scandiweb.Model.ProductContext)) as ProductContext; return(View(context.GetAllProducts())); }
public ProductService(ProductContext db) { _db = db ?? throw new ArgumentNullException(nameof(db)); }
public CartController(ProductContext context, IHttpContextAccessor httpContext) { _context = context; _httpContext = httpContext; }
/// <summary> /// 生成条型码 /// </summary> /// <param name="size_name">规格</param> /// <returns>条型码字符串</returns> public string BuildBarcode(string size_name) { using (ProductContext ctx = new ProductContext()) { string barcodePrefix = (from entity in ctx.PartName where entity.id == this.m_partname_id select entity.barcode).FirstOrDefault(); return string.Format("{0}{1}{2}", barcodePrefix, this.m_huohao, size_name); } }
public string GetWashFileName() { int materialdata_count = 0; if(m_wash_u > 0) { using (ProductContext ctx = new ProductContext()) { WashPrintTemplate wash_info = (from wash in ctx.WashPrintTemplate where wash.id == this.m_wash_u select wash).FirstOrDefault(); return wash_info.file_name; } } if (this.m_huohao.Substring(0, 1) == "L") { return "WashG.btw"; } if (this.m_huohao.Substring(0,1) == "W") { return "WashW.btw"; } foreach (var obj in this.m_material_data_list) { if (obj.Sel) ++materialdata_count; } int row = materialdata_count + (string.IsNullOrEmpty(this.MaterialFillInfo.material_type) ? 0 : 1); string str_class = this.m_huohao.Substring(0, 1); string file_name = string.Empty; using (ProductContext ctx = new ProductContext()) { IQueryable<WashPrintTemplate> wash_info = null; if(this.m_huohao.Substring(0,1) == "S") { int count = Regex.Matches(this.m_huohao, "-").Count; if(count == 1) { wash_info = from wash in ctx.WashPrintTemplate where wash.type.IndexOf(str_class) >= 0 && wash.daxiao == "7cm" select wash; } else { wash_info = from wash in ctx.WashPrintTemplate where wash.type.IndexOf(str_class) >= 0 && wash.daxiao == "4cm" select wash; } } else { wash_info = from wash in ctx.WashPrintTemplate where wash.type.IndexOf(str_class) >= 0 select wash; } foreach(var wash in wash_info) { if(wash.file_name.Substring(5,1) == row.ToString()) { file_name = wash.file_name; break; } } } if(this.m_ptemplate) { file_name = string.Format("T{0}", file_name); } return file_name; }
public ProductRepository(ProductContext db) { _db = db ?? throw new ArgumentNullException(nameof(db)); }
public void RemoveItem(string removeCartID, int removeProductID) { using (var _db = new 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); } } }
public HomeController(IMapper mapper, IProductRepository repository, ProductContext context) { _mapper = mapper; _repository = repository; _context = context; }
protected void Page_Load(object sender, EventArgs e) { if (!IsPostBack) { // Verify user has completed the checkout process. if ((string)Session["userCheckoutCompleted"] != "true") { Session["userCheckoutCompleted"] = string.Empty; Response.Redirect("CheckoutError.aspx?" + "Desc=Unvalidated%20Checkout."); } NVPAPICaller payPalCaller = new NVPAPICaller(); string retMsg = ""; string token = ""; string finalPaymentAmount = ""; string PayerID = ""; NVPCodec decoder = new NVPCodec(); token = Session["token"].ToString(); PayerID = Session["payerId"].ToString(); finalPaymentAmount = Session["payment_amt"].ToString(); bool ret = payPalCaller.DoCheckoutPayment(finalPaymentAmount, token, PayerID, ref decoder, ref retMsg); if (ret) { // Retrieve PayPal confirmation value. string PaymentConfirmation = decoder["PAYMENTINFO_0_TRANSACTIONID"].ToString(); TransactionId.Text = PaymentConfirmation; ProductContext _db = new ProductContext(); // Get the current order id. int currentOrderId = -1; if (Session["currentOrderId"] != string.Empty) { currentOrderId = Convert.ToInt32(Session["currentOrderID"]); } Order myCurrentOrder; if (currentOrderId >= 0) { // Get the order based on order id. myCurrentOrder = _db.Orders.Single(o => o.OrderId == currentOrderId); // Update the order to reflect payment has been completed. myCurrentOrder.PaymentTransactionId = PaymentConfirmation; // Save to DB. _db.SaveChanges(); } // Clear shopping cart. using (WingtipToys.Logic.ShoppingCartActions usersShoppingCart = new WingtipToys.Logic.ShoppingCartActions()) { usersShoppingCart.EmptyCart(); } // Clear order id. Session["currentOrderId"] = string.Empty; } else { Response.Redirect("CheckoutError.aspx?" + retMsg); } } }
protected GenericRepository(ProductContext aContext) { Context = aContext; }
public _productRepository(ProductContext dbContext) { _dbContext = dbContext; }
public ProductsController(ProductContext context, IHostingEnvironment hostingEnvironment) { _context = context; _environment = hostingEnvironment; }
public ProductRepository(ProductContext context) { _context = context; }
public ProductsEFController(ProductContext context, IMemoryCache memoryCache) { _context = context; _cache = memoryCache; }
/// <summary> /// 保存记录 /// </summary> /// <returns></returns> public SaveResult Save() { SaveResult result = new SaveResult(); //save new if(this.m_id == 0) { if(this.m_huohao.Trim() == string.Empty) { result.Code = CodeType.Error; result.Message = "[产品货号]不能为空或输入的不合法,无法保存!"; return result; } if (CheckProductHuoHaoExist(this.m_huohao.Trim())) { result.Code = CodeType.Error; result.Message = "[产品货号]重复,无法保存!"; return result; } if(this.m_partname_id == 0) { result.Code = CodeType.Error; result.Message = "[产品种类]不能为空,无法保存!"; return result; } if(this.m_dengji_id == 0) { result.Code = CodeType.Error; result.Message = "[产品等级]不能为空,无法保存!"; return result; } if(this.m_madeplace_id == 0) { result.Code = CodeType.Error; result.Message = "[产品产地]不能为空,无法保存!"; return result; } if(this.m_price == 0) { result.Code = CodeType.Error; result.Message = "[产品价格]不能为空,无法保存!"; return result; } if(this.m_safedata_id == 0) { result.Code = CodeType.Error; result.Message = "[安全标准]不能为空,无法保存!"; return result; } if(this.m_standarddata_id == 0) { result.Code = CodeType.Error; result.Message = "[执行标准]不能为空,无法保存!"; return result; } if(this.m_material_data_list.Count == 0) { result.Code = CodeType.Error; result.Message = "[面料成份信息列表]不能为空,无法保存!"; return result; } //当填充材质不为空时处理填充数据 if(!string.IsNullOrEmpty(this.MaterialFillInfo.material_type)) { foreach(MaterialFillInfoObject.MaterialFillData data in this.MaterialFillInfo.m_material_fill_list) { if(data.Fill == "0") { result.Code = CodeType.Error; result.Message = "填充规则数据制定不完整,请重新制定!"; return result; } } } ProductData info = new ProductData(); info.huohao = this.m_huohao; info.partname_id = this.m_partname_id; info.dengji_id = this.m_dengji_id; info.madeplace_id = this.m_madeplace_id; info.price = this.m_price; info.safedata_id = this.m_safedata_id; info.standarddata_id = this.m_standarddata_id; info.pwash = this.m_pwash == true ? 1:0; info.pbad = this.m_pbad == true ? 1:0; info.tag_id = this.GetTagFileNameId(); info.memo = this.m_memo; info.wash_id = this.GetWashFileNameId(); info.color_id = this.m_color_id; info.gyear = this.m_gyear; info.gmonth = this.m_gmonth; info.lastamp = System.Guid.NewGuid(); if(this.m_ptemplate) { info.ptemplate = 1; info.template_data = this.m_template_data; } if(info.tag_id == 0) { result.Code = CodeType.Error; result.Message = "系统未能找到对应的吊牌模板文件,保存无法继续!"; return result; } if(info.wash_id == 0) { if (this.m_partname_id == 21) info.wash_id = 1; else { result.Code = CodeType.Error; result.Message = "系统未能找到对应的洗唛模板文件,保存无法继续!"; return result; } } using (ProductContext ctx = new ProductContext()) { ctx.ProductData.Add(info); if(ctx.SaveChanges() == 0) { result.Code = CodeType.Error; result.Message = "产品基本信息保存失败"; return result; } } using (ProductContext ctx = new ProductContext()) { this.m_id = (from product in ctx.ProductData where product.huohao == this.m_huohao select product.id).FirstOrDefault(); } int index = 1; foreach(MaterialDataInfo ob in this.m_material_data_list) { using (ProductContext ctx = new ProductContext()) { MaterialData entity = new MaterialData(); entity.product_id = this.m_id; entity.sel = ob.Sel; entity.type = ob.Type; entity.order_index = index++; entity.memo = ob.Memo; entity.lastamp = System.Guid.NewGuid(); ctx.MaterialData.Add(entity); ctx.SaveChanges(); } } if(!string.IsNullOrEmpty(this.MaterialFillInfo.material_type)) { foreach(MaterialFillInfoObject.MaterialFillData fill in this.MaterialFillInfo.m_material_fill_list) { using (ProductContext ctx = new ProductContext()) { MaterialFill entity = new MaterialFill(); entity.product_id = this.m_id; entity.size_name = fill.SizeName; entity.type = this.MaterialFillInfo.material_type; entity.fill = fill.Fill; entity.lastamp = System.Guid.NewGuid(); ctx.MaterialFill.Add(entity); ctx.SaveChanges(); } } } result.Code = CodeType.Ok; result.Message = "保存成功!"; return result; } //Edit Save if(this.m_id > 0) { if (this.m_huohao.Trim() == string.Empty) { result.Code = CodeType.Error; result.Message = "[产品货号]不能为空或输入的不合法,无法保存!"; return result; } using (ProductContext ctx = new ProductContext()) { int count = (from product in ctx.ProductData where product.id == this.m_id && product.huohao == this.m_huohao select product).Count(); if(count > 1) { result.Code = CodeType.Error; result.Message = "[产品货号]重复,无法保存!"; return result; } } if (this.m_price == 0) { result.Code = CodeType.Error; result.Message = "[产品价格]不能为空,无法保存!"; return result; } if (this.m_safedata_id == 0) { result.Code = CodeType.Error; result.Message = "[安全标准]不能为空,无法保存!"; return result; } if (this.m_standarddata_id == 0) { result.Code = CodeType.Error; result.Message = "[执行标准]不能为空,无法保存!"; return result; } if (this.m_material_data_list.Count == 0) { result.Code = CodeType.Error; result.Message = "[面料成份信息列表]不能为空,无法保存!"; return result; } //当填充材质不为空时处理填充数据 if (!string.IsNullOrEmpty(this.MaterialFillInfo.material_type)) { foreach(MaterialFillInfoObject.MaterialFillData data in this.MaterialFillInfo.m_material_fill_list) { if(data.Fill == "0") { result.Code = CodeType.Error; result.Message = "填充规则数据制定不完整,请重新制定!"; return result; } } } using (ProductContext ctx = new ProductContext()) { System.Guid entity_lastamp = (from product in ctx.ProductData where product.id == this.m_id select product.lastamp).FirstOrDefault(); if(entity_lastamp != this.m_lastamp) { result.Code = CodeType.Error; result.Message = "当前编辑的记录已经变更,无法保存!"; return result; } } using (ProductContext ctx = new ProductContext()) { ProductData info = (from entity in ctx.ProductData where entity.id == this.m_id select entity).FirstOrDefault(); info.huohao = this.m_huohao; info.partname_id = this.m_partname_id; info.dengji_id = this.m_dengji_id; info.madeplace_id = this.m_madeplace_id; info.price = this.m_price; info.safedata_id = this.m_safedata_id; info.standarddata_id = this.m_standarddata_id; info.pwash = this.m_pwash == true ? 1:0; info.pbad = this.m_pbad == true ?1:0; info.memo = this.m_memo; info.tag_id = this.GetTagFileNameId(); info.wash_id = this.GetWashFileNameId(); info.color_id = this.m_color_id; info.gyear = this.m_gyear; info.gmonth = this.m_gmonth; info.lastamp = System.Guid.NewGuid(); if (this.m_ptemplate) { info.ptemplate = 1; info.template_data = this.m_template_data; } if (info.tag_id == 0) { result.Code = CodeType.Error; result.Message = "系统未能找到对应的吊牌模板文件,保存无法继续!"; return result; } if (info.wash_id == 0 ) { if(this.m_partname_id == 21) { info.wash_id = 1; } else { result.Code = CodeType.Error; result.Message = "系统未能找到对应的洗唛模板文件,保存无法继续!"; return result; } } if (ctx.SaveChanges() == 0) { result.Code = CodeType.Error; result.Message = "产品基本信息保存失败"; return result; } } //保存成份信息 using (ProductContext ctx = new ProductContext()) { var mi = from entity in ctx.MaterialData where entity.product_id == this.m_id select entity; foreach(var obj in mi) { ctx.MaterialData.Remove(obj); } ctx.SaveChanges(); } int index = 1; foreach (MaterialDataInfo ob in this.m_material_data_list) { using (ProductContext ctx = new ProductContext()) { MaterialData entity = new MaterialData(); entity.product_id = this.m_id; entity.sel = ob.Sel; entity.type = ob.Type; entity.order_index = index++; entity.memo = ob.Memo; entity.lastamp = System.Guid.NewGuid(); ctx.MaterialData.Add(entity); ctx.SaveChanges(); } } //////////////////////////////////////////////////////// using (ProductContext ctx = new ProductContext()) { var mi = from entity in ctx.MaterialFill where entity.product_id == this.m_id select entity; foreach (var obj in mi) { ctx.MaterialFill.Remove(obj); } ctx.SaveChanges(); } if (!string.IsNullOrEmpty(this.MaterialFillInfo.material_type)) { foreach (MaterialFillInfoObject.MaterialFillData fill in this.MaterialFillInfo.m_material_fill_list) { using (ProductContext ctx = new ProductContext()) { MaterialFill entity = new MaterialFill(); entity.product_id = this.m_id; entity.size_name = fill.SizeName; entity.type = this.MaterialFillInfo.material_type; entity.fill = fill.Fill; entity.lastamp = System.Guid.NewGuid(); ctx.MaterialFill.Add(entity); ctx.SaveChanges(); } } } result.Code = CodeType.Ok; result.Message = "保存成功!"; return result; } return result; }
public ValuesController(ProductContext context) { _context = context; }
public void SaveEAN13Info() { using (ProductContext ctx = new ProductContext()) { var data1 = from entity in ctx.BarcodeInfo where entity.product_id == this.m_id select entity; foreach ( var obj in data1) { ctx.BarcodeInfo.Remove(obj); } ctx.SaveChanges(); } foreach(EAN13DataInfo info in this.m_ean13_data_list ) { using (ProductContext ctx = new ProductContext()) { BarcodeInfo entity = new BarcodeInfo(); entity.product_id = this.m_id; entity.size_name = info.SizeName; entity.barcode = info.BarcodeType; entity.memo = info.Memo; entity.lastamp = System.Guid.NewGuid(); ctx.BarcodeInfo.Add(entity); ctx.SaveChanges(); } } }
public DeleteProductCommandHandler(ProductContext context) { _context = context; }
public static bool CheckProductHuoHaoExist(string huohao) { using (ProductContext ctx = new ProductContext()) { int count = (from product in ctx.ProductData where product.huohao == huohao select product).Count(); if (count > 0) return true; else return false; } }
public StoreController() { db = new ProductContext(); }
public int GetTagFileNameId() { string file = this.GetTagFileName(); using (ProductContext ctx = new ProductContext()) { return (from tag in ctx.TagPrintTemplate where tag.file_name == file select tag.id).FirstOrDefault(); } }
protected void Page_Load(object sender, EventArgs e) { if (!IsPostBack) { // Verify user has completed the checkout process. if ((string)Session["userCheckoutCompleted"] != "true") { Session["userCheckoutCompleted"] = string.Empty; Response.Redirect("CheckoutError.aspx?Desc=Unvalidated%20Checkout."); } NVPAPICaller payPalCaller = new NVPAPICaller(); string retMsg = string.Empty; string token = Session["token"].ToString(); string finalPaymentAmount = Session["payment_amt"].ToString(); string PayerID = Session["payerId"].ToString(); NVPCodec decoder = new NVPCodec(); bool ret = payPalCaller.DoCheckoutPayment(finalPaymentAmount, token, PayerID, ref decoder, ref retMsg); if (ret) { // Retrieve PayPal confirmation value. string PaymentConfirmation = decoder["PAYMENTINFO_0_TRANSACTIONID"].ToString(); TransactionId.Text = PaymentConfirmation; ProductContext _db = new ProductContext(); // Get the current order id. int currentOrderId = -1; try { currentOrderId = (int)Session["currentOrderId"]; } catch (InvalidCastException) { Response.Redirect("~/Default.aspx"); } Order myCurrentOrder; if (currentOrderId >= 0) { // Get the order based on order id. myCurrentOrder = _db.Orders.Single(o => o.OrderId == currentOrderId); // Update the order to reflect payment has been completed. myCurrentOrder.PaymentTransactionId = PaymentConfirmation; // Save to DB. _db.SaveChanges(); } // Clear shopping cart. using (ShoppingCartActions usersShoppingCart = new ShoppingCartActions()) { usersShoppingCart.EmptyCart(); } // Clear order id. Session["currentOrderId"] = string.Empty; } else { Response.Redirect("CheckoutError.aspx?" + retMsg); } } }
public string GetWashFileNameById(int id) { using(ProductContext ctx = new ProductContext()) { return ( from wash in ctx.WashPrintTemplate where wash.id == id select wash.file_name).FirstOrDefault(); } }
public ProductRepository(ProductContext context) { _context = context; }
/// <summary> /// 以产品ID号构造 /// </summary> /// <param name="id">ID号</param> public ProductObject(int id) { using (ProductContext ctx = new ProductContext()) { ProductData data = (from product in ctx.ProductData where product.id == id select product).FirstOrDefault(); if(data != null) LoadProductData(data); } }
public DiagnosticsModel(ProductContext context) { _context = context; }
public void UpdateItem(string updateCartID, int updateProductID, int quantity) { using (var _db = new 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); } } }
// This method gets called by the runtime. Use this method to configure the HTTP request pipeline. public void Configure(IApplicationBuilder app, IHostingEnvironment env, ILoggerFactory loggerFactory, ProductContext context) { loggerFactory.AddConsole(Configuration.GetSection("Logging")); loggerFactory.AddDebug(); if (env.IsDevelopment()) { app.UseDeveloperExceptionPage(); app.UseBrowserLink(); } else { app.UseExceptionHandler("/Home/Error"); } app.UseStaticFiles(); app.UseMvc(routes => { routes.MapRoute( name: "default", template: "{controller=Home}/{action=Index}/{id?}"); }); DbInitialize.Initialize(context); }
public EFStockRepository(ProductContext context) : base(context) { }
public DeleteOrderModel(ProductContext context, UserManager <TroydonFitnessWebsiteUser> userManager) : base(userManager) { _context = context; }
public IngredientRepository(ProductContext productContext) : base(productContext) { }
public AdminController(ProductContext context, IHostingEnvironment hostingEnvironment) { _context = context; _hostingEnvironment = hostingEnvironment; }
public IndexModel(ILogger <IndexModel> logger, ProductContext context) { _logger = logger; _dbContext = context; }
public UnitOfWork(ProductContext productContext) { _db = productContext; }
// Dependency injection public ProductController(ProductContext context) { this._context = context; }
public override EFRepositoryBase <Ingredient> GetRepository(ProductContext context) { return(new EFIngredientRepository(context)); }