示例#1
0
        // Deleting Packages from Package
        private void pkgdelete_Click(object sender, EventArgs e)
        {
            Packages pkgDel = new Packages();
            Packages_Products_Suppliers pkgPrdDel = new Packages_Products_Suppliers();
            List <Packages>             pack      = PackagesDB.GetPackages();

            if (
                Validation.IsListSelected(lstPkg, "Available Packages", lblError)
                )

            {
                // delete confirmaiton message box with ok or cancel
                if (MessageBox.Show("Delete Package?", "Delete Confirmation", MessageBoxButtons.OKCancel) == DialogResult.OK)
                {
                    lblError.Text = "";
                    foreach (var item in pack)
                    {
                        if (item.PackageId == Convert.ToInt32(txtpkgID.Text)) // txt box is one number ahead of newly added items
                        {
                            pkgDel.PackageId           = item.PackageId;
                            pkgDel.PkgName             = item.PkgName;
                            pkgDel.PkgStartDate        = item.PkgStartDate;
                            pkgDel.PkgEndDate          = item.PkgEndDate;
                            pkgDel.PkgDesc             = item.PkgDesc;
                            pkgDel.PkgBasePrice        = item.PkgBasePrice;
                            pkgDel.PkgAgencyCommission = item.PkgAgencyCommission;
                        }
                    }


                    var productSupplierid = from item in Products_SuppliersDB.GetProductsSuppliers()
                                            where item.PackageId == Convert.ToInt32(txtpkgID.Text)
                                            select new { item.ProductSupplierId };


                    Packages_Products_Suppliers pkgDelPro = new Packages_Products_Suppliers();

                    var id = productSupplierid.ToList();

                    foreach (var item in id)
                    {
                        pkgDelPro.ProductSupplierId = item.ProductSupplierId;
                    }
                    pkgDelPro.PackageId = Convert.ToInt32(txtpkgID.Text);

                    Packages_Products_SuppliersDB.DeletePackagePro(pkgDelPro);

                    PackagesDB.DeletePackage(pkgDel);
                    lstPkg.Items.Clear();

                    List <Packages> packupdatedel = PackagesDB.GetPackages();
                    foreach (var pkg in packupdatedel)
                    {
                        lstPkg.Items.Add(pkg.PkgName);
                    }

                    ResetPackage();
                }
            }
        }
示例#2
0
        public void ResetProductSupllierList()
        {
            lstPkg.Items.Clear();
            List <Packages> packupdated = PackagesDB.GetPackages();

            foreach (var pkg in packupdated)
            {
                lstPkg.Items.Add(pkg.PkgName);
            }

            lstPkg.SelectedIndex = 0;

            productSupplierList = Products_SuppliersDB.GetProductsSuppliers();
            var distinctPrd = productSupplierList.Select(o => o.ProdName).Distinct().ToList();

            comboPrdPack.DataSource  = distinctPrd;
            comboProduct.DataSource  = product;
            comboSupplier.DataSource = supplier;

            listSuppPkg.Items.Clear();
            foreach (var supname in productSupplierList)
            {
                if (supname.ProdName == comboPrdPack.SelectedItem.ToString())
                {
                    listSuppPkg.Items.Add(supname.SupName);
                }
            }
        }
示例#3
0
        //Package List load method
        public void PackageListLoad()
        {
            var pack = PackagesDB.GetPackages();

            foreach (var item in pack)
            {
                if (item.PkgName == lstPkg.SelectedItem.ToString())
                {
                    var pkgId = item.PackageId;
                    txtPkgName.Text    = item.PkgName;
                    txtpkgID.Text      = item.PackageId.ToString();
                    txtDesc.Text       = item.PkgDesc;
                    txtBasePrice.Text  = item.PkgBasePrice.ToString("c");
                    txtCommission.Text = item.PkgAgencyCommission.ToString("c");

                    if (item.PkgStartDate.HasValue)
                    {
                        dtpPkgStrt.Text = item.PkgStartDate.Value.ToShortDateString();
                    }
                    else
                    {
                        dtpPkgStrt.Format = DateTimePickerFormat.Short;
                    }


                    if (item.PkgEndDate.HasValue)
                    {
                        dtpPkgEndDate.Text = item.PkgEndDate.Value.ToShortDateString();
                    }
                    else
                    {
                        dtpPkgEndDate.Format = DateTimePickerFormat.Short;
                    }
                }
            }
        }
