private void GetStaffID() { try { SQLConn.sqL = "SELECT StaffID FROM STAFF ORDER BY StaffID DESC"; SQLConn.ConnDB(); SQLConn.cmd = new MySqlCommand(SQLConn.sqL, SQLConn.conn); SQLConn.dr = SQLConn.cmd.ExecuteReader(); if (SQLConn.dr.Read() == true) { lblProductNo.Text = (Convert.ToInt32(SQLConn.dr["StaffID"]) + 1).ToString(); } else { lblProductNo.Text = "1"; } } catch (Exception ex) { Interaction.MsgBox(ex.ToString()); } finally { SQLConn.cmd.Dispose(); SQLConn.conn.Close(); } }
private void LoadUpdateStaff() { txt_money.ReadOnly = true; try { SQLConn.sqL = "SELECT * FROM DACCOUNTS WHERE AccountID = '" + LSAccountID + "'"; SQLConn.ConnDB(); SQLConn.cmd = new MySqlCommand(SQLConn.sqL, SQLConn.conn); SQLConn.dr = SQLConn.cmd.ExecuteReader(); if (SQLConn.dr.Read() == true) { lblAccountNo.Text = SQLConn.dr["AccountID"].ToString(); txtName.Text = SQLConn.dr["Name"].ToString(); txtArea.Text = SQLConn.dr["Area"].ToString(); txtCity.Text = SQLConn.dr["City"].ToString(); txtShopNo.Text = SQLConn.dr["ShopNo"].ToString(); txtContractNo.Text = SQLConn.dr["ContactNo"].ToString(); txt_money.Text = SQLConn.dr["Money_Debt"].ToString(); } } catch (Exception ex) { Interaction.MsgBox(ex.ToString()); } finally { SQLConn.cmd.Dispose(); SQLConn.conn.Close(); } }
private void LoadUpdateCategory() { try { SQLConn.sqL = "SELECT * FROM Category WHERE CategoryNo = '" + categoryID + "'"; SQLConn.ConnDB(); SQLConn.cmd = new MySqlCommand(SQLConn.sqL, SQLConn.conn); SQLConn.dr = SQLConn.cmd.ExecuteReader(); if (SQLConn.dr.Read() == true) { lblCategoryNo.Text = SQLConn.dr["CategoryNo"].ToString(); txtCatName.Text = SQLConn.dr["CategoryName"].ToString(); txtDescription.Text = SQLConn.dr["Description"].ToString(); } } catch (Exception ex) { Interaction.MsgBox(ex.ToString()); } finally { SQLConn.cmd.Dispose(); SQLConn.conn.Close(); } }
private void button1_Click(object sender, EventArgs e) { try { if (textBox1.Text != "") { int i = Convert.ToInt32(textBox1.Text); SQLConn.sqL = "SELECT * FROM payment WHERE InvoiceNo LIKE '" + i + "'"; SQLConn.ConnDB(); SQLConn.cmd = new MySqlCommand(SQLConn.sqL, SQLConn.conn); SQLConn.dr = SQLConn.cmd.ExecuteReader(); if (SQLConn.dr.Read() == true) { frmPrint abcd = new frmPrint(i, "frmPOS"); abcd.ShowDialog(); } else { MessageBox.Show("Error:Invalid InvoiceNo."); } } } catch (Exception ex) { MessageBox.Show(ex.Message.ToString()); } this.Close(); }
private void btnImport_Click(object sender, EventArgs e) { try { OpenFileDialog theDialog = new OpenFileDialog(); theDialog.Title = "Open Text File"; theDialog.Filter = "BackUp File (*.sql)|*.sql"; if (theDialog.ShowDialog() == DialogResult.OK) { string file = Path.GetFullPath(theDialog.FileName); SQLConn.ConnDB(); SQLConn.cmd = new MySqlCommand(SQLConn.sqL, SQLConn.conn); MySqlBackup mb = new MySqlBackup(SQLConn.cmd); mb.ImportInfo.TargetDatabase = "rahman_educational_service"; mb.ImportInfo.DatabaseDefaultCharSet = "utf8"; mb.ImportFromFile(file); // LoadStaffs(""); MessageBox.Show("Restoring Successfully Completed."); } } catch (Exception ex) { MessageBox.Show("Restroring UnSuccessfull. " + ex); } }
public void LoadStaffs(string search) { try { SQLConn.sqL = "SELECT StaffID, CONCAT(Firstname, ', ', Lastname, ' ') as ClientName, CONCAT(Street, ', ', Area, ', ', City , ', ', Province) as Address, ContactNo, username, role FROM Staff WHERE Firstname LIKE '" + search.Trim() + "%' ORDER By Firstname"; SQLConn.ConnDB(); SQLConn.cmd = new MySqlCommand(SQLConn.sqL, SQLConn.conn); SQLConn.dr = SQLConn.cmd.ExecuteReader(); ListViewItem x = null; ListView1.Items.Clear(); while (SQLConn.dr.Read() == true) { x = new ListViewItem(SQLConn.dr["StaffId"].ToString()); x.SubItems.Add(SQLConn.dr["ClientName"].ToString()); x.SubItems.Add(SQLConn.dr["ContactNo"].ToString()); x.SubItems.Add(SQLConn.dr["Address"].ToString()); x.SubItems.Add(SQLConn.dr["username"].ToString()); x.SubItems.Add(SQLConn.dr["Role"].ToString()); ListView1.Items.Add(x); } } catch (Exception ex) { Interaction.MsgBox(ex.Message); } finally { SQLConn.cmd.Dispose(); SQLConn.conn.Close(); } }
private void GetProductInfo() { try { SQLConn.sqL = "SELECT ProductCode, Description, UnitPrice, StocksOnHand FROM Product WHERE ProductNo =" + productID + ""; SQLConn.ConnDB(); SQLConn.cmd = new MySqlCommand(SQLConn.sqL, SQLConn.conn); SQLConn.dr = SQLConn.cmd.ExecuteReader(); if (SQLConn.dr.Read() == true) { lblProductCode.Text = SQLConn.dr[0].ToString(); lblDescription.Text = SQLConn.dr[1].ToString(); lblPrice.Text = Strings.FormatNumber(SQLConn.dr[2]).ToString(); lblCurrentStocks.Text = SQLConn.dr[3].ToString(); } } catch (Exception ex) { Interaction.MsgBox(ex.ToString()); } finally { SQLConn.cmd.Dispose(); SQLConn.conn.Close(); } }
private void GetCategoryNo() { try { SQLConn.sqL = "SELECT CategoryNo FROM Category ORDER BY CategoryNo DESC"; SQLConn.ConnDB(); SQLConn.cmd = new MySqlCommand(SQLConn.sqL, SQLConn.conn); SQLConn.dr = SQLConn.cmd.ExecuteReader(); if (SQLConn.dr.Read() == true) { lblCategoryNo.Text = (Convert.ToInt32(SQLConn.dr["CategoryNo"]) + 1).ToString(); } else { lblCategoryNo.Text = "1"; } } catch (Exception ex) { Interaction.MsgBox(ex.ToString()); } finally { SQLConn.cmd.Dispose(); SQLConn.conn.Close(); } }
public void LoadCategories(string strSearch) { try { SQLConn.sqL = "SELECT * FROM CATEGORY WHERE CategoryName LIKE '" + strSearch + "%' ORDER By CategoryNO"; SQLConn.ConnDB(); SQLConn.cmd = new MySqlCommand(SQLConn.sqL, SQLConn.conn); SQLConn.dr = SQLConn.cmd.ExecuteReader(CommandBehavior.CloseConnection); ListViewItem x = null; ListView1.Items.Clear(); while (SQLConn.dr.Read() == true) { x = new ListViewItem(SQLConn.dr["CategoryNo"].ToString()); x.SubItems.Add(SQLConn.dr["CategoryName"].ToString()); x.SubItems.Add(SQLConn.dr["Description"].ToString()); ListView1.Items.Add(x); } } catch (Exception ex) { Interaction.MsgBox(ex.ToString()); } finally { SQLConn.cmd.Dispose(); SQLConn.conn.Close(); } }
private void LoadCategory() { try { SQLConn.sqL = "SELECT * FROM Category WHERE CategoryName LIKE '" + txtCatName.Text + "%' ORDER BY CategoryNo "; SQLConn.ConnDB(); SQLConn.cmd = new MySqlCommand(SQLConn.sqL, SQLConn.conn); SQLConn.dr = SQLConn.cmd.ExecuteReader(); ListViewItem x = null; ListView1.Items.Clear(); while (SQLConn.dr.Read() == true) { x = new ListViewItem(SQLConn.dr["CategoryNo"].ToString()); x.SubItems.Add(SQLConn.dr["CategoryName"].ToString()); x.SubItems.Add(SQLConn.dr["Description"].ToString()); ListView1.Items.Add(x); } } catch (Exception ex) { Interaction.MsgBox(ex.ToString()); } finally { SQLConn.cmd.Dispose(); SQLConn.conn.Close(); } }
public void AutoCompleteText(bool chec) { item_des_text.AutoCompleteMode = AutoCompleteMode.SuggestAppend; item_des_text.AutoCompleteSource = AutoCompleteSource.CustomSource; AutoCompleteStringCollection coll = new AutoCompleteStringCollection(); try { if (chec == true) { SQLConn.sqL = "SELECT * FROM Product "; SQLConn.ConnDB(); SQLConn.cmd = new MySqlCommand(SQLConn.sqL, SQLConn.conn); SQLConn.dr = SQLConn.cmd.ExecuteReader(); while (SQLConn.dr.Read() == true) { des = SQLConn.dr["Description"].ToString(); coll.Add(des); } } else if (chec == false) { string[] split = frmS.Split(','); foreach (string item in split) { SQLConn.sqL = "SELECT * FROM product WHERE ProductNo = '" + item + "'"; SQLConn.ConnDB(); SQLConn.cmd = new MySqlCommand(SQLConn.sqL, SQLConn.conn); SQLConn.dr = SQLConn.cmd.ExecuteReader(); while (SQLConn.dr.Read() == true) { des = SQLConn.dr["Description"].ToString(); coll.Add(des); } } } } catch (Exception ex) { MessageBox.Show("Error :" + ex); } finally // only checking remove in case of error { SQLConn.cmd.Dispose(); SQLConn.conn.Close(); } item_des_text.AutoCompleteCustomSource = coll; } //// Description textBox , Drop Down Class
void addTransactionsDetails() { String quan; String itemcode; String itemdes; String unitP; String disc; String to; productNo = 0; try { for (int i = 0; i < dataGridView1.Rows.Count; i++) { quan = dataGridView1.Rows[i].Cells[7].Value.ToString(); if (quan != "" && Convert.ToInt32(quan) > 0) { productNo = Convert.ToInt32(dataGridView1.Rows[i].Cells[0].Value.ToString()); itemcode = dataGridView1.Rows[i].Cells[1].Value.ToString(); itemdes = dataGridView1.Rows[i].Cells[2].Value.ToString(); unitP = dataGridView1.Rows[i].Cells[3].Value.ToString(); disc = dataGridView1.Rows[i].Cells[5].Value.ToString(); to = dataGridView1.Rows[i].Cells[8].Value.ToString(); SQLConn.sqL = "INSERT INTO transactiondetails(InvoiceNo,ProductNo,ItemPrice,Quantity,Discount,perItem) VALUES('" + invoiceNo + "', '" + productNo + "', '" + unitP + "' ,'" + quan + "','" + disc + "','" + to + "')"; SQLConn.ConnDB(); SQLConn.cmd = new MySqlCommand(SQLConn.sqL, SQLConn.conn); SQLConn.cmd.ExecuteNonQuery(); } } } catch (Exception ex) { Interaction.MsgBox(ex.ToString()); } finally { SQLConn.cmd.Dispose(); SQLConn.conn.Close(); } }
private void button3_Click(object sender, EventArgs e) { Stream myS = null; SaveFileDialog saveFileDialog1 = new SaveFileDialog(); saveFileDialog1.Filter = "BackUp File (*.sql)|*.sql"; saveFileDialog1.RestoreDirectory = true; try { if (saveFileDialog1.ShowDialog() == DialogResult.OK) { if ((myS = saveFileDialog1.OpenFile()) != null) { SQLConn.ConnDB(); SQLConn.cmd = new MySqlCommand(SQLConn.sqL, SQLConn.conn); MySqlBackup mb = new MySqlBackup(SQLConn.cmd); string file = Path.GetFullPath(saveFileDialog1.FileName); myS.Close(); mb.ExportInfo.AddCreateDatabase = true; List <string> abc = new List <string>(); abc.Add("daccounts"); abc.Add("saccounts"); abc.Add("debtin"); abc.Add("debtins"); abc.Add("payment"); abc.Add("transactions"); abc.Add("transactiondetails"); abc.Add("stockin"); abc.Add("staff"); abc.Add("product"); abc.Add("category"); mb.ExportInfo.TablesToBeExportedList = abc; mb.ExportInfo.ExportTableStructure = true; mb.ExportInfo.ExportRows = true; mb.ExportToFile(file); MessageBox.Show("BackUp Successfully Completed."); } } } catch (Exception ex) { MessageBox.Show("BackUp UnSuccessfull. " + ex); } }
public void AutoCompleteAccount() { accName.AutoCompleteMode = AutoCompleteMode.SuggestAppend; accName.AutoCompleteSource = AutoCompleteSource.CustomSource; AutoCompleteStringCollection accColl = new AutoCompleteStringCollection(); try { if (accType.Text == "Distributor") { SQLConn.sqL = "SELECT * FROM daccounts "; SQLConn.ConnDB(); SQLConn.cmd = new MySqlCommand(SQLConn.sqL, SQLConn.conn); SQLConn.dr = SQLConn.cmd.ExecuteReader(); while (SQLConn.dr.Read() == true) { des = SQLConn.dr["Name"].ToString(); accColl.Add(des); } } else if (accType.Text == "School Sale") { SQLConn.sqL = "SELECT * FROM saccounts "; SQLConn.ConnDB(); SQLConn.cmd = new MySqlCommand(SQLConn.sqL, SQLConn.conn); SQLConn.dr = SQLConn.cmd.ExecuteReader(); while (SQLConn.dr.Read() == true) { des = SQLConn.dr["Name"].ToString(); accColl.Add(des); } } } catch (Exception ex) { MessageBox.Show("Error :" + ex); } finally // only checking remove in case of error { SQLConn.cmd.Dispose(); SQLConn.conn.Close(); } accName.AutoCompleteCustomSource = accColl; }
void addTransactions() { string accT = ""; string no = ""; string name = ""; if (accType.Text == "Counter Sale") { accT = "CS"; no = "0"; name = accName.Text; } else if (accType.Text == "Distributor") { accT = "DS"; no = accNo.Text; name = accName.Text; } else if (accType.Text == "School Sale") { accT = "SS"; no = accNo.Text; name = accName.Text; } else { MessageBox.Show("Error."); } try { SQLConn.sqL = "INSERT INTO transactions(InvoiceNo,TDate,TTime,TotalAmount,StaffID,AccType,AccNo,AccName) VALUES('" + invoiceNo + "', '" + System.DateTime.Now.ToString("MM/dd/yyyy") + "', '" + System.DateTime.Now.ToString("hh:mm:ss") + "' ,'" + totalAmount + "','" + staffId + "','" + accT + "','" + no + "','" + name + "')"; SQLConn.ConnDB(); SQLConn.cmd = new MySqlCommand(SQLConn.sqL, SQLConn.conn); SQLConn.cmd.ExecuteNonQuery(); } catch (Exception ex) { Interaction.MsgBox(ex.ToString()); } finally { SQLConn.cmd.Dispose(); SQLConn.conn.Close(); } }
public void AEform() { string Fall = null; if (listView1.Items.Count == 0) { spring = null; } else { try { for (int i = 0; i < listView1.Items.Count; ++i) { string abc = listView1.Items[i].Text.ToString(); SQLConn.sqL = "SELECT ProductNo FROM product WHERE Description = '" + abc + "'"; SQLConn.ConnDB(); SQLConn.cmd = new MySqlCommand(SQLConn.sqL, SQLConn.conn); SQLConn.dr = SQLConn.cmd.ExecuteReader(); if (SQLConn.dr.Read() == true) { if (i == 0) { spring = SQLConn.dr["ProductNo"].ToString(); } else { Fall = SQLConn.dr["ProductNo"].ToString(); spring = string.Concat(spring, ",", Fall); } } } } catch (Exception ex) { Interaction.MsgBox(ex.ToString()); } finally { SQLConn.cmd.Dispose(); SQLConn.conn.Close(); } } }
private void AddPayment(string t, string a, string od, string nd) { try { SQLConn.sqL = "INSERT INTO PAYMENT(InvoiceNo, Cash, PChange,AccType,AccNo,OldDebt,NewDebt) VALUES('" + InvoiceNo + "', '" + txtCash.Text.Replace(",", "") + "', '" + txtChange.Text.Replace(",", "") + "', '" + t + "' ,'" + a + "','" + od.Replace(",", "") + "','" + nd.Replace(",", "") + "')"; SQLConn.ConnDB(); SQLConn.cmd = new MySqlCommand(SQLConn.sqL, SQLConn.conn); SQLConn.cmd.ExecuteNonQuery(); } catch (Exception ex) { Interaction.MsgBox(ex.ToString()); } finally { SQLConn.cmd.Dispose(); SQLConn.conn.Close(); } }
private void UpdateAccountDebt() { try { SQLConn.sqL = "UPDATE daccounts SET DateIN='" + System.DateTime.Now.ToString("MM-dd-yyyy") + "',Money_Debt = '" + txtTotalMoneyDebt.Text + "' WHERE AccountID = '" + accountID + "'"; SQLConn.ConnDB(); SQLConn.cmd = new MySqlCommand(SQLConn.sqL, SQLConn.conn); SQLConn.cmd.ExecuteNonQuery(); } catch (Exception ex) { Interaction.MsgBox(ex.ToString()); } finally { SQLConn.cmd.Dispose(); SQLConn.conn.Close(); } }
private void UpdateProductQuantity() { try { SQLConn.sqL = "UPDATE Product SET StocksOnhand = StocksOnHand + '" + quantity + "' WHERE ProductNo = '" + productNo + "'"; SQLConn.ConnDB(); SQLConn.cmd = new MySqlCommand(SQLConn.sqL, SQLConn.conn); SQLConn.cmd.ExecuteNonQuery(); } catch (Exception ex) { Interaction.MsgBox(ex.ToString()); } finally { SQLConn.cmd.Dispose(); SQLConn.conn.Close(); } }
private void AddStockIn() { try { SQLConn.sqL = "INSERT INTO StockIn(ProductNo, Quantity, DateIn) Values('" + lblProductNo.Text + "', '" + txtStocksOnHand.Text + "', '" + System.DateTime.Now.ToString("MM/dd/yyyy") + "')"; SQLConn.ConnDB(); SQLConn.cmd = new MySqlCommand(SQLConn.sqL, SQLConn.conn); SQLConn.cmd.ExecuteNonQuery(); } catch (Exception ex) { Interaction.MsgBox(ex.ToString()); } finally { SQLConn.cmd.Dispose(); SQLConn.conn.Close(); } }
public void insert_SchoolSale() { try { SQLConn.sqL = "UPDATE saccounts SET Money_Debt='" + txNewDebt.Text.Replace(",", "") + "',DateIN='" + System.DateTime.Now.ToString("MM-dd-yyyy") + "' where AccountID='" + AccNo + "'"; SQLConn.ConnDB(); SQLConn.cmd = new MySqlCommand(SQLConn.sqL, SQLConn.conn); SQLConn.cmd.ExecuteNonQuery(); } catch (Exception ex) { Interaction.MsgBox(ex.ToString()); } finally { SQLConn.cmd.Dispose(); SQLConn.conn.Close(); } }
private void Login() { try { SQLConn.sqL = "SELECT * FROM Staff WHERE Username = '******' AND UPassword = '******'"; SQLConn.ConnDB(); SQLConn.cmd = new MySqlCommand(SQLConn.sqL, SQLConn.conn); // MessageBox.Show(SQLConn.sqL.ToString()); SQLConn.dr = SQLConn.cmd.ExecuteReader(); if (SQLConn.dr.Read() == true) { if (SQLConn.dr["Role"].ToString().ToUpper() == "ADMIN") { frmMain m = new frmMain(SQLConn.dr["Username"].ToString(), Convert.ToInt32(SQLConn.dr["StaffID"])); // waitsplash(); m.Show(); this.Hide(); } else { frmMain m = new frmMain(SQLConn.dr["Username"].ToString(), Convert.ToInt32(SQLConn.dr["StaffID"])); // waitsplash(); m.Show(); this.Hide(); } } else { Interaction.MsgBox("Invalid Password. Please try again.", MsgBoxStyle.Exclamation, "Login"); } } catch (Exception ex) { Interaction.MsgBox(ex.Message); } finally { SQLConn.cmd.Dispose(); SQLConn.conn.Close(); } }
private void UpdateStaff() { try { SQLConn.sqL = "Update saccounts SET Name = '" + txtName.Text + "', Area = '" + txtArea.Text + "', City = '" + txtCity.Text + "', ContactNo = '" + txtContractNo.Text + "', ShopNo = '" + txtShopNo.Text + "', Money_Debt = '" + txt_money.Text + "' , form= '" + spring + "' WHERE AccountID = '" + LSAccountID + "'"; SQLConn.ConnDB(); SQLConn.cmd = new MySqlCommand(SQLConn.sqL, SQLConn.conn); SQLConn.cmd.ExecuteNonQuery(); // Interaction.MsgBox("Account record successfully updated", MsgBoxStyle.Information, "Update Account"); } catch (Exception ex) { MessageBox.Show(ex.Message.ToString()); } finally { SQLConn.cmd.Dispose(); SQLConn.conn.Close(); } }
private void AddStaff() { try { SQLConn.sqL = "INSERT INTO saccounts( Name, Area, City, ContactNo,ShopNo, Money_Debt ,form ) VALUES( '" + txtName.Text + "', '" + txtArea.Text + "', '" + txtCity.Text + "', '" + txtContractNo.Text + "', '" + txtShopNo.Text + "', '" + txt_money.Text + "','" + spring + "')"; SQLConn.ConnDB(); SQLConn.cmd = new MySqlCommand(SQLConn.sqL, SQLConn.conn); SQLConn.cmd.ExecuteNonQuery(); // Interaction.MsgBox("New Account successfully added.", MsgBoxStyle.Information, "Add Account"); } catch (Exception ex) { MessageBox.Show(ex.Message.ToString()); } finally { SQLConn.cmd.Dispose(); SQLConn.conn.Close(); } }
private void UpdateStaff() { try { SQLConn.sqL = "Update STAFF SET Firstname = '" + txtFirstname.Text + "',Lastname = '" + txtLastname.Text + "', Street= '" + txtStreet.Text + "', Area = '" + txtArea.Text + "', City = '" + txtCity.Text + "', Province = '" + txtProvince.Text + "', ContactNo = '" + txtContractNo.Text + "', Username ='******', Role = '" + txtRole.Text + "', UPassword = '******' WHERE StaffID = '" + LSStaffID + "'"; SQLConn.ConnDB(); SQLConn.cmd = new MySqlCommand(SQLConn.sqL, SQLConn.conn); SQLConn.cmd.ExecuteNonQuery(); Interaction.MsgBox("Staff record successfully updated", MsgBoxStyle.Information, "Update Staff"); } catch (Exception ex) { Interaction.MsgBox(ex.ToString()); } finally { SQLConn.cmd.Dispose(); SQLConn.conn.Close(); } }
private void AddCategory() { try { SQLConn.sqL = "INSERT INTO Category(CategoryName, Description) VALUES('" + txtCatName.Text + "', '" + txtDescription.Text + "')"; SQLConn.ConnDB(); SQLConn.cmd = new MySqlCommand(SQLConn.sqL, SQLConn.conn); SQLConn.cmd.ExecuteNonQuery(); Interaction.MsgBox("New category successfully added.", MsgBoxStyle.Information, "Add Category"); } catch (Exception ex) { Interaction.MsgBox(ex.ToString()); } finally { SQLConn.cmd.Dispose(); SQLConn.conn.Close(); } }
private void UpdateCategory() { try { SQLConn.sqL = "UPDATE Category SET CategoryName= '" + txtCatName.Text + "', Description = '" + txtDescription.Text + "' WHERE CategoryNo = '" + categoryID + "'"; SQLConn.ConnDB(); SQLConn.cmd = new MySqlCommand(SQLConn.sqL, SQLConn.conn); SQLConn.cmd.ExecuteNonQuery(); Interaction.MsgBox("Category successfully updated.", MsgBoxStyle.Information, "Update Category"); } catch (Exception ex) { Interaction.MsgBox(ex.ToString()); } finally { SQLConn.cmd.Dispose(); SQLConn.conn.Close(); } }
private void AddStaff() { try { SQLConn.sqL = "INSERT INTO STAFF( Firstname,Lastname, Street, Area, City, Province, ContactNo, Username, Role, UPassword) VALUES( '" + txtFirstname.Text + "','" + txtLastname.Text + "', '" + txtStreet.Text + "', '" + txtArea.Text + "', '" + txtCity.Text + "', '" + txtProvince.Text + "', '" + txtContractNo.Text + "', '" + txtUsername.Text + "', '" + txtRole.Text + "', '" + txtPassword.Text + "')"; SQLConn.ConnDB(); SQLConn.cmd = new MySqlCommand(SQLConn.sqL, SQLConn.conn); SQLConn.cmd.ExecuteNonQuery(); Interaction.MsgBox("New staff successfully added.", MsgBoxStyle.Information, "Add Staff"); } catch (Exception ex) { Interaction.MsgBox(ex.ToString()); } finally { SQLConn.cmd.Dispose(); SQLConn.conn.Close(); } }
private void UpdateProduct() { try { SQLConn.sqL = "UPDATE Product SET ProductCode = '" + txtProductCode.Text + "', Description = '" + txtDescription.Text + "', UnitPrice = '" + txtUnitPrice.Text.Replace(",", "") + "', StocksOnHand = '" + txtStocksOnHand.Text.Replace(",", "") + "', CategoryNo ='" + categoryID + "' WHERE ProductNo = '" + productID + "'"; SQLConn.ConnDB(); SQLConn.cmd = new MySqlCommand(SQLConn.sqL, SQLConn.conn); SQLConn.cmd.ExecuteNonQuery(); Interaction.MsgBox("Product successfully Updated.", MsgBoxStyle.Information, "Update Product"); } catch (Exception ex) { Interaction.MsgBox(ex.ToString()); } finally { SQLConn.cmd.Dispose(); SQLConn.conn.Close(); } }
private void AddProducts() { try { SQLConn.sqL = "INSERT INTO Product(ProductCode, Description, UnitPrice, StocksOnHand, CategoryNo) VALUES('" + txtProductCode.Text + "', '" + txtDescription.Text + "', '" + txtUnitPrice.Text.Replace(",", "") + "', '" + txtStocksOnHand.Text.Replace(",", "") + "', '" + categoryID + "')"; SQLConn.ConnDB(); SQLConn.cmd = new MySqlCommand(SQLConn.sqL, SQLConn.conn); SQLConn.cmd.ExecuteNonQuery(); Interaction.MsgBox("Product successfully added.", MsgBoxStyle.Information, "Add Product"); AddStockIn(); } catch (Exception ex) { Interaction.MsgBox(ex.Message); } finally { SQLConn.cmd.Dispose(); SQLConn.conn.Close(); } }