public void deleteAllSubs()
{
SMLIB_DBUtils dbu = new SMLIB_DBUtils();
dbu.excuteCommand("DELETE SMLIB_LISTBUILDER_ITEM WHERE ITEM_LIST_ID=" + this.LIST_ID.ToString("F0"));
dbu.excuteCommand("DELETE SMLIB_LISTBUILDER_SHARED WHERE SHARED_LIST_ID=" + this.LIST_ID.ToString("F0"));
}
public void CreateNew(ref SMLIB_OBJ_SMLIB_LISTBUILDER_SHARED Item)
{
SMLIB_DBUtils dbcontext = new SMLIB_DBUtils();
Item.DBObject.DBUtils = this.DBObject.DBUtils;
Item.insertItem();
}
public List <SMLIB_OBJ_SMLIB_LISTBUILDER_LIST> getCollaborateByPatronID(Double PatronID)
{
List <SMLIB_OBJ_SMLIB_LISTBUILDER_LIST> rv = new List <SMLIB_OBJ_SMLIB_LISTBUILDER_LIST>();
String sql = "SELECT * FROM SMLIB_LISTBUILDER_LIST WHERE LIST_ID IN (SELECT SHARED_LIST_ID FROM SMLIB_LISTBUILDER_SHARED WHERE SHARED_REF_ID='" + PatronID.ToString("F2") + "' AND SHARED_TYPE='COLLABORATE') ORDER BY LIST_NAME ";
SMLIB_DBUtils dbu = new SMLIB_DBUtils();
DataTable dt = new DataTable();
dt = dbu.getTable(sql);
foreach (DataRow dr in dt.Rows)
{
SMLIB_OBJ_SMLIB_LISTBUILDER_LIST item = new SMLIB_OBJ_SMLIB_LISTBUILDER_LIST();
item.getItem(dr);
rv.Add(item);
}
return(rv);
}
