public TblRoleCollection FetchByQuery(Query qry)
{
var coll = new TblRoleCollection();
coll.LoadAndCloseReader(qry.ExecuteReader());
return(coll);
}
public TblRoleCollection FetchAll()
{
var coll = new TblRoleCollection();
var qry = new Query(TblRole.Schema);
coll.LoadAndCloseReader(qry.ExecuteReader());
return(coll);
}
public static TblRoleCollection GetTblRoleCollection(string varPkSuid)
{
var cmd =
new QueryCommand(
"SELECT * FROM [dbo].[tbl_Roles] INNER JOIN [tbl_RolesForUsers] ON [tbl_Roles].[FP_sBranchID] = [tbl_RolesForUsers].[FP_sBranchID] WHERE [tbl_RolesForUsers].[FP_sBranchID] = @FP_sBranchID",
Schema.Provider.Name);
cmd.AddParameter("@FP_sBranchID", varPkSuid, DbType.String);
IDataReader rdr = DataService.GetReader(cmd);
var coll = new TblRoleCollection();
coll.LoadAndCloseReader(rdr);
return(coll);
}