private void btnAccept_Click_1(object sender, EventArgs e)
{
if (addPackage)
{
pack = new Packages();
putPackageData(pack);
int Id = PackagesDB.AddPackage(pack);
MessageBox.Show("New Package with Id of" + Id + " was added");
this.DialogResult = DialogResult.OK;
}
else
{
Packages newPackage = new Packages();
newPackage.PackageId = modifyPack.PackageId;
this.putPackageData(newPackage);
try
{
if (!PackagesDB.UpdatePackage(modifyPack, newPackage))
{
MessageBox.Show("Another user has updated or " +
"deleted that customer.", "Database Error");
this.DialogResult = DialogResult.Retry;
}
else
{
modifyPack = newPackage;
this.DialogResult = DialogResult.OK;
}
}
catch (Exception ex)
{
MessageBox.Show(ex.Message, ex.GetType().ToString());
}
}
}
// button the add the data to the DB
private void btnAccept_Click(object sender, EventArgs e)
{
if (isValid())
{
if (add)
{
package = this.createPackageObjects();
try
{
package.PackageId = PackagesDB.AddPackage(package);
foreach (Packages_Products_Suppliers ps in pack_prod_sup)
{
ps.PackageId = package.PackageId;
Packages_Products_SuppliersDB.AddPackProdSupp(ps);
}
this.DialogResult = DialogResult.OK;
}
catch (Exception ex)
{
MessageBox.Show(ex.Message, ex.GetType().ToString());
}
}
else
{
Package newPackage = new Package();
newPackage = this.createPackageObjects();
try
{
if (!PackagesDB.UpdatePackage(package, newPackage))
{
MessageBox.Show("That Package has been updated or deleted already.", "Database Error");
this.DialogResult = DialogResult.Retry;
}
else
{
package = newPackage;
this.DialogResult = DialogResult.OK;
}
}
catch (Exception ex)
{
MessageBox.Show(ex.Message, ex.GetType().ToString());
}
}
}
}
private void btnAcceptEdit_Click(object sender, EventArgs e)
{
Packages currentPackage = PackagesDB.GetPackageById((int)id);
Packages newPackage = new Packages();
bool currentDates = IsValidShippedDate();
if (currentPackage.PkgName == null ||
currentPackage.PkgDesc == null
)
{
MessageBox.Show("Fill in name and description before adding package", "Please check");
this.DialogResult = DialogResult.OK;
}
else if (Validator.IsPresent(txtPkgName) &&
Validator.IsPresent(txtPkgDesc) &&
Validator.IsDecimal(txtBasePrice) &&
Validator.IsDecimal(txtCommission) &&
currentDates == true)
{
newPackage.PackageId = currentPackage.PackageId;
this.PutPackageData(newPackage);
try
{
if (!PackagesDB.UpdatePackage(currentPackage, newPackage))
{
MessageBox.Show("Another user has updated or " +
"deleted that package.", "Database Error");
this.DialogResult = DialogResult.Retry;
}
else
{
package = newPackage;
MessageBox.Show("Package updated", "Success!");
this.DialogResult = DialogResult.OK;
}
}
catch (Exception ex)
{
MessageBox.Show(ex.Message, ex.GetType().ToString());
}
this.Close();
}
}
private void btnAccept_Click(object sender, EventArgs e)
{
if (addPackage)
{
package = new Packages();
this.PutPackageData(package);
try
{
package.PackageId = PackagesDB.AddPackage(package);
this.DialogResult = DialogResult.OK;
}
catch (Exception ex)
{
MessageBox.Show(ex.Message, ex.GetType().ToString());
}
}
else
{
Packages newPackage = new Packages();
newPackage.PackageId = package.PackageId;
this.PutPackageData(newPackage);
try
{
if (!PackagesDB.UpdatePackage(package, newPackage))
{
MessageBox.Show("Another user has updated or " +
"deleted that package.", "Database Error");
this.DialogResult = DialogResult.Retry;
}
else
{
package = newPackage;
this.DialogResult = DialogResult.OK;
}
}
catch (Exception ex)
{
MessageBox.Show(ex.Message, ex.GetType().ToString());
}
}
}