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);
}
}
}
}
