public SMLIB_OBJ_SMLIB_LISTBUILDER_ITEM getByItemTitleListID(String ItemTitle, Double ListID)
{
PCP_DB_Queries dbQS = new PCP_DB_Queries();
dbQS.addCondition("ITEM_TITLE", ItemTitle, PCP_DB_SEARCH_TYPE.EQUAL);
dbQS.addCondition("ITEM_LIST_ID", ListID.ToString("F0"), PCP_DB_SEARCH_TYPE.EQUAL);
this.getByQuery(dbQS);
if (this.ObjectHash.Count > 0)
{
return(this.getFirstObject() as SMLIB_OBJ_SMLIB_LISTBUILDER_ITEM);
}
else
{
return(null);
}
}
public SMLIB_OBJ_SMLIB_LISTBUILDER_SHARED getByShareRefListID(String ShareRef, Double ListID)
{
PCP_DB_Queries dbQS = new PCP_DB_Queries();
dbQS.addCondition("SHARED_REF_ID", ShareRef, PCP_DB_SEARCH_TYPE.EQUAL);
dbQS.addCondition("SHARED_LIST_ID", ListID.ToString("F0"), PCP_DB_SEARCH_TYPE.EQUAL);
this.getByQuery(dbQS);
if (this.ObjectHash.Count > 0)
{
return(this.getFirstObject() as SMLIB_OBJ_SMLIB_LISTBUILDER_SHARED);
}
else
{
return(null);
}
}
public SMLIB_OBJ_SMLIB_LISTBUILDER_LIST getByListNamePatronID(String ListName, Double PatronID)
{
PCP_DB_Queries dbQS = new PCP_DB_Queries();
dbQS.addCondition("LIST_NAME", ListName, PCP_DB_SEARCH_TYPE.EQUAL);
dbQS.addCondition("LIST_CREATOR", PatronID.ToString("F2"), PCP_DB_SEARCH_TYPE.EQUAL);
this.getByQuery(dbQS);
if (this.ObjectHash.Count > 0)
{
return(this.getFirstObject() as SMLIB_OBJ_SMLIB_LISTBUILDER_LIST);
}
else
{
return(null);
}
}