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