public void SetCompareGood(int id) { GoodDTO good = goodmanager.Get(id); int categoryId = good.Category_Id; ListCompareGoodDTO compgoods = Session["ComparingGoods"] as ListCompareGoodDTO; if (compgoods == null) { compgoods = new ListCompareGoodDTO(); if (!compgoods.CompareGoods.ContainsKey(categoryId)) { compgoods.CompareGoods.Add(categoryId, new List <int>()); } compgoods.CompareGoods[categoryId].Add(id); Session["ComparingGoods"] = compgoods; return; } else { if (compgoods.CompareGoods[categoryId].Find(c => c == id) != -1) { compgoods.CompareGoods[categoryId].Add(id); Session["ComparingGoods"] = compgoods; return; } } }
public GoodDTO getInforGoods(string maHang) { GoodDTO goodDTO = new GoodDTO(); string sql = string.Format("SELECT hh.MaHang, hh.TenHang, hh.GiaBanLe, hh.GiabanSi, hh.GiaMua , " + " dvt.Ten, tk.SoLuongToiThieu, hh.TinhChat, kh.TenKho, nh.TenNhom, hh.Active " + "FROM HANGHOA_DICHVU hh, TONKHO tk, DONVITINH dvt, KHOHANG kh, NHOMHANG nh " + "WHERE hh.MaDV = dvt.MaDVT and tk.mahang = hh.MaHang and hh.MaKho = kh.MaKho and nh.MaNhom = hh.MaNhom and hh.MaHang = '{0}'", maHang); DataTable data = ConnectionDB.getData(sql); if (data.Rows.Count > 0) { goodDTO.MaHang = data.Rows[0]["MaHang"].ToString(); goodDTO.TenHang = data.Rows[0]["TenHang"].ToString(); goodDTO.GiabanLe = float.Parse(data.Rows[0]["GiaBanLe"].ToString()); goodDTO.GiaBanSi = float.Parse(data.Rows[0]["GiabanSi"].ToString()); goodDTO.GiaMua = float.Parse(data.Rows[0]["GiaMua"].ToString()); goodDTO.TenKho = data.Rows[0]["TenKho"].ToString(); goodDTO.SoLuongToiThieu = int.Parse(data.Rows[0]["SoLuongToiThieu"].ToString()); goodDTO.TinhChat = data.Rows[0]["TinhChat"].ToString(); goodDTO.TenDV = data.Rows[0]["Ten"].ToString(); goodDTO.TenNhom = data.Rows[0]["TenNhom"].ToString(); goodDTO.Active = bool.Parse(data.Rows[0]["Active"].ToString()); } return(goodDTO); }
/// <summary> /// Update good into database /// </summary> /// <param name="good"></param> public void Update(GoodDTO good) { if (good == null) { return; } var goodDb = uOW.GoodRepo.GetByID(good.Id); if (goodDb == null) { return; } var uGood = Mapper.Map <Good>(good); goodDb.Name = uGood.Name; goodDb.Category_Id = uGood.Category_Id; goodDb.WebShop_Id = uGood.WebShop_Id; goodDb.ImgLink = uGood.ImgLink; goodDb.UrlLink = uGood.UrlLink; goodDb.XmlData = uGood.XmlData; goodDb.Price = uGood.Price; goodDb.Status = uGood.Status; uOW.Save(); }
public bool Delete(GoodDTO good) { if (good == null) { return(false); } var goodDb = sqlUnitOfWork.GoodRepo.GetByID(good.Id); if (goodDb == null) { return(false); } goodDb.Status = false; try { var elasticGood = Mapper.Map <GoodDTO>(goodDb); elasticUnitOfWork.Repository.Delete(elasticGood); if (sqlUnitOfWork.Save() < 1) { throw new Exception("Item isn't added into MS SQL Server"); } elasticUnitOfWork.Save(); } catch (Exception ex) { Logger.Error(ex.Message); return(false); } return(true); }
private void InitCommands() { RemoveGoodCommand = new RelayCommand(x => { goodService.Remove(SelectedGood); Goods.Remove(SelectedGood); }); RemoveCategoryCommand = new RelayCommand(x => { categoryService.Remove(SelectedCategory); Categories.Remove(SelectedCategory); }); RemoveManufacturerCommand = new RelayCommand(x => { manufacturerService.Remove(SelectedManufactirer); Manufacturers.Remove(SelectedManufactirer); }); AddUpdateGoodCommand = new RelayCommand(x => { AddUpdateGood dlg = new AddUpdateGood(); dlg.ShowDialog(); var good = new GoodDTO { GoodName = GoodViewModelProxy.Proxy.GoodName, GoodCount = GoodViewModelProxy.Proxy.GoodCount, Price = GoodViewModelProxy.Proxy.GoodPrice, CategoryId = categoryService.GetAll().FirstOrDefault(y => y.CategoryName == GoodViewModelProxy.Proxy.GoodCategory).CategoryId, ManufacturerId = manufacturerService.GetAll().FirstOrDefault(y => y.ManufacturerName == GoodViewModelProxy.Proxy.GoodManufacturer).ManufacturerId }; var result = goodService.CreateOrUpdate(good); Goods.Add(result); }); AddUpdateCategoryCommand = new RelayCommand(x => { AddUpdateCategoryView dlg = new AddUpdateCategoryView(); dlg.ShowDialog(); var category = new CategoryDTO { CategoryName = CategoryViewModelProxy.Proxy.CategoryName }; var result = categoryService.CreateOrUpdate(category); Categories.Add(result); }); AddUpdateManufacturerCommand = new RelayCommand(x => { AddUpdateManufactorerView dlg = new AddUpdateManufactorerView(); dlg.ShowDialog(); var manufactorer = new ManufacturerDTO { ManufacturerName = ManufacturerModelProxy.Proxy.ManufacturerName }; var result = manufacturerService.CreateOrUpdate(manufactorer); Manufacturers.Add(result); }); }
public GoodDTO UpdateProd(GoodDTO productToUpdate) { using (var db = new companyEntities()) { var prod = db.tblGoods.FirstOrDefault(u => u.id == productToUpdate.id); return(_mapper.Map <GoodDTO>(prod)); } }
public ActionResult CreateGoods(GoodDTO goodViewModel) { if (ModelState.IsValid) { goodService.CreateOrUpdate(goodViewModel); return(RedirectToAction("Index")); } return(View(goodViewModel)); }
public async Task <IActionResult> Put([FromBody] GoodDTO good) { if (ModelState.IsValid) { Good g = _mapper.Map <Good>(good); return(Ok(_mapper.Map <GoodDTO>(await _repository.UpdateGoodAsync(g)))); } return(BadRequest(ModelState)); }
public int updateGoods(GoodDTO g) { string sql = string.Format(" update [HANGHOA_DICHVU] " + " set TenHang = N'{0}', MaDV = N'{1}', GiaMua = {2}, GiaBanSi = {3}, GiaBanLe = {4}, " + " SoLuongToiThieu = {5}, MaKho = N'{6}', Active = '{7}', MaNhom = '{8}', MaNCC = '{9}', TinhChat = N'{10}' " + " where MaHang = N'{11}' ", g.TenHang, g.MaDonVi, g.GiaMua, g.GiaBanSi, g.GiabanLe, g.SoLuongToiThieu, g.MaKho, g.Active, g.MaNhom, g.MaNCC, g.TinhChat, g.MaHang); return(ConnectionDB.ExcuteNonQuery(sql)); }
public ActionResult GoodEdit(GoodDTO good) { if (ModelState.IsValid) { service.CreateOrUpdate(good); service.SaveAll(); return(RedirectToAction("GoodView")); } return(RedirectToAction("GoodEdit")); }
public ActionResult PhotoList(int id = 1) { GoodDTO good = goodService.Get(id); ViewBag.GoodInfo = $"{good.GoodName}, price - {good.Price} uah"; ViewBag.GoodId = id; var model = photoService.FindBy(g => g.GoodId == id); return(View(model)); }
//public GoodDTO getInforGoodsFromMaHang(string mahang) //{ // string sql = string.Format("SELECT * FROM [HANGHOA_DICHVU] where [MaHang] = '{0}'", mahang); // DataTable data = ConnectionDB.getData(sql); // GoodDTO goodDTO = new GoodDTO(); // if (data.Rows.Count > 0) // { // goodDTO.MaHang = data.Rows[0]["MaHang"].ToString(); // goodDTO.TenHang = data.Rows[0]["TenHang"].ToString(); // goodDTO.MaDonVi = data.Rows[0]["MaDV"].ToString(); // goodDTO.GiaMua = float.Parse(data.Rows[0]["GiaMua"].ToString()); // goodDTO.GiaBanSi = float.Parse(data.Rows[0]["GiabanSi"].ToString()); // goodDTO.GiabanLe = float.Parse(data.Rows[0]["GiaBanLe"].ToString()); // //goodDTO.TinhChat = "Hàng hóa"; // goodDTO.MaKho = data.Rows[0]["MaKho"].ToString(); // goodDTO.MaNhom = data.Rows[0]["MaNhom"].ToString(); // goodDTO.MaNCC = data.Rows[0]["MaNCC"].ToString(); // goodDTO.Active = bool.Parse(data.Rows[0]["Active"].ToString()); // } // return goodDTO; //} public int InsertGood(GoodDTO goodDTO) { string sql = string.Format("INSERT INTO HANGHOA_DICHVU (MaHang, TenHang, MaDV, GiaMua, " + " GiabanLe, GiaBanSi, TinhChat, MaKho, Active, MaNhom, MaNCC, SoLuongToiThieu) values('{0}', N'{1}', '{2}', {3}, {4}," + " {5}, N'{6}', N'{7}', '{8}', N'{9}', '{10}', {11})", goodDTO.MaHang, goodDTO.TenHang, goodDTO.MaDonVi, goodDTO.GiaMua, goodDTO.GiabanLe, goodDTO.GiaBanSi, goodDTO.TinhChat, goodDTO.MaKho, goodDTO.Active, goodDTO.MaNhom, goodDTO.MaNCC, goodDTO.SoLuongToiThieu); int check = ConnectionDB.ExcuteNonQuery(sql); return(check); }
public IActionResult Delete([FromBody] GoodDTO good) { try { service.Delete(good); return(NoContent()); } catch (Exception) { return(NotFound()); } }
private void AddOrder_Click(object sender, RoutedEventArgs e) { GoodDTO good = new GoodDTO { Height = Int32.Parse(HeightTextBox.Text), Weight = Int32.Parse(WeightTextBox.Text), Width = Int32.Parse(WidthTextBox.Text), Name = NameTextBox.Text }; GoodService goodService = new GoodService(); goodService.Create(good); MessageBox.Show("Order added"); }
public Good MapGood(GoodDTO value) { return(new Good { Id = value.Id, Name = value.Name, Price = value.Price, Count = value.Count, GoodType = MapGoodType(value.GoodType), GoodImportance = MapImportance(value.GoodImportance), BoughtDate = value.BoughtDate }); }
public HttpResponseMessage Update(GoodDTO good) { try { var g = goodService.Update(good); return((good != null) ? Request.CreateResponse(HttpStatusCode.OK, good) : Request.CreateResponse(HttpStatusCode.BadRequest, $"Не смогли обновить товар с id = {good.GoodId}")); } catch (Exception exc) { return(Request.CreateResponse(HttpStatusCode.BadRequest, $"Не смогли обновить товар с id = {good.GoodId}")); } }
public int Create(GoodDTO good) { var validationResult = validator.Validate(good); if (validationResult.IsValid) { return(repository.Create(mapper.MapGood(good))); } else { throw new ValidationException(validationResult.Errors); } }
public void Update(GoodDTO good) { var name = good.CategoryName; var category = db.Categories.TryGetByName(name); Good dbgood = db.Goods.Get(good.Id); dbgood.Name = good.Name; dbgood.CategoryId = category.Id; dbgood.Price = good.Price; dbgood.Quantity = good.Quantity; db.Goods.Update(dbgood); db.Save(); }
public void Put(int id, [FromBody] GoodDTO goodDTO) { GoodDTO editgood = goodService.Get(id); editgood.GoodCount = goodDTO.GoodCount; editgood.GoodName = goodDTO.GoodName; editgood.Price = goodDTO.Price; editgood.ManufacturerId = goodDTO.ManufacturerId; editgood.ManufacturerName = goodDTO.ManufacturerId.HasValue ? manufacturerService.Get(goodDTO.ManufacturerId.Value).ManufacturerName:""; editgood.CategoryId = goodDTO.CategoryId; editgood.CategoryName = goodDTO.CategoryId.HasValue?categoryService.Get(goodDTO.CategoryId.Value).CategoryName:""; goodService.CreateOrUpdate(editgood); }
public int AddProd(GoodDTO prod) { if (prod != null) { using (var db = new companyEntities()) { db.tblGoods.Add(_mapper.Map <tblGood>(prod)); db.SaveChanges(); return(prod.id); } } return(0); }
private void HardRemove(GoodDTO item) { if (item == null) { return; } var good = GetByIdUrl(item.UrlLink); if (good == null) { return; } client.Delete <GoodDTO>(good.UrlLink, i => i.Refresh()); }
/// <summary> /// Insert good into database and return inserted item /// </summary> /// <param name="good"></param> /// <returns></returns> public GoodDTO Insert(GoodDTO good) { if (good.ImgLink == null) { good.ImgLink = @"http://www.kalahandi.info/wp-content/uploads/2016/05/sorry-image-not-available.png"; } var goodDb = Mapper.Map <Good>(good); goodDb.Status = true; var res = uOW.GoodRepo.Insert(goodDb); uOW.Save(); return(Mapper.Map <GoodDTO>(res)); }
public HttpResponseMessage Post(GoodDTO good) { try { var g = goodService.Add(good); HttpResponseMessage message = Request.CreateResponse(HttpStatusCode.Accepted, g); message.Headers.Add("GoodId", g.GoodId.ToString()); return(message); } catch (Exception exc) { return(Request.CreateResponse(HttpStatusCode.BadRequest, "Не смогли добавить категорию")); } }
private void Remove(GoodDTO item) { if (item == null) { return; } var good = GetByIdUrl(item.UrlLink); if (good == null) { return; } good.Status = false; Update(good); }
private bool Update(GoodDTO item) { if (item == null) { return(false); } var good = GetByIdUrl(item.UrlLink); if (good == null) { return(false); } client.Index(item, i => i.Id(item.UrlLink).Refresh()); return(true); }
public void Add(GoodDTO good) { var name = good.CategoryName; var category = db.Categories.TryGetByName(name); Good dbgood = new Good(); //dbgood.Id = good.Id; dbgood.Name = good.Name; dbgood.CategoryId = category.Id; dbgood.Price = good.Price; dbgood.Quantity = good.Quantity; db.Goods.Add(dbgood); db.Save(); }
public IActionResult Post([FromBody] GoodDTO good) { try { return(Ok(service.Create(good))); } catch (ValidationException e) { return(BadRequest(e.Message)); } catch (Exception) { return(BadRequest()); } }
/// <summary> /// Delete good into database /// </summary> /// <param name="good"></param> public void Delete(GoodDTO good) { if (good == null) { return; } var goodDb = uOW.GoodRepo.GetByID(good.Id); if (goodDb == null) { return; } goodDb.Status = false; uOW.Save(); }
public ProductForm(IEntityBL entityBL, GoodDTO good) { InitializeComponent(); _entityBL = entityBL; _good = good; _text = new List <TextBox>(); ProductPictureBox.Size = new Size(120, 150); ProductPictureBox.SizeMode = PictureBoxSizeMode.Zoom; ProductPictureBox.Image = Image.FromFile(_good.photo_url); NameLabel.Text = _good.name; this.Text = _good.name; DetailsLabel.Text = _good.details; _feedBacks = _entityBL.GetAllFeedBackByProduct(_good.id); }
public void Post([FromBody] GoodDTO goodDTO) { GoodDTO newGood = new GoodDTO { GoodCount = goodDTO.GoodCount, GoodName = goodDTO.GoodName, Price = goodDTO.Price, ManufacturerName = goodDTO.ManufacturerName, ManufacturerId = goodDTO.ManufacturerId, CategoryName = goodDTO.CategoryName, CategoryId = goodDTO.CategoryId }; goodService.CreateOrUpdate(newGood); }