public async Task Delete(long id)
{
using (var context = new PicturesDbContext())
{
var picture = new Picture() {Id = id};
context.Pictures.Attach(picture);
context.Entry(picture).State = EntityState.Deleted;
await context.SaveChangesAsync();
}
}
public async Task Save(SavePictureDto savePictureDto)
{
using (var context = new PicturesDbContext())
{
if (savePictureDto.Id == 0)
{
context.Pictures.Add(new Picture
{
Name = savePictureDto.Name,
PainterId = savePictureDto.PainterId,
StyleId = savePictureDto.StyleId,
Year = savePictureDto.Year,
Guid = savePictureDto.Guid,
ImageUrl = savePictureDto.ImageUrl,
});
}
else
{
var existedPicture = new Picture {Id = savePictureDto.Id};
context.Pictures.Attach(existedPicture);
existedPicture.Name = savePictureDto.Name;
existedPicture.PainterId = savePictureDto.PainterId;
existedPicture.StyleId = savePictureDto.StyleId;
existedPicture.Year = savePictureDto.Year;
existedPicture.Guid = savePictureDto.Guid;
existedPicture.ImageUrl = savePictureDto.ImageUrl;
context.Entry(existedPicture).State = EntityState.Modified;
}
await context.SaveChangesAsync();
}
}
public async Task UpdateUserInfo(long id, string firstName, string lastName)
{
using (var context = new PicturesDbContext())
{
var userEntity = new User {Id = id};
var entity = context.Users.Attach(userEntity);
entity.FirstName = firstName;
entity.LastName = lastName;
context.Entry(entity).Property(item => item.FirstName).IsModified = true;
context.Entry(entity).Property(item => item.LastName).IsModified = true;
await context.SaveChangesAsync();
}
}
