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);
}
