List <PatientAppointmentInsertGet> getPatientAppFutureData(PatientAppGetHistoryData data)
        {
            using (SqlConnection conn = new SqlConnection(Connection.ConnStr()))
            {
                //close it
                conn.Open();

                SqlDataAdapter adapter = new SqlDataAdapter();

                List <PatientAppointmentInsertGet> appList = new List <PatientAppointmentInsertGet>();

                DateTime now       = DateTime.Now;
                string   nowString = now.ToString("yyyy-MM-dd");
                string   Q         = "USE Hospitology;" +
                                     "SELECT d.last_name, h.patient_id,h.appointment_date,h.[description],h.[patient_pain] " +
                                     "FROM dbo.GP_Appointment_History h " +
                                     "FULL OUTER JOIN dbo.Doctors d ON d.id_doctor=h.doctor_id " +
                                     "WHERE patient_id=@PatientID and " +
                                     "(appointment_date >= @today)";

                adapter.SelectCommand = new SqlCommand(Q, conn);
                adapter.SelectCommand.Parameters.AddWithValue("@today", nowString);


                adapter.SelectCommand.Parameters.AddWithValue("@PatientID", data.PatientID);


                DataTable tb = new DataTable();

                adapter.Fill(tb);
                foreach (DataRow appItem in tb.Rows)
                {
                    PatientAppointmentInsertGet app = new PatientAppointmentInsertGet();
                    app.IDDoctor = appItem["last_name"].ToString();
                    DateTime appTime = Convert.ToDateTime(appItem["appointment_date"]);
                    app.appointment_date = appTime.ToString("dd-MM-yyyy HH:mm");
                    app.description      = appItem["description"].ToString();
                    app.patient_paint    = appItem["patient_pain"].ToString();

                    appList.Add(app);
                }
                return(appList);
            }
        }
        public JsonResult getPatientFutureApp(PatientAppGetHistoryData user)
        {
            List <PatientAppointmentInsertGet> future = getPatientAppFutureData(user);

            return(this.Json(future, JsonRequestBehavior.AllowGet));
        }
        public JsonResult getPatientAppHistory(PatientAppGetHistoryData user)
        {
            List <PatientAppointmentInsertGet> history = getPatientAppHistoryData(user);

            return(this.Json(history, JsonRequestBehavior.AllowGet));
        }