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