private void addItemsToolStripMenuItem_Click(object sender, EventArgs e) { panelMain.Controls.Clear(); Add_Items Itadd = new Add_Items(); Itadd.TopLevel = false; Itadd.Visible = true; panelMain.Controls.Add(Itadd); Add_Items.tx_brcde.Focus(); }
private void btnAddItemAddItem_Click(object sender, EventArgs e) { //____________________________________________________________________________________________________________ //____________________________________________________________________________________________________________ ep_iname.SetError(txtAddItemItemName, ""); ep_isalePrz.SetError(txtAddItemSalesPrice, ""); ep_ipuchsPriz.SetError(lbl_p_piz, ""); ep_isupp.SetError(cbxAddItemSupplier, ""); ep_ictogry.SetError(cbxAddItemCatogory, ""); ep_isubCotory.SetError(cbxAddItemSubCatogory, ""); ep_ibrnd.SetError(cbxAddItemBrande, ""); string warrty; if (cb_warnty.Checked == true) { string wtyNo = cbx_wrty_number.Text; string wtydu = cbx_wrty_duretion.Text; warrty = wtyNo + " " + wtydu; } else { warrty = "No Warranty"; } try { if (txtAddItemBarcode.Text != "" || txtAddItemSerial.Text != "") { if (txtAddItemItemName.Text != "" && txtAddItemSalesPrice.Text != "" && lbl_p_piz.Text != "" && cbxAddItemCatogory.Text != "" && cbxAddItemSubCatogory.Text != "" && cbxAddItemBrande.Text != "" && cbxAddItemSupplier.Text != "") { if (txtAddItemTaxRate.Text == "") { txtAddItemTaxRate.Text = "0.00"; } if (txtAddItemSerial.Text == "") { txtAddItemSerial.Text = txtAddItemBarcode.Text; } //___________________________________________________________________________________________________ SqlDataReader srldr = itemdb.select_seril_alrdy(txtAddItemSerial.Text); if (!srldr.Read()) { //___________________________________________________________________________________________________ if (cb_warnty.Checked == true) { if (cbx_wrty_number.Text != "" && cbx_wrty_duretion.Text != "") { itemdb.insert(lbl_itemNo.Text, txtAddItemSerial.Text, txtAddItemItemName.Text, Convert.ToDecimal(txtAddItemSalesPrice.Text), Convert.ToDecimal(lbl_p_piz.Text), Convert.ToDecimal(txtAddItemTaxRate.Text), txtAddItemBarcode.Text, cbxAddItemCatogory.Text, cbxAddItemSubCatogory.Text, cbxAddItemBrande.Text, cbxAddItemItemType.Text, cbxAddItemSupplier.Text, warrty, txtAddItemDiscription.Text); // MessageBox.Show("Item Added"); if (cbx_stok.Text == "") { SqlDataReader dr = itemdb.select_to_Qntity(cbxAddItemCatogory.SelectedItem.ToString(), cbxAddItemSubCatogory.SelectedItem.ToString(), cbxAddItemBrande.SelectedItem.ToString()); if (dr.Read()) { string qt = dr["Quntity"].ToString(); int q1 = int.Parse(qt); int q2 = q1 + 1; string qty = q2.ToString(); itemdb.update_Quntity(qty, cbxAddItemCatogory.Text, cbxAddItemSubCatogory.Text, cbxAddItemBrande.Text); // MessageBox.Show("Quntity Updated"); } else { itemdb.Quntity(txtAddItemItemName.Text, cbxAddItemCatogory.Text, cbxAddItemSubCatogory.Text, cbxAddItemBrande.Text, "1", lbl_p_piz.Text, txtAddItemSalesPrice.Text); // MessageBox.Show("quntity Added"); } } //++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++ SqlDataReader stcdr = odr.R_stock_selec(cbx_stok.Text, cbxAddItemSupplier.Text); if (stcdr.Read()) { qqty = ""; q_count = ""; qqty = stcdr["Quntity"].ToString(); q_count = stcdr["Add_Count"].ToString(); if (q_count != "") { if (Convert.ToDouble(qqty) > Convert.ToDouble(q_count)) { q_count = (Convert.ToDouble(q_count) + 1).ToString(); } } else { q_count = "1"; } odr.Update_R_stok_qty(cbx_stok.Text, cbxAddItemSupplier.Text, q_count); //MessageBox.Show("addddddd"); } //+++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++ if (MessageBox.Show("New Ttem Added Successfuly.", "New Item", MessageBoxButtons.OK, MessageBoxIcon.Information) == DialogResult.OK) { SqlDataReader stcdr1 = odr.R_stock_selec(cbx_stok.Text, cbxAddItemSupplier.Text); if (stcdr1.Read()) { lbl_a_qty.Text = stcdr1["Quntity"].ToString(); lbl_add_qty.Text = stcdr1["Add_Count"].ToString(); } //____________________________________________________________________________________ if (lbl_a_qty.Text == lbl_add_qty.Text) { Main.p1.Controls.Clear(); Add_Items d1 = new Add_Items(); d1.TopLevel = false; d1.Visible = true; Main.p1.Controls.Add(d1); } else { //==================================================From Item Table==========================================================// string rNo = itemdb.Itemno(); if (rNo.Equals("") || rNo == null) { iNo = 001000; } else { iNo = Convert.ToInt32(rNo); iNo = iNo + 1; //MessageBox.Show(iNo.ToString()); } //==============================================================================================================================// string rcNo = itemdb.getCusno(); if (rcNo.Equals("") || rcNo == null) { cNo = 001000; } else { cNo = Convert.ToInt32(rcNo); cNo = cNo + 1; //MessageBox.Show(cNo.ToString()); } int[] numbers = new[] { iNo, cNo }; int max = numbers.Max(); lbl_itemNo.Text = Convert.ToString(max); txtAddItemBarcode.Clear(); txtAddItemSerial.Clear(); txtAddItemBarcode.Focus(); } //_____________________________________________________________________________________ } } else { ep_wanty.SetError(cbx_wrty_duretion, "Complete warranty"); } } else { if (txtAddItemTaxRate.Text == "") { txtAddItemTaxRate.Text = "0.00"; } if (txtAddItemSerial.Text == "") { txtAddItemSerial.Text = txtAddItemBarcode.Text; } itemdb.insert(lbl_itemNo.Text, txtAddItemSerial.Text, txtAddItemItemName.Text, Convert.ToDecimal(txtAddItemSalesPrice.Text), Convert.ToDecimal(lbl_p_piz.Text), Convert.ToDecimal(txtAddItemTaxRate.Text), txtAddItemBarcode.Text, cbxAddItemCatogory.Text, cbxAddItemSubCatogory.Text, cbxAddItemBrande.Text, cbxAddItemItemType.Text, cbxAddItemSupplier.Text, warrty, txtAddItemDiscription.Text); // MessageBox.Show("Item Added"); if (cbx_stok.Text == "") { SqlDataReader dr = itemdb.select_to_Qntity(cbxAddItemCatogory.SelectedItem.ToString(), cbxAddItemSubCatogory.SelectedItem.ToString(), cbxAddItemBrande.SelectedItem.ToString()); if (dr.Read()) { string qt = dr["Quntity"].ToString(); int q1 = int.Parse(qt); int q2 = q1 + 1; string qty = q2.ToString(); itemdb.update_Quntity(qty, cbxAddItemCatogory.Text, cbxAddItemSubCatogory.Text, cbxAddItemBrande.Text); // MessageBox.Show("Quntity Updated"); } else { itemdb.Quntity(txtAddItemItemName.Text, cbxAddItemCatogory.Text, cbxAddItemSubCatogory.Text, cbxAddItemBrande.Text, "1", lbl_p_piz.Text, txtAddItemSalesPrice.Text); // MessageBox.Show("quntity Added"); } } //++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++ SqlDataReader stcdr = odr.R_stock_selec(cbx_stok.Text, cbxAddItemSupplier.Text); if (stcdr.Read()) { qqty = ""; q_count = ""; qqty = stcdr["Quntity"].ToString(); q_count = stcdr["Add_Count"].ToString(); if (q_count != "") { if (Convert.ToDouble(qqty) > Convert.ToDouble(q_count)) { q_count = (Convert.ToDouble(q_count) + 1).ToString(); } } else { q_count = "1"; } odr.Update_R_stok_qty(cbx_stok.Text, cbxAddItemSupplier.Text, q_count); //MessageBox.Show("addddddd"); } //+++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++ if (MessageBox.Show("New Ttem Added Successfuly.", "New Item", MessageBoxButtons.OK, MessageBoxIcon.Information) == DialogResult.OK) { SqlDataReader stcdr1 = odr.R_stock_selec(cbx_stok.Text, cbxAddItemSupplier.Text); if (stcdr1.Read()) { lbl_a_qty.Text = stcdr1["Quntity"].ToString(); lbl_add_qty.Text = stcdr1["Add_Count"].ToString(); } //____________________________________________________________________________________ if (lbl_a_qty.Text == lbl_add_qty.Text) { Main.p1.Controls.Clear(); Add_Items d1 = new Add_Items(); d1.TopLevel = false; d1.Visible = true; Main.p1.Controls.Add(d1); } else { //==================================================From Item Table==========================================================// string rNo = itemdb.Itemno(); if (rNo.Equals("") || rNo == null) { iNo = 001000; } else { iNo = Convert.ToInt32(rNo); iNo = iNo + 1; //MessageBox.Show(iNo.ToString()); } //==============================================================================================================================// string rcNo = itemdb.getCusno(); if (rcNo.Equals("") || rcNo == null) { cNo = 001000; } else { cNo = Convert.ToInt32(rcNo); cNo = cNo + 1; //MessageBox.Show(cNo.ToString()); } int[] numbers = new[] { iNo, cNo }; int max = numbers.Max(); lbl_itemNo.Text = Convert.ToString(max); txtAddItemBarcode.Clear(); txtAddItemSerial.Clear(); txtAddItemBarcode.Focus(); } //_____________________________________________________________________________________ ////-----------------clear all textbox.text----------------------- //Action<Control.ControlCollection> func = null; //func = (controls) => //{ // foreach (Control control in controls) // if (control is TextBox) // (control as TextBox).Clear(); // else // func(control.Controls); //}; //func(Controls); //Main.p1.Controls.Clear(); //Add_Items d1 = new Add_Items(); //d1.TopLevel = false; //d1.Visible = true; //Main.p1.Controls.Add(d1); } } } else { toolTip_check.Show("Serial number alrady in Stok", lbl_tp, 1500); } } else { if (txtAddItemItemName.Text == "") { ep_iname.SetError(txtAddItemItemName, "Enter Item name"); } if (txtAddItemSalesPrice.Text == "") { ep_isalePrz.SetError(txtAddItemSalesPrice, "Enter Item Sales Price"); } if (lbl_p_piz.Text == "") { ep_ipuchsPriz.SetError(lbl_p_piz, "Enter Item Purchas Price"); } if (cbxAddItemSupplier.Text == "") { ep_isupp.SetError(cbxAddItemSupplier, "Choose Supplier name"); } if (cbxAddItemCatogory.Text == "") { ep_ictogry.SetError(cbxAddItemCatogory, "Choose Item Catogary"); } if (cbxAddItemSubCatogory.Text == "") { ep_isubCotory.SetError(cbxAddItemSubCatogory, "Choose Item sub Catogary"); } if (cbxAddItemBrande.Text == "") { ep_ibrnd.SetError(cbxAddItemBrande, "Choose Item Brande"); } tp_required.Show("Fill Require fileds", btnAddItemAddItem, 5000); } } else { tp_seril_barcobe.Show("Must Enter Serial or Barcode For Iditify Items", lbl_tp, 4000); } } catch (Exception ex) { MessageBox.Show(ex.Message); } }