예제 #1
0
    protected void Import(DataSet SpreadsheetTables)
    {
        foreach (DataTable Table in SpreadsheetTables.Tables)
        {
            if (Table.TableName == "Seizures$")
            {
                SeizureManager sm = new SeizureManager();
                foreach (DataRow Row in Table.Rows)
                {
                    if (!String.IsNullOrWhiteSpace(Row[0].ToString()) || !String.IsNullOrWhiteSpace(Row[1].ToString()))
                    {
                        Seizure s = new Seizure();
                        Int32.TryParse(Row[0].ToString(), out s.seizureId);
                        Int32.TryParse(Row[1].ToString(), out s.patientId);

                        DateTime dateTime = DateTime.Parse(Row[2].ToString());
                        s.assessDate = dateTime.ToString("MM/dd/yyyy");
                        Int32.TryParse(Row[3].ToString(), out s.frequency);
                        if (String.IsNullOrEmpty(Row[4].ToString()))
                        {
                            s.episode = 0;
                        }
                        else
                        {
                            Int32.TryParse(Row[4].ToString(), out s.episode);
                        }

                        if (String.IsNullOrEmpty(Row[5].ToString()))
                        {
                            s.confidence = 0;
                        }
                        else
                        {
                            Int32.TryParse(Row[5].ToString(), out s.confidence);
                        }

                        sm.Save(s);
                    }
                }
            }
            else if (Table.TableName == "Meds$")
            {
                PrescriptionManager pm = new PrescriptionManager();
                foreach (DataRow Row in Table.Rows)
                {
                    if (!String.IsNullOrWhiteSpace(Row[0].ToString()) || !String.IsNullOrWhiteSpace(Row[1].ToString()))
                    {
                        Prescription p = new Prescription();

                        Int32.TryParse(Row[0].ToString(), out p.prescriptionId);
                        Int32.TryParse(Row[1].ToString(), out p.patientId);
                        float.TryParse(Row[2].ToString(), out p.dose);
                        p.unit      = Row[3].ToString();
                        p.frequency = Row[4].ToString();
                        p.medName   = Row[5].ToString();
                        DateTime dt = DateTime.Parse(Row[6].ToString());
                        p.assessDate = dt.ToString("MM/dd/yyyy");
                        Int32.TryParse(Row[7].ToString(), out p.noMedications);

                        pm.Save(p);
                        // Debug.WriteLine("adding meds " + Row[0].ToString() + " " + Row[1].ToString());
                    }
                }
            }
            else if (Table.TableName == "Surgery$")
            {
                SurgeryManager surm = new SurgeryManager();
                foreach (DataRow Row in Table.Rows)
                {
                    if (!String.IsNullOrWhiteSpace(Row[0].ToString()) || !String.IsNullOrWhiteSpace(Row[1].ToString()))
                    {
                        Surgery s = new Surgery();

                        Int32.TryParse(Row[0].ToString(), out s.surgeryId);
                        Int32.TryParse(Row[1].ToString(), out s.patientId);
                        DateTime dateTime = DateTime.Parse(Row[2].ToString());
                        s.surgeryDate = dateTime.ToString("MM/dd/yyyy");
                        s.surgeryType = Row[3].ToString();

                        surm.Save(s);
                        //Debug.WriteLine("adding surgery " + Row[0].ToString() + " " + Row[1].ToString());
                    }
                }
            }
            else
            {
                throw new ApplicationException("Invalid Worksheet Name: Only Seizures, Meds and Surgery");
            }
        }
    }
예제 #2
0
    // public PixelPerfectCamera ppc;

    private void Awake()
    {
        Instance = this;
    }
