public static Objects.Record UploadFile(string fileDir, string name, string extension)
{
using (LiteDatabase db = new LiteDatabase(DATABASE_LOCATION))
{
var records = db.GetCollection <Objects.Record>(MEDIA_TABLE);
Objects.Record record = new Objects.Record(name.GetHashCode().ToString(), name, fileDir, extension, DateTime.Now);
bool success = false;
success = records.Upsert(record);
if (db.FileStorage.Exists(name.GetHashCode().ToString()))
{
db.FileStorage.Delete(name.GetHashCode().ToString());
}
try
{
db.FileStorage.Upload(name.GetHashCode().ToString(), name);
} catch (Exception e)
{
success = false;
Console.Write(e);
}
if (!success)
{
return(record);
}
return(null);
}
}
public static void RemoveRecordFromPlaylist(string playlistName, string songName)
{
using (LiteDatabase db = new LiteDatabase(DATABASE_LOCATION))
{
var playlistTable = db.GetCollection <Objects.Playlist>(PLAYLIST_TABLE);
var playlistSongTable = db.GetCollection <Objects.PlaylistSong>(PLAYLIST_SONG_TABLE);
var recordTable = db.GetCollection <Objects.Record>(MEDIA_TABLE);
Objects.Playlist playlist = playlistTable.FindOne(x => x.id.Equals(playlistName.GetHashCode().ToString()));
Objects.Record record = recordTable.FindOne(x => x.id.Equals(songName.GetHashCode().ToString()));
playlistSongTable.Delete(x => x.playlistId.Equals(playlist.id) && x.mediaId.Equals(record.id));
}
}
public static void SetRecordToPlaylist(string playlistName, ArrayList records)
{
using (LiteDatabase db = new LiteDatabase(DATABASE_LOCATION))
{
var playlistTable = db.GetCollection <Objects.Playlist>(PLAYLIST_TABLE);
var playlistSongTable = db.GetCollection <Objects.PlaylistSong>(PLAYLIST_SONG_TABLE);
var recordTable = db.GetCollection <Objects.Record>(MEDIA_TABLE);
foreach (string recordName in records)
{
Objects.Playlist playlist = playlistTable.FindById(playlistName.GetHashCode().ToString());
Objects.Record record = recordTable.FindById(recordName.GetHashCode().ToString());
Objects.PlaylistSong playlistSong = new Objects.PlaylistSong(playlist.id + record.id, record.id, playlist.id);
playlistSongTable.Upsert(playlistSong);
}
}
}
private void BtnUpload_Click(object sender, EventArgs e)
{
ArrayList failed = new ArrayList();
foreach (DataGridViewRow row in lstFiles.SelectedRows)
{
Objects.Record record = DatabaseManager.UploadFile(row.Cells[1].Value.ToString(),
row.Cells[2].Value.ToString(), row.Cells[3].Value.ToString());
if (record == null)
{
failed.Add(row.Cells[2].Value.ToString());
}
}
if (failed.Count >= 1)
{
ShowPopup(failed);
}
else
{
MessageBox.Show("Records added successfully");
}
}