public void SaveProductPhoto(int productId, string photoname, byte[] photo)
{
_context.BeginTransaction();
var productPhoto = new ModelStore <ProductPhoto>()
.TrackChanges(ChangeTrackingStrategy.PropertyState);
productPhoto.Add(new ProductPhoto()
{
ProductPhotoID = productId,
LargePhotoFileName = photoname,
LargePhoto = photo
});
var result = productPhoto.SaveChanges(_context);
if (result.InsertedCount == 1)
{
var productPhotoID = productPhoto.FirstOrDefault().ProductPhotoID;
var pordProdPhoto = new ModelStore <ProductProductPhoto>()
.TrackChanges(ChangeTrackingStrategy.PropertyState);
pordProdPhoto.Add(new ProductProductPhoto()
{
ProductID = productId,
ProductPhotoID = productPhotoID,
Primary = 1
});
pordProdPhoto.SaveChanges(_context);
}
_context.Commit();
}
public int SavePerson(IModelStore <Person> person,
IModelStore <BusinessEntityAddress> addresses,
IModelStore <PersonPhone> phones,
IModelStore <Customer> customers)
{
int intPersonId = 0;
_context.BeginTransaction();
if (person.TrackedCount(StateTrackable.NewModified) == 1)
{
var businessEntity = new ModelStore <BusinessEntity>()
.TrackChanges(ChangeTrackingStrategy.PropertyState);
businessEntity.Add(new BusinessEntity()
{
ModifiedDate = DateTime.Now
});
var result = businessEntity.SaveChanges(_context);
if (result.InsertedCount == 1)
{
intPersonId = businessEntity.FirstOrDefault().BusinessEntityID;
person.SetValue(0, "Businessentityid", intPersonId);
}
}
else
{
intPersonId = person.FirstOrDefault().Businessentityid;
}
SetPrimaryKey(person, addresses, phones, customers);
//Save person address, phone, customer
person.SaveChanges(_context);
addresses.SaveChanges(_context);
phones.SaveChanges(_context);
customers.SaveChanges(_context);
_context.Commit();
return(intPersonId);
}