private static void InsertSong(SongInfo sngI)
{
if (AnalyticalFileAdder.GetSongID(sngI.sngName, sngI.artist) != 0)
{
return;
}
OleDbCommand oleDbCommand = new OleDbCommand("INSERT INTO songs(song_name,artist,album,length,bit_rate,genre,song_year,disk,MIME_type,location,TimeString,checked) VALUES(@sngn,@ar,@al,@len,@brt,@gnr,@year,@dsk,@mtype,@loc,@tims,@chkd)", AnalyticalFileAdder.dbcon.oledbconn);
oleDbCommand.Parameters.AddWithValue("@sngn", (object)sngI.sngName);
oleDbCommand.Parameters.AddWithValue("@ar", (object)sngI.artist);
oleDbCommand.Parameters.AddWithValue("@al", (object)sngI.album);
oleDbCommand.Parameters.AddWithValue("@len", (object)sngI.length);
oleDbCommand.Parameters.AddWithValue("@brt", (object)sngI.bitrate);
oleDbCommand.Parameters.AddWithValue("@gnr", (object)sngI.genre);
oleDbCommand.Parameters.AddWithValue("@year", (object)sngI.year);
oleDbCommand.Parameters.AddWithValue("@dsk", (object)sngI.disk);
oleDbCommand.Parameters.AddWithValue("@mtype", (object)sngI.MIME);
oleDbCommand.Parameters.AddWithValue("@loc", (object)sngI.location);
oleDbCommand.Parameters.AddWithValue("@tims", (object)AnalyticalFileAdder.ToTimeString(sngI.length));
oleDbCommand.Parameters.AddWithValue("@chkd", (object)0);
oleDbCommand.ExecuteNonQuery();
}
