/// <summary>
/// Update auto photos
/// </summary>
/// <param name="autoPhoto">Auto photo to update</param>
public void UpdateAutoPhotos(AutoPhotos autoPhoto)
{
AutoRentEntities context = new AutoRentEntities();
DbTransaction transaction = null;
try
{
context.Connection.Open();
transaction = context.Connection.BeginTransaction();
context.AutoPhotos.Attach(context.AutoPhotos.Single(o => o.AutoNumber == autoPhoto.AutoNumber && o.DoDate == autoPhoto.DoDate));
context.AutoPhotos.ApplyCurrentValues(autoPhoto);
context.SaveChanges();
transaction.Commit();
}
catch
{
transaction.Rollback();
}
finally
{
context.Connection.Close();
}
}
public void InsertAutoPhotos(AutoPhotos autoPhotos)
{
if ((autoPhotos.EntityState != EntityState.Detached))
{
this.ObjectContext.ObjectStateManager.ChangeObjectState(autoPhotos, EntityState.Added);
}
else
{
this.ObjectContext.AutoPhotos.AddObject(autoPhotos);
}
}
public void DeleteAutoPhotos(AutoPhotos autoPhotos)
{
if ((autoPhotos.EntityState != EntityState.Detached))
{
this.ObjectContext.ObjectStateManager.ChangeObjectState(autoPhotos, EntityState.Deleted);
}
else
{
this.ObjectContext.AutoPhotos.Attach(autoPhotos);
this.ObjectContext.AutoPhotos.DeleteObject(autoPhotos);
}
}
public void UpdateAutoPhotosTest()
{
AutoPhotosAccessor accessor = new AutoPhotosAccessor();
AutoPhotos autoPhotos = new AutoPhotos
{
AutoNumber = "AA 5676 CH",
DoDate = new DateTime(2011, 12, 28),
PhotoFileName = "photo_5.jpg"
};
accessor.UpdateAutoPhotos(autoPhotos);
}
/// <summary>
/// Create new auto photo
/// </summary>
/// <param name="autoPhoto">Auto photo to add</param>
public void CreateAutoPhotos(AutoPhotos autoPhoto)
{
AutoRentEntities context = new AutoRentEntities();
DbTransaction transaction = null;
try
{
context.Connection.Open();
transaction = context.Connection.BeginTransaction();
context.AddToAutoPhotos(autoPhoto);
context.SaveChanges();
transaction.Commit();
}
catch
{
transaction.Rollback();
}
finally
{
context.Connection.Close();
}
}
public void UpdateAutoPhotos(AutoPhotos currentAutoPhotos)
{
this.ObjectContext.AutoPhotos.AttachAsModified(currentAutoPhotos, this.ChangeSet.GetOriginal(currentAutoPhotos));
}