public List<Doctor> DoctorAssignList()
        {
            string query =
                "select DoctorID,DoctorName from doctors where doctorid not in (select DoctorID from DoctorClinics)";
            aSqlConnection.Open();
            aSqlCommand = new SqlCommand(query, aSqlConnection);
            SqlDataReader aDataReader = aSqlCommand.ExecuteReader();

            List<Doctor> aList = new List<Doctor>();

            while (aDataReader.Read())
            {
                //Designation aDesignation = new Designation();
                Doctor aDoctor = new Doctor();
                aDoctor.DoctorID = Convert.ToInt32(aDataReader[0]);
                aDoctor.DoctorName = aDataReader[1].ToString();

                aList.Add(aDoctor);
            }
            aDataReader.Close();
            aSqlConnection.Close();
            return aList;
        }
        public List<Doctor> GetDoctors()
        {
            string query = string.Format("select Doctors.DoctorID,DoctorName from Doctors,DoctorClinics where Doctors.DoctorID=DoctorClinics.DoctorID and DoctorClinics.CommunityClinicID={0}", Convert.ToInt32(System.Web.HttpContext.Current.User.Identity.Name.Split('|')[2]));
            aSqlConnection.Open();
            aSqlCommand = new SqlCommand(query, aSqlConnection);
            SqlDataReader aDataReader = aSqlCommand.ExecuteReader();

            List<Doctor> aList = new List<Doctor>();

            while (aDataReader.Read())
            {
                //Designation aDesignation = new Designation();
                Doctor aDoctor = new Doctor();
                aDoctor.DoctorID = Convert.ToInt32(aDataReader[0]);
                aDoctor.DoctorName = aDataReader[1].ToString();

                aList.Add(aDoctor);
            }
            aDataReader.Close();
            aSqlConnection.Close();
            return aList;
        }