public long InsertProduct(ProductEntity entity) { var dbCommand = DB.GetStoredProcCommand("spA_Product_i"); AddInParameter(dbCommand, entity, false); DB.AddOutParameter(dbCommand, "@ProductId", DbType.Int64, 8); DB.ExecuteNonQuery(dbCommand); entity.ProductId = DbHelper.ConvertTo<long>(DB.GetParameterValue(dbCommand, "@ProductId")); return entity.ProductId; }
public void PlaceProduct(ProductEntity product) { if (product == null) { var msg = Msgs.product_does_not_exist; throw new Exceptions.ExternalException(msg); } if (product.Validate()) { Repository.Update(product); } }
public bool Delete(ProductEntity entity) { try { _productRepository.Delete(entity); return true; } catch (Exception e) { _log.Error(e,"数据库操作出错"); return false; } }
public ProductEntity Create(ProductEntity entity) { try { _productRepository.Insert(entity); return entity; } catch (Exception e) { _log.Error(e,"数据库操作出错"); return null; } }
protected void AddInParameter(DbCommand command, ProductEntity entity, bool containsPrimaryKey) { DB.AddInParameter(command, "@ProductName", DbType.String, entity.ProductName); DB.AddInParameter(command, "@CreateTime", DbType.DateTime, entity.CreateTime); DB.AddInParameter(command, "@UpdateTime", DbType.DateTime, entity.UpdateTime); if (containsPrimaryKey) { DB.AddInParameter(command, "@ProductId", DbType.Int64, entity.ProductId); } }
/// <summary> /// 更新Product 实体 /// </summary> /// <param name="entity">ProductModel对象</param> public void UpdateProduct(ProductEntity entity) { var parameters = new StatementParameterCollection(); parameters.AddInParameter("@ProductId", DbType.Int64, entity.ProductId); parameters.AddInParameter("@ProductName", DbType.String, entity.ProductName); parameters.AddInParameter("@CreateTime", DbType.DateTime, entity.CreateTime); parameters.AddInParameter("@UpdateTime", DbType.DateTime, entity.UpdateTime); try { DB.ExecSp("spA_Product_u", parameters); } catch (Exception ex) { throw new DalException("调用 ProductDal 时,访问 UpdateProduct 时出错", ex); } }
/// <summary> /// 向数据库中插入 Product 实体 /// </summary> /// <param name="entity">ProductModel对象</param> /// <returns>自增主键</returns> public long InsertProduct(ProductEntity entity) { var parameters = new StatementParameterCollection(); parameters.AddOutParameter("@ProductId", DbType.Int64, 8); parameters.AddInParameter("@ProductName", DbType.String, entity.ProductName); parameters.AddInParameter("@CreateTime", DbType.DateTime, entity.CreateTime); parameters.AddInParameter("@UpdateTime", DbType.DateTime, entity.UpdateTime); try { DB.ExecSp("spA_Product_i", parameters); return Convert.ToInt64(parameters["@ProductId"].Value); } catch (Exception ex) { throw new DalException("调用 ProductDal 时,访问 InsertProduct 时出错", ex); } }
public void ReplaceProduct(ProductEntity product, string newBin) { if(product == null) { var msg = Msgs.product_does_not_exist; throw new ExternalException(msg); } if(string.IsNullOrEmpty(newBin)) { var msg = Msgs.new_product_bin_is_not_specified; throw new ExternalException(msg); } if(product.Validate()) { product.Bin = newBin; product.Status = ProductStatus.Placed; Repository.Replace(product); } }
/// <summary> /// Method To Insert Product Into DB From UI /// </summary> /// <param name="_product"></param> /// <returns></returns> public bool AddProduct(ProductEntity _product) { bool isSuccess = false; using (var scope = new TransactionScope()) { //var config = new MapperConfiguration(cfg => { cfg.CreateMap<ProductEntity, Product>(); }); //IMapper mapper = config.CreateMapper(); // var productsModel = mapper.Map<ProductEntity, Product>(_product); var productsModel = Mapper.DynamicMap<ProductEntity, Product>(_product); _unitOfWork.ProductRepository.Insert(productsModel); _unitOfWork.Save(); scope.Complete(); isSuccess = true; } return isSuccess; }
/// <summary> /// Updates a product /// </summary> /// <param name="productId"></param> /// <param name="productEntity"></param> /// <returns></returns> public bool UpdateProduct(int productId, ProductEntity productEntity) { var success = false; if (productEntity != null) { using (var scope = new TransactionScope()) { var product = _unitOfWork.ProductRepository.GetByID(productId); if (product != null) { product.ProductName = productEntity.ProductName; _unitOfWork.ProductRepository.Update(product); _unitOfWork.Save(); scope.Complete(); success = true; } } } return(success); }
public static IEnumerable <SourceItemEntity> Build(ProductEntity product, DateTime on, string CreatedBy, ISheet sheet) { var result = new List <SourceItemEntity>(); for (int row = 2; row <= sheet.getRows(); row++) { var source = sheet.get <string>(row, 1); var group = sheet.get <string>(row, 2); var good = sheet.get <int>(row, 3); var total = sheet.get <int>(row, 4); var target = DateTime.Parse(sheet.get <string>(row, 5)); var measure = sheet.get <decimal>(row, 6); var sourceInstance = product.Sources.Where(e => e.Name == source).Single(); var targetGroup = sourceInstance.ParseGroup(group); var item = SourceEntity.Factory.CreateItem(sourceInstance, target, good, total, on, CreatedBy, targetGroup); result.Add(item); } return(result); }
public void EditarProduto() { ProductEntity product = new ProductEntity() { Name = "Arroz", Discount = 20, Price = 19, Stock = 30 }; Moq.Mock <IRepositoryProducts> mock = new Moq.Mock <IRepositoryProducts>(); mock.Setup(p => p.Insert(product)).ReturnsAsync(product); IRepositoryProducts repository = mock.Object; repository.Insert(product); product.Name = "Feijão"; mock.Setup(p => p.Update(product)).ReturnsAsync(product); repository = mock.Object; var result = repository.Update(product); Assert.NotNull(result.Result); }
public static void Main(string[] args) { Container cc = new Container(new Uri("http://localhost:24339/")); var entity = new ProductEntity { Id = 3, Configuration = new Configuration { Things = new ObservableCollection <Product>(new List <Product> { new ProductA { Name = "ProductC", Price = 10.0, Category = "CategoryC" } }) } }; cc.AddToProductEntity(entity); cc.SaveChanges(); }
public async Task <IActionResult> Insert() { var categories = Enumerable.Range(0, 10).Select(x => { var model = CategoryMother.Create(); var entity = CategoryEntity.Create(model.Name); return(entity); }); await storageTableService.Create(categories); var products = Enumerable.Range(0, 10).Select(x => { var model = ProductMother.Create(); var entity = ProductEntity.Create(model.Name, model.Price, model.Quantity); return(entity); }); await storageTableService.Create(products); return(RedirectToAction(nameof(Index))); }
public IActionResult GetById(int?id) { try { if (id == null) { return(BadRequest("El identificador es nulo.")); } ProductEntity productEntity = _services.GetById(id); if (productEntity == null) { return(NotFound("Producto no encontrado.")); } return(Ok(productEntity)); } catch (Exception ex) { return(StatusCode(500, "Ocurrio un error al obtener los datos del producto. " + ex.Message)); } }
public static ProductEntity ToEntity(this Product product) { var entityPostResponse = new ProductEntity() { SellerId = product.SellerId, Id = product.Id, Name = product.Name, Description = product.Description, HeroImage = product.HeroImage, Price = product.Price, Category = product.Category, Status = product.Status, PostDateTime = product.PostDateTime, ExpirationDate = product.ExpirationDate, Images = product.Images, PurchasedDate = product.PurchasedDate, PickupAddress = product.PickupAddress }; return(entityPostResponse); }
/// <summary> /// 编辑产品 /// </summary> /// <returns></returns> public ActionResult Edit() { string CompanyID = WebUtil.GetFormValue <string>("CompanyID"); ProductEntity entity = WebUtil.GetFormObject <ProductEntity>("Entity"); ProductProvider provider = new ProductProvider(CompanyID); int line = provider.Update(entity); DataResult result = new DataResult(); if (line > 0) { result.Code = (int)EResponseCode.Success; result.Message = "产品修改成功"; } else { result.Code = (int)EResponseCode.Exception; result.Message = "产品修改失败"; } return(Content(JsonHelper.SerializeObject(result))); }
public async Task <ProductModel> AddProduct(AddProductModel model) { var product = new ProductEntity() { Name = model.Name, Price = model.Price, Description = model.Description }; var entity = await _db.Products.AddAsync(product); await _db.SaveChangesAsync(); await entity.ReloadAsync(); product = await _db.Products .AsNoTracking() .FirstOrDefaultAsync(v => v.Id == entity.Entity.Id); return(new ProductModel(product)); }
private void Save() { ProductEntity productEntity = new ProductEntity(); productEntity.Name = txtName.Text; productEntity.Price = decimal.Parse(Helpers.CurrencyToString(txtPrice.Text).ToString()); productEntity.MadeDate = DateTime.Parse(dtpMadeDate.Value.ToString("dd/MM/yyyy")); productEntity.ExpiredDate = DateTime.Parse(dtpExpiredDate.Value.ToString("dd/MM/yyyy")); productEntity.Active = chkActive.Checked; productEntity.Photo = pic; if (getId != Guid.Empty) { productEntity.Id = getId; ProductDao.Update(productEntity); } else { productEntity.Id = Guid.NewGuid(); ProductDao.Insert(productEntity); } }
protected ProductSourceCodeDiscountEntity(SerializationInfo info, StreamingContext context) : base(info, context) { if (SerializationHelper.Optimization != SerializationOptimization.Fast) { _coupons = (CouponsEntity)info.GetValue("_coupons", typeof(CouponsEntity)); if (_coupons != null) { _coupons.AfterSave += new EventHandler(OnEntityAfterSave); } _product = (ProductEntity)info.GetValue("_product", typeof(ProductEntity)); if (_product != null) { _product.AfterSave += new EventHandler(OnEntityAfterSave); } base.FixupDeserialization(FieldInfoProviderSingleton.GetInstance()); } // __LLBLGENPRO_USER_CODE_REGION_START DeserializationConstructor // __LLBLGENPRO_USER_CODE_REGION_END }
public static List <ProductEntity> Mapper(List <ProductModel> pmList) { List <ProductEntity> peList = new List <ProductEntity>(); foreach (var pm in pmList) { ProductEntity pEntity = new ProductEntity { Id = pm.Id, Code = pm.Code, Description = pm.Description, ImageUrl = pm.ImageUrl, Name = pm.Name, Skus = SkuMapper.Mapper(pm.Skus) }; peList.Add(pEntity); } return(peList); }
public static ProductEntity ConvertToProductEntity(this Product product) { ProductEntity productEntity = new ProductEntity(); productEntity.Id = product.Id; productEntity.Categories = new List <ShoppingCartEL.CategoryEntity>(); foreach (var obj in product.Category_Product_Mapping) { productEntity.Categories.Add(new ShoppingCartEL.CategoryEntity() { Id = obj.Category.Id, CategoryName = obj.Category.CategoryName }); } productEntity.ImageUrl = product.ImageUrl; productEntity.IsAvailable = product.IsAvailable.HasValue ? product.IsAvailable.Value : false; productEntity.Name = product.Name; productEntity.Price = product.Price.HasValue ? product.Price.Value : 0; productEntity.Quantity = product.Quantity.HasValue ? product.Quantity.Value : 0; productEntity.Description = product.Description; return(productEntity); }
private void btnDirectUpdate_Click(object sender, EventArgs e) { /// Set Discontinued=True ALL products of category 'Sea Food' (8) /// This is for test the AuditDirectUpdateOfEntities of SimpleTextFileAuditor Class // category = seaFood IPredicateExpression filter = new PredicateExpression(); filter.Add(ProductFields.CategoryId == 8); // set discontinued ProductEntity productUpdatedValues = new ProductEntity(); productUpdatedValues.Discontinued = true; // perform update int updatedRows = (new ProductCollection()).UpdateMulti(productUpdatedValues, filter); // show message to user MessageBox.Show(string.Format("Updated rows: {0}", updatedRows)); }
public static ProductEntity FromDto(this Product dto) { OnBeforeDtoToEntity(dto); var entity = new ProductEntity(); // Map entity properties entity.ProductName = dto.ProductName; entity.SupplierId = dto.SupplierId; entity.CategoryId = dto.CategoryId; entity.QuantityPerUnit = dto.QuantityPerUnit; entity.UnitPrice = dto.UnitPrice; entity.UnitsInStock = dto.UnitsInStock; entity.UnitsOnOrder = dto.UnitsOnOrder; entity.ReorderLevel = dto.ReorderLevel; entity.Discontinued = dto.Discontinued; // Map entity associations // n:1 Category association if (dto.Category != null) { entity.Category = dto.Category.FromDto(); } // 1:n OrderDetails association if (dto.OrderDetails != null && dto.OrderDetails.Any()) { foreach (var relatedDto in dto.OrderDetails) { entity.OrderDetails.Add(relatedDto.FromDto()); } } // n:1 Supplier association if (dto.Supplier != null) { entity.Supplier = dto.Supplier.FromDto(); } OnAfterDtoToEntity(dto, entity); return(entity); }
public void GetProduct() { var options = new DbContextOptionsBuilder <DataContext>() .UseInMemoryDatabase("GetProduct").Options; //Given var catalgue = new CatalogueEntity { Id = Guid.NewGuid(), Name = "Sports" }; var product1 = new ProductEntity { Id = Guid.NewGuid(), Name = "Golf Clubs", CatalogueId = catalgue.Id }; var product2 = new ProductEntity { Id = Guid.NewGuid() }; using (var context = new DataContext(options)) { context.Catalogue.Add(catalgue); context.Product.Add(product2); context.Product.Add(product1); context.SaveChanges(); } using (var context = new DataContext(options)) { var service = new ProductService(context); //When var actual = service.GetProduct(product1.Id); //Then Assert.Equal(product1.Id, actual.Id); Assert.Equal(product1.Name, actual.Name); Assert.Equal(catalgue.Id, actual.CatalogueId); Assert.Equal(catalgue.Name, actual.CatalogueName); } }
/// <summary> /// 查询分页 /// </summary> /// <returns></returns> public ActionResult GetPage() { string CompanyID = WebUtil.GetFormValue <string>("CompanyID"); int PageIndex = WebUtil.GetFormValue <int>("PageIndex", 1); int PageSize = WebUtil.GetFormValue <int>("PageSize", 10); string BarCode = WebUtil.GetFormValue <string>("BarCode"); string ProductName = WebUtil.GetFormValue <string>("ProductName"); string FactoryNum = WebUtil.GetFormValue <string>("FactoryNum"); string InCode = WebUtil.GetFormValue <string>("InCode"); string UnitNum = WebUtil.GetFormValue <string>("UnitNum"); string CateNum = WebUtil.GetFormValue <string>("CateNum"); string Size = WebUtil.GetFormValue <string>("Size"); int IsSingle = WebUtil.GetFormValue <int>("IsSingle", 0); ProductEntity entity = new ProductEntity(); entity.BarCode = BarCode; entity.ProductName = ProductName; entity.FactoryNum = FactoryNum; entity.InCode = InCode; entity.UnitNum = UnitNum; entity.CateNum = CateNum; entity.Size = Size; entity.IsSingle = IsSingle; PageInfo pageInfo = new PageInfo(); pageInfo.PageIndex = PageIndex; pageInfo.PageSize = PageSize; ProductProvider provider = new ProductProvider(CompanyID); List <ProductEntity> list = provider.GetList(entity, ref pageInfo); DataListResult <ProductEntity> result = new DataListResult <ProductEntity>() { Code = (int)EResponseCode.Success, Message = "响应成功", Result = list, PageInfo = pageInfo }; return(Content(JsonHelper.SerializeObject(result))); }
public async Task <Response> CreateNewBid(NewBidRequest bidRequest) { BidEntity bidEntity = _mapper.Map <BidEntity>(bidRequest); PopulateBidEntity(bidEntity); ProductEntity existingProduct = await FindExistingProductAsync(bidRequest.Product); if (existingProduct != null) { bidEntity.Product = existingProduct; } if (!(await this.isValidNewBidAsync(bidEntity))) { // new Response Error Code return(new Response() { IsOperationSucceeded = false, SuccessOrFailureMessage = "Not Valid Group: This owner has an active bid of this product / There are too many groups for this product / There is an equivalent available group already" }); } _context.Bids.Add(bidEntity); try { await _context.SaveChangesAsync().ConfigureAwait(false); } catch (Exception ex) { //TODO log exception and return proper error message instead return(new Response() { IsOperationSucceeded = false, SuccessOrFailureMessage = ex.Message }); } return(new Response() { IsOperationSucceeded = true, SuccessOrFailureMessage = this.getSuccessMessage() }); }
public override WidgetViewModelPart Display(WidgetDisplayContext widgetDisplayContext) { var actionContext = widgetDisplayContext.ActionContext; int productId = actionContext.RouteData.GetPost(); ProductEntity product = null; if (productId != 0) { product = actionContext.RouteData.GetProduct(productId) ?? _productService.Get(productId); if (product != null && product.Url.IsNotNullAndWhiteSpace() && actionContext.RouteData.GetProductUrl().IsNullOrWhiteSpace()) { actionContext.RedirectTo($"{actionContext.RouteData.GetPath()}/{product.Url}.html", true); } } if (product == null && ApplicationContext.IsAuthenticated) { product = _productService.Get().OrderByDescending(m => m.ID).FirstOrDefault(); if (product != null) { product = _productService.Get(product.ID); } } if (product == null) { actionContext.NotFoundResult(); } if (product != null) { var layout = widgetDisplayContext.PageLayout; if (layout != null && layout.Page != null) { var page = layout.Page; page.MetaDescription = product.SEODescription; page.MetaKeyWorlds = product.SEOKeyWord; page.Title = product.SEOTitle ?? product.Title; } } return(widgetDisplayContext.ToWidgetViewModelPart(product ?? new ProductEntity())); }
/// <summary> /// 得到产品 /// </summary> /// <param name="infos"></param> /// <returns></returns> protected virtual void UpdateProducts(IList <InventoryEntity> infos) { IList <ProductEntity> products = new List <ProductEntity>(); foreach (var info in infos) { if (info.Product == null) { continue; } if (string.IsNullOrEmpty(info.Weeks) || !info.Weeks.Contains(((int)DateTime.Now.DayOfWeek).ToString(CultureInfo.InvariantCulture))) { continue; } if (info.MonthsArray == null || info.MonthsArray.Count(it => it.Equals((DateTime.Now.Day).ToString(CultureInfo.InvariantCulture))) == 0) { continue; } if (info.Type == InvertoryType.Reset && info.Recycle != 0 && (DateTime.Now - info.StartTime).TotalMinutes % info.Recycle == 0) { continue; } var product = new ProductEntity { Id = info.Product.Id, Count = info.Count, SaveType = SaveType.Modify }; product.SetProperty(it => it.Count); products.Add(product); } var unitofworks = Repository.Save(products); Commit(unitofworks); }
public async Task <bool> EditAsync(long id, string name, decimal price, int inventory, int saleNumber, bool putaway, bool hotSale, string description) { using (MyDbContext dbc = new MyDbContext()) { ProductEntity entity = await dbc.GetAll <ProductEntity>().SingleOrDefaultAsync(a => a.Id == id); if (entity == null) { return(false); } entity.Name = name; entity.Price = price; entity.Inventory = inventory; entity.SaleNumber = saleNumber; entity.Putaway = putaway ? 1 : 0; entity.HotSale = hotSale ? 1 : 0; entity.Description = description; await dbc.SaveChangesAsync(); return(true); } }
private async void OnScanButtonClick(object sender, EventArgs e) { ZXing.Mobile.MobileBarcodeScanner scanner = new ZXing.Mobile.MobileBarcodeScanner(); ZXing.Result result = await scanner.Scan(); ProductEntity product = Model.FindProductByEAN(uint.Parse(result.Text)); AlertDialog.Builder alertBuilder = new AlertDialog.Builder(Activity); if (product != null) { alertBuilder.SetTitle($"Product - {product.Name}"); alertBuilder.SetMessage(product.Description); } else { alertBuilder.SetTitle("Error"); alertBuilder.SetMessage($"Product with EAN {result.Text} couldnt be found!"); } alertBuilder.Show(); }
public string GetSetting(string setting, string idCampaign) { string value = string.Empty; ProductSettingsRepository repository = new ProductSettingsRepository(); CampaignEntity campaign = CampaignRepository.FindById(new Guid(idCampaign)); ProductEntity product = ProductRepository.FindById(campaign.PRODUCT_IdProduct); List <ProductSettingsEntity> settings = repository.GetProductSettingsByIdProduct(product.IdProduct); switch (setting) { case "ApiKey": { foreach (var item in settings) { value = item.SettingName.Equals("pushApiToken") ? item.SettingValue : value; } } break; } return(value); }
public static Product ToStoreModel(this ProductEntity addProductStoreResponse) { if (addProductStoreResponse == null) { return(null); } var product = new Product(addProductStoreResponse.Price.ToModel(), addProductStoreResponse.SellerId, addProductStoreResponse.Name) { Id = addProductStoreResponse.Id, Description = addProductStoreResponse.Description, HeroImage = addProductStoreResponse.HeroImage, Category = addProductStoreResponse.Category.ToModel(), Status = addProductStoreResponse.Status.ToModel(), PostDateTime = addProductStoreResponse.PostDateTime, ExpirationDate = addProductStoreResponse.ExpirationDate, Images = addProductStoreResponse.Images, PurchasedDate = addProductStoreResponse.PurchasedDate, PickupAddress = addProductStoreResponse.PickupAddress.ToModel() }; return(product); }
public async Task <IActionResult> Create(ProductViewModel productViewModel) { if (ModelState.IsValid) { string path = string.Empty; if (productViewModel.ImageFile != null) { path = await _imageHelper.UploadImageAsync(productViewModel.ImageFile, "Products"); } ProductEntity productEntity = _converterHelper.ToProductEntity(productViewModel, path, true); var user = await _userHelper.GetUserAsync(User.Identity.Name); productEntity.Station = user.Station; _context.Add(productEntity); try { await _context.SaveChangesAsync(); return(RedirectToAction(nameof(Index))); } catch (Exception ex) { if (ex.InnerException.Message.Contains("duplicate")) { ModelState.AddModelError(string.Empty, "Already there is a record with the same name."); } else { ModelState.AddModelError(string.Empty, ex.InnerException.Message); } } } return(View(productViewModel)); }
public ActionResult Edit(ProductViewModels vModel) { if (ModelState.IsValid) { if (Request.Files["File1"] != null) { byte[] ImageContent = null; using (BinaryReader br = new BinaryReader(Request.Files["File1"].InputStream)) { ImageContent = br.ReadBytes( Request.Files["File1"].ContentLength); } vModel.Picture = ImageContent; } ProductEntity pe = new ProductEntity(); Boolean isSucced; //取得目前登入使用者Id var UserId = HttpContext.User.Identity.GetUserId(); vModel.MId = UserId; isSucced = pe.Update(vModel); return(RedirectToAction("Index")); //return Content("Update state==>" + isSucced.ToString()); //string total = ShowInfo(vModel); //return Content(total); } //return Content("<root>check failure</root>", "application/xml"); return(View(vModel)); }
public void Edit(ProductEntity Product) { //Validando datos this.Validation(Product); using (var db = new ModelDb()) { //Se carga el producto var p = db.Products.Where(c => c.ProductID == Product.ProductID).FirstOrDefault(); //Se verifica que existe if (p != null) { //Validando Código var pExist = this.Find(Product.ProductCode); if (pExist != null) // Si existe, entra { if (pExist.ProductID != p.ProductID) { throw new Exception("Ya existe un producto con este Código"); } } //Se editan los datos p.ProductCode = Product.ProductCode; p.ProductName = Product.ProductName; p.ProductPrice = Product.ProductPrice; p.ProductDescription = Product.ProductDescription; p.MarkID = Product.MarkID; p.LineID = Product.LineID; //Se prepara para la edición db.Entry(p).State = System.Data.Entity.EntityState.Modified; //Se guardan los datos db.SaveChanges(); } } }
public ServiceResult <ProductEntity> Update(ProductEntity product) { var validResult = ValidProductType(product); if (validResult.HasViolation) { return(validResult); } if (product.ProductImages != null) { foreach (var item in product.ProductImages) { if (item.ActionType == null) { item.ActionType = ActionType.Create; } } } product.ProductContent = _htmlSanitizer.Sanitize(product.ProductContent); return(_productService.Update(product)); }
public ProductEntity AddProduct(string title, double price, string redirectUrl, int catId, int brandId, string detail, bool newItemStatus, bool freeShippingStatus, int storeId) { ProductEntity product = new ProductEntity(); product.Title = title; product.Price = price; product.CategoryId = catId; product.BrandId = brandId; product.DetailDescription = detail; product.Status = false; product.StoreId = storeId; product.IsNewItem = newItemStatus; product.IsSliderProduct = false; product.IsSpeacialProduct = false; product.IsFreeShipping = freeShippingStatus; product.AddedDate = DateTime.Now; product.RedirectUrl = redirectUrl; product.Save(); return(product); }
public bool Edit(Product product) { using (TiendaEntities ctx = new TiendaEntities()) { try { int id = Convert.ToInt32(product.Id); ProductEntity p = ctx.ProductEntities.Single(pe => pe.Id == id); p.Name = product.Name; p.Price = product.Price; p.Quantity = product.Quantity; p.CreationDate = product.CreationDate; ctx.ProductEntities.Add(p); ctx.SaveChanges(); return(true); } catch { return(false); } } }
/// <summary>Konvertira entitet u business object.</summary> protected Product(ProductEntity entity) : base(entity) { }
public void DeleteProduct(ProductEntity entity) { productInsertDB.DeleteProduct(entity); }
public bool UpdateProduct(ProductEntity entity) { return productInsertDB.UpdateProduct(entity); }
public long AddProduct(ProductEntity entity) { return productInsertDB.InsertProduct(entity); }
public void DeleteProduct(ProductEntity entity) { var command = DB.GetStoredProcCommand("spA_Product_d"); DB.AddInParameter(command, "@ProductId", DbType.Int64, entity.ProductId); DB.ExecuteNonQuery(command); }
public bool Post(ProductModel model) { var user = (UserBase)_workContext.CurrentUser; var entity = new ProductEntity { Name = model.Name, Spec = model.Spec, Price = model.Price, Adduser = user, Addtime = DateTime.Now, Upduser = user, Updtime = DateTime.Now, Unit = model.Unit, Image = model.Image, Detail = new ProductDetailEntity { Detail = model.Detail.Detail, ImgUrl1 = model.Detail.ImgUrl1, ImgUrl2 = model.Detail.ImgUrl2, ImgUrl3 = model.Detail.ImgUrl3, ImgUrl4 = model.Detail.ImgUrl4, ImgUrl5 = model.Detail.ImgUrl5, }, Category = _categoryService.GetCategoryById(model.Category.Id), Status = EnumProductStatus.OnSale, // PropertyValues = model.PropertyValues.SelectMany(pv=>new ProductPropertyValueEntity // { // Addtime = DateTime.Now, // Adduser = (UserBase)_workContext.CurrentUser, // UpdTime = DateTime.Now, // UpdUser = (UserBase)_workContext.CurrentUser, // Property = _propertyService.GetPropertyById(pv.PropertyId), // PropertyValue = _propertyValueService.GetOrCreatEntityWithValue(pv.PropertyValue, _propertyService.GetPropertyById(pv.PropertyId)) // }).ToList() }; var productProperty = (from pv in model.PropertyValues let p = _propertyService.GetPropertyById(pv.PropertyId) from v in pv.PropertyValues select new ProductPropertyValueEntity { Addtime = DateTime.Now, Adduser = (UserBase) _workContext.CurrentUser, UpdTime = DateTime.Now, UpdUser = (UserBase) _workContext.CurrentUser, Property = p, PropertyValue = _propertyValueService.GetOrCreatEntityWithValue(v.Value, p) }).ToList(); entity.PropertyValues = productProperty; return _productService.Create(entity).Id > 0; }
public bool UpdateProduct(ProductEntity entity) { var dbCommand = DB.GetStoredProcCommand("spA_Product_u"); AddInParameter(dbCommand, entity, true); return DbHelper.ConvertTo<int>(DB.ExecuteScalar(dbCommand)) == 0; }
private ProductEntity getNewsid(string keyword, int _catid) { ProductEntity pro = new ProductEntity(); var list = (from a in db.ESHOP_NEWs join b in db.ESHOP_NEWS_CATs on a.NEWS_ID equals b.NEWS_ID where (SqlMethods.Like(a.NEWS_KEYWORD_ASCII, "%" + keyword + "%")) && (_catid != 0 ? b.CAT_ID == _catid : true) select new { a.NEWS_ID, a.NEWS_PRICE2 }).ToList(); if (list.Count > 0) { pro.NEWS_ID = list[0].NEWS_ID; pro.PRICE = list[0].NEWS_PRICE2; } return pro; }
protected void lbtSearch_Click(object sender, EventArgs e) { string keyword = CpanelUtils.ClearUnicode(txtKeyword.Value); int _catid = Utils.CIntDef(ddlCategory.SelectedValue); ProductEntity pro = new ProductEntity(); if (!String.IsNullOrEmpty(keyword)) pro = getNewsid(keyword, _catid); var list = db.BAO_GIADETAILs.Where(n => n.ID_BAOGIA == idbaogia && n.NEWS_ID == pro.NEWS_ID).ToList(); if (list.Count == 0) { BAO_GIADETAIL bgdetail = new BAO_GIADETAIL(); bgdetail.ID_BAOGIA = idbaogia; bgdetail.NEWS_ID = pro.NEWS_ID; bgdetail.BGD_PRICE = pro.PRICE; bgdetail.BGD_QUANTITY = 1; db.BAO_GIADETAILs.InsertOnSubmit(bgdetail); db.SubmitChanges(); } txtKeyword.Value = ""; loadPro(); }
/// <summary>Po potrebi konvertira entity u business objekt.</summary> public static Product ConvertEntityToBusinessObject(ProductEntity entity) { Product bizobj = entity as Product; if (bizobj == null) bizobj = new Product(entity); return bizobj; }
private void ShowItem(ProductEntity ent) { Cursor = Cursors.WaitCursor; lblId.Text = ent.Id.HasValue ? ent.Id.Value.ToString() : string.Empty; txtProductNr.Text = ent.ProductNr; txtDescription.Text = ent.Description; txtHochflor.Text = ent.Hochflor.ToString(); txtKnots.Text = ent.Knots.ToString(); txtWeight.Text = ent.Weight.ToString(); txtBuyPrice.Text = ent.BuyPrice.ToString(); txtColor.Text = ent.Color.ToString(); txtMaterial.Text = ent.Material.ToString(); txtMatInside.Text = ent.MaterialInside.ToString(); txtForm.Text = ent.Form.ToString(); cbSuppliers.Text = string.Empty; txtComment.Text = ent.Comment; if (ent.SupplierEnt != null && ent.SupplierEnt.NumberSerieEnt != null) { cbSuppliers.Text = ent.SupplierEnt.ToString(); // preview image manualRotation = false; picPreview.Image = Common.LoadImageFromStore(ent.SupplierEnt.NumberSerieEnt.Prefix + "-1.jpg"); RotatePreviewIfNeeded(); } Cursor = Cursors.Default; }
private void gridProducts_SelectionChanged(object sender, EventArgs e) { if (gridProducts.SelectedCells == null || gridProducts.SelectedCells.Count == 0) current = ProductEntity.Empty; else current = gridProducts.Rows[gridProducts.SelectedCells[0].RowIndex].DataBoundItem as ProductEntity; ShowItem(current); }
private void NewItem() { current = ProductEntity.Empty; ShowItem(current); }