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 gvsales_CellContentClick(object sender, DataGridViewCellEventArgs e)
{
try
{
if (gvsales.Rows[e.RowIndex].Cells[4].Selected == true)
{
string namee = gvsales.Rows[e.RowIndex].Cells[0].Value.ToString();
SAdapter.SALES_DELETE_by_name(namee);
// STADapter.DeleteById(Convert.ToInt32(m));
// BindGrid();
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();
}
}
catch (Exception)
{ }
}
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();
}
