//send another symptom and execute correct desease

        public IHttpActionResult SendanotherSym(idnum idnum)
        {
            string item1;



            if (idnum.id1 == null)
            {
                item1 = "";
            }
            else
            {
                item1 = idnum.id1.ToString();
            }



            string query = "EXEC [dbo].[correctdis]'" + item1 + "'";

            DataTable    Names = connectionProvider.LoadSomething(query);
            List <idnum> items = new List <idnum>();

            foreach (DataRow item in Names.Rows)
            {
                idnum data = new idnum();

                data.id1 = item["DiseaseName"].ToString();



                items.Add(data);
            }

            return(Ok(items));
        }
        //post method to send desease and get doctors

        public IHttpActionResult getDoctor(idnum idnum)
        {
            string item1;



            if (idnum.id1 == null)
            {
                item1 = "";
            }
            else
            {
                item1 = idnum.id1.ToString();
            }



            string query = "EXEC [dbo].[Load_Doctor]'" + item1 + "'EXEC [dbo].[report]'" + item1 + "'";

            DataTable    Names = connectionProvider.LoadSomething(query);
            List <idnum> items = new List <idnum>();

            foreach (DataRow item in Names.Rows)
            {
                idnum data = new idnum();

                data.id1 = item["Doctor"].ToString();


                items.Add(data);
            }

            return(Ok(items));
        }
        //post method to send symptoms and get dsease
        public IHttpActionResult SendSym(idnum idnum)
        {
            string item1;
            string item2;
            string item3;
            string item4;

            {
            }
            if (idnum.id1 == null)
            {
                item1 = "";
            }
            else
            {
                item1 = idnum.id1.ToString();
            }
            if (idnum.id2 == null)
            {
                item2 = "";
            }
            else
            {
                item2 = idnum.id2.ToString();
            }
            if (idnum.id3 == null)
            {
                item3 = "";
            }
            else
            {
                item3 = idnum.id3.ToString();
            }
            if (idnum.id4 == null)
            {
                item4 = "";
            }
            else
            {
                item4 = idnum.id4.ToString();
            }


            string query = "EXEC [dbo].[Diseasesp1]'" + item1 + "','" + item2 + "','" + item3 + "','" + item4 + "'";

            DataTable    Names = connectionProvider.LoadSomething(query);
            List <idnum> items = new List <idnum>();

            foreach (DataRow item in Names.Rows)
            {
                idnum data = new idnum();
                if (item.ItemArray.Length == 2)
                {
                    data.id1 = item["DiseaseName"].ToString();
                    data.id2 = item["DiseaseName"].ToString();
                }
                else
                {
                    data.id1 = item["DiseaseName"].ToString();
                }


                items.Add(data);
            }

            return(Ok(items));
        }