public void addReport()
{
string query1 = "Insert into doctor_report(doctorReportId,doctorId,patientId,glaucomaTest,possibleDiseases,coverTest,refractionTest,slitLampProcedure,dialationProcedure,framesNeededStatus,conclusion) values('" + doctorReportId + "','" + doctorId + "','" + patientId + "','" + glaucomaTest + "','" + possibleDiseases + "','" + coverTest + "','" + refractionTest + "','" + slitLampProcedure + "','" + dialationProcedure + "','" + framesNeededStatus + "','" + conclusion + "')";
Crud inserter = new Crud();
inserter.insertData(query1);
}
public void addSale()
{
string addSaleRecord = "Insert into sale(saleId,patientId,GlassesBrand,frameColour,saleDate,totalCost,balance) values('" + saleId + "','" + patientId + "','" + GlassesBrand + "','" + frameColour + "','" + saleDate + "','" + totalCost + "','" + balance + "')";
Crud inserter = new Crud();
inserter.insertData(addSaleRecord);
}
public void addPatient()
{
string newPatient = "Insert into patient (patientId,fname,lname,gender,telephone) values('" + patientId + "','" + Fname + "','" + Lname + "','" + Gender + "','" + telephone + "')";
Crud inserter = new Crud();
inserter.insertData(newPatient);
}
public void addCredentials()
{
string query = "Insert into login_details (employeeId,password,authLevel) values('" + UserId + "','" + password + "','" + AuthLevel + "')";
Crud inserter = new Crud();
inserter.insertData(query);
}
public void addGlasses()
{
string query = "Insert into glasses (glassId,glassesBrand,initialCost,quantity,glassesPic) values('" + glassesId + "','" + glassesBrand + "','" + initialCost + "','" + quantity + "','" + glassesPic + "')";
Crud inserter = new Crud();
inserter.insertData(query);
}
public void addEmployee()
{
string query = "Insert into employee (employeeId,fname,lname,gender,profilePic) values('" + userId + "','" + Fname + "','" + Lname + "','" + Gender + "','" + profilePic + "')";
Crud inserter = new Crud();
inserter.insertData(query);
}
public void addAppointment()
{
string newPatient = "Insert into appointment(appointmentId,doctorId,patientId,visitingDate,visitingTime,visitCost,paymentStatus,appointmentStatus) values('" + appointmentId + "','" + doctorId + "','" + patientId + "','" + visitingDate + "','" + visitingTime + "'," + visitCost + ",'" + paymentStatus + "','" + appointmentStatus + "')";
Crud inserter = new Crud();
inserter.insertData(newPatient);
}
public void addPreReport(string reportId, string patientId, string userId, string reportDate, string issues, int readingTest, string familyHistory, double eyePressure, double sphereDistance, double sphereNear, double cylinderDistance, double cylinderNear, double axisDistance, double axisNear, double baseDistance, double prismDistance, double prismNear, double baseNear)
{
string query = "Insert into pre_test(reportId,patientId,userId,reportDate,issues,readingTest,familyHistory,eyePressure,sphereDistance,sphereNear,cylinderDistance,cylinderNear,axisDistance,axisNear,prismDistance,prismNear,baseDistance,baseNear) values('" + reportId + "','" + patientId + "','" + userId + "','" + reportDate + "','" + issues + "','" + readingTest + "','" + familyHistory + "','" + eyePressure + "','" + sphereDistance + "','" + sphereNear + "','" + cylinderDistance + "','" + cylinderNear + "','" + axisDistance + "','" + axisNear + "','" + prismDistance + "','" + prismNear + "','" + baseDistance + "','" + baseNear + "')";
Crud inserter = new Crud();
inserter.insertData(query);
}