//public DataTable GetGroupsByUserDT(Contract contract, Guid userId) //{ // DataTable dt = CachedQuery(contract.ConnectionString, contract.Database, StoredProcedure.GetGroupsByUser, new CacheAccessor("C3Cache", string.Format("UserGroups{0}", userId.ToString())), userId); // //DataTable dt = Query(contract.ConnectionString, contract.Database, StoredProcedure.GetGroupsByUser, userId); // dt.PrimaryKey = new DataColumn[] {dt.Columns["GroupId"]}; // return dt; //} public DataTable GetGroupsByUserAndProductDT(Contract contract, Guid userId, GroupEntityTypes type) { DataTable dt = CachedQuery(contract.ConnectionString, contract.Database, StoredProcedure.GetGroupsByUserAndProduct, new CacheAccessor("C3Cache", string.Format("UserGroups{0}{1}{2}", userId.ToString(), (int)type, contract.ContractId.ToString())), userId, (int)type); dt.PrimaryKey = new DataColumn[] { dt.Columns["GroupId"] }; return(dt); }
public List <Subscriber> GetSubscribersByUserAndType(Contract contract, Guid userId, GroupEntityTypes type) { return(CachedQueryAll <Subscriber>(contract.ConnectionString, contract.Database, StoredProcedure.GetSubscribersByUser, Subscriber.Build, new CacheAccessor("C3Cache", string.Format("Subscribers{0}", userId.ToString())), userId, (int)type)); }
public List <Group> GetGroupsByUserAndProduct(Contract contract, Guid userId, GroupEntityTypes type) { return(QueryAll <Group>(contract.ConnectionString, contract.Database, StoredProcedure.GetGroupsByUserAndProduct, Group.Build, userId, (int)type)); }