public void add() { if (validateAll()) { MessageBox.Show(validateAll() + ""); TripPackage package = new TripPackage(); package.id_package = textBox1.Text; package.name = textBox2.Text; package.description = textBox3.Text; package.id_hotel = getHotelId(comboBox1.Text); package.id_roomType = getRoomTypeId(comboBox3.Text); package.totalPrice_local = sumOfLocalPrice(); package.totalPrice_international = sumOfInternationalPrice(); package.dayOfTrip = int.Parse(textBox5.Text); /*helpers.showInfo(textBox1.Text + "\n " + textBox2.Text + "\n " + textBox3.Text + "\n " + getHotelId(comboBox1.Text) + "\n " + getRoomTypeId(comboBox3.Text) + "\n " + sumOfLocalPrice() + "\n " + sumOfInternationalPrice());*/ try { data.TripPackages.Add(package); data.SaveChanges(); foreach (DataGridViewRow room in dataGridView1.Rows) { TripPackageDetail roomType = new TripPackageDetail(); roomType.id_package = textBox1.Text; roomType.id_trip = room.Cells[0].Value.ToString(); try { data.TripPackageDetails.Add(roomType); data.SaveChanges(); } catch (SqlException ex) { if (ex.Number == 2627) { helpers.showError("Sorry, can't add duplicate package data!"); } else { helpers.showError(ex.Message); } } } helpers.showInfo("New package has been added!"); } catch (SqlException ex) { if (ex.Number == 2627) { helpers.showError("Sorry, can't add duplicate package data!"); } else { helpers.showError(ex.Message); } } } }
public void edit(string id) { if (validateAll()) { var package = data.TripPackages.Find(id); package.name = textBox2.Text; package.description = textBox3.Text; package.id_hotel = getHotelId(comboBox1.Text); package.id_roomType = getRoomTypeId(comboBox3.Text); package.totalPrice_local = sumOfLocalPrice(); package.totalPrice_international = sumOfInternationalPrice(); package.dayOfTrip = int.Parse(textBox5.Text); try { data.SaveChanges(); var PackageDetails = data.TripPackageDetails.Where(x => x.id_package.Equals(id)); foreach (var type in PackageDetails) { try { data.TripPackageDetails.Remove(type); data.SaveChanges(); } catch (Exception ex) { helpers.showError(ex.Message); } } foreach (DataGridViewRow room in dataGridView1.Rows) { TripPackageDetail roomType = new TripPackageDetail(); roomType.id_package = textBox1.Text; roomType.id_trip = room.Cells[0].Value.ToString(); try { data.TripPackageDetails.Add(roomType); data.SaveChanges(); } catch (SqlException ex) { if (ex.Number == 2627) { helpers.showError("Sorry, can't add duplicate package room data!"); } else { helpers.showError(ex.Message); } } } helpers.showInfo("Package has been updated!"); } catch (SqlException ex) { if (ex.Number == 2627) { helpers.showError("Sorry, can't add duplicate package data!"); } else { helpers.showError(ex.Message); } } } }