private void BtnSave_Click(object sender, EventArgs e)
{
// strip dollar signs
string packageBase = Regex.Replace(txtBasePrice.Text, "\\$", "");
string packageComm = Regex.Replace(txtCommission.Text, "\\$", "");
int packageId = Convert.ToInt32(txtPackageID.Text);
string packageName = txtPackageName.Text;
DateTime packageStartDate = dateStart.Value;
DateTime packageEndDate = dateEnd.Value;
string packageDescription = txtPackageDesc.Text;
double packageBasePrice = Convert.ToDouble(packageBase);
double packageCommission = Convert.ToDouble(packageComm);
try
{
TravelPackageDB updateTravelPackage = new TravelPackageDB();
updateTravelPackage.EditTravelPackage(packageId, packageName, packageStartDate, packageEndDate, packageDescription, packageBasePrice, packageCommission);
this.Close();
TravelPackageForm refreshFrom = new TravelPackageForm();
refreshFrom.Refresh();
}
catch (Exception ex)
{
MessageBox.Show(ex.Message, ex.GetType().ToString());
}
}
private void AddPackageForm_Load(object sender, EventArgs e)
{
List <Package> packageView = TravelPackageDB.GetPackages(lstViewTravelPackages);
ClearLabels();
btnEditPackage.Enabled = false;
btnDeletePackage.Enabled = false;
}
private void ClearForm()
{
lstViewTravelPackages.Clear();
List <Package> refreshPackageView = TravelPackageDB.GetPackages(lstViewTravelPackages);
ClearLabels();
btnEditPackage.Enabled = false;
btnDeletePackage.Enabled = false;
}
private void LstViewTravelPackages_SelectedIndexChanged(object sender, EventArgs e)
{
TravelPackageDB packageDetails = new TravelPackageDB();
packageDetails.ShowSelectedOrder(lstViewTravelPackages, lblPackageID, lblPackageName, lblStartDate, lblEndDate, lblDescription, lblBasePrice, lblCommission);
ShowLabels();
btnEditPackage.Enabled = true;
btnDeletePackage.Enabled = true;
int packageId = Convert.ToInt32(lblPackageID.Text);
List <Package> packageProducts = TravelPackageDB.GetPackageProducts(lstProducts, packageId);
}
// lists all products in package and available products not yet added
public AddProductForm(int packageId, string packageName)
{
InitializeComponent();
lblPackageName.Text = packageName;
lblPackageId.Text = Convert.ToString(packageId);
if (lstProducts.Items != null)
{
List <Package> packageProducts = TravelPackageDB.GetPackageProducts(lstProducts, packageId);
List <Package> showProducts = TravelPackageDB.ShowAllProducts(lstAllProducts, packageId);
}
}
// delete package with dialog box
private void BtnDeletePackage_Click(object sender, EventArgs e)
{
string packageName = lblPackageName.Text;
DialogResult deleteClient = MessageBox.Show("Are you sure you want to delete the " + packageName + " package?", "Confirm Delete", MessageBoxButtons.YesNo, MessageBoxIcon.Question);
if (deleteClient == DialogResult.Yes)
{
int packageID = Convert.ToInt32(lblPackageID.Text);
TravelPackageDB deletePackage = new TravelPackageDB();
deletePackage.DeleteTravelPackage(lstViewTravelPackages, packageID);
ClearForm();
}
}
// remove product from package
private void BtnRemoveProduct_Click(object sender, EventArgs e)
{
if (lstProducts.SelectedItem == null)
{
MessageBox.Show("A product must be selected to remove");
}
else
{
int packageId = Convert.ToInt32(lblPackageId.Text);
int productId = Convert.ToInt32(lblProductId.Text);
TravelPackageDB removeProduct = new TravelPackageDB();
removeProduct.RemovePackageProduct(productId, packageId);
List <Package> refreshProducts = TravelPackageDB.GetPackageProducts(lstProducts, packageId);
List <Package> showProducts = TravelPackageDB.ShowAllProducts(lstAllProducts, packageId);
}
}
// add product to package
private void BtnAdd_Click(object sender, EventArgs e)
{
if (lstAllProducts.SelectedItem == null)
{
MessageBox.Show("A product must be selected to add");
}
else
{
int packageId = Convert.ToInt32(lblPackageId.Text);
int productId = Convert.ToInt32(lblListNewProd.Text);
TravelPackageDB getProdSupplierId = new TravelPackageDB();
int supplierId = getProdSupplierId.GetSupplierId(productId);
getProdSupplierId.AddPackageToProd(Convert.ToInt32(lblPackageId.Text), supplierId);
List <Package> refreshProducts = TravelPackageDB.GetPackageProducts(lstProducts, packageId);
List <Package> showProducts = TravelPackageDB.ShowAllProducts(lstAllProducts, packageId);
}
}
// validate changes and save form
private void BtnSave_Click(object sender, EventArgs e)
{
if (Validator.IsNotEmpty(txtPackageName, "Package Name") &&
Validator.IsLettersAndSpaces(txtPackageName, "Package Name") &&
Validator.IsValidStartDate(dateStart) &&
Validator.IsValidEndDate(dateStart, dateEnd) &&
Validator.IsNotEmpty(txtPackageDesc, "Package description") &&
Validator.IsNotEmpty(txtBasePrice, "Base price") &&
Validator.IsCurrency(txtBasePrice, "base price") &&
Validator.IsNotEmpty(txtCommission, "Commission") &&
Validator.IsCurrency(txtCommission, "commission"))
{
// strip dollar signs
string packageBase = Regex.Replace(txtBasePrice.Text, "\\$", "");
string packageComm = Regex.Replace(txtCommission.Text, "\\$", "");
string packageName = txtPackageName.Text;
DateTime packageStartDate = dateStart.Value;
DateTime packageEndDate = dateEnd.Value;
string packageDescription = txtPackageDesc.Text;
double packageBasePrice = Convert.ToDouble(packageBase);
double packageCommission = Convert.ToDouble(packageComm);
try
{
TravelPackageDB addNewPackage = new TravelPackageDB();
addNewPackage.AddTravelPackage(packageName, packageStartDate, packageEndDate, packageDescription, packageBasePrice, packageCommission);
this.Close();
TravelPackageForm refreshFrom = new TravelPackageForm();
refreshFrom.Refresh();
}
catch (Exception ex)
{
MessageBox.Show(ex.Message, ex.GetType().ToString());
}
}
}
// selects index of product not added to package
private void LstAllProducts_SelectedIndexChanged(object sender, EventArgs e)
{
TravelPackageDB getProdId = new TravelPackageDB();
getProdId.GetProductId(lstAllProducts.Text, lblListNewProd);
}
