// confirm deleteion and call delete package function, inserting in the selected package
private void btnDelete_Click(object sender, EventArgs e)
{
if (lstPackages.SelectedItems.Count == 0)
{
MessageBox.Show("Please select a package from the list");
}
else
{
int selectedPkg = Convert.ToInt32(lstPackages.SelectedItems[0].Text);
string selectedPkgName = lstPackages.FocusedItem.SubItems[1].Text;
var confirmDelete = MessageBox.Show("Are you sure you want to delete " + selectedPkgName + "?", "Confirm?", MessageBoxButtons.YesNo);
if (confirmDelete == DialogResult.Yes)
{
try
{
TravelPackageDB.DeletePackage(selectedPkg);
MessageBox.Show("Package deleted successfully");
}
catch
{
MessageBox.Show("Package could not be deleted, contact the administrator");
}
displayPackages();
}
}
}
//Display all packages from list
private void listPackages()
{
cbPackage.Items.Clear();
packages = TravelPackageDB.GetTavelPackage();
foreach (TravelPackage package in packages)
{
cbPackage.Items.Add(package.PkgName);
}
}
// validate text boxes and put fields into an object to be added into database
private void btnAddPackage_Click(object sender, EventArgs e)
{
if (Validator.IsProvided(txtPkgName, "Package Name") &&
Validator.IsProvided(txtPkgDesc, "Package Description") &&
Validator.IsProvided(txtPkgBasePrice, "Package Base Price") &&
Validator.IsNonNegativeMoney(txtPkgBasePrice, "Package Base Price") &&
Validator.IsNonNegativeMoney(txtPkgAgncCommish, "Agency Commision"))
{
if (dtpStartDate.Value < dtpEndDate.Value)
{
// get input fields
string pkgName = txtPkgName.Text;
DateTime pkgStartDate = dtpStartDate.Value;
DateTime pkgEndDate = dtpEndDate.Value;
string pkgDesc = txtPkgDesc.Text;
decimal pkgBasePrice = Convert.ToDecimal(txtPkgBasePrice.Text);
decimal pkgAgncCommish = 0;
if (txtPkgAgncCommish.Text == "")
{
txtPkgAgncCommish.Text = null;
}
else
{
pkgAgncCommish = Convert.ToDecimal(txtPkgAgncCommish.Text);
}
//create package class
TravelPackage package = new TravelPackage();
package.PkgName = pkgName;
package.PkgStartDate = pkgStartDate;
package.PkgEndDate = pkgEndDate;
package.PkgDesc = pkgDesc;
package.PkgBasePrice = pkgBasePrice;
package.PkgAgencyCommission = pkgAgncCommish;
// call insert command
TravelPackageDB.AddPackage(package);
// clear fields
txtPkgName.Text = "";
dtpStartDate.Value = DateTime.Today;
txtPkgDesc.Text = "";
txtPkgBasePrice.Text = "";
txtPkgAgncCommish.Text = "";
displayPackages();
}
else
{
MessageBox.Show("The Start Date must be before the End Date");
}
}
}
// on click validate text fields and create new package for insertion
private void btnUpdatePackage_Click(object sender, EventArgs e)
{
if (Validator.IsProvided(txtPkgName, "Package Name") &&
Validator.IsProvided(txtPkgDesc, "Package Description") &&
Validator.IsProvided(txtPkgBasePrice, "Package Base Price") &&
Validator.IsNonNegativeMoney(txtPkgBasePrice, "Package Base Price") &&
Validator.IsNonNegativeMoney(txtPkgAgncComm, "Agency Commision"))
{
if (dtpStartDate.Value < dtpEndDate.Value)
{
// get input fields
string pkgName = txtPkgName.Text;
DateTime pkgStartDate = dtpStartDate.Value.Date;
DateTime pkgEndDate = dtpEndDate.Value.Date;
string pkgDesc = txtPkgDesc.Text;
decimal pkgBasePrice = Convert.ToDecimal(txtPkgBasePrice.Text);
decimal pkgAgncCommish = 0;
if (txtPkgAgncComm.Text == "")
{
txtPkgAgncComm.Text = null;
}
else
{
pkgAgncCommish = Convert.ToDecimal(txtPkgAgncComm.Text);
}
//create new newpackage class
TravelPackage newpackage = new TravelPackage();
newpackage.PkgName = pkgName;
newpackage.PkgStartDate = pkgStartDate;
newpackage.PkgEndDate = pkgEndDate;
newpackage.PkgDesc = pkgDesc;
newpackage.PkgBasePrice = pkgBasePrice;
newpackage.PkgAgencyCommission = pkgAgncCommish;
// call insert function and insert new package with old package
if (TravelPackageDB.UpdatePackage(package, newpackage))
{
MessageBox.Show("Package was updated successfully");
this.Close();
}
else
{
MessageBox.Show("Error while updating, try again");
}
}
}
}
//Display all packages from list
private void displayPackages()
{
// lists items in list view in specified sub list items
lstPackages.Items.Clear();
packages = TravelPackageDB.GetTavelPackage();
int i = 0;
foreach (TravelPackage package in packages)
{
ListViewItem lvi = new ListViewItem(package.PkgID.ToString(), i); // new list view item starting with package name
lvi.SubItems.Add(package.PkgName);
lvi.SubItems.Add((package.PkgStartDate).ToShortDateString());
lvi.SubItems.Add((package.PkgEndDate).ToShortDateString());
lvi.SubItems.Add(package.PkgDesc);
lvi.SubItems.Add(package.PkgBasePrice.ToString("c"));
lvi.SubItems.Add(package.PkgAgencyCommission.ToString("c"));
lstPackages.Items.Add(lvi);
i++;
}
}
