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; }