private void ExportData(FileTypeEnum storageEnum, bool selected = false, bool all = false)
{
var players = FilePath.GetBasketballPlayers();
var teams = FilePath.GetTeams();
var selectedTeam = lvTeamsOutput.SelectedItem as Teams;
var refer = new ImpExpDB();
string path;
refer.DataStorage = storageEnum;
if (players.Count > 0 && storageEnum.ToString().Contains("player", StringComparison.OrdinalIgnoreCase))
{
if (all)
{
refer.ExportPlayerDataFromDB(players.ToArray());
}
if (selected)
{
refer.ExportPlayerDataFromDB(selectedTeam.BasketballPlayers.ToArray());
}
ToLog("Basketball players data was inserted from database", MessageBoxImage.Information);
path = refer.GetFilePath();
ShowFileDialog(path);
return;
}
if (teams.Count > 0 && storageEnum.ToString().Contains("team", StringComparison.OrdinalIgnoreCase))
{
if (all)
{
refer.ExportTeamDataFromDB(teams.ToArray());
}
if (selected)
{
refer.ExportTeamDataFromDB(selectedTeam);
}
ToLog("Team data was inserted from database", MessageBoxImage.Information);
path = refer.GetFilePath();
ShowFileDialog(path);
return;
}
else
{
ToLog("Database is empty", MessageBoxImage.Error);
}
}
private void miImportTeams_Click(object sender, RoutedEventArgs e)
{
OpenFileDialog opnfldlg = new OpenFileDialog();
opnfldlg.Filter = "Storage Files(*.TXT;*.CSV;*.JSON;*.XML;*.XLSX)|*.TXT;*.CSV;*.JSON;*.XML;*.XLSX";
string filePath = null;
var result = opnfldlg.ShowDialog();
if (result == true)
{
filePath = opnfldlg.FileName;
}
if (string.IsNullOrEmpty(filePath))
{
ToLog("You haven't chosen a file", MessageBoxImage.Error);
return;
}
var refer = new ImpExpDB(filePath, false);
refer.StorageTeamsEmptinessCheck();
refer.ImportTeamDataToDB();
}
private void miImportPlayers_Click(object sender, RoutedEventArgs e)
{
OpenFileDialog opnfldlg = new OpenFileDialog();
opnfldlg.Filter = "Storage Files(*.TXT;*.CSV;*.JSON;*.XML;*.XLSX)|*.TXT;*.CSV;*.JSON;*.XML;*.XLSX";
string filePath = null;
var result = opnfldlg.ShowDialog();
if (result == true)
{
filePath = opnfldlg.FileName;
}
if (string.IsNullOrEmpty(filePath))
{
ToLog("You haven't chosen a file", MessageBoxImage.Error);
return;
}
var refer = new ImpExpDB(filePath, true);
var cont = (Control)sender;
refer.StoragePlayersEmptinessCheck();
if (cont.Name.Contains("all", StringComparison.OrdinalIgnoreCase))
{
refer.ImportPlayerDataToDB();
UpdateInterface();
}
if (cont.Name.Contains("selected", StringComparison.OrdinalIgnoreCase))
{
var team = lvTeamsOutput.SelectedItem as Teams;
refer.ImportPlayerDataToDB(true, team);
UpdateInterface();
}
}