//delete public static void Delete <BO, EO>(BO obj, DbContext context, DbSet <EO> dbSet, List <string> dbColumns = null, bool bCommitOnChange = true) where BO : new() where EO : class, new() { bool validateOnSaveEnabled = context.Configuration.ValidateOnSaveEnabled; EO entityObj = new EO(); try { if (dbColumns == null) { entityObj = BusinessLayerUtils.PopulateEntity <EO, BO>(obj); } else { entityObj = BusinessLayerUtils.PopulateEntity <EO, BO>(obj, dbColumns); } context.Configuration.ValidateOnSaveEnabled = false; context.Entry <EO>(entityObj).State = EntityState.Deleted; if (bCommitOnChange) { context.SaveChanges(); } } catch (Exception ex) { ThrowException <BO>(context, "Delete()", ex); } finally { context.Configuration.ValidateOnSaveEnabled = validateOnSaveEnabled; } }
//Update public static void Update <BO, EO>(BO obj, DbContext context, DbSet <EO> dbSet, List <string> dbColumns = null, bool bCommitOnChange = true) where BO : new() where EO : class, new() { EO entityObj = new EO(); try { if (dbColumns == null) { entityObj = BusinessLayerUtils.PopulateEntity <EO, BO>(obj); } else { entityObj = BusinessLayerUtils.PopulateEntity <EO, BO>(obj, dbColumns); } context.Entry <EO>(entityObj).State = EntityState.Modified; if (bCommitOnChange) { context.SaveChanges(); } } catch (Exception ex) { ThrowException <BO>(context, "Update()", ex); } }
//Insert public static EO Insert <BO, EO>(BO obj, DbContext context, DbSet <EO> dbSet, List <string> dbColumns = null, bool bCommitOnChange = true) where BO : new() where EO : class, new() { EO entityObj = new EO(); try { if (dbColumns == null) { entityObj = BusinessLayerUtils.PopulateEntity <EO, BO>(obj); } else { entityObj = BusinessLayerUtils.PopulateEntity <EO, BO>(obj, dbColumns); } dbSet.Add(entityObj); if (bCommitOnChange) { context.SaveChanges(); } } catch (Exception ex) { ThrowException <BO>(context, "Insert()", ex); } return(entityObj); }
protected static List <I> GetCollection(IEnumerable <E> entitySet, List <string> DBColumns = null) { return(BusinessLayerUtils.BuildCollectionFromEntitySet <I, E>(entitySet, DBColumns)); }
protected static I GetOneObject(E entity) { return(BusinessLayerUtils.PopulateObject <I, E>(entity)); }
protected static List <I> GetCollection(IEnumerable <E> entitySet) { return(BusinessLayerUtils.BuildCollectionFromEntitySet <I, E>(entitySet)); }