private void btnAdd_Click(object sender, RoutedEventArgs e) { if (checkFields()) { try { queryString = "INSERT INTO dbspa.tbldiscount (discount, description,isDeleted)" + "VALUES(?,?,?)"; parameters = new List <string>(); parameters.Add(txtDiscount.Text); parameters.Add(String.Format("{0:0.00}", txtDescription.Text)); parameters.Add(0.ToString()); conDB.AddRecordToDatabase(queryString, parameters); conDB.closeConnection(); loadDataGridDetails(); MessageBox.Show("RECORD SAVED SUCCESSFULLY!"); this.Close(); } catch (Exception ex) { MessageBox.Show(ex.Message); } } }
private void btnAdd_Click(object sender, RoutedEventArgs e) { try { if (checkFields()) { queryString = "INSERT INTO dbspa.tblservicemode (serviceType, isDeleted)" + "VALUES(?,?)"; parameters = new List <string>(); parameters.Add(txtServiceMode.Text); parameters.Add(0.ToString()); conDB.AddRecordToDatabase(queryString, parameters); conDB.closeConnection(); loadDataGridDetails(); MessageBox.Show("RECORD SAVED SUCCESSFULLY!"); this.Close(); } } catch (Exception ex) { MessageBox.Show(ex.Message); } }
private void updateCommissionDetails(CommissionModel comModel) { try { CommissionModel stm = cmbServiceType.SelectedItem as CommissionModel; queryString = "UPDATE dbspa.tblcommissions SET commission = ? " + "WHERE ID = ?"; parameters = new List <string>(); parameters.Add(String.Format("{0:0.00}", txtCommission.Text)); parameters.Add(comModel.ID1); conDB.AddRecordToDatabase(queryString, parameters); conDB.closeConnection(); MessageBox.Show("RECORD UPDATED SUCCESSFULLY!"); conDB.writeLogFile("UPDATED COMMISSION RECORD: RECORD ID: " + comModel.ID1); this.Close(); } catch (Exception ex) { MessageBox.Show("FAILED TO UPDATE RECORD! " + "," + ex.Message); } }
private void saveProductsAndPackages(string strRecordID) { conDB = new ConnectionDB(); string queryString = "INSERT INTO dbpackage.tblorderdetails (orderID, packageID, productID, qty, price, isDeleted) VALUES (?,?,?,?,?,0)"; foreach (PackageModel pMod in lstPackages) { List <string> parameters = new List <string>(); parameters.Add(strRecordID); parameters.Add(pMod.ID); parameters.Add("0"); parameters.Add(pMod.Qty); parameters.Add(pMod.Total); conDB.AddRecordToDatabase(queryString, parameters); } queryString = "INSERT INTO dbpackage.tblorderdetails (orderID, packageID, productID, qty, price, isDeleted) VALUES (?,?,?,?,?,0)"; foreach (ProductModel prodMod in lstProducts) { List <string> parameters = new List <string>(); parameters.Add(strRecordID); parameters.Add("0"); parameters.Add(prodMod.ID); parameters.Add(prodMod.Qty); parameters.Add(prodMod.Total); conDB.AddRecordToDatabase(queryString, parameters); } conDB.closeConnection(); }
private void updateProductsOnList(string strSalesID) { string query = ""; conDB = new ConnectionDB(); foreach (ProductModel p in lstProductModel) { if (!p.newlyAdded) { query = "UPDATE dbfh.tblproductsordered SET productID = ?, qty = ?, totalamt = ?, isDeleted = ? WHERE ID = ?"; List <string> parameters = new List <string>(); parameters.Add(p.ProductID); parameters.Add(p.Quantity); parameters.Add(p.TotalAmount); parameters.Add(p.isDeleted); parameters.Add(p.ID); conDB.AddRecordToDatabase(query, parameters); } else { query = "INSERT INTO dbfh.tblproductsordered (productID, salesID, qty, totalamt, isDeleted) VALUES (?,?,?,?,0)"; List <string> parameters = new List <string>(); parameters.Add(p.ProductID); parameters.Add(strSalesID); parameters.Add(p.Quantity); parameters.Add(p.TotalAmount); conDB.AddRecordToDatabase(query, parameters); } } }
private void btnSave_Click(object sender, RoutedEventArgs e) { try { if (checkFields()) { queryString = "INSERT INTO dbspa.tbltherapist (firstName,lastName,wage,description,isDeleted)" + "VALUES(?,?,?,?,?)"; parameters = new List <string>(); string fullName = txtFirstName.Text + " " + txtLastName.Text; parameters.Add(txtFirstName.Text); parameters.Add(txtLastName.Text); parameters.Add(txtWage.Text); parameters.Add(fullName); parameters.Add(0.ToString()); conDB.AddRecordToDatabase(queryString, parameters); conDB.closeConnection(); therapist.dgvTherapist.ItemsSource = getDatagridDetails(); MessageBox.Show("RECORD SAVED SUCCESSFULLY!"); this.Close(); } } catch (Exception ex) { MessageBox.Show(ex.Message); } }
private void saveLoyaltyCard() { queryString = "INSERT INTO dbspa.tblloyaltycard (serialnumber, isDeleted) VALUES (?,?)"; parameters = new List <string>(); parameters.Add(txtSerialNumber.Text); parameters.Add("0"); conDB.AddRecordToDatabase(queryString, parameters); conDB.closeConnection(); }
private void DeleteProductRecord(string strProductID) { string queryString = "UPDATE dbpackage.tblproducts SET isDeleted = 1 WHERE ID = ?"; List <string> parameters = new List <string>(); parameters.Add(strProductID); conDB.AddRecordToDatabase(queryString, parameters); conDB.closeConnection(); }
private void deleteRecord(string recID) { queryString = "UPDATE dbspa.tblloyaltycard SET isDeleted = 1 WHERE ID = ?"; parameters = new List <string>(); parameters.Add(recID); conDB.AddRecordToDatabase(queryString, parameters); conDB.closeConnection(); }
private void addServiceToPromo(string ID) { queryString = "INSERT INTO dbspa.tblpromoservices (promoID, serviceID, isDeleted) VALUES (?,?,?)"; parameters = new List <string>(); parameters.Add(ID); parameters.Add(cmbServices.SelectedValue.ToString()); parameters.Add("0"); conDB.AddRecordToDatabase(queryString, parameters); conDB.closeConnection(); insertedPromoID = ID; }
private void savePromoRecord() { queryString = "INSERT INTO dbspa.tblpromo (promoname, price, commission, isDeleted) VALUES (?,?,?,?)"; parameters = new List <string>(); parameters.Add(txtPromoName.Text); parameters.Add(String.Format("{0:0.00}", txtPromoPrice.Text)); parameters.Add(txtCommission.Text); parameters.Add("0"); conDB.AddRecordToDatabase(queryString, parameters); conDB.closeConnection(); }
private void updateRecord() { conDB = new ConnectionDB(); string queryString = "UPDATE dbpackage.tblproducts SET name = ?, description = ?, nonmemberprice = ?, memberprice = ?, " + "homeprice = ?, megaprice = ?, depotprice = ?, employeeprice = ?, MFG = ?, unilevel = ?, lb = ? WHERE ID = ?"; List <string> parameters = new List <string>(); parameters.Add(txtProductName.Text); parameters.Add(txtDescription.Text); parameters.Add(txtNonMemberPrice.Text); parameters.Add(txtMemberPrice.Text); parameters.Add(txtHomePrice.Text); parameters.Add(txtMegaPrice.Text); parameters.Add(txtDepotPrice.Text); parameters.Add(txtEmployeePrice.Text); parameters.Add(txtMFG.Text); parameters.Add(txtUnilevel.Text); parameters.Add(txtLB.Text); parameters.Add(productMod.ID); conDB.AddRecordToDatabase(queryString, parameters); conDB.closeConnection(); }
private void updateRecordConso(string strRecID) { conDB = new ConnectionDB(); queryString = "UPDATE dbjuiceacct.tblaccountorderconso SET clientID = ?, paymentmodeID = ?, drNo = ?, " + "deliverydate = ?, terms = ?, paymentduedate = ?, total = ?, repID = ?, isPaid = ?, remainingbalance = ? WHERE " + "ID = ?"; parameters = new List <string>(); parameters.Add(cmbClient.SelectedValue.ToString()); parameters.Add(cmbPayment.SelectedValue.ToString()); parameters.Add(txtDRNo.Text); DateTime pdate = DateTime.Parse(deliveryDate.Text); parameters.Add(pdate.Year + "/" + pdate.Month + "/" + pdate.Day); parameters.Add(txtTerms.Text); pdate = DateTime.Parse(paymentDueDate.Text); parameters.Add(pdate.Year + "/" + pdate.Month + "/" + pdate.Day); parameters.Add(txtTotal.Text); parameters.Add(cmbRep.SelectedValue.ToString()); if (chkPaid.IsChecked.Value) { parameters.Add("1"); } else { parameters.Add("0"); } parameters.Add(txtRemainingBalance.Text); parameters.Add(strRecID); conDB.AddRecordToDatabase(queryString, parameters); conDB.closeConnection(); }
private void saveEmployeeRecord() { conDB = new ConnectionDB(); queryString = "INSERT INTO tblemployees (employeeID, firstname, lastname, incomeperday, " + " companyID, startdate, status, empsss, empphilhealth, emppagibig, empsssloan, emppel, empeml, " + "empgrl, emppey, empelecbill, empallowance, regworkingdays, isDeleted) VALUES (?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,0)"; parameters = new List <string>(); parameters.Add(txtEmployeeID.Text); parameters.Add(txtFirstName.Text); parameters.Add(txtLastName.Text); parameters.Add(txtWage.Text); parameters.Add(cmbCompany.SelectedValue.ToString()); DateTime sdate = DateTime.Parse(startDate.Text); parameters.Add(sdate.Year + "/" + sdate.Month + "/" + sdate.Day); parameters.Add(cmbStatus.SelectedValue.ToString()); parameters.Add(txtSSS.Text); parameters.Add(txtPhilHealth.Text); parameters.Add(txtPagibig.Text); parameters.Add(txtSSSLoan.Text); parameters.Add(txtPEL.Text); parameters.Add(txtEML.Text); parameters.Add(txtGRL.Text); parameters.Add(txtPEY.Text); parameters.Add(txtElecBill.Text); parameters.Add(txtAllowance.Text); parameters.Add(txtRegWorkingDays.Text); conDB.AddRecordToDatabase(queryString, parameters); conDB.writeLogFile("SAVE EMPLOYEE RECORD: " + "Employee name: " + txtFirstName.Text + " " + txtLastName.Text); }
private void saveRecord() { conDB = new ConnectionDB(); queryString = "INSERT INTO tbluser (name, username, password, isAdmin, isViewing, pincode, isDeleted) " + "VALUES (?,?, aes_encrypt(?,?),?,?,?,0)"; parameters = new List <string>(); parameters.Add(txtName.Text); parameters.Add(txtUsername.Text); parameters.Add(txtPassword.Password); parameters.Add("sp3ctrum"); if (chkAdmin.IsChecked.Value) { parameters.Add("1"); parameters.Add("1"); parameters.Add(txtPin.Text); } else { parameters.Add("0"); parameters.Add("1"); parameters.Add("NULL"); } conDB.AddRecordToDatabase(queryString, parameters); conDB.closeConnection(); }
private void updateRecord() { conDB = new ConnectionDB(); queryString = "UPDATE dbfh.tblstocksjuiceout SET datedelivered = ?, productID = ?, qty = ?, " + "drNo = ?, isPaid = ?, terms = ?, paymentduedate = ? WHERE ID = ?"; parameters = new List <string>(); DateTime sdate = DateTime.Parse(dateDelivered.Text); parameters.Add(sdate.Year + "/" + sdate.Month + "/" + sdate.Day); parameters.Add(cmbProducts.SelectedValue.ToString()); parameters.Add(txtQty.Text); parameters.Add(txtDRNo.Text); string strPaid = (chkPaid.IsChecked.Value) ? "1" : "0"; parameters.Add(strPaid); parameters.Add(txtTerms.Text); sdate = DateTime.Parse(paymentDueDate.Text); parameters.Add(sdate.Year + "/" + sdate.Month + "/" + sdate.Day); parameters.Add(recordID); conDB.AddRecordToDatabase(queryString, parameters); conDB.closeConnection(); }
private async void addProduct() { conDB = new ConnectionDB(); string queryString = "INSERT INTO dbpackage.tblproducts (name, description, nonmemberprice, memberprice, homeprice, megaprice, " + "depotprice, employeeprice, MFG, unilevel, lb, isDeleted) " + "VALUES (?,?,?,?,?,?,?,?,?,?,?,0)"; List <string> parameters = new List <string>(); parameters.Add(txtProductName.Text); parameters.Add(txtDescription.Text); parameters.Add(txtNonMemberPrice.Text); parameters.Add(txtMemberPrice.Text); parameters.Add(txtHomePrice.Text); parameters.Add(txtMegaPrice.Text); parameters.Add(txtDepotPrice.Text); parameters.Add(txtEmployeePrice.Text); parameters.Add(txtMFG.Text); parameters.Add(txtUnilevel.Text); parameters.Add(txtLB.Text); conDB.AddRecordToDatabase(queryString, parameters); conDB.closeConnection(); await this.ShowMessageAsync("Add Product", "Record successfully saved!"); }
private bool insertCODNumber(int cod) { bool ifInserted = false; try { conDB = new ConnectionDB(); queryString = "INSERT INTO dbspa.tblcod (COD, dateServiced)VALUES(?,?)"; parameters = new List <string>(); parameters.Add(cod.ToString()); DateTime date = DateTime.Parse(DateTime.Now.ToShortDateString()); parameters.Add(date.Year + "/" + date.Month + "/" + date.Day); conDB.AddRecordToDatabase(queryString, parameters); conDB.closeConnection(); ifInserted = true; } catch (Exception ex) { System.Windows.MessageBox.Show(ex.Message); } return(ifInserted); }
private int AddPackageName() { conDB = new ConnectionDB(); string queryString = "INSERT INTO dbpackage.tblpackage (name, nonmemberprice, memberprice, " + "homeprice, megaprice, depotprice, employeeprice," + " MFG, unilevel, lb, isDeleted) " + "VALUES (?,?,?,?,?,?,?,?,?,?,0)"; List <string> parameters = new List <string>(); parameters.Add(txtPackageName.Text); parameters.Add(txtNonMemberPrice.Text); parameters.Add(txtMemberPrice.Text); parameters.Add(txtHomePrice.Text); parameters.Add(txtMegaPrice.Text); parameters.Add(txtDepotPrice.Text); parameters.Add(txtEmployeePrice.Text); parameters.Add(txtMFG.Text); parameters.Add(txtUnilevel.Text); parameters.Add(txtLB.Text); conDB.AddRecordToDatabase(queryString, parameters); MySqlDataReader reader = conDB.getSelectConnection("select ID from dbpackage.tblpackage order by ID desc limit 1", null); int x = 0; while (reader.Read()) { x = Convert.ToInt32(reader["ID"].ToString()); } conDB.closeConnection(); return(x); }
private void addMembersPayment() { conDB = new ConnectionDB(); string queryString = "INSERT INTO dbpackage.tblpaymenthistory (clientID, orderID, amountpaid, date, notes, isDeleted) VALUES (?,?,?,?,?,0)"; List <string> parameters = new List <string>(); parameters.Add(membersModel.ID); parameters.Add(orderHistory.ID); parameters.Add(txtAmount.Text); DateTime date = DateTime.Parse(datePaid.Text); parameters.Add(date.Year + "-" + date.Month + "-" + date.Day); if (string.IsNullOrEmpty(txtNotes.Text)) { parameters.Add(""); } else { parameters.Add(txtNotes.Text); } conDB.AddRecordToDatabase(queryString, parameters); conDB.closeConnection(); }
private void insertProductsBought(int id) { conDB = new ConnectionDB(); queryString = "INSERT INTO dbspa.tblproductbought (productID, clientID, totalqty, datebought, isDiscounted, discountID, isDeleted) " + "VALUES (?,?,?,?,?,?,?)"; parameters = new List <string>(); DiscountModel dm = cmbDiscount.SelectedItem as DiscountModel; parameters.Add(cmbProducts.SelectedValue.ToString()); parameters.Add(id.ToString()); parameters.Add(txtQty.Text); DateTime date = DateTime.Parse(DateTime.Now.ToShortDateString()); parameters.Add(date.Year + "/" + date.Month + "/" + date.Day); int numDiscounted = 0; if (Convert.ToInt32(dm.Discount) > 0) { //ifDiscounted = true; numDiscounted = 1; } parameters.Add(numDiscounted.ToString()); parameters.Add(dm.ID1); parameters.Add("0"); conDB.AddRecordToDatabase(queryString, parameters); conDB.closeConnection(); conDB.writeLogFile("ADDED PRODUCTS FOR CLIENT ID: " + id + " PRODUCTS BOUGHT : " + cmbProducts.SelectedValue.ToString() + " QTY: " + txtQty.Text); }
private void updateRecord(string eID) { conDB = new ConnectionDB(); queryString = "UPDATE tbluser SET username = ?, password = aes_encrypt(?,?), isAdmin = ?," + " isViewing = ?, pincode = ? WHERE ID = ?"; parameters = new List <string>(); parameters.Add(txtUsername.Text); parameters.Add(txtPassword.Password); parameters.Add("sp3ctrum"); if (chkAdmin.IsChecked.Value) { parameters.Add("1"); parameters.Add("1"); parameters.Add(txtPin.Text); } else { parameters.Add("0"); parameters.Add("1"); parameters.Add("NULL"); } parameters.Add(eID); conDB.AddRecordToDatabase(queryString, parameters); conDB.closeConnection(); }
private void saveConsumable() { queryString = "INSERT INTO dbspa.tblconsumableleft (date, consumableID, qty, used, isDeleted) VALUES (?,?,?,?,?)"; parameters = new List <string>(); DateTime dte = DateTime.Parse(dateBought.Text); parameters.Add(dte.Year + "-" + dte.Month + "-" + dte.Day); parameters.Add(cmbConsumables.SelectedValue.ToString()); parameters.Add(txtQty.Text); parameters.Add(txtUsed.Text); parameters.Add("0"); conDB.AddRecordToDatabase(queryString, parameters); conDB.closeConnection(); }
private void saveStocksProduct() { ProductsModel p = cmbProducts.SelectedItem as ProductsModel; queryString = "INSERT INTO dbspa.tblproductstocks (productID, date, stocks, isDeleted) VALUES (?,?,?,?)"; parameters = new List <string>(); parameters.Add(p.ID); DateTime date = DateTime.Parse(deliveryDate.Text); parameters.Add(date.Year + "/" + date.Month + "/" + date.Day); parameters.Add(txtStocks.Text); parameters.Add("0"); conDB.AddRecordToDatabase(queryString, parameters); conDB.closeConnection(); }
private void saveCashAdvanceRecord() { queryString = "INSERT INTO dbspa.tblcashadvance (Date, therapistID, cash, isDeleted) VALUES (?,?,?,0)"; parameters = new List <string>(); DateTime dte = DateTime.Parse(dateCashAdvance.Text); parameters.Add(dte.Year + "-" + dte.Month + "-" + dte.Day); parameters.Add(cmbTherapist.SelectedValue.ToString()); parameters.Add(txtCash.Text); conDB.AddRecordToDatabase(queryString, parameters); conDB.closeConnection(); conDB.writeLogFile("ADDED CASH ADVANCE: DETAILS: DATE: " + dte.ToShortDateString() + " THERAPIS: " + cmbTherapist.SelectedValue.ToString() + " CASH: " + txtCash.Text); }
private void deleteRecordStocksOUt(string strID) { conDB = new ConnectionDB(); queryString = "UPDATE dbfh.tblstocksjuiceout SET isDeleted = 1 WHERE ID = ?"; parameters = new List <string>(); parameters.Add(strID); conDB.AddRecordToDatabase(queryString, parameters); conDB.closeConnection(); }
private void deleteProductsOnPackage(string strPackageID) { conDB = new ConnectionDB(); string queryString = "UPDATE dbpackage.tblpackageproduct SET isDeleted = 1 WHERE packageID = ?"; List <string> parameters = new List <string>(); parameters.Add(strPackageID); conDB.AddRecordToDatabase(queryString, parameters); conDB.closeConnection(); }
private void deleteDR(string recID) { conDB = new ConnectionDB(); queryString = "UPDATE dbpackage.tblorderhistory SET isDeleted = 1 WHERE ID = ?"; parameters = new List <string>(); parameters.Add(recID); conDB.AddRecordToDatabase(queryString, parameters); conDB.closeConnection(); }
private void updateOriginalRecordtoConsolidated() { conDB = new ConnectionDB(); queryString = "UPDATE dbjuiceacct.tblaccountorder SET isConso = 1 WHERE ID = ?"; parameters = new List <string>(); parameters.Add(accountOrder.ID); conDB.AddRecordToDatabase(queryString, parameters); conDB.closeConnection(); }
private void deleteHomeStockist(string stockistID) { conDB = new ConnectionDB(); queryString = "UPDATE dbpackage.tblclients SET isDeleted = 1 WHERE ID = ?"; parameters = new List <string>(); parameters.Add(stockistID); conDB.AddRecordToDatabase(queryString, parameters); conDB.closeConnection(); }