private void refreshitems()
{
DataTable dtpkg = PackageDB.GetAllPkg();
int nindex = Convert.ToInt32(PackagesBindingNavigator.PositionItem.Text) - 1;
packageIdTextBox.Text = dtpkg.Rows[nindex]["PackageId"].ToString();
pkgNameTextBox.Text = dtpkg.Rows[nindex]["PkgName"].ToString();
pkgStartDateDateTimePicker.Value = Convert.ToDateTime(dtpkg.Rows[nindex]["PkgStartDate"]);
pkgEndDateDateTimePicker.Value = Convert.ToDateTime(dtpkg.Rows[nindex]["PkgEndDate"]);
pkgDescTextBox.Text = dtpkg.Rows[nindex]["PkgDesc"].ToString();
pkgBasePriceTextBox.Text = dtpkg.Rows[nindex]["PkgBasePrice"].ToString();
pkgAgencyCommissionTextBox.Text = dtpkg.Rows[nindex]["PkgAgencyCommission"].ToString();
if (packageIdTextBox.Text != "")
{
Package pkg = new Package();
pkg.nPkgId = Convert.ToInt32(packageIdTextBox.Text);
dgvPkgProd.Columns.Clear();
dgvPkgProd.DataSource = Pkg_Product_SuppliersDB.GetAllPkgProdSupData(pkg.nPkgId);
//dgvPkgSup.DataSource = Pkg_Product_SuppliersDB.GetAllPkgSupData(pkg.nPkgId);
}
}
private void ToolStripBtnSave_Click(object sender, EventArgs e)
{
if (Validation())
{
int pkgId = 0;
Package pkg = new Package();
pkg.PkgName = pkgNameTextBox.Text;
pkg.pkgStDate = pkgStartDateDateTimePicker.Value;
pkg.pkgEndDate = pkgEndDateDateTimePicker.Value;
pkg.pkgDesc = pkgDescTextBox.Text;
pkg.pkgBasePrice = Convert.ToDouble(pkgBasePriceTextBox.Text);
pkg.pkgAgentCom = Convert.ToDouble(pkgAgencyCommissionTextBox.Text);
if (packageIdTextBox.Text == "-1")
{
pkgId = PackageDB.AddPackage(pkg);
if (pkgId != 0)
{
if (dgvPkgProd.Rows.Count > 0)
{
for (int i = 0; i < dgvPkgProd.Rows.Count; i++)
{
Prod_Suppliers prodsup = new Prod_Suppliers();
Products prod = ProductDB.GetProductsbyName(dgvPkgProd.Rows[i].Cells[0].Value.ToString());
prodsup.nProdId = prod.nProdId; //cbProducts.SelectedValue);
Suppliers sup = SupplierDB.GetSuppliersbyName(dgvPkgProd.Rows[i].Cells[1].Value.ToString());
prodsup.nSupId = sup.nSupId; // Convert.ToInt32(cbSups.SelectedValue);
DataTable dt = Prod_SuppliersDB.GetProd_SupbyPsId(prodsup.nProdId, prodsup.nSupId);
int prodsupid = Convert.ToInt32(dt.Rows[0]["ProductSupplierId"]);
//int prodsupid = Prod_SuppliersDB.AddRecord(prodsup);
Pkg_Product_Suppliers pps = new Pkg_Product_Suppliers();
pps.prodSupId = prodsupid;
pps.pkgId = pkgId;
Pkg_Product_SuppliersDB.AddPPSData(pps);
}
}
}
}
else
{
//update package
pkgId = Convert.ToInt32(packageIdTextBox.Text);
if (pkgId != 0)
{
Package oldpkg = new Package();
oldpkg.nPkgId = pkgId;
PackageDB.UpdatePkg(oldpkg, pkg);
DataTable dtprodsup = Pkg_Product_SuppliersDB.GetAllPkgProdSupData(pkgId);
if (dgvPkgProd.Rows.Count > 0)
{
for (int i = 0; i < dgvPkgProd.Rows.Count; i++)
{
string strprodname = dgvPkgProd.Rows[i].Cells[0].Value.ToString();
string strsupName = dgvPkgProd.Rows[i].Cells[1].Value.ToString();
for (int j = 0; j < dtprodsup.Rows.Count; j++)
{
if (strprodname != dtprodsup.Rows[j]["ProdName"].ToString() && strsupName != dtprodsup.Rows[j]["SupName"].ToString())
{
Prod_Suppliers prodsup = new Prod_Suppliers();
Products prod = ProductDB.GetProductsbyName(dgvPkgProd.Rows[i].Cells[0].Value.ToString());
prodsup.nProdId = prod.nProdId; //cbProducts.SelectedValue);
Suppliers sup = SupplierDB.GetSuppliersbyName(dgvPkgProd.Rows[i].Cells[1].Value.ToString());
prodsup.nSupId = sup.nSupId; // Convert.ToInt32(cbSups.SelectedValue);
DataTable dt = Prod_SuppliersDB.GetProd_SupbyPsId(prodsup.nProdId, prodsup.nSupId);
Prod_Suppliers newprodsup = new Prod_Suppliers();
newprodsup.nProdSupId = Convert.ToInt32(dt.Rows[0]["ProductSupplierId"]);
int prodsupid = newprodsup.nProdSupId;
Pkg_Product_Suppliers oldpps = new Pkg_Product_Suppliers();
Pkg_Product_Suppliers pps = new Pkg_Product_Suppliers();
pps.prodSupId = prodsupid;
oldpps.pkgId = pkgId;
Pkg_Product_SuppliersDB.UpdatePkgData(oldpps, pps);
}
}
}
}
}
}
BindingSource pkgbindsource = new BindingSource();
pkgbindsource.DataSource = PackageDB.GetAllPkg();
PackagesBindingNavigator.BindingSource = pkgbindsource;
refreshitems();
}
}
