private void GetAllFirearms() { List <Firearms> firearms = FirearmDB.GetFirearms(); lstFirearms.DataSource = firearms; lstFirearms.DisplayMember = nameof(Firearms.Manufacturer); }
private void btnUpdateFirearm_Click(object sender, EventArgs e) { Firearms gun = new Firearms(); try { //Keep the ID of the gun the same because we are UPDATING gun.FirearmID = existingFirearm.FirearmID; FirearmDB.UpdateFirearm(gun); MessageBox.Show("Firearm has been updated!"); Close(); } catch (SqlException ex) { MessageBox.Show("There was an issue contacting the Database, please try agian"); MessageBox.Show(ex.Message); MessageBox.Show(ex.GetType().ToString()); } }
private void btnAddFirearm_Click(object sender, EventArgs e) { Firearms f = new Firearms() { SerialNumber = txtSerialNumber.Text, Manufacturer = txtManufacturer.Text, ModelName = txtModel.Text, Caliber = txtCaliper.Text, Price = Convert.ToDecimal(txtPrice.Text) }; try { FirearmDB.AddFirearm(f); MessageBox.Show("Firearm was added!"); Close(); } catch (SqlException) { MessageBox.Show("Database Error", "There was an issue when trying to add to the DB"); } }