private void btnConfirm_Click(object sender, EventArgs e) { using (PokemonEntities context = new PokemonEntities()) { string check; var max = context.Trainers.DefaultIfEmpty().Max(r => r == null ? 0 : r.TrainerID); max = Convert.ToInt16(max) + 1; short NextID = Convert.ToInt16(max); Trainer trainer = new Trainer { TrainerID = NextID, TName = tbUsername.Text, Password = tbPassword.Text, Email = tbEmail.Text, CreationDate = DateTime.Now }; context.Trainers.Add(trainer); context.SaveChanges(); for (int i = 0; i < 5; i++) { context.getNewPokemon(NextID); context.SaveChanges(); } MessageBox.Show("You did it...well done kid!"); this.Hide(); var nextForm = new ViewTeam(NextID, parent); nextForm.Show(); } }
private void btnLogin_Click(object sender, EventArgs e) { string user; using (PokemonEntities context = new PokemonEntities()) { user = Convert.ToString(tbUsername.Text); var result = context.Trainers .Where(t => t.TName == user) .Select(t => new { t.TrainerID }).ToList(); dataGridView1.DataSource = result; if (context.Trainers.Any(t => t.TName == user)) { if (dataGridView1.RowCount == 0) { MessageBox.Show(user + " does not use the password you have entered"); tbPassword.Clear(); } else { short trainerID = Convert.ToInt16(dataGridView1.Rows[0].Cells[0].Value); this.Hide(); var nextForm = new ViewTeam(trainerID, parent); nextForm.Show(); } } else { MessageBox.Show(user + " does not exist in the system create an account"); } } }