private void IncSupplier(int SuppID, Double amount) { try { Varibles.setConnection(); cmd = Varibles.getCommand(); String query = "UPDATE `merp`.`suppliers` SET `SPLR_BLNCE`= SPLR_BLNCE + " + amount + " WHERE `SPLR_ID`='" + SuppID + "'"; cmd.CommandText = query; cmd.ExecuteNonQuery(); } catch (Exception ex) { MessageBox.Show(ex.Message); }finally{ Varibles.closeConnection(); } }
private void fillPayables() { try { Varibles.setConnection(); cmd = Varibles.getCommand(); DateTime date1 = new DateTime(dtp_from.Value.Year, dtp_from.Value.Month, dtp_from.Value.Day, 0, 0, 0); DateTime date2 = new DateTime(dtp_to.Value.Year, dtp_to.Value.Month, dtp_to.Value.Day, 23, 59, 59); String query = "SELECT CLT_NAME , TE_BLNCE, TE_IN, TE_OUT, TE_CMMTS, TE_DATE FROM merp.treasuryentries , merp.clients " + " WHERE TE_CLNT_ID = CLT_ID AND TE_CLNT_ID = '" + ClientID + "' AND TE_DATE <= '" + date2.ToString("yyyy-MM-dd HH:mm:ss") + "' AND TE_DATE >= '" + date1.ToString("yyyy-MM-dd HH:mm:ss") + "' ;"; cmd.CommandText = query; reader = cmd.ExecuteReader(); Double PaidHim, PaidME, Balance; DateTime InvDate; String Comments, clientName; while (reader.Read()) { clientName = reader.GetString("CLT_NAME"); PaidME = reader.GetDouble("TE_IN");; PaidHim = reader.GetDouble("TE_OUT"); Balance = reader.GetDouble("TE_BLNCE"); InvDate = reader.GetDateTime("TE_DATE"); Comments = reader.GetString("TE_CMMTS"); dGridV_InvenLog.Rows.Add(Balance, clientName, PaidME, PaidHim, "اذن دفع", InvDate, Comments); } } catch (Exception ex) { MessageBox.Show(ex.Message); } finally { reader.Close(); Varibles.closeConnection(); } }
private void fillAllInvoices() { try { Varibles.setConnection(); cmd = Varibles.getCommand(); DateTime date1 = new DateTime(dtp_from.Value.Year, dtp_from.Value.Month, dtp_from.Value.Day, 0, 0, 0); DateTime date2 = new DateTime(dtp_to.Value.Year, dtp_to.Value.Month, dtp_to.Value.Day, 23, 59, 59); String query = "SELECT CLT_NAME , INV_CRNTBLNCE, INV_TOTAL, INV_DATE FROM merp.invoices , merp.clients WHERE" + " CLT_ID = INV_CLNT AND INV_DATE <= '" + date2.ToString("yyyy-MM-dd HH:mm:ss") + "' AND INV_DATE >= '" + date1.ToString("yyyy-MM-dd HH:mm:ss") + "' AND INV_CLNT is not NULL ;"; cmd.CommandText = query; reader = cmd.ExecuteReader(); Double For, Against, Balance; DateTime InvDate; String clientName; while (reader.Read()) { clientName = reader.GetString("CLT_NAME"); Against = reader.GetDouble("INV_TOTAL"); For = 0; Balance = reader.GetDouble("INV_CRNTBLNCE"); InvDate = reader.GetDateTime("INV_DATE"); dGridV_InvenLog.Rows.Add(Balance, clientName, For, Against, "فاتوره", InvDate, ""); } } catch (Exception ex) { MessageBox.Show(ex.Message); } finally { reader.Close(); Varibles.closeConnection(); } }
private void UpdateRecPapers(int pprID, int newState) { try { Varibles.setConnection(); cmd = Varibles.getCommand(); String query = "UPDATE `merp`.`receivable_papers` SET `RCVP_STATE`='" + newState + "' WHERE `RCVP_ID`='" + pprID + "'"; cmd.CommandText = query; cmd.ExecuteNonQuery(); } catch (Exception ex) { MessageBox.Show(ex.Message); } finally { Varibles.closeConnection(); } }
private void updatePaper(int paperID, int newState) { try { Varibles.setConnection(); cmd = Varibles.getCommand(); String query = "UPDATE `merp`.`payment_papers` SET `PYMNT_STATE`='" + newState + "' WHERE `PYMNTP_ID`='" + paperID + "'"; cmd.CommandText = query; cmd.ExecuteNonQuery(); } catch (Exception ex) { MessageBox.Show(ex.Message); } finally { Varibles.closeConnection(); } }
private void IncClientBalance(int ClientID, Double Amount) { try { Varibles.setConnection(); cmd = Varibles.getCommand(); String query = "UPDATE `merp`.`clients` SET `CLNT_BLNCE`= CLNT_BLNCE + " + Amount + " WHERE `CLT_ID`='" + ClientID + "'"; cmd.CommandText = query; cmd.ExecuteNonQuery(); } catch (Exception ex) { MessageBox.Show(ex.Message); } finally { Varibles.closeConnection(); } }
public ProdTypeMod() { InitializeComponent(); this.BackgroundImageLayout = ImageLayout.Stretch; this.Icon = Properties.Resources.merp1_ExR_icon; Varibles.setConnection(); cmd = Varibles.getCommand(); fillProdTypes(); cmbbx_ProdType.SelectedIndex = -1; txtbx_editProdName.Enabled = false; btn_Edit.Enabled = false; btn_Add.Enabled = false; this.ActiveControl = txtbx_NewProdType; }
private void loadClientBalance() { try { Varibles.setConnection(); cmd = Varibles.getCommand(); int cltNameID = Convert.ToInt32(clientNameComboBox.SelectedValue); String query = "SELECT CLNT_BLNCE FROM merp.clients WHERE CLT_ID = '" + cltNameID + "' ;"; cmd.CommandText = query; reader = cmd.ExecuteReader(); cltBalance = 0; while (reader.Read()) { try { cltBalance = reader.GetDouble("CLNT_BLNCE"); } catch (Exception ex) { cltBalance = 0; } } double tempCltBalance = cltBalance * (-1); clientBalanceTextBox.Text = tempCltBalance.ToString("0.00"); } catch (Exception ex) { MessageBox.Show(ex.Message); } finally { reader.Close(); Varibles.closeConnection(); } }
private void changeBtn_Click(object sender, EventArgs e) { if (newUser.Text == "") { newUser.Focus(); MessageBox.Show("من فضلك إستكمل البيانات المطلوبة"); return; } ; if (newPass.Text == "") { newPass.Focus(); MessageBox.Show("من فضلك إستكمل البيانات المطلوبة"); return; } ; try { Varibles.setConnection(); cmd = Varibles.getCommand(); String username = newUser.Text; String pass = newPass.Text; String condition = " USR_ID = " + "1"; cmd.CommandText = "UPDATE merp.users" + " SET USR_NAME = '" + username + "' , USR_PASS = '******'" + " WHERE ( " + condition + " )"; cmd.ExecuteReader().Close(); Varibles.closeConnection(); MessageBox.Show("تم تعديل بيانات المدير بنجاح"); this.Close(); } catch (Exception ex) { MessageBox.Show(ex.Message); } }
private int getItemBalance(int id) { try { Varibles.setConnection(); cmd = Varibles.getCommand(); int prdID = id; String query = "SELECT PRD_BALANCE FROM merp.products WHERE PRD_ID = " + prdID + " ;"; cmd.CommandText = query; reader = cmd.ExecuteReader(); int itemBlnc = 0; while (reader.Read()) { try { itemBlnc = reader.GetInt32("PRD_BALANCE"); } catch (Exception ex) { itemBlnc = 0; } } return(itemBlnc); } catch (Exception ex) { MessageBox.Show(ex.Message); return(0); } finally { reader.Close(); Varibles.closeConnection(); } }
private void UpdateClientBalance() { try { double clientBalance = getClientBalance(clientID); Varibles.setConnection(); cmd = Varibles.getCommand(); string query = "UPDATE `merp`.`clients` SET `CLNT_BLNCE`='" + (clientBalance + paymentAmount) + "' WHERE `CLT_ID` = '" + clientID + "'"; cmd.CommandText = query; cmd.ExecuteNonQuery(); } catch (Exception ex) { MessageBox.Show(ex.Message); } finally { Varibles.closeConnection(); } }
private void UpdateSuppBalance() { try { double suppBalance = getSuppBalance(suppID); Varibles.setConnection(); cmd = Varibles.getCommand(); string query = "UPDATE `merp`.`suppliers` SET `SPLR_BLNCE`='" + (suppBalance - paymentAmount) + "' WHERE `SPLR_ID`='" + suppID + "'"; cmd.CommandText = query; cmd.ExecuteNonQuery(); } catch (Exception ex) { MessageBox.Show(ex.Message); } finally { Varibles.closeConnection(); } }
private void loadAllClientsBalance() { try { Varibles.setConnection(); cmd = Varibles.getCommand(); String query = "SELECT SUM(CLNT_BLNCE) AS SUMCLNT_BLNCE FROM merp.clients ;"; cmd.CommandText = query; reader = cmd.ExecuteReader(); cltBalance = 0; while (reader.Read()) { try { cltBalance = reader.GetDouble("SUMCLNT_BLNCE"); } catch (Exception ex) { cltBalance = 0; } } double tempCltBalance = cltBalance * (-1); clientBalanceTextBox.Text = tempCltBalance.ToString("0.00"); } catch (Exception ex) { MessageBox.Show(ex.Message); } finally { reader.Close(); Varibles.closeConnection(); } }
private double getClientBalance(int clientID) { try { Varibles.setConnection(); cmd = Varibles.getCommand(); String query = "SELECT CLNT_BLNCE FROM merp.clients WHERE CLT_ID = '" + clientID + "' ;"; cmd.CommandText = query; reader = cmd.ExecuteReader(); double cltBalance = 0; while (reader.Read()) { try { cltBalance = reader.GetDouble("CLNT_BLNCE"); } catch (Exception ex) { cltBalance = 0; } } return(cltBalance); } catch (Exception ex) { MessageBox.Show(ex.Message); } finally { reader.Close(); Varibles.closeConnection(); } return(0); }
private double getSuppBalance(int suppID) { try { Varibles.setConnection(); cmd = Varibles.getCommand(); String query = "SELECT SPLR_BLNCE FROM merp.suppliers WHERE SPLR_ID = '" + suppID + "' ;"; cmd.CommandText = query; reader = cmd.ExecuteReader(); double splrBalance = 0; while (reader.Read()) { try { splrBalance = reader.GetDouble("SPLR_BLNCE"); } catch (Exception ex) { splrBalance = 0; } } return(splrBalance); } catch (Exception ex) { MessageBox.Show(ex.Message); } finally { reader.Close(); Varibles.closeConnection(); } return(0); }
private void fillprodNames() { try { Varibles.setConnection(); cmd = Varibles.getCommand(); int prodTypeID = Convert.ToInt32(this.cmbbx_ProdType.SelectedValue); String sqlCommand = "SELECT PRD_ID, PRD_NAME, PRDTYP_NAME, PRD_BALANCE, PRD_WHLSALEPRICE, PRD_SCTRPRICE, PRD_BUYPRICE " + " FROM merp.products , merp.prod_types WHERE PRDTYP_ID = PRD_TYPE_ID AND PRD_TYPE_ID = " + prodTypeID; cmd.CommandText = sqlCommand; MySqlDataAdapter da = new MySqlDataAdapter(sqlCommand, Varibles.getConnection()); DataSet ds = new DataSet(); da.Fill(ds); cmd.ExecuteNonQuery(); cmbbx_ProdName.DisplayMember = "PRD_NAME"; cmbbx_ProdName.ValueMember = "PRD_ID"; cmbbx_ProdName.DataSource = ds.Tables[0]; cmbbx_ProdName.AutoCompleteMode = AutoCompleteMode.Suggest; cmbbx_ProdName.AutoCompleteSource = AutoCompleteSource.ListItems; cmbbx_ProdName.SelectedIndex = -1; txt_Count.Text = "0"; } catch (Exception ex) { MessageBox.Show(ex.Message); } finally { Varibles.closeConnection(); } }
public void showInfo() { try { if (!lock1) { Varibles.setConnection(); cmd = Varibles.getCommand(); String sqlCommand = "Select SPLR_RespName , SPLR_EMAIL , SPLR_TEL , SPLR_MOB , SPLR_ADRS FROM merp.suppliers WHERE SPLR_NAME LIKE '" + supplierNameComboBox.Text + "'"; cmd.CommandText = sqlCommand; reader = cmd.ExecuteReader(); if (reader.HasRows) { while (reader.Read()) { formFormat(false); supplierRespTB.Text = reader.GetString(0); emailTB.Text = reader.GetString(1); PhoneTB.Text = reader.GetString(2); mobileTB.Text = reader.GetString(3); addressTB.Text = reader.GetString(4); } } else { formFormat(true); } reader.Close(); Varibles.closeConnection(); } } catch (Exception ex) { MessageBox.Show(ex.Message); } }
private bool isInStock(int prdId, double prdBuyPrice) { Varibles.setConnection(); cmd = Varibles.getCommand(); int count = 0; try { String query = "SELECT COUNT(*) AS count FROM stock where stock.prod_id = '" + prdId + "' AND stock.buy_price = '" + prdBuyPrice + "'"; cmd.CommandText = query; reader = cmd.ExecuteReader(); while (reader.Read()) { count = reader.GetInt32("count"); } } catch (Exception ex) { MessageBox.Show(ex.Message); } finally { reader.Close(); Varibles.closeConnection(); } if (count == 0) { return(false); } else { return(true); } }
private bool checkStock(int pr_id, int pr_balance, String pr_name) { try //check stock { Varibles.setConnection(); cmd = Varibles.getCommand(); int stock_balance = 0; if (isInStock(pr_id)) { stock_balance = balanceInStock(pr_id); if (pr_balance > stock_balance) { MessageBox.Show("خطأ" + " " + "العدد الموجود من هذا الصنف" + "\n" + pr_name + "\n" + "في المخزن" + " " + stock_balance); return(false); } } else { MessageBox.Show("خطأ" + " " + "لا يوجد من هذا الصنف" + "\n" + pr_name + "\n" + "في المخزن"); return(false); } } catch (Exception ex) { MessageBox.Show(ex.Message); return(false); } finally { Varibles.closeConnection(); } return(true); }
public ItemCatalogeEdit() { InitializeComponent(); this.BackgroundImageLayout = ImageLayout.Stretch; this.Icon = Properties.Resources.merp1_ExR_icon; this.MaximizeBox = false; Varibles.setConnection(); cmd = Varibles.getCommand(); fillProdTypes(); //Fill Prod Types Combobox cmbbx_ProdType.SelectedIndex = -1; fillProdTypes2(); cmbbx_NewProdType.SelectedIndex = -1; btn_ChooseProd.Enabled = false; this.groupBox2.Enabled = false; }
private void loadSupplierBalance() { try { Varibles.setConnection(); cmd = Varibles.getCommand(); int splrNameID = Convert.ToInt32(supplierNameComboBox.SelectedValue); String query = "SELECT SPLR_BLNCE FROM merp.suppliers WHERE SPLR_ID = '" + splrNameID + "' ;"; cmd.CommandText = query; reader = cmd.ExecuteReader(); while (reader.Read()) { try { splrBalance = reader.GetDouble("SPLR_BLNCE"); } catch (Exception ex) { splrBalance = 0; } } supplierBalanceTextBox.Text = splrBalance.ToString("0.00"); } catch (Exception ex) { MessageBox.Show(ex.Message); } finally { reader.Close(); Varibles.closeConnection(); } }
private void loadAllSupplierBalance() { try { Varibles.setConnection(); cmd = Varibles.getCommand(); String query = "SELECT SUM(SPLR_BLNCE) as SumSPLR_BLNCE FROM merp.suppliers ;"; cmd.CommandText = query; reader = cmd.ExecuteReader(); while (reader.Read()) { try { splrBalance = reader.GetDouble("SumSPLR_BLNCE"); } catch (Exception ex) { splrBalance = 0; } } supplierBalanceTextBox.Text = splrBalance.ToString("0.00"); } catch (Exception ex) { MessageBox.Show(ex.Message); } finally { reader.Close(); Varibles.closeConnection(); } }
private void fillChildrenForms() { for (int i = 0; i < userPermTreeView.Nodes.Count; i++) { try { Varibles.setConnection(); cmd = Varibles.getCommand(); String sqlCommand = "Select forms_name FROM merp.forms_name where form_parent = '" + i + "' "; cmd.CommandText = sqlCommand; reader = cmd.ExecuteReader(); String formName; while (reader.Read()) { formName = reader.GetString("forms_name"); userPermTreeView.Nodes[i].Nodes.Add(formName); } reader.Close(); } catch (Exception ex) { MessageBox.Show(ex.Message); } finally { Varibles.closeConnection(); } } }
private void saveBtn_Click(object sender, EventArgs e) { bool newUser = false; try { Varibles.setConnection(); cmd = Varibles.getCommand(); int selected = Convert.ToInt32(usersComboBox.SelectedValue); string query = ""; if (selected == 0) { query = "INSERT INTO `merp`.`users` (`USR_NAME`, `USR_PASS`) VALUES ('" + usersComboBox.Text + "' , '" + passTextBox.Text + "')"; newUser = true; } else { query = "UPDATE merp.users" + " SET USR_NAME = '" + usersComboBox.Text + "' , USR_PASS = '******' " + " WHERE ( USR_ID = '" + selected + "' )"; } cmd.CommandText = query; cmd.ExecuteNonQuery(); if (selected != 0) { query = "DELETE FROM usr_prm WHERE PRMUSR_USR_ID = '" + selected + "'"; cmd.CommandText = query; cmd.ExecuteNonQuery(); } int counter = 0; permissionArray = new List <string>(); for (int i = 0; i < userPermTreeView.Nodes.Count; i++) { for (int j = 0; j < userPermTreeView.Nodes[i].Nodes.Count; j++) { if (userPermTreeView.Nodes[i].Nodes[j].Checked == true) { permissionArray.Add(Convert.ToString(counter)); } counter++; } } MessageBox.Show("تم التعديل بنجاح"); } catch (Exception ex) { MessageBox.Show(ex.Message); } finally { Varibles.closeConnection(); if (newUser) { resetUsersNameComboBox(); usersComboBox.SelectedIndex = usersComboBox.Items.Count - 1; } putCheckedinTable(); setPermissionsFalse(); setPermissions(); } }
public TreasuryEntry() { Varibles.setConnection(); cmd = Varibles.getCommand(); }
private void editBtn_Click(object sender, EventArgs e) { if (supplierNameComboBox.Text == "") { supplierNameComboBox.Focus(); MessageBox.Show("من فضلك إستكمل البيانات المطلوبة"); return; } ; if (newSupplierNameTB.Text == "") { newSupplierNameTB.Focus(); MessageBox.Show("من فضلك إستكمل البيانات المطلوبة"); return; } ; try { Varibles.setConnection(); cmd = Varibles.getCommand(); String oldsupplierName = supplierNameComboBox.Text; String condition = "SPLR_NAME LIKE '" + oldsupplierName + "'"; String sqlCommand = "Select SPLR_NAME FROM merp.suppliers " + " WHERE ( " + condition + " )"; cmd.CommandText = sqlCommand; reader = cmd.ExecuteReader(); String newSupplierName = newSupplierNameTB.Text; if (reader.HasRows) { reader.Close(); if (newSupplierName != "" && newSupplierName != null) { cmd.CommandText = "UPDATE merp.suppliers" + " SET SPLR_NAME = '" + newSupplierName + "'" + " WHERE ( " + condition + " ) "; cmd.ExecuteReader().Close(); MessageBox.Show("تم اجراء التعديل بنجاح"); newSupplierNameTB.Text = ""; resetClientNameComboBox(); supplierNameComboBox.Text = newSupplierName; } else { MessageBox.Show("لا يمكن ترك اسم المورد فارغ"); } } else { reader.Close(); MessageBox.Show("يجب اختيار مورد اولا"); } Varibles.closeConnection(); } catch (Exception ex) { MessageBox.Show(ex.Message); } }
private void removeFromStock(int pr_id, int pr_balance) { List <StockItem> stockItemsList = new List <StockItem>(); Varibles.setConnection(); cmd = Varibles.getCommand(); double stock_price = 0; int stock_balance = 0; try { String query = "SELECT * FROM stock where stock.prod_id = '" + pr_id + "' ORDER BY stock.buy_price ASC "; cmd.CommandText = query; reader = cmd.ExecuteReader(); while (reader.Read()) { stock_price = reader.GetDouble("buy_price"); stock_balance = reader.GetInt32("count"); StockItem st = new StockItem(stock_balance, stock_price); stockItemsList.Add(st); } } catch (Exception ex) { MessageBox.Show(ex.Message); } finally { reader.Close(); Varibles.closeConnection(); } bool finishReader = false; for (int ii = 0; ii < stockItemsList.Count; ii++) { StockItem st = stockItemsList[ii]; stock_balance = st.getCount(); stock_price = st.getBuyPrice(); int currentBlnc = 0; int soldCount = 0; if (pr_balance > stock_balance) { currentBlnc = stock_balance; pr_balance -= stock_balance; deleteFromStock(pr_id, stock_price); } else { currentBlnc = pr_balance; int new_balance = countInStock(pr_id, stock_price) - pr_balance; if (new_balance == 0) { deleteFromStock(pr_id, stock_price); } else { updateStock(pr_id, new_balance, stock_price); } finishReader = true; } if (finishReader) { break; } } }
private void populateGrid() { try { Varibles.setConnection(); cmd = Varibles.getCommand(); String query; DateTime date1 = new DateTime(dtp_from.Value.Year, dtp_from.Value.Month, dtp_from.Value.Day, 0, 0, 0); DateTime date2 = new DateTime(dtp_to.Value.Year, dtp_to.Value.Month, dtp_to.Value.Day, 23, 59, 59); if (AllTypes == true) { query = "SELECT TE_DATE, TE_IN, TE_OUT, TE_OPTITLE, TE_CMMTS FROM merp.treasuryentries " + " WHERE TE_DATE >= '" + date1.ToString("yyyy-MM-dd HH:mm:ss") + "' AND TE_DATE <= '" + date2.ToString("yyyy-MM-dd HH:mm:ss") + "'"; } else { query = "SELECT TE_DATE, TE_IN, TE_OUT, TE_OPTITLE, TE_CMMTS FROM merp.treasuryentries " + " WHERE TE_DATE >= '" + date1.ToString("yyyy-MM-dd HH:mm:ss") + "' AND TE_DATE <= '" + date2.ToString("yyyy-MM-dd HH:mm:ss") + "' AND TE_OPTYPE_ID = " + TEType; } cmd.CommandText = query; dGridV_InvenLog.Rows.Clear(); reader = cmd.ExecuteReader(); DateTime TEDate; Double In, Out; String TETitle, TENotes; Double TotalIn = 0, TotalOut = 0, totalAll = 0; while (reader.Read()) { TEDate = reader.GetDateTime("TE_DATE"); In = reader.GetDouble("TE_IN"); Out = reader.GetDouble("TE_OUT"); TETitle = reader.GetString("TE_OPTITLE"); TENotes = reader.GetString("TE_CMMTS"); TotalIn = TotalIn + In; TotalOut = TotalOut + Out; dGridV_InvenLog.Rows.Add(TEDate, Out, In, TETitle, TENotes); } txt_TotalIn.Text = Convert.ToString(TotalIn); txt_TotalOut.Text = Convert.ToString(TotalOut); if (checkBox1.Checked) { totalAll = TotalIn - TotalOut; netSaleBox.Text = Convert.ToString(totalAll); } else { netSaleBox.Text = "0"; } } catch (Exception ex) { MessageBox.Show(ex.Message); } finally { reader.Close(); Varibles.closeConnection(); } }
private void addBtn_Click(object sender, EventArgs e) { try { String splr_name = supplierNameComboBox.Text; if (splr_name == "" || splr_name == null) { MessageBox.Show("لا يمكن ترك اسم المورد فارغ"); } else { Varibles.setConnection(); cmd = Varibles.getCommand(); String splr_REspName = supplierRespTB.Text; String splr_Email = emailTB.Text; String splr_Tele = PhoneTB.Text; String splr_mob = mobileTB.Text; String splr_adrs = addressTB.Text; double value = 0; try { value = Convert.ToDouble(beginBalanceTB.Text); } catch (Exception ex) { MessageBox.Show("يوجد خطأ فى رصيد البداية سيتم احتساب قيمة رصيد البداية بصفر"); value = 0; } if (radioButton1.Checked) { value *= -1; } else if (radioButton2.Checked) { } cmd.CommandText = "INSERT merp.suppliers" + " SET SPLR_NAME = '" + splr_name + "' , SPLR_RespName = '" + splr_REspName + "' , " + " SPLR_EMAIL = '" + splr_Email + "' , SPLR_TEL = '" + splr_Tele + "' , " + " SPLR_MOB = '" + splr_mob + "' , SPLR_ADRS = '" + splr_adrs + "' , SPLR_BLNCE = " + value; cmd.ExecuteReader().Close(); Varibles.closeConnection(); resetClientNameComboBox(); supplierNameComboBox.Text = splr_name; MessageBox.Show("تم اضافة مورد جديد بنجاح "); supplierNameComboBox.Text = ""; } } catch (Exception ex) { MessageBox.Show(ex.Message); } }
public InvLog() { Varibles.setConnection(); cmd = Varibles.getCommand(); }