internal OCL.PlayList GetPlayList(int PlayListID)
{
try
{
OCL.PlayList X = null;
string sSQL = "Select * FROM tblPlayList WHERE ID = " + PlayListID +
" ORDER BY Name";
DataSet DS = RF.GetDataSet(sSQL);
if(DS.Tables[0].Rows.Count > 0)
{
X = new OCL.PlayList();
DataRow r = DS.Tables[0].Rows[0];
X.mvarID = Convert.ToInt32((object)r[0]);
X.mvarName = Convert.ToString((object)r[1]);
X.mvarFileImage = r[2].ToString();
X.mvarCreated = Convert.ToDateTime((object)r[3]);
X.mvarUserID = Convert.ToInt32((object)r[4]);
}
return X;
}
catch(Exception Err)
{
throw new ApplicationException(Err.Message);
}
}
internal OCL.PlayLists GetUsersPlayList(int UserID)
{
try
{
OCL.PlayLists MyPlayList = new OCL.PlayLists();
string sSQL = "Select * FROM tblPlayList WHERE UserID = " + UserID +
" ORDER BY Name";
DataSet DS = RF.GetDataSet(sSQL);
foreach(DataRow r in DS.Tables[0].Rows)
{
OCL.PlayList X = new OCL.PlayList();
X.mvarID = Convert.ToInt32((object)r[0]);
X.mvarName = Convert.ToString((object)r[1]);
X.mvarFileImage = r[2].ToString();
X.mvarCreated = Convert.ToDateTime((object)r[3]);
X.mvarUserID = Convert.ToInt32((object)r[4]);
MyPlayList.Add(X);
}
return MyPlayList;
}
catch(Exception Err)
{
throw new ApplicationException(Err.Message);
}
}
private void listBox1_SelectedIndexChanged(object sender, System.EventArgs e)
{
btnOK.Enabled = true;
m_playlist = (OCL.PlayList)listBox1.SelectedItem;
}
