public void DeleteSong(int ID)
{
try
{
currentSong = "delete from Audio where ID=" + ID;
getStatus = connectionClass.insertData(currentSong);
}
catch (Exception ex)
{
Global_Log.EXC_WriteIn_LOGfile(ex.StackTrace);
}
}
public DataTable getAllSong()
{
DataTable dt = null;
try
{
dt = connectionClass.retriveData("select * from Audio", "Audio");
{ }
}
catch (Exception ex)
{
Global_Log.EXC_WriteIn_LOGfile(ex.StackTrace);
}
return(dt);
}
public int insertData(String quary)
{
count = 0;
try
{
cmd = new SqlCommand(quary, con);
checkConnection();
count = cmd.ExecuteNonQuery();
checkConnection();
}
catch (Exception ex)
{
Global_Log.EXC_WriteIn_LOGfile(ex.StackTrace);
}
return(count);
}
//queryStatus=true => Insert The Song ...
//else Update the song..
public void insertSong(Audio audio, bool queryStatus)
{
try
{
if (queryStatus)
{
audio.UID = "abcdUID";
currentSong = "insert into Audio (UID, Title, fileName, filesize, fileType, filepath," +
" duration, Chain, track, trimIn, trimOut, Intro, EOM)values(" +
"'" + audio.UID + "','" + audio.Title + "','" + audio.FileName + "'," + audio.Filesize + "," +
"'" + audio.Filetype + "','" + audio.Filepath + "','" + audio.Duration + "','Chain_0','" + audio.Track + "" +
"','" + audio.Trim_Start + "','" + audio.Trim_End + "','" + audio.Intro + "','" + audio.EOM + "' )";
//ID UID Title fileName filesize fileType filepath duration Chain track trimIn trimOut Intro EOM
{ }
getStatus = connectionClass.insertData(currentSong);
if (getStatus == 1)
{
currentSong = "select ID from audio where UID = 'abcdUID'";
DataTable dt = connectionClass.retriveData(currentSong, "Audio");
int ID = Convert.ToInt32(dt.Rows[0][0]);
string newId = "0000" + ID;
currentSong = "update audio set UID = '" + newId + "' where ID = " + ID;
getStatus = connectionClass.insertData(currentSong);
}
else
{
}
}
else
{
//currentSong = "update Audio set title='" + audio.Title + "',Trim_Start='" + audio.Trim_Start + "'" +
// ",Trim_End='" + audio.Trim_End + "' where ID=" + audio.ID;
currentSong = "update Audio set Title='" + audio.Title + "',trimIn='" + audio.Trim_Start + "'" +
"trimOut='" + audio.Trim_End + "' where ID=" + audio.ID;
getStatus = connectionClass.insertData(currentSong);
}
}
catch (Exception ex)
{
Global_Log.EXC_WriteIn_LOGfile(ex.StackTrace);
}
}