public async Task <RepositoryResponseDto> Delete(int id) { RepositoryResponseDto flagValid = new RepositoryResponseDto { Flag = false, Message = "" }; Katalog item = await _db.Katalogs.FirstOrDefaultAsync(x => x.Id == id); if (item == null) { flagValid.Message = "Каталога с таким id не существует!"; flagValid.Flag = false; return(flagValid); } _db.Katalogs.Remove(item); int i = await _db.SaveChangesAsync(); if (i != 0) { flagValid.Flag = true; flagValid.Message = "БД delete ok"; return(flagValid); } else { flagValid.Message = "БД delete not"; flagValid.Flag = false; return(flagValid); } }
public async Task <RepositoryResponseDto> CreateImage(Image item) { await _db.Images.AddAsync(item); int i = await _db.SaveChangesAsync(); // Console.WriteLine("async Task<bool> Add(Katalog item)-----------"+i.ToString()+"_db.Entry.State--"+_db.Entry(item).State.ToString()); RepositoryResponseDto flag = new RepositoryResponseDto { Flag = false, Message = null, Item = null }; if (i != 0) { flag.Message = "БД Images add ok!"; flag.Flag = true; flag.Item = item; return(flag); } else { flag.Message = "БД Images add not(false)!"; flag.Flag = false; flag.Item = null; return(flag); } }
public async Task <RepositoryResponseDto> Add(Katalog item) { RepositoryResponseDto flag = new RepositoryResponseDto { Flag = false, Message = null }; // db.Users.Add(user); await _db.Katalogs.AddAsync(item); int i = await _db.SaveChangesAsync(); // Console.WriteLine("async Task<bool> Add(Katalog item)-----------"+i.ToString()+"_db.Entry.State--"+_db.Entry(item).State.ToString()); if (i != 0) { flag.Flag = true; flag.Message = "БД add ok!"; return(flag); } else { flag.Flag = false; flag.Message = "БД add not!"; return(flag); } }
public async Task <RepositoryResponseDto> Create(Product item) { var flag = new RepositoryResponseDto { Flag = false, Item = null, Message = "" }; // db.Users.Add(user); if (item.KatalogId == -1) { flag.Message = "Ошибка БД KatalogId==-1"; flag.Flag = false; return(flag); } if (item.TypeProductId == -1) { flag.Message = "Ошибка БД TypeProductId==-1"; flag.Flag = false; return(flag); } // Проверить на уникольность ??? await _db.Products.AddAsync(item); int i = await _db.SaveChangesAsync(); // Console.WriteLine("async Task<bool> Add(Katalog item)-----------"+i.ToString()+"_db.Entry.State--"+_db.Entry(item).State.ToString()); if (i != 0) { /// Console.WriteLine("async Task<bool> Add(Katalog item)--- _del.Invoke-- bigin"+"_dev==null"+(_del==null).ToString()); // _del(selectItem.Image,photo); делегат не работаете error null async metod // Console.WriteLine("async Task<bool> Add(Katalog item)--- _del.Invoke-- end"); flag.Message = ""; flag.Flag = true; return(flag); } flag.Message = "Ошибка субд Create,запись в бд не создана!"; flag.Flag = false; return(flag); }
public async Task <RepositoryResponseDto> Delete(Product item) { RepositoryResponseDto flag = new RepositoryResponseDto { Flag = false, Message = null, Item = null }; int i = 0; // Product item = _db.Products.FirstOrDefault(x => x.Id == id); try { // Image item= await _db.Images.Where(p=>p.Id==id).FirstOrDefaultAsync(); _db.Attach <Product>(item); _db.Products.Remove(item); i = await _db.SaveChangesAsync(); } catch (Exception ex) { Console.WriteLine("--- ProductRepository----Ошибка БД Images delete not(false)!"); Console.WriteLine(ex.Message); flag.Message = "БД Products delete not(false)!"; flag.Flag = false; } if (i != 0) { flag.Message = "БД Products delete ok!"; flag.Flag = true; flag.Item = null; return(flag); } else { flag.Message = "БД Products delete not(false)!"; flag.Flag = false; flag.Item = null; return(flag); } }
public async Task <RepositoryResponseDto> DeleteImage(Image item) { RepositoryResponseDto flag = new RepositoryResponseDto { Flag = false, Message = null, Item = null }; int i = 0; try{ // Image item= await _db.Images.Where(p=>p.Id==id).FirstOrDefaultAsync(); _db.Attach <Image>(item); _db.Images.Remove(item); i = await _db.SaveChangesAsync(); } catch (Exception ex) { Console.WriteLine("---UploadImageRepository----Ошибка БД Images delete not(false)!"); Console.WriteLine(ex.Message); flag.Message = "БД Images delete not(false)!"; flag.Flag = false; } if (i != 0) { flag.Message = "БД Images delete ok!"; flag.Flag = true; flag.Item = null; return(flag); } else { flag.Message = "БД Images delete not(false)!"; flag.Flag = false; flag.Item = null; return(flag); } // throw new Exception("not implimetn exeption 14.11.20"); // return await _db.TypeProduct.ToListAsync(); }
public async Task <RepositoryResponseDto> Update(Katalog item) { // throw new Exception("NOt Implimetn Exception"); // Console.WriteLine("async Task<bool> Update(Katalog item)------_db.Kagalog.Any-----"+item.Id.ToString()+" "+item.Name); RepositoryResponseDto flag = new RepositoryResponseDto { Flag = false, Message = null, Item = null }; Katalog selectItem = await _db.Katalogs.FirstOrDefaultAsync(x => x.Id == item.Id); if (selectItem == null) { flag.Message = "Товар с таким id в БД ненайден"; return(flag); } selectItem.Name = item.Name.Trim(); _db.Katalogs.Update(selectItem); int i = await _db.SaveChangesAsync(); if (i != 0) { flag.Message = "БД update ok!"; flag.Flag = true; flag.Item = selectItem; return(flag); } else { flag.Message = "БД update not(false)!"; flag.Flag = false; flag.Item = selectItem; return(flag); } }
//Обновляет значения в бд но не img (photo) public async Task <RepositoryResponseDto> Update(Product item) { bool flag_edit = false; Product selectItem = await _db.Products.FirstOrDefaultAsync(x => x.Id == item.Id); // var flagValid=new FlagValid {Flag=false,ErrorMessage=""}; var flag = new RepositoryResponseDto { Flag = false, Item = null, Message = "" }; if (selectItem == null) { return(new RepositoryResponseDto { Flag = false, Message = "Товар с таким id в БД ненайден" }); } // проверка на уникльность if (item.KatalogId == -1) { flag.Message = "Ошибка БД KatalogId==-1"; flag.Flag = false; return(flag); } if (item.TypeProductId == -1) { flag.Message = "Ошибка БД TypeProductId==-1"; flag.Flag = false; return(flag); } if (selectItem.KatalogId != item.KatalogId) { flag_edit = true; selectItem.KatalogId = item.KatalogId; } if (selectItem.TypeProductId != item.TypeProductId) { flag_edit = true; selectItem.TypeProductId = item.TypeProductId; } if (selectItem.Name != item.Name.Trim()) { flag_edit = true; selectItem.Name = item.Name.Trim(); } if (selectItem.Description != item.Description) { flag_edit = true; selectItem.Description = item.Description; } if (selectItem.Price != item.Price) { flag_edit = true; selectItem.Price = item.Price; } if (selectItem.Markup != item.Markup) { flag_edit = true; selectItem.Markup = item.Markup; } selectItem.Image = item.Image; // _db.Product.Update(selectItem); // _db.Product.Update(item); int i = await _db.SaveChangesAsync(); if (i != 0) { flag.Message = ""; flag.Flag = true; // _del.Invoke(selectItem.Image,photo); return(flag); } if (!flag_edit) { flag.Message = ""; flag.Flag = true; // _del.Invoke(selectItem.Image,photo); return(flag); } flag.Flag = false; flag.Message = "Ошибка субд Update,запись в бд не создана!"; return(flag); }