public static int GetTotalDoctorsCount()
    {
        // declare the web service
        var service = new DoctorServiceReference.DoctorServiceSoapClient();

        // get the item count
        var result = service.GetITotalDoctorsCount();

        return(result);
    }
    public static IEnumerable <DoctorServiceReference.SerializableDoctor> GetAllDoctors(int startIndex, int pageSize, string sortBy)
    {
        // declare the web service
        var service = new DoctorServiceReference.DoctorServiceSoapClient();

        // select the data from database, sort by date by default
        DoctorServiceReference.SerializableDoctor[] doctorList = service.GetAllDoctors(startIndex, pageSize, SearchDoctorName);

        return(doctorList);
    }