private void btnWritePlayersXml_Click(object sender, RoutedEventArgs e)
{
// Kirjoitetaan listassa olevien kaikkien olioitten tiedot käyttäjän Save-dialogissa valitsemaan xml-tiedostoon
if (lstPlayers.Items.Count == 0)
{
lblInfo.Text = "Tallennusta ei voi suorittaa koska listalla ei ole pelaajia";
return;
}
var sfd = new SaveFileDialog();
try
{
sfd.InitialDirectory = @"C:\temp\";
sfd.FileName = "Pelaajalista.xml";
sfd.Filter = "xml files|*.xml|All files|*.*";
if (sfd.ShowDialog() == true)
{
DBPlayers.SerializePlayersToXmlFile(sfd.FileName, Players.PlayerList);
lblInfo.Text = string.Format("{0}-tiedostoon serialisointi on suoritettu", sfd.FileName);
}
}
catch (Exception ex)
{
lblInfo.Text = "xml-tiedostoon serialisointi ei onnistunut: " + ex.Message;
}
}
/// <summary>
/// Refresh Players List
/// </summary>
public static void RefreshPlayers()
{
try
{
players = new ObservableCollection <Player>();
string message = "";
DataTable dt = DBPlayers.GetPlayers(out message);
// ORM = Muutetaan datatablen rivit olioiksi
Player player;
foreach (DataRow row in dt.Rows)
{
player = new Player(int.Parse(row[0].ToString()));
player.FirstName = row[1].ToString();
player.LastName = row[2].ToString();
player.Price = int.Parse(row[3].ToString());
player.Team = row[4].ToString();
players.Add(player);
}
}
catch (Exception ex)
{
throw ex;
}
}
/// <summary>
/// Delete Player
/// </summary>
/// <param name="player">Player to Insert</param>
/// <param name="message">return message</param>
/// <returns>Count of affected rows</returns>
public static int DeletePlayer(Player player, out string message)
{
try
{
return(DBPlayers.DeletePlayer(player.Id, out message));
}
catch (Exception)
{
throw;
}
}
/// <summary>
/// Create Player
/// </summary>
/// <param name="player">Player to Create</param>
/// <param name="message">return message</param>
/// <returns>Count of affected rows</returns>
public static int CreatePlayer(Player player, out string message)
{
try
{
return(DBPlayers.InsertPlayer(player, out message));
}
catch (Exception)
{
throw;
}
}
private void btnReadPlayersXml_Click(object sender, RoutedEventArgs e)
{
var ofd = new OpenFileDialog();
try
{
ofd.InitialDirectory = @"C:\temp\";
ofd.Filter = "xml-files (*.xml)|*.xml|All files|*.*";
if (ofd.ShowDialog() == true && File.Exists(ofd.FileName))
{
refreshPlayerList(DBPlayers.DeserializePlayersFromXmlFile(ofd.FileName));
lblInfo.Text = string.Format("{0}-tiedoston deserialisointi suoritettu", ofd.FileName);
}
}
catch (Exception ex)
{
lblInfo.Text = "xml-tiedostosta deserialisointi ei onnistunut: " + ex.Message;
}
}
private void btnReadPlayersBin_Click(object sender, RoutedEventArgs e)
{
var ofd = new OpenFileDialog();
try
{
ofd.InitialDirectory = @"C:\temp\";
ofd.Filter = "bin-files (*.bin)|*.bin|All files|*.*";
if (ofd.ShowDialog() == true && File.Exists(ofd.FileName))
{
object obj = new object();
DBPlayers.DeserializePlayersFromBinFile(ofd.FileName, ref obj);
refreshPlayerList((ObservableCollection <Player>)obj);
lblInfo.Text = string.Format("{0}-tiedoston deserialisointi suoritettu", ofd.FileName);
}
}
catch (Exception ex)
{
lblInfo.Text = "bin-tiedostosta deserialisointi ei onnistunut: " + ex.Message;
}
}
