public void updateBalance(string searchKey) { string paymentUpdate = "Update sale set balance=" + balance + " where patientId='" + searchKey + "'"; Crud updater = new Crud(); updater.updateData(paymentUpdate); }
public void updatePatient(string searchKey) { string updatePatient = "Update patient set fname='" + Fname + "',lname='" + Lname + "',gender='" + Gender + "',telephone='" + telephone + "' where patientId='" + searchKey + "'"; Crud updatePat = new Crud(); updatePat.updateData(updatePatient); }
public void updateSale(string searchKey) { string saleUpdate = "Update glasses set GlassesBrand='" + GlassesBrand + "',frameColour='" + frameColour + "saleDate=" + saleDate + ",totalCost='" + totalCost + ",balance='" + balance + "' where saleId='" + searchKey + "'"; Crud updater = new Crud(); updater.updateData(saleUpdate); }
public void updateGlasses(string searchKey) { string query1 = "Update glasses set glassesBrand='" + glassesBrand + "',initialCost=" + initialCost + ",quantity=" + quantity + ",glassesPic='" + glassesPic + "' where glassId='" + searchKey + "'"; Crud inserter = new Crud(); inserter.updateData(query1); }
public void updateEmployee(string searchKey) { string query1 = "Update employee set fname='" + Fname + "',lname='" + Lname + "',gender='" + Gender + "',profilePic='" + ProfilePic + "' where employeeId='" + searchKey + "'"; Crud updateEmp = new Crud(); updateEmp.updateData(query1); }
public void updatePayment(string searchKey) { string updatePayment = "Update appointment set paymentStatus='" + paymentStatus + "' where patientId='" + searchKey + "'"; Crud updatePayments = new Crud(); updatePayments.updateData(updatePayment); }
public void updateAppointment(string searchKey) { string updatePatient = "Update appointment set doctorId='" + doctorId + "',patientId='" + patientId + "',visitingDate='" + visitingDate + "',visitingTime='" + visitingTime + "',visitCost=" + visitCost + ",paymentStatus='" + paymentStatus + "',appointmentStatus='" + appointmentStatus + "' where patientId='" + searchKey + "'"; Crud updateAppointments = new Crud(); updateAppointments.updateData(updatePatient); }