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