示例#4
0
        // Save Edit Packages
        private void saveEdit_Click(object sender, EventArgs e)
        {
            if
            (
                Validation.IsPresent(txtPkgName, "Package Name", lblError) &&


                Validation.IsPresent(txtBasePrice, "Base Price", lblError) &&
                Validation.NotNegativeDeciaml(txtBasePrice, "Base Price", lblError) &&

                Validation.IsPresent(txtCommission, "Commission", lblError) &&
                Validation.NotNegativeDeciaml(txtCommission, "Commission", lblError) &&

                Validation.IsPresent(txtDesc, "Description", lblError)
            )

            {
                var      pack   = PackagesDB.GetPackages();
                Packages oldPck = new Packages();



                foreach (var item in pack)
                {
                    if (item.PackageId == Convert.ToInt32(txtpkgID.Text))
                    {
                        oldPck.PackageId           = item.PackageId;
                        oldPck.PkgName             = item.PkgName;
                        oldPck.PkgStartDate        = item.PkgStartDate;
                        oldPck.PkgEndDate          = item.PkgEndDate;
                        oldPck.PkgDesc             = item.PkgDesc;
                        oldPck.PkgBasePrice        = item.PkgBasePrice;
                        oldPck.PkgAgencyCommission = item.PkgAgencyCommission;
                    }
                }
                DateTime?StartDate = string.IsNullOrWhiteSpace(dtpPkgStrt.Text)
                        ? (DateTime?)null
                        : DateTime.Parse(dtpPkgStrt.Text);

                DateTime?EndDate = string.IsNullOrWhiteSpace(dtpPkgEndDate.Text)
                  ? (DateTime?)null
                  : DateTime.Parse(dtpPkgEndDate.Text);

                var duration = (EndDate.Value - StartDate.Value).TotalDays;

                if (duration < 0 | duration == 0)
                {
                    lblError.Text = "Package End Date must be greater than Package Start Date";
                    return;
                }

                if (Convert.ToDecimal(txtCommission.Text.Replace("$", "")) >= Convert.ToDecimal(txtBasePrice.Text.Replace("$", "")))
                {
                    lblError.Text = "Commission Should be less than Package Price";
                    return;
                }


                Packages updtPck = new Packages();
                updtPck.PackageId    = Convert.ToInt32(txtpkgID.Text);
                updtPck.PkgName      = txtPkgName.Text;
                updtPck.PkgStartDate = StartDate;
                updtPck.PkgEndDate   = EndDate;
                updtPck.PkgDesc      = txtDesc.Text;

                updtPck.PkgBasePrice        = Convert.ToDecimal(txtBasePrice.Text.Replace("$", ""));
                updtPck.PkgAgencyCommission = Convert.ToDecimal(txtCommission.Text.Replace("$", ""));

                PackagesDB.UpdatePackage(oldPck, updtPck);

                lstPkg.Items.Clear();
                List <Packages> packupdated = PackagesDB.GetPackages();

                foreach (var pkg in packupdated)
                {
                    lstPkg.Items.Add(pkg.PkgName);
                }

                lstPkg.SelectedIndex = 0;

                ResetPackage();
            }
        }
示例#5
0
        // saving Added Packges
        private void pkgSave_Click(object sender, EventArgs e)
        {
            if
            (
                Validation.IsPresent(txtPkgName, "Package Name", lblError) &&

                Validation.IsPresent(txtBasePrice, "Base Price", lblError) &&
                Validation.NotNegativeDeciaml(txtBasePrice, "Base Price", lblError) &&

                Validation.IsPresent(txtCommission, "Commission", lblError) &&
                Validation.NotNegativeDeciaml(txtCommission, "Commission", lblError) &&

                Validation.IsPresent(txtDesc, "Description", lblError)
            )

            {
                lblError.Text = "";

                DateTime?StartDate = string.IsNullOrWhiteSpace(dtpPkgStrt.Text)
                          ? (DateTime?)null
                          : DateTime.Parse(dtpPkgStrt.Text);

                DateTime?EndDate = string.IsNullOrWhiteSpace(dtpPkgEndDate.Text)
                  ? (DateTime?)null
                  : DateTime.Parse(dtpPkgEndDate.Text);

                var duration = (EndDate.Value - StartDate.Value).TotalDays;

                if (duration < 0 | duration == 0)
                {
                    lblError.Text = "Package End Date must be greater than Package Start Date";
                    return;
                }


                if (Convert.ToDecimal(txtCommission.Text.Replace("$", "")) >= Convert.ToDecimal(txtBasePrice.Text.Replace("$", "")))
                {
                    lblError.Text = "Commission Should be less than Package Price";
                    return;
                }

                Packages pckAdd = new Packages();
                pckAdd.PkgName             = txtPkgName.Text;
                pckAdd.PkgStartDate        = StartDate;
                pckAdd.PkgEndDate          = EndDate;
                pckAdd.PkgDesc             = txtDesc.Text;
                pckAdd.PkgBasePrice        = Convert.ToDecimal(txtBasePrice.Text.Replace("$", ""));
                pckAdd.PkgAgencyCommission = Convert.ToDecimal(txtCommission.Text.Replace("$", ""));


                PackagesDB.AddPackage(pckAdd);

                lstPkg.Items.Clear();

                List <Packages> packlstAdd = PackagesDB.GetPackages();


                foreach (var pkg in packlstAdd)
                {
                    lstPkg.Items.Add(pkg.PkgName);
                }

                lstPkg.SelectedIndex = 0;
                lstPkg.Enabled       = true;

                lstPkg.Items.Clear();
                List <Packages> packupdated = PackagesDB.GetPackages();

                foreach (var pkg in packupdated)
                {
                    lstPkg.Items.Add(pkg.PkgName);
                }

                lstPkg.SelectedIndex = 0;

                ResetPackage();

                //disable the Date Time Pickers
                dtpPkgStrt.Enabled    = false;
                dtpPkgEndDate.Enabled = false;
            }
        }