private void btnitemsearch_Click(object sender, EventArgs e)
{
txtcname.Text = "";
//SDT = SAdapter.SelectBY_INAME(txtiname.Text);
IDT = IAdapter.SelectByINmae(txtiname.Text);
GVReports.DataSource = IDT;
}
private void ADDItem_Load(object sender, EventArgs e)
{
if (strmenu == "Add")
{
tabControl1.SelectedIndex = 0;
}
else if (strmenu == "Update")
{
tabControl1.SelectedIndex = 1;
}
else if (strmenu == "Delete")
{
tabControl1.SelectedIndex = 2;
}
else if (strmenu == "View")
{
tabControl1.SelectedIndex = 3;
}
CDT = CAdapter.SelectComapny();
cmbdompany.DataSource = CDT;
cmbdompany.DisplayMember = "Cname";
cmbdompany.ValueMember = "Cid";
cmbdompany.Text = "SELECT";
IDT = IAdapter.SelectItem();
comboBox1.DataSource = IDT;
comboBox1.DisplayMember = "I_name";
comboBox1.ValueMember = "I_ID";
comboBox1.Text = "SELECT";
}
private void tabControl1_SelectedIndexChanged(object sender, EventArgs e)
{
if (tabControl1.SelectedIndex == 0)
{
CDT = CAdapter.SelectComapny();
cmbdompany.DataSource = CDT;
cmbdompany.DisplayMember = "Cname";
cmbdompany.ValueMember = "Cid";
cmbdompany.Text = "SELECT";
}
else if (tabControl1.SelectedIndex == 1)
{
// IDT = IAdapter.SelectItem();
SDT = SAdapter.SelectStock();
comboBox1.DataSource = SDT;
comboBox1.DisplayMember = "Iname";
comboBox1.ValueMember = "s_ID";
comboBox1.Text = "SELECT";
}
else if (tabControl1.SelectedIndex == 2)
{
// IDT = IAdapter.SelectItem();
SDT = SAdapter.SelectStock();
comboBox2.DataSource = SDT;
comboBox2.DisplayMember = "Iname";
comboBox2.ValueMember = "s_ID";
comboBox2.Text = "SELECT";
}
else if (tabControl1.SelectedIndex == 3)
{
IDT = IAdapter.SelectItem();
dataGridView1.DataSource = IDT;
}
}
private void ADDItem_Load(object sender, EventArgs e)
{
CDT = CAdapter.SelectComapny();
cmbdompany.DataSource = CDT;
cmbdompany.DisplayMember = "Cname";
cmbdompany.ValueMember = "Cid";
IDT = IAdapter.SelectItem();
comboBox1.DataSource = IDT;
comboBox1.DisplayMember = "I_name";
comboBox1.ValueMember = "I_ID";
}
private void button2_Click(object sender, EventArgs e)
{
if (MessageBox.Show("Are you sure !! You want to Update Stock !!", "Medical system", MessageBoxButtons.OKCancel) == DialogResult.OK)
{
IDT = IAdapter.SelectBYID(Convert.ToInt32(comboBox1.SelectedValue));
//IAdapter.StockInMst_Updateitem(Convert.ToInt32(comboBox1.SelectedValue), Convert.ToInt32(txtnewqnt.Text));
int inst = IAdapter.Insert(comboBox1.Text, IDT.Rows[0]["I_Descrip"].ToString(), Convert.ToInt32(txtnewqnt.Text), Convert.ToDouble(IDT.Rows[0]["I_Price"].ToString()), IDT.Rows[0]["c_name"].ToString(), Convert.ToDateTime(IDT.Rows[0]["I_Ex_date"].ToString()), IDT.Rows[0]["I_location"].ToString());
double tprice = Convert.ToDouble(txtnewqnt.Text) * Convert.ToDouble(IDT.Rows[0]["I_Price"].ToString());
SAdapter.StockMst_ADD_Update_Quantity(Convert.ToInt32(txtnewqnt.Text), tprice, comboBox1.Text);
MessageBox.Show("Quantity Updated Successfully !!", "MEdical System");
}
}
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 ADDItem_Load(object sender, EventArgs e)
{
// TODO: This line of code loads data into the 'mEDICALDataSet.StockInMst' table. You can move, or remove it, as needed.
this.stockInMstTableAdapter.Fill(this.mEDICALDataSet.StockInMst);
groupBox3.Visible = false;
//if (strmenu == "mENUToolStripMenuItem")
//{
// tabControl1.SelectedIndex = 0;
// tabControl1.SelectedIndex = 1;
// tabControl1.SelectedIndex = 2;
// tabControl1.SelectedIndex = 0;
//}
//else if (strmenu == "Update")
//{
//}
//else if (strmenu == "Delete")
//{
//}
//else if (strmenu == "View")
//{
//}
CDT = CAdapter.SelectComapny();
cmbdompany.DataSource = CDT;
cmbdompany.DisplayMember = "Cname";
cmbdompany.ValueMember = "Cid";
cmbdompany.Text = "SELECT";
IDT = IAdapter.SelectItem();
comboBox1.DataSource = IDT;
comboBox1.DisplayMember = "I_name";
comboBox1.ValueMember = "I_ID";
comboBox1.Text = "SELECT";
}
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();
}
private void button4_Click(object sender, EventArgs e)
{
IDT = IAdapter.SelectBYID(Convert.ToInt32(comboBox1.SelectedValue));
txtcurentqnt.Text = IDT.Rows[0]["I_Quantity"].ToString();
}
public void formUpload()
{
IDT = IAdapter.SelectItem();
dataGridView1.DataSource = IDT;
}
