/// <summary> /// Updates a Firearm in the Database. /// Returns the updated Firearm. /// </summary> /// <param name="firearm">The Firearm to update.</param> /// <returns></returns> public static Firearms UpdateFirearm(Firearms firearm) { using (var context = new SimpleGunShopDatabaseEntities()) { try { context.Firearms.Add(firearm); context.Entry(firearm).State = EntityState.Modified; // Tell EF it has been modified context.SaveChanges(); return(firearm); } catch (System.Data.Entity.Validation.DbEntityValidationException dbEx) { Exception raise = dbEx; foreach (var validationErrors in dbEx.EntityValidationErrors) { foreach (var validationError in validationErrors.ValidationErrors) { string message = string.Format("{0}:{1}", validationErrors.Entry.Entity.ToString(), validationError.ErrorMessage); raise = new InvalidOperationException(message, raise); } } throw raise; } } }
private void DisplayUpdateForm() { Firearms selectedFirearm = lstFirearms.SelectedItem as Firearms; var updateForm = new FormUpdateFirearm(selectedFirearm); updateForm.ShowDialog(); }
/// <summary> /// Deletes a Firearm from the Database. /// </summary> /// <param name="firearm"></param> public static void DeleteFirearm(Firearms firearm) { using (var context = new SimpleGunShopDatabaseEntities()) { context.Firearms.Add(firearm); // Track with EF context.Entry(firearm).State = EntityState.Deleted; // Tell EF we are removing it context.SaveChanges(); // Update on DB } }
/// <summary> /// Adds a Firearm. Returns the newly added Firearm /// with the FirearmID populated /// </summary> /// <param name="firearm">The Firearm to add.</param> /// <returns></returns> public static Firearms AddFirearm(Firearms firearm) { using (var context = new SimpleGunShopDatabaseEntities()) { context.Firearms.Add(firearm); context.SaveChanges(); context.Entry(firearm).State = EntityState.Added; // Tell EF firearm has been added return(firearm); } }
public FormUpdateFirearm(Firearms f = null) { InitializeComponent(); existingFirearm = f; if (f != null) { Text = "Updating firearm : " + f.SerialNumber; //Populate existing firearm on the update form with main form txtUpdateSerialNum.Text = existingFirearm.SerialNumber; txtUpdateManufacturer.Text = existingFirearm.Manufacturer; txtUpdateModel.Text = existingFirearm.ModelName; txtUpdateCaliber.Text = existingFirearm.Caliber; txtUpdatePrice.Text = Convert.ToString(existingFirearm.Price); } }
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"); } }