//add data to the database
private void btnAddPkg_Click(object sender, EventArgs e)
{
DateTime newStartDate = new DateTime();
DateTime newEndDate = new DateTime();
decimal newBasePrice;
decimal newCommission;
// Check that the input data can be parsed
if (!DateTime.TryParse(textBoxAddStartDate.Text, out newStartDate))
{
MessageBox.Show("Please enter a date for the start date", "Error");
}
if (!DateTime.TryParse(textBoxAddEndDate.Text, out newEndDate))
{
MessageBox.Show("Please enter a date for the end date", "Error");
}
if (!Decimal.TryParse(textBoxAddBasePrice.Text, out newBasePrice))
{
MessageBox.Show("Please enter a decimal value for the base price", "Error");
}
if (!Decimal.TryParse(textBoxAddComission.Text, out newCommission))
{
MessageBox.Show("Please enter a decimal value for the agency commission", "Error");
}
// Create the package object to be added
Package newPkg = new Package(0, textBoxAddPkgName.Text, newStartDate, newEndDate, textBoxAddDesc.Text, newBasePrice, newCommission);
// Validate the values of the input data. If the input is valid, add the new package
// to the Packages table in the database.
try
{
if (PackageValidation.ValidatePackageData(newPkg))
{
PackageDB.AddPackage(newPkg);
}
LoadUIforPackages();
comboBoxPkgName.SelectedIndex = (packages.Count() - 1);
panelDetailPkg.Visible = true;
panelAddPkg.Visible = false;
btnEditPkgClick.Enabled = true;
btnDeletePkgClick.Enabled = true;
}
catch (Exception ex)
{
MessageBox.Show(ex.Message, ex.GetType().ToString());
}
}
private void btnSubmit_Click(object sender, EventArgs e)
{
//create package
if (package == null)
{
if (ValidatePackageDataInput())
{
//create package object
Package p = new Package();
p.Name = txtName.Text;
p.Description = txtDescription.Text;
p.Start_Date = dtpStart.Value;
p.End_Date = dtpEnd.Value;
p.Base_Price = Convert.ToDecimal(txtPrice.Text);
p.Agency_Commission = Convert.ToDecimal(txtCommission.Text);
//insert package to DB
if (PackageDB.AddPackage(p)) //package was created
{
//get list of added products and suppliers
List <int> list = new List <int>();
foreach (DataGridViewRow item in dgvProductSuppliers.Rows)
{
int id = Convert.ToInt32(item.Cells[0].Value);
list.Add(id);
}
p.ID = PackageDB.GetMaxPackageID();
//insert products suppliers
foreach (int l in list)
{
PackageDB.AddPackageProductSupplier(p.ID, l);
}
MessageBox.Show("The Package was Added.",
"Package was Added");
Close();
}
else
{
MessageBox.Show("Error Occured. Try Again",
"Package was NOT Added");
}
}
}
//update package
else
{
if (ValidatePackageDataInput())
{
//edit package class
package.Name = txtName.Text;
package.Description = txtDescription.Text;
package.Base_Price = Convert.ToDecimal(txtPrice.Text);
package.Agency_Commission = Convert.ToDecimal(txtCommission.Text);
package.Start_Date = dtpStart.Value;
package.End_Date = dtpEnd.Value;
//update db
if (PackageDB.UpdatePackage(package))
{
//delete or add PackageProductSupplier Records
//get list of products and suppliers
List <int> list = new List <int>();
foreach (DataGridViewRow item in dgvProductSuppliers.Rows)
{
int prodSupID = Convert.ToInt32(item.Cells[0].Value);
list.Add(prodSupID);
}
//delete packageproductsupplier
if (PackageDB.DeletePackageProductSupplier(package.ID, list))
{
}
//insert packageproductsupplier
foreach (int l in list)
{
PackageDB.AddPackageProductSupplier(package.ID, l);
}
MessageBox.Show("The Package was Added.",
"Package was Added");
Close();
}
else
{
MessageBox.Show("Error occured when saving package");
}
}
}
}