private void Delete_btn_Click(object sender, RoutedEventArgs e)
{
MotoGPTeam modified = (MotoGPTeam)Teams_dgw.SelectedItem;
//if nothing selected, do not respond
if (modified == null)
{
return;
}
Delete delete = new Delete();
delete.ShowDialog();
//Clicked OK
if (delete.DialogResult.HasValue && delete.DialogResult.Value)
{
//Upserting value
using (MotoGPContext db = new MotoGPContext())
{
db.Teams.Remove(db.Teams.Find(modified.Name));
db.SaveChanges();
teams = db.Teams.ToList();
Teams_dgw.ItemsSource = teams;
}
}
}
private void Modify_btn_Click(object sender, RoutedEventArgs e)
{
MotoGPTeam modified = (MotoGPTeam)Teams_dgw.SelectedItem;
//if nothing selected, do not respond
if (modified == null)
{
return;
}
AddOrModify addOrModify = new AddOrModify(modified, true);
addOrModify.ShowDialog();
//Clicked OK (validated)
if (addOrModify.DialogResult.HasValue && addOrModify.DialogResult.Value)
{
//Upserting value
using (MotoGPContext db = new MotoGPContext())
{
db.Teams.AddOrUpdate(modified);
db.SaveChanges();
teams = db.Teams.ToList();
Teams_dgw.ItemsSource = teams;
}
}
}
public MainWindow()
{
InitializeComponent();
//LINQ-able
using (MotoGPContext db = new MotoGPContext())
{
teams = db.Teams.ToList();
}
Teams_dgw.ItemsSource = teams; //Changes dynamically with the list
}
private void Add_btn_Click(object sender, RoutedEventArgs e)
{
MotoGPTeam modified = new MotoGPTeam();
AddOrModify addOrModify = new AddOrModify(modified, false);
addOrModify.ShowDialog();
//Clicked OK (validated)
if (addOrModify.DialogResult.HasValue && addOrModify.DialogResult.Value)
{
//Upserting value
using (MotoGPContext db = new MotoGPContext())
{
db.Teams.AddOrUpdate(modified);
db.SaveChanges();
teams = db.Teams.ToList();
Teams_dgw.ItemsSource = teams;
}
}
}
private void OK_btn_Click(object sender, RoutedEventArgs e)
{
//Validate everything
bool isEverythingOK = true;
Name_err_tb.Text = "";
Established_err_tb.Text = "";
Trophies_err_tb.Text = "";
if (Name_tb.Text == null || Name_tb.Text == "")
{
isEverythingOK = false;
Name_err_tb.Text = "Field must not be empty";
}
else if (Name_tb.Text != null && Name_tb.Text.Length > 80)
{
isEverythingOK = false;
Name_err_tb.Text = "Maximum length is 80 character";
}
else
{
using (MotoGPContext db = new MotoGPContext())
{
MotoGPTeam team = db.Teams.Find(Name_tb.Text);
if (team != null && adding)
{
isEverythingOK = false;
Name_err_tb.Text = "Name already exists";
}
}
}
if (Established_tb.Text != null && Established_tb.Text != "")
{
int value = -1;
if (!int.TryParse(Established_tb.Text, out value))
{
isEverythingOK = false;
Established_err_tb.Text = "Field must contain an integer";
}
else if (value < 1)
{
isEverythingOK = false;
Established_err_tb.Text = "Field must contain a positive number";
}
else if (value > DateTime.Now.Year)
{
isEverythingOK = false;
Established_err_tb.Text = "Field must not contain a year from future";
}
}
else
{
isEverythingOK = false;
Established_err_tb.Text = "Field must not be empty";
}
if (Trophies_tb.Text != null && Trophies_tb.Text != "")
{
int value = -1;
if (!int.TryParse(Trophies_tb.Text, out value))
{
isEverythingOK = false;
Trophies_err_tb.Text = "Field must contain an integer";
}
else if (value < 0)
{
isEverythingOK = false;
Trophies_err_tb.Text = "Field must contain a non negative number";
}
}
else
{
isEverythingOK = false;
Trophies_err_tb.Text = "Field must not be empty";
}
if (isEverythingOK)
{
modified.Name = Name_tb.Text;
modified.Established = int.Parse(Established_tb.Text);
modified.Trophies = int.Parse(Trophies_tb.Text);
modified.Registered = Registered_cb.IsChecked == true;
DialogResult = true;
Close();
}
}
