private void btnAddSuppProd_Click(object sender, EventArgs e)
{
Products_Suppliers prodSupp = new Products_Suppliers();
prodSupp.ProductId = Convert.ToInt32(cbProductforCombination.SelectedValue);
prodSupp.SupplierId = Convert.ToInt32(cbSupplierIDForCombined.SelectedValue);
Products_SuppliersDB.AddProductsSuppliers(prodSupp);
lblAddSuppProd.Text = "Supplier/Product Combo has been added";
supplierDataGridView.DataSource = SupplierDB.GetSuppliers();
}
/// <summary>
/// Method responsible for creating BookingDetails accrording to the passed bookingId and class
/// </summary>
public static void CreateBookingDetailPckg(Booking newBooking, string Class)
{
List <Package> selectedPckg = PackageDB.GetPackagesById((int)newBooking.PackageId);
List <FlightsTable> inclFlights = FlightsTableDB.getFlightsById(selectedPckg[0].DepartureFlight, selectedPckg[0].ReturnFlight);
List <Products_Suppliers> usedProds = Products_SuppliersDB.GetProductsSuppliersIdFromPackageId((int)newBooking.PackageId);
SqlConnection con = UnversalDBControls.GetConnection();
string insertStatement = "ALTER TABLE BookingDetails " +
"NOCHECK CONSTRAINT FK_BookingDetails_Bookings; " +
"ALTER TABLE BookingDetails " +
"NOCHECK CONSTRAINT FK_BookingDetails_Regions; " +
"INSERT INTO BookingDetails (ItineraryNo, TripStart, TripEnd, Description, Destination, BasePrice, " +
"AgencyCommission, BookingId, RegionId, ClassId, FeeId, ProductSupplierId, " +
"DeparturePlnId, ReturnPlnId) " +
"VALUES(@ItineraryNo, @TripStart, @TripEnd, @Description, @Destination, @BasePrice, " +
"@AgencyCommission, @BookingId, @RegionId, @ClassId, @FeeId, @ProductSupplierId, " +
"@DeparturePlnId, @ReturnPlnId)";
SqlCommand cmd = new SqlCommand(insertStatement, con);
cmd.Parameters.AddWithValue("@ItineraryNo", RandomString(6));
cmd.Parameters.AddWithValue("@TripStart", inclFlights[0].FltDepart);
cmd.Parameters.AddWithValue("@TripEnd", inclFlights[1].FltReturn);
cmd.Parameters.AddWithValue("@Description", inclFlights[0].FltLocation + "/" + inclFlights[1].FltDestination + "/" + inclFlights[0].FltLocation);
cmd.Parameters.AddWithValue("@Destination", inclFlights[1].FltDestination);
cmd.Parameters.AddWithValue("@BasePrice", selectedPckg[0].PkgBasePrice);
cmd.Parameters.AddWithValue("@AgencyCommission", selectedPckg[0].PkgAgencyCommission);
cmd.Parameters.AddWithValue("@BookingId", newBooking.BookingId);
cmd.Parameters.AddWithValue("@RegionId", inclFlights[1].RegionId);
cmd.Parameters.AddWithValue("@ClassId", Class);
if (newBooking.TravelerCount == 1)
{
cmd.Parameters.AddWithValue("@FeeId", "BK");
}
else if (newBooking.TravelerCount >= 2)
{
cmd.Parameters.AddWithValue("@FeeId", "GR");
}
cmd.Parameters.AddWithValue("@ProductSupplierId", usedProds[0].ProductSupplierId);
cmd.Parameters.AddWithValue("@DeparturePlnId", inclFlights[0].FlightId);
cmd.Parameters.AddWithValue("@ReturnPlnId", inclFlights[1].FlightId);
try
{
con.Open();
cmd.ExecuteNonQuery();
}
catch (SqlException ex)
{
throw ex;
}
finally
{
con.Close();
}
}
private void btnAccept_Click(object sender, EventArgs e)
{
bool success = Products_SuppliersDB.UpdateProductsSuppliers(oldSuppProd, newSuppProd);
if (success)
{
this.DialogResult = DialogResult.OK;
ManagementForm frm = new ManagementForm();
frm.Refresh();
}
else
{
this.DialogResult = DialogResult.Retry;
}
}
private void btnRefreshSuppProd_Click(object sender, EventArgs e)
{
products_SuppliersDataGridView.DataSource = Products_SuppliersDB.GetProductsSuppliers();
}
private void btnAddProdToPkg_Click(object sender, EventArgs e)
{
PackageDB.AddProductToPackage(Convert.ToInt32(cbPack.SelectedValue), Convert.ToInt32(cbProduct.SelectedValue));
lblAddProdPkg.Text = "Product has been added to the selected package";
products_SuppliersDataGridView.DataSource = Products_SuppliersDB.GetProductsSuppliers();
}
