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();
}