예제 #3
0
    protected void Page_Load(object sender, EventArgs e)
    {
        String[] Meds = new String[] { "Med1", "Med2", "Med3" };

        string json2 = Newtonsoft.Json.JsonConvert.SerializeObject(Meds);

        HiddenField jsonField2 = new HiddenField {
            ID = "data2"
        };

        jsonField2.Value = json2;
        this.Controls.Add(jsonField2);

        DBManager dbman = new DBManager();

        String[] datelist = dbman.getDatesByPatientId(1);


        List <string[]> timeline = new List <string[]>();

        for (int i = 0; i < datelist.Length; i++)
        {
            string[] x = new string[2];
            x[0] = i.ToString();
            x[1] = Utility.ConvertDateToAus(datelist[i]);
            timeline.Add(x);
        }


        SeizureManager seizureman = new SeizureManager();

        List <Seizure> lseizure = seizureman.FetchByPatientId(1);

        List <string[]> stimeline = new List <string[]>();

        List <string[]> badnesstimeline = new List <string[]>();

        List <string[]> eptimeline = new List <string[]>();

        for (int i = 0; i < lseizure.Count; i++)
        {
            string[] x = new string[2];
            x[1] = lseizure[i].frequency.ToString();
            x[0] = Utility.GetDateIndex(timeline, lseizure[i].assessDate);

            stimeline.Add(x);

            string[] y = new string[2];

            y[0] = Utility.GetDateIndex(timeline, lseizure[i].assessDate);

            switch (lseizure[i].episode.ToString())
            {
            case "0":
                y[1] = "Nocturnal";
                break;

            case "1":
                y[1] = "Not disabling";
                break;

            case "2":
                y[1] = "Not disabling";
                break;

            case "3":
                y[1] = "Short brief disabling";
                break;

            case "4":
                y[1] = "Short brief disabling";
                break;

            case "5":
                y[1] = "Convulsion";
                break;

            case "6":
                y[1] = "Convulsion";
                break;
            }

            eptimeline.Add(y);

            string[] z = new string[2];

            z[0] = Utility.GetDateIndex(timeline, lseizure[i].assessDate);

            switch (lseizure[i].confidence.ToString())
            {
            case "0":
                z[1] = "Definetly not an epilpetic seizure";
                break;

            case "1":
                z[1] = "Unsure if epileptic";
                break;

            case "2":
                z[1] = "Unsure if epileptic";
                break;

            case "3":
                z[1] = "Posibbilty epilepsti";
                break;

            case "4":
                z[1] = "Posibbilty epilepsti";
                break;

            case "5":
                z[1] = "Epileptic seizure";
                break;
            }

            badnesstimeline.Add(z);
        }


        PrescriptionManager psc        = new PrescriptionManager();
        List <Prescription> pscPatient = psc.FetchByPatientId(1);

        List <string[]> pscLine = new List <string[]>();

        for (int i = 0; i < pscPatient.Count; i++)
        {
            string[] x = new string[2];
            x[1] = Convert.ToString(0.5);
            x[0] = Utility.GetDateIndex(timeline, pscPatient[i].assessDate);
            pscLine.Add(x);
        }


        SurgeryManager  surman          = new SurgeryManager();
        List <Surgery>  surgery         = surman.FetchByPatientId(1);
        List <String[]> surgeryTimeline = new List <String[]>();

        for (int i = 0; i < timeline.Count; i++)
        {
            String[] t = new String[2];

            for (int ii = 0; ii < surgery.Count; ii++)
            {
                if (timeline.ElementAt(i)[1].Equals(Utility.ConvertDateToAus(surgery[ii].surgeryDate)))
                {
                    t[0] = i + "";
                    t[1] = "7";
                }
                else if (i == 10)
                {
                    t[0] = i + "";
                    t[1] = "7";
                }
                else
                {
                    t[0] = i + "";
                    t[1] = "0";
                }
            }

            surgeryTimeline.Add(t);
        }

        string jsonsurgeryTimeline = Newtonsoft.Json.JsonConvert.SerializeObject(surgeryTimeline);

        HiddenField jsonFieldsurgeryTimeline = new HiddenField {
            ID = "dataSurgery"
        };

        jsonFieldsurgeryTimeline.Value = jsonsurgeryTimeline;
        this.Controls.Add(jsonFieldsurgeryTimeline);

        string jsonmed = Newtonsoft.Json.JsonConvert.SerializeObject(pscLine);

        HiddenField jsonMedField = new HiddenField {
            ID = "meddata"
        };

        jsonMedField.Value = jsonmed;
        this.Controls.Add(jsonMedField);

        string jsonepisode = Newtonsoft.Json.JsonConvert.SerializeObject(eptimeline);

        HiddenField episodeField = new HiddenField {
            ID = "dataepisode"
        };

        episodeField.Value = jsonepisode;
        this.Controls.Add(episodeField);

        string json = Newtonsoft.Json.JsonConvert.SerializeObject(stimeline);

        HiddenField jsonField = new HiddenField {
            ID = "data"
        };

        jsonField.Value = json;
        this.Controls.Add(jsonField);

        string jsonbadness = Newtonsoft.Json.JsonConvert.SerializeObject(badnesstimeline);

        HiddenField badnessField = new HiddenField {
            ID = "databadness"
        };

        badnessField.Value = jsonbadness;
        this.Controls.Add(badnessField);


        string json5 = Newtonsoft.Json.JsonConvert.SerializeObject(timeline);

        HiddenField jsonField5 = new HiddenField {
            ID = "data5"
        };

        jsonField5.Value = json5;
        this.Controls.Add(jsonField5);
    }