示例#1
0
 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);
     }
 }
示例#2
0
        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);
 }
示例#4
0
        //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);
            }
        }