Example #1
0
        private void btnAdd_Click(object sender, EventArgs e)
        {
            orderGenerateId();
            Purchase_Order purchaseorder = new Purchase_Order(this, CommonConstant.DB_INSERT);

            purchaseorder.txtOrderNo.Text = orderID;
            purchaseorder.Show();
        }
Example #2
0
        private void orderviewDataGridView_CellDoubleClick(object sender, DataGridViewCellEventArgs e)
        {
            int i;

            i = orderviewDataGridView.CurrentRow.Index;
            if (orderviewDataGridView.Rows[i].Cells[3].Value.ToString() == "Progress")
            {
                Purchase_Order purchaseorder = new Purchase_Order(this, CommonConstant.DB_UPDATE);
                String         Orderid       = orderviewDataGridView.Rows[i].Cells[0].Value.ToString();
                purchaseorder.cbPublisher.Text = orderviewDataGridView.Rows[i].Cells[2].Value.ToString();
                String strODT = "SELECT OD.BOOK_ID,B.BK_TITLE,B.BK_PURCHASE_PRICE,OD.QUANTITY FROM ORDER_DETAIL OD INNER JOIN BOOK B ON OD.BOOK_ID =B.BOOK_ID WHERE ORDER_ID = '" + Orderid + "'";
                connection();
                SqlDataAdapter ODTad = new SqlDataAdapter(strODT, consql);
                DataSet        ODTds = new DataSet();
                ODTad.Fill(ODTds, "OrderDT");
                DataTable ODTtable;
                ODTtable = ODTds.Tables["OrderDT"];
                int totamt = 0;
                for (int j = 0; j < ODTtable.Rows.Count; j++)
                {
                    ListViewItem odtlistviewitem = new ListViewItem(ODTtable.Rows[j].ItemArray[0].ToString());
                    for (int k = 1; k < ODTtable.Columns.Count; k++)
                    {
                        odtlistviewitem.SubItems.Add(ODTtable.Rows[j].ItemArray[k].ToString());
                    }
                    int Amount = (int.Parse(ODTtable.Rows[j].ItemArray[2].ToString())) * (int.Parse(ODTtable.Rows[j].ItemArray[3].ToString()));
                    totamt += Amount;
                    odtlistviewitem.SubItems.Add(Amount.ToString());
                    purchaseorder.purorderList.Items.Add(odtlistviewitem);
                }
                purchaseorder.pubid = orderviewDataGridView.Rows[i].Cells[1].Value.ToString();
                purchaseorder.txtTotalAmount.Text = totamt.ToString();
                purchaseorder.bookname            = ODTtable.Rows[0].ItemArray[1].ToString();
                purchaseorder.txtQty.Text         = ODTtable.Rows[0].ItemArray[3].ToString();
                purchaseorder.txtOrderNo.Text     = orderviewDataGridView.Rows[i].Cells[0].Value.ToString();
                purchaseorder.Show();
            }
            else
            {
                MessageBox.Show("This Order is not on Progress.");
            }
        }