Example #1
0
        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);
        }
Example #2
0
        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);
        }
Example #3
0
        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);
        }
Example #5
0
        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);
        }
Example #7
0
        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);
        }
Example #8
0
        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);
        }