private void txtq_Leave(object sender, EventArgs e) { if (txtq.Text != "") { StockDT = StockAdapter.SelectBY_INAME(label8.Text); IDT = IAdapter.SelectByINmae(label8.Text); if (StockDT.Rows.Count > 0) { if (StockDT.Rows[0]["AvailableQuantity"].ToString() == "0") { MessageBox.Show("No Enought Quantity !!", "Medical System"); } else { SDT = SAdapter.SelectBY_NAME(label8.Text); if (SDT.Rows.Count > 0) { SDT = SAdapter.SelectBY_NAME(label8.Text); int exiqnt = Convert.ToInt32(SDT.Rows[0]["Quantity"].ToString()); int qntt = exiqnt + Convert.ToInt32(txtq.Text); if (Convert.ToInt32(StockDT.Rows[0]["AvailableQuantity"].ToString()) > qntt) { // int QNT = Convert.ToInt32(SDT.Rows[0]["Quantity"].ToString()) + 1; double TPRICE = Convert.ToInt32(SDT.Rows[0]["Price"].ToString()) * qntt; int existsalseupdate = SAdapter.Update(label8.Text, qntt.ToString(), TPRICE); SDT = SAdapter.SelectBy_PNAME(txtpname.Text); gpdispatch.Visible = true; gvsales.AutoGenerateColumns = false; gvsales.DataSource = SDT; SUMDT = SUMAdapter.SelectTotla(); lblqnt.Text = SUMDT.Rows[0]["qnt"].ToString(); lbltprice.Text = SUMDT.Rows[0]["Tprice"].ToString(); } else { MessageBox.Show("No Enought Quantity", "Medical system"); } } } } } }
private void txtiname_Leave(object sender, EventArgs e) { if (txtiname.Text != "") { label8.Text = txtiname.Text; StockDT = StockAdapter.SelectBY_INAME(txtiname.Text); IDT = IAdapter.SelectByINmae(txtiname.Text); if (StockDT.Rows.Count > 0) { if (StockDT.Rows[0]["AvailableQuantity"].ToString() == "0") { MessageBox.Show("No Enought Quantity !!", "Medical System"); } else { SDT = SAdapter.SelectBY_NAME(txtiname.Text); if (SDT.Rows.Count > 0) { SDT = SAdapter.SelectBY_NAME(txtiname.Text); int exiqnt = Convert.ToInt32(SDT.Rows[0]["Quantity"].ToString()); if (Convert.ToInt32(StockDT.Rows[0]["AvailableQuantity"].ToString()) > exiqnt) { int QNT = Convert.ToInt32(SDT.Rows[0]["Quantity"].ToString()) + 1; double TPRICE = Convert.ToInt32(SDT.Rows[0]["Price"].ToString()) * QNT; int existsalseupdate = SAdapter.Update(txtiname.Text, QNT.ToString(), TPRICE); } else { MessageBox.Show("No Enought Quantity", "Medical system"); } } else { lblq.Text = StockDT.Rows[0]["AvailableQuantity"].ToString(); lblp.Text = IDT.Rows[0]["I_Price"].ToString(); lbll.Text = IDT.Rows[0]["I_location"].ToString(); txtq.Text = "1"; double tprice = Convert.ToDouble(IDT.Rows[0]["I_Price"].ToString()); int salinst = SAdapter.Insert(txtpname.Text, txtiname.Text, tprice, 1, tprice); } SDT = SAdapter.SelectBy_PNAME(txtpname.Text); gpdispatch.Visible = true; gvsales.AutoGenerateColumns = false; gvsales.DataSource = SDT; SUMDT = SUMAdapter.SelectTotla(); lblqnt.Text = SUMDT.Rows[0]["qnt"].ToString(); lbltprice.Text = SUMDT.Rows[0]["Tprice"].ToString(); } gpdispatch.Visible = true; } else { MessageBox.Show("Item Not Available !!", "Medical System"); } } // txtiname.Text = ""; // txtiname.Focus(); }