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