public GoodDto UpdateGood(GoodDto goodDto) { Execute($"UPDATE [dbo].[Good] SET [Price] = @Price, [Count] = @Count WHERE [BookId] = @BookId", goodDto); var result = GetGoodByBookId(goodDto.BookId); return(result); }
/// <summary> /// Создать товар /// </summary> /// <param name="good">Товар</param> /// <param name="sessionRows">Кол-во товара в рамках сессии</param> /// <param name="goodsTotal">Кол-во товаров в системе</param> private void CreateGood(GoodDto good, int sessionRows, int goodsTotal) { for (int i = 0; i < (sessionRows - goodsTotal); i++) { _context.Add(_mapper.Mapper.Map <GoodDto, Good>(good)); } }
public Book Update(Book book) { var bookDto = new BookDto() { Id = book.Id, Name = book.Name, Description = book.Description, ReleaseDate = book.ReleaseDate, Image = book.Image }; var goodDto = new GoodDto() { BookId = book.Id, Count = book.Count, Price = book.Price }; _goodRepository.UpdateGood(goodDto); var bookResult = _bookRepository.Update(bookDto); _authorRepository.DeleteBookAuthorByBookId(book.Id); _genreRepository.DeleteBookGenreByBookId(book.Id); book.AuthorIds.ForEach(authorId => { _authorRepository.AddBookAuthor(new BookAuthorDto() { BookId = bookResult.Id, AuthorId = authorId }); }); book.GenreIds.ForEach(genreId => { _genreRepository.AddBookGenre(new BookGenreDto() { BookId = bookResult.Id, GenreId = genreId }); }); return(new Book() { Id = bookResult.Id, Name = bookResult.Name, Description = bookResult.Description, ReleaseDate = bookResult.ReleaseDate, Count = bookResult.Count, Price = bookResult.Price, Image = bookResult.Image, AuthorIds = book.AuthorIds, GenreIds = book.GenreIds }); }
public void UpdateGood(GoodDto good) { var dbGood = _goodsRepository.GetByUniqueNumber(good.ItemUniqueId); dbGood.Name = good.Name; dbGood.Amount = good.Amount; dbGood.CategoryId = good.CategoryId; dbGood.Price = good.Price; dbGood.ShortCharacteristics = good.ShortCharacteristics; dbGood.Characteristics = good.Characteristics; this._goodsRepository.Update(dbGood); this._goodsRepository.SaveChanges();; }
public async Task <IActionResult> GetGood(string key, string field) { //var currentUserId = int.Parse(User.FindFirst(ClaimTypes.NameIdentifier).Value); Good good; if (field.Equals("name")) { good = await _repo.GetFirstAsync(woak => woak.FarshboomCode.Equals(key)); } else { good = await _repo.GetFirstAsync(woak => woak.Id == Convert.ToInt32(key)); } GoodDto goodDto = _mapper.Map <GoodDto>(good); return(Ok(new { goodDto = goodDto })); }
public void AddGood(GoodDto good) { var dbGood = new Good() { Name = good.Name, Amount = good.Amount, CategoryId = good.CategoryId, Price = good.Price, ShortCharacteristics = good.ShortCharacteristics, Characteristics = good.Characteristics, ItemUniqueId = "" }; this._goodsRepository.Add(dbGood); this._goodsRepository.SaveChanges(); dbGood.ItemUniqueId = $"{dbGood.CategoryId}{dbGood.Name.Substring(0, 2)}{dbGood.Id}"; this._goodsRepository.SaveChanges(); }
public Good MapToEntity(GoodDto model) { // var Units = new Collection<GoodUnit>(); // model.Units.ForEach(p => // { // var u = new UnitX(p.Id,p.Name); // Units.Add(u); // }); //// //// model.Brands.ForEach(p => //// { //// var b = new Brand(p.Id,p.Name); //// Brands.Add(b); //// }); // var res = new Good(model.Id, model.Name, model.Code,Units); // // return res; return null; }
public async Task CreateDish(GoodDto goodDto, Guid categoryId, CancellationToken cancellationToken) { var createCommand = new CreateDishCommand( goodDto.Id, categoryId, goodDto.Description, goodDto.Measure, isAvailable: true, goodDto.Name, goodDto.Price); var content = new StringContent(JsonSerializer.Serialize(createCommand), Encoding.UTF8, "application/json"); using var response = await this.httpClient.PostAsync(this.options.DishesUri, content, cancellationToken) .ConfigureAwait(false); if (response.StatusCode != HttpStatusCode.Conflict) { response.EnsureSuccessStatusCode(); } }
public async Task PatchDish(Guid id, GoodDto groupDto, Guid categoryId, CancellationToken cancellationToken) { var command = new { Id = id, CategoryId = categoryId, Consist = groupDto.Description, Unit = groupDto.Measure, IsAvailable = true, Name = groupDto.Name, Price = groupDto.Price }; var content = new StringContent(JsonSerializer.Serialize(command), Encoding.UTF8, "application/json"); using var response = await this.httpClient.PatchAsync(this.options.DishesUri, content, cancellationToken) .ConfigureAwait(false); if (response.StatusCode != HttpStatusCode.Conflict) { response.EnsureSuccessStatusCode(); } }
public void UpdateGood(GoodDto good) { this._goodService.UpdateGood(good); }
public void AddGood(GoodDto good) { this._goodService.AddGood(good); }
public GoodDto RemapModel(GoodDto model) { throw new NotImplementedException(); }
public IActionResult GetGood(string key, string field) { string connectionString = "Data Source=185.88.152.127,1430;Initial Catalog=94_farsheboom ;User Id=94_vaq;Password=V@qef2512740;MultipleActiveResultSets=True;Max Pool Size=9000;persist security info=True;"; SqlConnection cnn = new SqlConnection(connectionString); if (cnn.State == ConnectionState.Closed) { cnn.Open(); } SqlCommand command = new SqlCommand(); command.Connection = cnn; // command.CommandText = @"SELECT [srl], [porz_type] ,[chele_type] ,[carpet_type] ,[ibt_srl] ,[size_srl] ,[color_srl] ,[color_srl2], [raj_srl], [title_igd], [lenght] ,[widht] ,[code_igd] ,[provider_code] ,[brand_name], [size_title], [color_name], [porz_title], [carpet_title] FROM [94_farsheboom].[94_vaq].[FarshBoomSite] Where (sold = 0 or sold is null) And srl=" + key; SqlDataReader reader = command.ExecuteReader(); GoodDto good = new GoodDto(); while (reader.Read()) { if (reader["title_igd"].ToString().Length < 5) { continue; } good.Id = Convert.ToInt32(reader["srl"]); good.ImageUrl = reader["title_igd"].ToString(); good.FarshboomCode = reader["code_igd"].ToString(); good.ProviderCode = reader["provider_code"].ToString(); good.Brand = reader["brand_name"].ToString(); good.Size = reader["size_title"].ToString(); good.Color = reader["color_name"].ToString(); good.Porz = reader["porz_title"].ToString(); good.Type = reader["carpet_title"].ToString(); good.ImageUrl = reader["title_igd"].ToString(); good.ImageUrl = good.ImageUrl.Replace("../", "http://bank.farshboom.com/"); if (reader["porz_type"] != null && !Convert.IsDBNull(reader["porz_type"])) { good.PorzId = Convert.ToInt32(reader["porz_type"]); } if (reader["chele_type"] != null && !Convert.IsDBNull(reader["chele_type"])) { good.CheleId = Convert.ToInt32(reader["chele_type"]); } if (reader["carpet_type"] != null && !Convert.IsDBNull(reader["carpet_type"])) { good.TypeId = Convert.ToInt32(reader["carpet_type"]); } if (reader["ibt_srl"] != null && !Convert.IsDBNull(reader["ibt_srl"])) { good.BrandId = Convert.ToInt32(reader["ibt_srl"]); } if (reader["size_srl"] != null && !Convert.IsDBNull(reader["size_srl"])) { good.SizeId = Convert.ToInt32(reader["size_srl"]); } if (reader["color_srl"] != null && !Convert.IsDBNull(reader["color_srl"])) { good.ColorId = Convert.ToInt32(reader["color_srl"]); } if (reader["color_srl2"] != null && !Convert.IsDBNull(reader["color_srl2"])) { good.ColorId2 = Convert.ToInt32(reader["color_srl2"]); } if (reader["lenght"] != null && !Convert.IsDBNull(reader["lenght"])) { good.Lenght = Convert.ToInt32(reader["lenght"]); } if (reader["widht"] != null && !Convert.IsDBNull(reader["widht"])) { good.Width = Convert.ToInt32(reader["widht"]); } if (reader["raj_srl"] != null && !Convert.IsDBNull(reader["raj_srl"])) { good.RajId = Convert.ToInt32(reader["raj_srl"]); } } cnn.Close(); return(Ok(new { goodDto = good })); }
public IActionResult GetAllGoods([FromQuery] UserParams userParams) { string where = string.Empty; if (userParams.TypeId != null) { where += "And carpet_type = " + userParams.TypeId; } if (userParams.SizeId != null) { where += "And size_srl = " + userParams.SizeId; } if (userParams.BrandId != null) { where += "And ibt_srl = " + userParams.BrandId; } if (userParams.ColorId != null) { where += "And color_srl = " + userParams.ColorId; } if (userParams.PorzId != null) { where += "And porz_type = " + userParams.PorzId; } if (userParams.Length != null) { where += "And lenght = " + userParams.Length; } if (userParams.Weight != null) { where += "And widht = " + userParams.Weight; } if (userParams.CheleId != null) { where += "And chele_type = " + userParams.CheleId; } if (userParams.PlanId != null) { where += "And city_srl = " + userParams.PlanId; } if (userParams.AssessmentId != null) { where += "And carpet_type = " + userParams.AssessmentId; } if (userParams.FromPrice != null && userParams.ToPrice != null) { where += "And sale_price BETWEEN " + userParams.FromPrice + " And " + userParams.ToPrice; } string connectionString = "Data Source=185.88.152.127,1430;Initial Catalog=94_farsheboom ;User Id=94_vaq;Password=V@qef2512740;MultipleActiveResultSets=True;Max Pool Size=9000;persist security info=True;"; SqlConnection cnn = new SqlConnection(connectionString); if (cnn.State == ConnectionState.Closed) { cnn.Open(); } SqlCommand command = new SqlCommand(); command.Connection = cnn; // command.CommandText = @"SELECT Top(300) [srl], [porz_type] ,[chele_type] ,[carpet_type] ,[ibt_srl] ,[size_srl] ,[color_srl] ,[color_srl2], [raj_srl], [title_igd], [lenght] ,[widht] ,[code_igd] ,[provider_code] ,[brand_name], [size_title], [color_name], [porz_title], [carpet_title], [city_srl], [sale_price], [raj_title] FROM [94_farsheboom].[94_vaq].[FarshBoomSite] Where (sold = 0 or sold is null)" + where + " Order By srl Desc"; SqlDataReader reader = command.ExecuteReader(); List <GoodDto> lstGood = new List <GoodDto>(); while (reader.Read()) { if (reader["title_igd"].ToString().Length < 5) { continue; } GoodDto good = new GoodDto(); good.Id = Convert.ToInt32(reader["srl"]); good.ImageUrl = reader["title_igd"].ToString(); good.FarshboomCode = reader["code_igd"].ToString(); good.ProviderCode = reader["provider_code"].ToString(); good.Brand = reader["brand_name"].ToString(); good.Size = reader["size_title"].ToString(); good.Color = reader["color_name"].ToString(); good.Porz = reader["porz_title"].ToString(); good.Type = reader["carpet_title"].ToString(); good.Chele = reader["chele_title"].ToString(); good.Plan = reader["plan_title"].ToString(); good.Raj = reader["raj_title"].ToString(); good.ImageUrl = reader["title_igd"].ToString(); good.ImageUrl = good.ImageUrl.Replace("../", "http://bank.farshboom.com/"); if (reader["porz_type"] != null && !Convert.IsDBNull(reader["porz_type"])) { good.PorzId = Convert.ToInt32(reader["porz_type"]); } if (reader["chele_type"] != null && !Convert.IsDBNull(reader["chele_type"])) { good.CheleId = Convert.ToInt32(reader["chele_type"]); } if (reader["carpet_type"] != null && !Convert.IsDBNull(reader["carpet_type"])) { good.TypeId = Convert.ToInt32(reader["carpet_type"]); } if (reader["ibt_srl"] != null && !Convert.IsDBNull(reader["ibt_srl"])) { good.BrandId = Convert.ToInt32(reader["ibt_srl"]); } if (reader["size_srl"] != null && !Convert.IsDBNull(reader["size_srl"])) { good.SizeId = Convert.ToInt32(reader["size_srl"]); } if (reader["color_srl"] != null && !Convert.IsDBNull(reader["color_srl"])) { good.ColorId = Convert.ToInt32(reader["color_srl"]); } if (reader["color_srl2"] != null && !Convert.IsDBNull(reader["color_srl2"])) { good.ColorId2 = Convert.ToInt32(reader["color_srl2"]); } if (reader["lenght"] != null && !Convert.IsDBNull(reader["lenght"])) { good.Lenght = Convert.ToInt32(reader["lenght"]); } if (reader["widht"] != null && !Convert.IsDBNull(reader["widht"])) { good.Width = Convert.ToInt32(reader["widht"]); } if (reader["raj_srl"] != null && !Convert.IsDBNull(reader["raj_srl"])) { good.RajId = Convert.ToInt32(reader["raj_srl"]); } if (reader["city_srl"] != null && !Convert.IsDBNull(reader["city_srl"])) { good.RajId = Convert.ToInt32(reader["city_srl"]); } if (reader["sale_price"] != null && !Convert.IsDBNull(reader["sale_price"])) { good.SalePrice = Convert.ToInt32(reader["sale_price"]); } lstGood.Add(good); } cnn.Close(); var pagedList = lstGood.AsQueryable(); var goods = Paginiation <GoodDto> .CreateAsync(pagedList, userParams.PageNumber, userParams.PageSize); IEnumerable <GoodDto> goodDto; goodDto = _mapper.Map <IEnumerable <GoodDto> >(goods); Response.AddPagination(goods.CurrentPage, goods.PageSize, goods.TotalCount, goods.TotalPages); return(Ok(goodDto)); }
public bool AddGood(GoodDto goodDto) { Execute($"INSERT INTO [dbo].[Good] ([BookId], [Count], [Price]) VALUES (@BookId, @Count, @Price)", goodDto); return(true); }