private void deleteBtn_Click(object sender, EventArgs e) { try { Varibles.setConnection(); cmd = Varibles.getCommand(); String supplierName = supplierNameComboBox.Text; String condition = " SPLR_NAME LIKE '" + supplierName + "'"; cmd.CommandText = "DELETE FROM merp.suppliers" + " WHERE ( " + condition + " )"; cmd.ExecuteReader().Close(); Varibles.closeConnection(); MessageBox.Show("تم حذف العميل بنجاح"); resetClientNameComboBox(); supplierNameComboBox.SelectedIndex = -1; } catch (Exception ex) { MessageBox.Show(ex.Message); } }
public void resetClientNameComboBox() { try { Varibles.setConnection(); cmd = Varibles.getCommand(); String sqlCommand = "Select SPLR_NAME, SPLR_ID FROM merp.suppliers"; cmd.CommandText = sqlCommand; MySqlDataAdapter da = new MySqlDataAdapter(sqlCommand, Varibles.getConnection()); DataSet ds = new DataSet(); da.Fill(ds); cmd.ExecuteNonQuery(); supplierNameComboBox.DisplayMember = "SPLR_NAME"; supplierNameComboBox.ValueMember = "SPLR_ID"; supplierNameComboBox.DataSource = ds.Tables[0]; supplierNameComboBox.AutoCompleteMode = AutoCompleteMode.Suggest; supplierNameComboBox.AutoCompleteSource = AutoCompleteSource.ListItems; } catch (Exception ex) { MessageBox.Show(ex.Message); } finally { Varibles.closeConnection(); } }
private void putCheckedinTable() { try { int selected = Convert.ToInt32(usersComboBox.SelectedValue); Varibles.setConnection(); cmd = Varibles.getCommand(); for (int i = 0; i < permissionArray.Count; i++) { String sqlCommand = "INSERT INTO `merp`.`usr_prm` (`PRMUSR_USR_ID`, `PRMUSR_PRM_ID`) VALUES ('" + selected + "', '" + permissionArray[i] + "');"; cmd.CommandText = sqlCommand; cmd.ExecuteNonQuery(); } } catch (Exception ex) { MessageBox.Show(ex.Message); } finally { Varibles.closeConnection(); } }
private void updateProdBlnc(int prodID, int Count, int opType) { try { Varibles.setConnection(); cmd = Varibles.getCommand(); String query; if (opType == 1) { query = "UPDATE `merp`.`products` SET `PRD_BALANCE`= PRD_BALANCE + '" + Count + "' WHERE `PRD_ID`='" + prodID + "'"; } else { query = "UPDATE `merp`.`products` SET `PRD_BALANCE`= PRD_BALANCE - '" + Count + "' WHERE `PRD_ID`='" + prodID + "'"; } cmd.CommandText = query; cmd.ExecuteNonQuery(); } catch (Exception ex) { MessageBox.Show(ex.Message); } finally { Varibles.closeConnection(); } }
private int getProdCount(int prdID) { int count = -1; try { Varibles.setConnection(); cmd = Varibles.getCommand(); String query = "SELECT PRD_BALANCE FROM merp.products WHERE PRD_ID = " + prdID; cmd.CommandText = query; reader = cmd.ExecuteReader(); count = -1; while (reader.Read()) { count = reader.GetInt32("PRD_BALANCE"); } return(count); } catch (Exception ex) { MessageBox.Show(ex.Message); return(count); } finally { reader.Close(); Varibles.closeConnection(); } }
private void fillProdTypes() { try { Varibles.setConnection(); cmd = Varibles.getCommand(); String sqlCommand = "SELECT PRDTYP_ID, PRDTYP_NAME FROM merp.prod_types"; cmd.CommandText = sqlCommand; MySqlDataAdapter da = new MySqlDataAdapter(sqlCommand, Varibles.getConnection()); DataSet ds = new DataSet(); da.Fill(ds); cmd.ExecuteNonQuery(); cmbbx_ProdType.DisplayMember = "PRDTYP_NAME"; cmbbx_ProdType.ValueMember = "PRDTYP_ID"; cmbbx_ProdType.DataSource = ds.Tables[0]; cmbbx_ProdType.AutoCompleteMode = AutoCompleteMode.Suggest; cmbbx_ProdType.AutoCompleteSource = AutoCompleteSource.ListItems; } catch (Exception ex) { MessageBox.Show(ex.Message); } finally { Varibles.closeConnection(); } }
private int countInStock(int prdId, double prdBuyPrice) { Varibles.setConnection(); cmd = Varibles.getCommand(); int count = 0; try { String query = "SELECT stock.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(); } return(count); }
private Double getSuppBalance(int SuppID) { Double blnce = -1; try { Varibles.setConnection(); cmd = Varibles.getCommand(); String query = "SELECT SPLR_BLNCE FROM merp.suppliers WHERE SPLR_NAME = " + SuppID; cmd.CommandText = query; reader = cmd.ExecuteReader(); while (reader.Read()) { blnce = reader.GetDouble("SPLR_BLNCE"); } } catch (Exception ex) { MessageBox.Show(ex.Message); } finally { reader.Close(); Varibles.closeConnection(); } return(blnce); }
private void fillParentForms() { try { Varibles.setConnection(); cmd = Varibles.getCommand(); String sqlCommand = "Select Parent_name FROM merp.parents_form"; cmd.CommandText = sqlCommand; reader = cmd.ExecuteReader(); String parentName; while (reader.Read()) { parentName = reader.GetString("Parent_name"); userPermTreeView.Nodes.Add(parentName); } reader.Close(); } catch (Exception ex) { MessageBox.Show(ex.Message); } finally { Varibles.closeConnection(); } }
private void editBtn_Click(object sender, EventArgs e) { try { Varibles.setConnection(); cmd = Varibles.getCommand(); String splrName = supplierNameComboBox.Text; String condition = " SPLR_NAME LIKE '" + splrName + "'"; String respName = supplierRespTB.Text; String email = emailTB.Text; String tele = PhoneTB.Text; String mob = mobileTB.Text; String address = addressTB.Text; cmd.CommandText = "UPDATE merp.suppliers" + " SET SPLR_RespName = '" + respName + "' , SPLR_EMAIL = '" + email + "' , SPLR_TEL = '" + tele + "' , SPLR_MOB = '" + mob + "' , SPLR_ADRS = '" + address + "' " + " WHERE ( " + condition + " )"; cmd.ExecuteReader().Close(); Varibles.closeConnection(); MessageBox.Show("تم اجراء التعديل بنجاح"); } catch (Exception ex) { MessageBox.Show(ex.Message); } }
private Double getClientBlnc(int clientID) { Double blnce = -1; try { Varibles.setConnection(); cmd = Varibles.getCommand(); String query = "SELECT CLNT_BLNCE FROM merp.clients WHERE CLT_ID = " + clientID; cmd.CommandText = query; reader = cmd.ExecuteReader(); while (reader.Read()) { blnce = reader.GetDouble("CLNT_BLNCE"); } } catch (Exception ex) { MessageBox.Show(ex.Message); } finally { reader.Close(); Varibles.closeConnection(); } return(blnce); }
private void login() { try { Varibles.setConnection(); cmd = Varibles.getCommand(); String username = userNametextBox.Text; String pass = PasstextBox.Text; if (username == "MMM" && pass == "M123M123M") { DBConfiguration form = new DBConfiguration(); this.Hide(); form.ShowDialog(); this.Close(); } else { String condition = "USR_NAME LIKE '" + username + "' AND " + "USR_PASS LIKE '" + pass + "' "; cmd.CommandText = "SELECT USR_NAME , USR_ID" + " FROM merp.users" + " WHERE ( " + condition + " )"; reader = cmd.ExecuteReader(); int usr_id = 0; while (reader.Read()) { usr_id = reader.GetInt32("USR_ID"); break; } Varibles.setUserId(usr_id); if (reader.HasRows) { MainForm form = new MainForm(); this.Hide(); form.ShowDialog(); this.Close(); } else { MessageBox.Show("اسم المستخدم او كلمة المرور خاطئة"); } reader.Close(); Varibles.closeConnection(); } } catch (Exception ex) { MessageBox.Show(ex.Message); } }
private void populateGrid() { 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 PYMNTP_SPPLRID, PYMNTP_ID, SPLR_NAME, PYMNT_BANKNAME, PYMNT_BANKBRNCH, PYMNT_ACCNO, PYMNT_PPRNO, " + "PYMNT_RLSEDATE, PYMNT_ENDDATE, PYMNT_PPRTYPE, PYMNT_AMNT FROM merp.payment_papers, " + "merp.suppliers WHERE PYMNTP_SPPLRID = SPLR_ID AND PYMNT_STATE = '" + state + "' AND " + "PYMNT_RLSEDATE <= '" + date2.ToString("yyyy-MM-dd HH:mm:ss") + "' AND PYMNT_RLSEDATE >= '" + date1.ToString("yyyy-MM-dd HH:mm:ss") + "' ;"; cmd.CommandText = query; reader = cmd.ExecuteReader(); String bankName, bankbranch, accNo, pprNo, pprType, SpplrName; int paymentID, suppId; Double Amount; DateTime releaseDate, EndDate; dGridV_InvenLog.Rows.Clear(); while (reader.Read()) { suppId = reader.GetInt32("PYMNTP_SPPLRID"); bankName = reader.GetString("PYMNT_BANKNAME"); bankbranch = reader.GetString("PYMNT_BANKBRNCH"); accNo = reader.GetString("PYMNT_ACCNO"); pprNo = reader.GetString("PYMNT_PPRNO"); pprType = reader.GetString("PYMNT_PPRTYPE"); SpplrName = reader.GetString("SPLR_NAME"); Amount = reader.GetDouble("PYMNT_AMNT"); releaseDate = reader.GetDateTime("PYMNT_RLSEDATE"); EndDate = reader.GetDateTime("PYMNT_ENDDATE"); paymentID = reader.GetInt32("PYMNTP_ID"); dGridV_InvenLog.Rows.Add(suppId, SpplrName, bankName, bankbranch, accNo, pprNo, releaseDate, EndDate, pprType, Amount, paymentID); } } catch (Exception ex) { MessageBox.Show(ex.Message); } finally { reader.Close(); Varibles.closeConnection(); } calcTotal(); }
private void btn_save_Click(object sender, EventArgs e) { String bankName, bankbranch, accNo, pprNo, pprType; Int32 SpplrID; Double Amount; DateTime releaseDate, EndDate; try { foreach (DataGridViewRow i in dGridV_InvenLog.Rows) { try { Varibles.setConnection(); cmd = Varibles.getCommand(); bankName = Convert.ToString(i.Cells["clmn_BNKName"].Value); bankbranch = Convert.ToString(i.Cells["clmn_BNKBranch"].Value); accNo = Convert.ToString(i.Cells["clmn_AccNo"].Value); pprNo = Convert.ToString(i.Cells["clmn_PprNo"].Value); pprType = Convert.ToString(i.Cells["clmn_pprType"].Value); SpplrID = Convert.ToInt32(i.Cells["spplrID"].Value); Amount = Convert.ToDouble(i.Cells["clmn_Amnt"].Value); releaseDate = Convert.ToDateTime(i.Cells["clmn_ReleaseDate"].Value);; EndDate = Convert.ToDateTime(i.Cells["clmn_endDate"].Value); String query = "INSERT INTO `merp`.`payment_papers` (`PYMNTP_SPPLRID`, `PYMNT_BANKNAME`, `PYMNT_BANKBRNCH`, " + "`PYMNT_ACCNO`, `PYMNT_PPRNO`, `PYMNT_RLSEDATE`, " + "`PYMNT_ENDDATE`, `PYMNT_PPRTYPE`, `PYMNT_AMNT`) " + "VALUES ('" + SpplrID + "', '" + bankName + "', '" + bankbranch + "', '" + accNo + "', '" + pprNo + "', '" + releaseDate.ToString("yyyy-MM-dd HH:mm:ss") + "', " + "'" + EndDate.ToString("yyyy-MM-dd HH:mm:ss") + "', '" + pprType + "', '" + Amount + "')"; cmd.CommandText = query; cmd.ExecuteNonQuery(); Varibles.closeConnection(); DecSupplier(SpplrID, Amount); } catch (Exception ex) { MessageBox.Show(ex.Message); Varibles.closeConnection(); } finally { } } MessageBox.Show("العملية تمت بنجاح"); dGridV_InvenLog.Rows.Clear(); } catch (SystemException ex) { MessageBox.Show("Error " + ex.Message); } }
private void populateGrid() { 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 RCVP_CLNT_ID, RCVP_ID, CLT_NAME, RCVP_BANKNAME, RCVP_BANKBRNCH, RCVP_ACCNO, RCVP_PPRNO, RCVP_RELDATE, RCVP_ENDDATE, RCVP_PPRTYPE, RCVP_AMNT" + " FROM merp.receivable_papers, merp.clients WHERE RCVP_CLNT_ID = CLT_ID AND RCVP_STATE = " + state + " AND " + " RCVP_RELDATE >= '" + date1.ToString("yyyy-MM-dd HH:mm:ss") + "' AND RCVP_RELDATE <= '" + date2.ToString("yyyy-MM-dd HH:mm:ss") + "' ;"; cmd.CommandText = query; reader = cmd.ExecuteReader(); String bankName, bankbranch, accNo, pprNo, pprType, SpplrName; Int32 pprID, clntID; Double Amount; DateTime releaseDate, EndDate; dGridV_InvenLog.Rows.Clear(); while (reader.Read()) { bankName = reader.GetString("RCVP_BANKNAME"); bankbranch = reader.GetString("RCVP_BANKBRNCH"); accNo = reader.GetString("RCVP_ACCNO"); pprNo = reader.GetString("RCVP_PPRNO"); pprType = reader.GetString("RCVP_PPRTYPE"); SpplrName = reader.GetString("CLT_NAME"); Amount = reader.GetDouble("RCVP_AMNT"); releaseDate = reader.GetDateTime("RCVP_RELDATE"); EndDate = reader.GetDateTime("RCVP_ENDDATE"); pprID = reader.GetInt32("RCVP_ID"); clntID = reader.GetInt32("RCVP_CLNT_ID"); dGridV_InvenLog.Rows.Add(clntID, SpplrName, bankName, bankbranch, accNo, pprNo, releaseDate, EndDate, pprType, Amount, pprID); } } catch (Exception ex) { MessageBox.Show(ex.Message); } finally { reader.Close(); Varibles.closeConnection(); } calcTotal(); }
private void usersComboBox_SelectedIndexChanged(object sender, EventArgs e) { if (usersComboBox.Text != "") { try { string usrPassword = ""; int usrID = Convert.ToInt32(usersComboBox.SelectedValue); Varibles.setConnection(); cmd = Varibles.getCommand(); String query = "SELECT USR_PASS FROM merp.users WHERE USR_ID = '" + usrID + "' ;"; cmd.CommandText = query; reader = cmd.ExecuteReader(); while (reader.Read()) { try { usrPassword = reader.GetString("USR_PASS"); } catch (Exception ex) { usrPassword = ""; } } passTextBox.Text = usrPassword; } catch (Exception ex) { MessageBox.Show(ex.Message); } finally { Varibles.closeConnection(); } try { setPermissionsFalse(); setPermissions(); } catch (Exception ex) { MessageBox.Show(ex.Message); } } else { MessageBox.Show("برجاء إدحال اسم الستخدم"); } }
private void deleteFromStock(int prdId, double prdBuyPrice) { Varibles.setConnection(); cmd = Varibles.getCommand(); String query = "Delete From stock where stock.prod_id = '" + prdId + "' AND stock.buy_price = '" + prdBuyPrice + "'"; cmd.CommandText = query; cmd.ExecuteNonQuery(); Varibles.closeConnection(); }
private void updateStock(int prdId, int prdBalance, double prdBuyPrice) { Varibles.setConnection(); cmd = Varibles.getCommand(); String query = "Update stock set stock.count = '" + prdBalance + "' where stock.prod_id = '" + prdId + "' AND stock.buy_price = '" + prdBuyPrice + "'"; cmd.CommandText = query; cmd.ExecuteNonQuery(); Varibles.closeConnection(); }
private void setPermissions() { try { int usrID = Convert.ToInt32(usersComboBox.SelectedValue); Varibles.setConnection(); cmd = Varibles.getCommand(); String query = "SELECT * FROM merp.usr_prm WHERE PRMUSR_USR_ID = '" + usrID + "' ;"; cmd.CommandText = query; reader = cmd.ExecuteReader(); while (reader.Read()) { int prm_ID = 0; try { prm_ID = reader.GetInt32("PRMUSR_PRM_ID"); int counter = 0; for (int i = 0; i < userPermTreeView.Nodes.Count; i++) { for (int j = 0; j < userPermTreeView.Nodes[i].Nodes.Count; j++) { if (counter == prm_ID) { userPermTreeView.Nodes[i].Nodes[j].Checked = true; userPermTreeView.Nodes[i].Checked = true; userPermTreeView.Nodes[i].Expand(); } counter++; } } } catch (Exception ex) { prm_ID = 0; } } } catch (Exception ex) { MessageBox.Show(ex.Message); } finally { Varibles.closeConnection(); } }
private void confirmOldPassBtn_Click(object sender, EventArgs e) { if (usernameTB.Text == "") { usernameTB.Focus(); MessageBox.Show("من فضلك إستكمل البيانات المطلوبة"); return; } ; if (passTB.Text == "") { passTB.Focus(); MessageBox.Show("من فضلك إستكمل البيانات المطلوبة"); return; } ; try { Varibles.setConnection(); cmd = Varibles.getCommand(); String username = usernameTB.Text; String pass = passTB.Text; String condition = "USR_NAME LIKE '" + username + "' AND " + "USR_PASS LIKE '" + pass + "' AND USR_ID = " + "1"; cmd.CommandText = "SELECT USR_NAME" + " FROM merp.users" + " WHERE ( " + condition + " )"; reader = cmd.ExecuteReader(); if (reader.HasRows) { this.groupBox2.Visible = true; this.Height = 424; } else { MessageBox.Show("اسم المستخدم او كلمة المرور خاطئة"); this.groupBox2.Visible = false; this.Height = 234; } reader.Close(); Varibles.closeConnection(); } catch (Exception ex) { MessageBox.Show(ex.Message); } }
private void insertInStock(int prdId, int prdBalance, double prdBuyPrice) { Varibles.setConnection(); cmd = Varibles.getCommand(); String query = "Insert Into stock (stock.prod_id, stock.count , stock.buy_price ) " + "VALUES ( " + prdId + " , " + prdBalance + " , " + prdBuyPrice + " )"; cmd.CommandText = query; cmd.ExecuteNonQuery(); Varibles.closeConnection(); }
private void fillAllPayables() { 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 is not NULL 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 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 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 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 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 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(); } }
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(); } }