private void shpUpdate_Click(object sender, EventArgs e)
        {
            if (this.shpIdTxt.Text == "" || this.shpProTxt.Text == "" || this.comboBox2.Text == "")
            {
                MessageBox.Show("Insert the data");
            }
            else
            {
                ShipmentR i = new ShipmentR();

                i.ShipmentId       = Convert.ToInt32(this.shpIdTxt.Text);
                i.ShipmentProgress = Convert.ToInt32(this.shpProTxt.Text);
                i.Status           = this.comboBox2.GetItemText(this.comboBox2.SelectedItem);

                ShipmentRepository sr = new ShipmentRepository();
                if (sr.Update(i))
                {
                    List <ShipmentR> iList = sr.GetAllShipment();
                    this.dataGrid3.DataSource = iList;

                    this.shpIdTxt.Text  = "";
                    this.shpProTxt.Text = "";
                    this.comboBox2.Text = "";
                }
                else
                {
                    MessageBox.Show("Can Not Update Shipment", "Update Error");
                }
            }
        }
        private void ShipOrderbtn_Click(object sender, EventArgs e)
        {
            ShipmentR i = new ShipmentR();

            i.OrderId          = this.orderIdTxt.Text;
            i.ShipmentProgress = 0;
            i.Status           = "";
            ShipmentRepository shipRepo = new ShipmentRepository();

            //insert into shipment table if the product is sufficient in inventory
            if (Convert.ToInt32(this.quantityTxt.Text) <= Convert.ToInt32(this.textBox7.Text))
            {
                if (shipRepo.Insert(i))
                {
                    //---------------update the volume in inventory after successful shipment-----------------//

                    int latestVolume       = Convert.ToInt32(this.textBox7.Text) - Convert.ToInt32(this.quantityTxt.Text);
                    InventoryRepository ir = new InventoryRepository();
                    if (ir.updateInventory(this.productIdTxt.Text, latestVolume))
                    {
                        MessageBox.Show("One Row Updated in Inventory");
                    }
                    else
                    {
                        MessageBox.Show("Can't update inventory", "Update Error");
                    }

                    //---------------Update and hide From Order Tabel after Shipment-----------------//
                    OrderRepository or = new OrderRepository();

                    if (or.updateStatus(this.orderIdTxt.Text))
                    {
                        MessageBox.Show("Order Updated");
                    }
                    else
                    {
                        MessageBox.Show("unSuccessfull order update", "Update Error");
                    }

                    MessageBox.Show("Succsfull ", "Shipment");

                    //---------------refresh the order Grid-----------------//

                    List <OrderR> order = new List <OrderR>();
                    order = or.GetAllOrder();
                    this.dataGrid2.DataSource = order;

                    this.orderIdTxt.Text      = "";
                    this.productIdTxt.Text    = "";
                    this.productNameTxt.Text  = "";
                    this.quantityTxt.Text     = "";
                    this.addressTxt.Text      = "";
                    this.employeeNameTxt.Text = "";
                }
                else
                {
                    MessageBox.Show("Can Not Ship Order", "Ship Error");
                }
            }
            else
            {
                MessageBox.Show("Unsufficient amount of Product", "Available Error");
            }
        }