public void SetControl()
{
try
{
//Global_Log.pID = playlists.PID;
//Global_Log.playlistName = playlists.Name;
int count = 0;
if (HeaderText.Text == "Create Playlist")
{
string get = "GETDATE()";
query = "insert into playlists(name, createdDate, TotalSong) values('" + txtPlaylist.Text + "'," + get + "," + count + ")";
Global_Log.connectionClass.insertData(query);
MessageBox.Show(this, "Playlist Created..!", "Playlist");
}
else if (HeaderText.Text == "Update Playlist:")
{
//query = "update playlists set totalsong =" + count + " where pid =" + 2;
query = "update playlists set name='" + txtPlaylist.Text + "'where PID=" + Global_Log.pID;
Global_Log.connectionClass.insertData(query);
MessageBox.Show(this, "Playlist Updated..!", "Playlist");
}
}
catch (Exception ex)
{
Global_Log.EXC_WriteIn_LOGfile(ex.StackTrace);
}
this.Close();
}
public void LoadAllSong()
{
if (Global_Log.playBack == null)
{
Global_Log.playBack = new PlayBack();
}
List <Audio> audioList = new List <Audio>();
try
{
DataTable dt = Global_Log.playBack.getAllSong();
if (dt != null)
{
int count = dt.Rows.Count;
if (count != 0)
{
Audio info = new Audio();
for (int i = 0; i < count; i++)
{
DataRow dr = dt.Rows[i];
try
{
audioList.Add(new Audio()
{
ID = Convert.ToInt32(dr.ItemArray[0]),
UID = dr.ItemArray[1].ToString(),
Title = dr.ItemArray[2].ToString(),
FileName = dr.ItemArray[3].ToString(),
Filesize = Convert.ToInt32(dr.ItemArray[4]),
Filetype = dr.ItemArray[5].ToString(),
Filepath = dr.ItemArray[6].ToString(),
Duration = (TimeSpan)dr.ItemArray[7],
Chain = dr.ItemArray[8].ToString(),
Track = dr.ItemArray[9].ToString(),
Trim_Start = (TimeSpan)dr.ItemArray[10],
Trim_End = (TimeSpan)dr.ItemArray[11],
Intro = (TimeSpan)dr.ItemArray[12],
EOM = (TimeSpan)dr.ItemArray[13]
});
}
catch (Exception ex)
{
Global_Log.EXC_WriteIn_LOGfile(ex.StackTrace);
}
}
}
}
}
catch (Exception ex)
{ }
//playlistnames.ItemsSource = audioList;
datagrid.ItemsSource = audioList;
}
