public int Delete(int?id, Csla.SmartDate modifiedDate)
{
using (var entities = new AdventureWorks2014Entities())
{
entities.Database.Log += WriteLog;
var model = entities.ProductSubcategories.SingleOrDefault(b => b.ProductSubcategoryID == id && b.ModifiedDate == modifiedDate.Date);
entities.ProductSubcategories.Remove(model);
return(entities.SaveChanges());
}
}
public List <int> RetreiveCollection(int?id = null)
{
using (var entities = new AdventureWorks2014Entities())
{
entities.Database.Log += WriteLog;
return(entities.ProductCategories
.Where(b => b.ProductCategoryID == id || !id.HasValue)
.Select(b => b.ProductCategoryID)
.ToList());
}
}
public int Create(string name)
{
using (var entities = new AdventureWorks2014Entities())
{
entities.Database.Log += WriteLog;
var model = entities.ProductCategories.Add(new ProductCategory {
Name = name, rowguid = Guid.NewGuid(), ModifiedDate = DateTime.Now
});
entities.SaveChanges();
return(model.ProductCategoryID);
}
}
public int Read(int?id)
{
using (var entities = new AdventureWorks2014Entities())
{
entities.Database.Log += WriteLog;
var model = entities.ProductCategories.SingleOrDefault(b => b.ProductCategoryID == id);
this.Id = model.ProductCategoryID;
this.Name = model.Name;
this.RowGuidId = model.rowguid;
this.ModifiedDate = model.ModifiedDate;
return(1);
}
}
public int Update(int?id, string name, Guid rowGuidId, SmartDate modifiedDate)
{
using (var entities = new AdventureWorks2014Entities())
{
try
{
entities.Database.Log += WriteLog;
var model = entities.ProductCategories.SingleOrDefault(b => b.ProductCategoryID == id);
model.ModifiedDate = DateTime.Now;
model.rowguid = rowGuidId;
model.Name = name;
return(entities.SaveChanges());
}
catch (System.Data.Entity.Validation.DbEntityValidationException ex)
{
var temp = ex.EntityValidationErrors.Select(b => b.ValidationErrors.Select(c => c.ErrorMessage)).ToList();
throw;
}
}
}
