// delete button to delete a package
private void btnDelete_Click(object sender, EventArgs e)
{
DialogResult result = MessageBox.Show("Delete " + package.PkgName + "?",
"Confirm Delete", MessageBoxButtons.YesNo, MessageBoxIcon.Question);
if (result == DialogResult.Yes)
{
try
{
if (!PackageDB.DeletePackage(package)) // optimistic concurrency violation
{
MessageBox.Show("Another user has updated or deleted " +
"that package.", "Database Error");
this.GetPackage(package.PackageId);
if (package != null)
{
this.DisplayPackage();
}
else
{
this.ClearControls();
}
}
else // successful delete
{
this.ClearControls();
}
}
catch (Exception ex)
{
MessageBox.Show(ex.Message, ex.GetType().ToString());
}
}
}
// Deletes the currently selected package
private void btnPkgDelete_Click(object sender, EventArgs e)
{
//Delete Package
DialogResult confirmation = DialogResult.No;
confirmation = MessageBox.Show("Are you sure you want to delete the package '" +
selectedPackage.Name + "'?", "Confirm Delete", MessageBoxButtons.YesNo,
MessageBoxIcon.Warning, MessageBoxDefaultButton.Button2);
if (confirmation != DialogResult.Yes)
{
return;
}
int rowsDeleted = 0;
try
{
rowsDeleted = PackageDB.Delete(selectedPackage);
if (rowsDeleted > 0)
{
//package deleted. Refill combo box and display result
FillPackageComboBox(btnPkgDelete, EventArgs.Empty);
lblPkgStatus.Text = "Package deleted";
MessageBox.Show("Package deleted");
}
}
catch (Exception ex)
{
MessageBox.Show(ex.Message, "Error Deleting Package");
}
}
/// <summary>
/// Update accepted
/// </summary>
private void btnAccept_Click(object sender, EventArgs e)
{
newPkg = Validation();
if (newPkg == null)
{
return;
}
try
{
int success = PackageDB.UpdatePackage(oldPkg, newPkg);
if (success == 1)
{
this.DialogResult = DialogResult.OK;
}
else if (success == 0) // there was a concurrency issue
{
this.DialogResult = DialogResult.Abort;
}
else
{
this.DialogResult = DialogResult.Cancel;
}
}
catch (Exception ex)
{
MessageBox.Show("Error while editing package.\n" + ex.Message,
ex.GetType().ToString());
}
}
//Delete Package
private void btnPkgDelete_Click(object sender, EventArgs e)
{
int getPkgId = 0;
if (pkgDataGrid.SelectedCells.Count > 0)
{
int selectedrowindex = pkgDataGrid.SelectedCells[0].RowIndex;
DataGridViewRow selectedRow = pkgDataGrid.Rows[selectedrowindex];
getPkgId = Convert.ToInt32(selectedRow.Cells["PackageId"].Value);
Package_AddProduct_DB pkgDeleteObj = new Package_AddProduct_DB();
string message = "Do you want to delete this Record?";
string caption = "Delete Info";
MessageBoxButtons buttons = MessageBoxButtons.YesNo;
DialogResult result;
// Displays the MessageBox.
result = MessageBox.Show(message, caption, buttons);
if (result == System.Windows.Forms.DialogResult.Yes)
{
pkgDeleteObj.Pkg_Products_Delete(getPkgId);
if (pkgDeleteObj.DeletePackage(getPkgId))
{
MessageBox.Show("Package Deleted");
}
PackageDB ObjDeletePkg = new PackageDB();
if (ObjDeletePkg.FillDataGrid())
{
pkgDataGrid.DataSource = ObjDeletePkg.dt;
}
Load_PkgProducts();
cmbProducts.SelectedIndex = -1;
}
}
}
private void DisplayPackages()
{
int rows;
decimal basePrice, agencyCom;
decimal subTotal = 0;
try
{
packageList = PackageDB.GetPackages();
packageDataGridView.DataSource = packageList; // bind the grid view to the Package list
rows = packageList.Count;
for (int i = 0; i < rows; i++)
{
basePrice = (decimal)packageDataGridView.Rows[i].Cells["dataGridViewTextBoxColumn6"].Value;
agencyCom = (decimal)packageDataGridView.Rows[i].Cells["dataGridViewTextBoxColumn7"].Value;
subTotal = basePrice + agencyCom;
packageDataGridView.Rows[i].Cells["PkgSubTotal"].Value = subTotal;
}
}
catch (Exception ex)
{
MessageBox.Show("Error while retrieving packages: " + ex.Message,
ex.GetType().ToString());
}
}
/// <summary>
/// Show edit form
/// </summary>
/// @author Harry
private void btnEdit_Click(object sender, EventArgs e)
{
// get a copy of the current order
Package oldPkg = packages[pkgPos].Clone();
frmEditPkg updatePkg = new frmEditPkg();
// set new and old packages on update form
updatePkg.oldPkg = oldPkg;
updatePkg.newPkg = packages[pkgPos];
// show package edit form
DialogResult editPkgResult = updatePkg.ShowDialog();
if (editPkgResult == DialogResult.OK) // edit accepted
{
// re-gather packages from DB
packages = PackageDB.GetPackages();
ShowPackages();
}
else if (editPkgResult == DialogResult.Abort) // concurrency issue
{
packages[pkgPos] = oldPkg;
MessageBox.Show("Edit aborted. Another user has modified or deleted that package.", "Edit Abort");
}
else // edit cancelled
{
// set back to un-edited package
packages[pkgPos] = oldPkg;
}
}
//add packages, based on the criteria
private void btnAddPackage_Click_1(object sender, EventArgs e)
{
if (validaterClass.isProvided(txtPkgName, "Package Name can not be null") &&
(validaterClass.validateDate(Convert.ToDateTime(dtPkgStartDate.Text), Convert.ToDateTime(dtPkgEndDate.Text)) &&
(validaterClass.isProvided(txtPkgDesc, "Package Description can not be null")) &&
(validaterClass.isProvided(txtPkgBasePrice, "Package Base Price can not be null")) &&
(validaterClass.isNonNegativeDoub(txtPkgBasePrice, "Package Price must be a Positive Whole number")) &&
(validaterClass.isProvided(txtPkgComision, "Agency Comm can not be null")) &&
(validaterClass.isNonNegativeDoub(txtPkgComision, "Agency Comm must be a positive whole number") &&
(validaterClass.isValidateComm(txtPkgBasePrice, txtPkgComision)))))
{
try
{
PackageDB addPkgObj = new PackageDB();
string pkgName = Convert.ToString(txtPkgName.Text);
DateTime pkgStartDate = Convert.ToDateTime(dtPkgStartDate.Text);
DateTime pkgEndDate = Convert.ToDateTime(dtPkgEndDate.Text);
string pkgDesc = Convert.ToString(txtPkgDesc.Text);
decimal pkgBasePrice = Convert.ToDecimal(txtPkgBasePrice.Text);
decimal pkgAgencyComm = Convert.ToDecimal(txtPkgComision.Text);
addPkgObj.addPackage(pkgName, pkgStartDate, pkgEndDate, pkgDesc, pkgBasePrice, pkgAgencyComm);
if (addPkgObj.FillDataGrid())
{
pkgDataGrid.DataSource = addPkgObj.dt;
}
}
catch (OverflowException ex)
{
MessageBox.Show(ex.Message);
}
Clear_Form();
}
}
/// <summary>
/// Adding new package accepted
/// </summary>
private void btnAccept_Click(object sender, EventArgs e)
{
Package newPkg = Validation();
if (newPkg == null) // validation failed
{
return;
}
try
{
bool success = PackageDB.AddPackage(newPkg);
if (success)
{
this.DialogResult = DialogResult.OK;
}
else
{
this.DialogResult = DialogResult.Cancel;
}
}
catch (Exception ex)
{
MessageBox.Show("Error while adding package.\n" + ex.Message,
ex.GetType().ToString());
}
}
/// <summary>
/// Sets the start date of the package
/// </summary>
/// <param name="dateTimePicker"></param>
/// <param name="removeDate"></param>
private void SetStartDate(DateTimePicker dateTimePicker, bool removeDate = false)
{
//update display date and DB
if (!removeDate)
{
dateTimePicker.CustomFormat = DateTimePickerFormat;
DateTime date = dateTimePicker.Value;
PackageSelected.PkgStartDate = date;
PackageDB.UpdatePropertyById(nameof(Package.PkgStartDate), PackageSelected);
//enable editing end date;
dtpPkgEndDate.Enabled = true;
}
else //date field is cleared, display it as such and update DB, also remove end date
{
//clear start date field and End Date Field and updated db
PackageSelected.PkgStartDate = null;
dateTimePicker.CustomFormat = " ";
PackageDB.UpdatePropertyById(nameof(Package.PkgStartDate), PackageSelected);
SetEndDate(dtpPkgEndDate, true);
//disable editing of end date
dtpPkgEndDate.Enabled = false;
}
}
//On combo box selected index changed event populate data into list box
private void cmbProducts_SelectedIndexChanged(object sender, EventArgs e)
{
PackageDB supplierObj = new PackageDB();
int getPkgId = 0;
if (pkgDataGrid.SelectedCells.Count > 0)
{
int selectedrowindex = pkgDataGrid.SelectedCells[0].RowIndex;
DataGridViewRow selectedRow = pkgDataGrid.Rows[selectedrowindex];
getPkgId = Convert.ToInt32(selectedRow.Cells["PackageId"].Value);
Package_AddProduct_DB getSupIdobj = new Package_AddProduct_DB();
getSupIdobj.GetSupplierId(getPkgId);
pkgProductGrid.DataSource = getSupIdobj.getPackageProduct();
}
if (supplierObj.FetchSuppliers(Convert.ToString(cmbProducts.Text), getPkgId))
{
lstSuppliers.Items.Clear();
while (supplierObj.reader.Read())
{
lstSuppliers.Items.Add(supplierObj.reader.GetValue(0));
}
supplierObj.reader.Close();
}
}
private void dgvPackages_Selected(object sender, EventArgs e)
{
dgvProductsSuppliers.Rows.Clear();
int index = dgvPackages.CurrentCell.RowIndex; //get the the user selection
Package selectedPackage = packages[index]; //get the package details
this.DisplayPackage(selectedPackage); //display package details
List <Product> productList = PackageDB.GetProducts(selectedPackage.PackageID);
List <Supplier> supplierList = PackageDB.GetSuppliers(selectedPackage.PackageID);
//add rows to the dTgrid view
for (int i = 0; i < productList.Count; i++)
{
dgvProductsSuppliers.Rows.Add();
}
//add package data to the rows
for (int i = 0; i <= productList.Count - 1; i++)
{
dgvProductsSuppliers.Rows[i].Cells[0].Value = productList[i].ProdName;
dgvProductsSuppliers.Rows[i].Cells[1].Value = supplierList[i].SupName;
}
}
private void btnAddPackage_Click(object sender, EventArgs e)
{
DialogResult result = new DialogResult();
if (txtDesc.Text == "")
{
MessageBox.Show("Package Description is a required field. Please fill in.");
result = DialogResult.Retry;
}
if (txtPrice.Text == "" || txtCommission.Text == "" || Convert.ToDouble(txtPrice.Text) < Convert.ToDouble(txtCommission.Text))
{
MessageBox.Show("The Agency Commission cannot be larger than the Base Price of the package.");
result = DialogResult.Retry;
}
if (txtStart.Text == "" || txtCommission.Text == "" || Convert.ToDateTime(txtStart.Text) >= Convert.ToDateTime(txtEnd.Text))
{
MessageBox.Show("The Start Date must be an earlier date than the End Date.");
result = DialogResult.Retry;
}
if (result != DialogResult.Retry)
{
Package pkg = new Package();
pkg.PkgAgencyCommission = Convert.ToDouble(txtCommission.Text);
pkg.PkgBasePrice = Convert.ToDouble(txtPrice.Text);
pkg.PkgDesc = txtDesc.Text.ToString();
pkg.PkgEndDate = Convert.ToDateTime(txtEnd.Text);
pkg.PkgName = txtPackageName.Text.ToString();
pkg.PkgStartDate = Convert.ToDateTime(txtStart.Text);
TravelExpertData.PackageDB.AddPackage(pkg);
lblAddPkg.Text = "Package Added Successfully";
packageDataGridView.DataSource = PackageDB.GetPackages();
}
}
/// <summary>
/// Add selected product to package in detail view
/// </summary>
/// @author Harry
private void btnAddProdToPkg_Click(object sender, EventArgs e)
{
if (cmboBoxSupsOfProd.SelectedIndex > -1) // selection required
{
// get product and supplier ids (to get ProductSupplierId)
int prodId = products[cmboBoxProducts.SelectedIndex].ProductID;
int supplierId = suppliersOfProd[cmboBoxSupsOfProd.SelectedIndex].SupplierId;
try
{
// get product supplier id
int prodSuppId = ProductSupplierDB.GetId(prodId, supplierId);
// create new package product supplier object to enter into package products suppliers table
PackageProductSupplier newPkgProdSup = new PackageProductSupplier();
newPkgProdSup.PackageId = Convert.ToInt32(packageIdTextBox.Text);
newPkgProdSup.ProductSupplierId = prodSuppId;
// update packages product supplier table
bool success = PackageProductSupplierDB.AddNewPkgProdSupp(newPkgProdSup);
if (success)
{
// clear combo boxes
cmboBoxProducts.Items.Clear();
cmboBoxSupsOfProd.Items.Clear();
// show updated version of products associated with package
List <string> pkgProducts;
List <string> pkgProdSupps;
// access products and suppliers associated with current package
PackageDB.GetPackageProducts(packages[pkgPos].PackageId, out pkgProducts, out pkgProdSupps);
ShowPkgProducts(pkgProducts, pkgProdSupps);
ShowAllProducts();
cmboBoxSupsOfProd.Text = "";
cmboBoxProducts.Text = "";
cmboBoxSupsOfProd.Items.Clear();
MessageBox.Show("Added product successfully.", "Success");
}
else
{
// clear combo boxes
cmboBoxProducts.Items.Clear();
cmboBoxSupsOfProd.Items.Clear();
MessageBox.Show("Error occured while adding product.", "Failure");
}
}
catch (Exception ex)
{
MessageBox.Show("Error while adding product to package\n" + ex.Message,
ex.GetType().ToString());
}
}
else
{
MessageBox.Show("Please select a product and its supplier.", "Select Error");
}
}
/// <summary>
/// Fills the package ComboBox.
/// </summary>
/// <param name="sender">The sender.</param>
/// <param name="e">The instance containing the event data.</param>
private void FillPackageComboBox(object sender, EventArgs e)
{
//Fills the selection box with package items
cmbPackageID.Items.Clear();
cmbPackageID.Items.AddRange(PackageDB.GetTravelPackages().ToArray());
cmbPackageID.SelectedIndex = 0;
accessMode = AccessMode.Read;
}
private void btnAddRemoveProduct_Click(object sender, EventArgs e)
{
pkgId = selected.PackageId;
frmAddProductToPackage viewProductsForPackage = new frmAddProductToPackage();
viewProductsForPackage.selected = PackageDB.GetPackageById(pkgId);
DialogResult result = viewProductsForPackage.ShowDialog();
}
private void reloadData()
{
packageList = PackageDB.GetAllPackages();
productsList = ProductDB.GetProducts();
suppliersList = SupplierDB.GetSuppliers();
prodSuppList = ProductsSupplierDB.GetAllProductsSuppliers();
pkgProdSuppList = PackagesProductsSuppliersDB.GetPackagesProductsSuppliers();
}
/// <summary>
/// Event after validating commission field
/// </summary>
/// <param name="sender"></param>
/// <param name="e"></param>
private void tbxPkgCommission_Validated(object sender, EventArgs e)
{
string commission = (sender as TextBox).Text;
PackageSelected.PkgAgencyCommission = (commission != null) ? Convert.ToDecimal(commission) : (decimal?)null;
PackageDB.UpdatePropertyById(nameof(Package.PkgAgencyCommission), PackageSelected);
}
/// <summary>
/// event occurs when descript has been validated
/// </summary>
/// <param name="sender"></param>
/// <param name="e"></param>
private void tbxPkgDesc_Validated(object sender, EventArgs e)
{
string desc = (sender as TextBox).Text;
PackageSelected.PkgDesc = desc;
PackageDB.UpdatePropertyById(nameof(Package.PkgDesc), PackageSelected);
}
/// <summary>
/// Updates the Package Fields displayed on the form
/// </summary>
/// <param name="package"></param>
private bool DisplayPackage(int packageId)
{
//the package displayed is the same as the package selected from the drop down... do not redisplay.
if (!Object.Equals(PackageSelected, null) && packageId == PackageSelected.PackageId && PackageSelected.PkgName == lblPackageName.Text)
{
return(false);
}
//get the package data
PackageSelected = PackageDB.GetById(packageId);
//Update non-nullable properties
tbxPkgName.Text = PackageSelected.PkgName.ToString();
tbxPkgPrice.Text = Decimal.Round(PackageSelected.PkgBasePrice, 2).ToString();
//Update nullable properties
tbxPkgCommission.Text =
(PackageSelected.PkgAgencyCommission.HasValue) ?
Decimal.Round((decimal)PackageSelected.PkgAgencyCommission, 2).ToString() : String.Empty;
tbxPkgDesc.Text = PackageSelected.PkgDesc.ToString();
//start date is null, remove format
if (Object.Equals(PackageSelected.PkgStartDate, null))
{
dtpPkgStartDate.CustomFormat = " ";
}
else
{
dtpPkgStartDate.CustomFormat = DateTimePickerFormat;
dtpPkgStartDate.Text = PackageSelected.PkgStartDate.ToString();
}
//end date is null, remove format
if (Object.Equals(PackageSelected.PkgEndDate, null))
{
dtpPkgEndDate.CustomFormat = " ";
}
else
{
dtpPkgEndDate.CustomFormat = DateTimePickerFormat;
dtpPkgEndDate.Text = PackageSelected.PkgEndDate.ToString();
}
//update char count labels
DisplayCharCount(tbxPkgDesc, lblDescCharCount);
DisplayCharCount(tbxPkgName, lblNameCharCount);
//If package name is updated, update controls
if (PackageSelected.PkgName != lblPackageName.Text)
{
lblPackageName.Text = PackageSelected.PkgName.ToString();
GetBindedPackageIds();
}
return(true);
}
private void GetHomePageInfo()
{
List <int> duration = new List <int>();
List <decimal> subCost = new List <decimal>();
int rows, rowDuration, minDuration, maxDuration;
decimal minBasePrice, maxBasePrice, rowSubCost;
subTotalChecked = checkBox1.Checked;
packageList = PackageDB.GetPackages();
rows = packageList.Count;
txtPackageCount.Text = rows.ToString();
if (subTotalChecked)
{
for (int i = 0; i < rows; i++)
{
rowSubCost = (decimal)packageList[i].PkgBasePrice + (decimal)packageList[i].PkgAgencyCommission;
subCost.Add(rowSubCost);
}
minBasePrice = subCost.Min();
txtMinBasePrice.Text = minBasePrice.ToString("c");
maxBasePrice = subCost.Max();
txtMaxBasePrice.Text = maxBasePrice.ToString("c");
}
else
{
minBasePrice = packageList.Min(r => r.PkgBasePrice);
txtMinBasePrice.Text = minBasePrice.ToString("c");
maxBasePrice = packageList.Max(r => r.PkgBasePrice);
txtMaxBasePrice.Text = maxBasePrice.ToString("c");
}
for (int i = 0; i < rows; i++)
{
rowDuration = (int)((DateTime)packageList[i].PkgEndDate - (DateTime)packageList[i].PkgStartDate).TotalDays;
duration.Add(rowDuration);
}
minDuration = duration.Min();
txtMinDuration.Text = minDuration.ToString();
maxDuration = duration.Max();
txtMaxDuration.Text = maxDuration.ToString();
supplierList = SupplierDB.GetSuppliers();
txtTotalNumSuppliers.Text = supplierList.Count.ToString();
engagedSuppliers = SupplierDB.GetEngagedSuppliers();
txtEngagedSuppliers.Text = engagedSuppliers.Count.ToString();
productList = ProductDB.GetProducts();
txtTotalNumProducts.Text = productList.Count.ToString();
engagedProducts = ProductDB.GetEngagedProducts();
txtEngagedProducts.Text = engagedProducts.Count.ToString();
}
static PackageDB CreatePackageLevel0DB(bool atOnce, bool?revert)
{
var db = new PackageDB();
db = AddPackageLevel0(db, 0, atOnce, revert);
db = AddPackageLevel0(db, 1, atOnce, revert);
db = AddPackageLevel0(db, 2, atOnce, revert);
db = AddPackageLevel0(db, 3, atOnce, revert);
return(db);
}
private void btnDeletePkg_Click(object sender, EventArgs e)
{
if (loggedInAgt == null)
{
mainForm.btnSignIn_Click(null, null);
}
else
{
// Get Selected Package Id
int pkgId = (int)pkgNameComboBox.SelectedValue;
// Get Selected Package Object
var selectedPkg = packageList.SingleOrDefault(p => p.PackageId == pkgId);
// Get Data from datagridview
int prodSuppId = (int)productSupplierViewModelDataGridView.CurrentRow.Cells[0].Value;
var selectedProdSupp = prodSuppList.SingleOrDefault(ps => ps.ProductSupplierId == prodSuppId);
var selectedPkgProdSupp = pkgProdSuppList.SingleOrDefault(pps => pps.ProductSupplierId == prodSuppId &&
pps.PackageId == pkgId);
int pkgIdCount = pkgProdSuppList.Where(pps => pps.PackageId == pkgId).Count();
if (pkgIdCount == 1)
{
// If the packageId is the last one inside the Package_Products_Supplier table
// Then we delete that package in the Package Table
try {
deletePkgProdSupp(selectedPkgProdSupp);
if (!PackageDB.DeletePackage(selectedPkg))
{
MessageBox.Show("Another user has updated or " +
"deleted that Package.", "Database Error");
// Refresh data
reloadData();
refreshComboBox();
}
else
{
int index = pkgNameComboBox.Items.IndexOf(selectedPkg);
packageList.Remove(selectedPkg);
pkgNameComboBox.SelectedIndex = index - 1;
refreshComboBox();
}
} catch (Exception ex) {
MessageBox.Show("Error: " + ex.Message, ex.GetType().ToString());
}
}
else
{
deletePkgProdSupp(selectedPkgProdSupp);
// If there are 2 or more packageIds inside Package_Products_Supplier, only delete
// from the package_products_supplier table, not the Package table
}
}
}
/// <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();
}
}
}// end of GetPackage button
// GetPackage function to display the packageid information
private void GetPackage(int packageId)
{
try
{
package = PackageDB.GetPackage(packageId);
}
catch (Exception ex)//show an error if catch any problem
{
MessageBox.Show(ex.Message, ex.GetType().ToString());
}
}
// user typing in search bar
private void txtSearchPackage_KeyUp(object sender, KeyEventArgs e)
{
// get search
string search = txtSearchPackage.Text.Trim();
// get products filtered by search
int packageId = 0;
List <Package> packages = PackageDB.GetPackages(packageId, search);
// update binding source
packageBindingSource.DataSource = packages;
}
/// <summary>
/// event occurs when descript has been validated
/// </summary>
/// <param name="sender"></param>
/// <param name="e"></param>
private void tbxPkgDesc_Validated(object sender, EventArgs e)
{
PackageSelected.PkgDesc = (sender as TextBox).Text;
try
{
PackageDB.UpdatePropertyById(nameof(Package.PkgDesc), PackageSelected);
}
catch (Exception f)
{
MessageBox.Show(f.Message, "Unable to update package description", MessageBoxButtons.OK, MessageBoxIcon.Error);
}
}
private void RegistPackageInfo(string[] args)
{
string new_package_name = null;
string new_package_id = null;
while (true)
{
if (new_package_name == null)
{
Console.Write("新しいパッケージ名: ");
new_package_name = Console.ReadLine();
if (new_package_name == null)
{
Console.WriteLine("新しいパッケージ名を入力してください。");
continue;
}
}
if (new_package_id == null)
{
Console.Write("新しいパッケージID: ");
new_package_id = Console.ReadLine();
if (new_package_id == null)
{
Console.WriteLine("新しいパッケージIDを入力してください。");
continue;
}
}
break;
}
PackageDB package_db = new PackageDB();
PackageInfo package_info = new PackageInfo()
{
PackageName = new_package_name,
PackageId = new_package_id
};
Console.WriteLine("-- 登録するパッケージ情報 --");
Console.WriteLine($"パッケージ名: {package_info.PackageName}");
Console.WriteLine($"パッケージID: {package_info.PackageId}");
Console.WriteLine("----");
Console.WriteLine("新しいパッケージ情報を登録しています…");
package_db.RegisterPackageInfo(package_info);
Console.WriteLine("完了");
return;
}
/// <summary>
/// event occures when price has been validated
/// </summary>
/// <param name="sender"></param>
/// <param name="e"></param>
private void tbxPkgPrice_Validated(object sender, EventArgs e)
{
PackageSelected.PkgBasePrice = Convert.ToDecimal((sender as TextBox).Text);
try
{
PackageDB.UpdatePropertyById(nameof(Package.PkgBasePrice), PackageSelected);
}
catch (Exception f)
{
MessageBox.Show(f.Message, "Unable to update package price", MessageBoxButtons.OK, MessageBoxIcon.Error);
}
}
private void SetPackageName(string packageName)
{
//name hasnt changed. return
if (packageName == PackageSelected.PkgName)
{
return;
}
PackageIds.Remove(PackageSelected);
PackageSelected.PkgName = packageName;
PackageDB.UpdatePropertyById(nameof(Package.PkgName), PackageSelected);
}
private void AddModifyPackages_Load(object sender, EventArgs e)
{
if (addPackage) //if addProduct is true then add button was picked
{
this.Text = "Add Package"; //changed form title
txtPackageId.Text = PackageDB.GetNextPackageID().ToString();
}
else //if modify button was picked
{
this.Text = "Modify Package";
this.DisplayPackage();
}
}
