private DeathCertData putDeathCertData(DeathCertData deathCertData, string[] data)
 {
     deathCertData.seq        = Utils.getVal("seq", data, deathcertIndex);
     deathCertData.area       = Utils.getVal("area", data, deathcertIndex);
     deathCertData.province   = Utils.getVal("province", data, deathcertIndex);
     deathCertData.hospcode   = Utils.getVal("hospcode", data, deathcertIndex);
     deathCertData.hospname   = Utils.getVal("hospname", data, deathcertIndex);
     deathCertData.systemcode = Utils.getVal("systemcode", data, deathcertIndex);
     deathCertData.hn         = Utils.getVal("hn", data, deathcertIndex);
     deathCertData.prename    = Utils.getVal("prename", data, deathcertIndex);
     deathCertData.name       = Utils.getVal("name", data, deathcertIndex);
     deathCertData.surname    = Utils.getVal("surname", data, deathcertIndex);
     deathCertData.cid        = Utils.getVal("cid", data, deathcertIndex);
     deathCertData.gender     = Utils.getVal("gender", data, deathcertIndex);
     deathCertData.birthdate  = Utils.getVal("birthdate", data, deathcertIndex);
     deathCertData.age        = Utils.getVal("age", data, deathcertIndex).Replace("ปี", "").Trim();
     deathCertData.nonthai    = Utils.getVal("nonthai", data, deathcertIndex);
     deathCertData.nation     = Utils.getVal("nation", data, deathcertIndex);
     deathCertData.race       = Utils.getVal("race", data, deathcertIndex);
     deathCertData.deathdate  = Utils.getVal("deathdate", data, deathcertIndex);
     deathCertData.deathtime  = Utils.getVal("deathtime", data, deathcertIndex);
     deathCertData.checkdate  = Utils.getVal("checkdate", data, deathcertIndex);
     deathCertData.checktime  = Utils.getVal("checktime", data, deathcertIndex);
     deathCertData.deathcause = Utils.getVal("deathcause", data, deathcertIndex);
     deathCertData.deathcheck = Utils.getVal("deathcheck", data, deathcertIndex);
     return(deathCertData);
 }
        public void mergeDeathData(List <HealthCareData> deathFromHealthData, List <DeathCertData> deathFromDeathCertData, String exportFolder, System.Windows.Forms.RichTextBox statusTextBox)
        {
            this.statusTextBox          = statusTextBox;
            this.deathFromDeathCertData = deathFromDeathCertData;
            this.exportFolder           = exportFolder;
            cid_deathCertData.Clear();
            foreach (DeathCertData data in deathFromDeathCertData)
            {
                String cid = data.cid.Replace("-", "");

                if (!cid_deathCertData.ContainsKey(cid))
                {
                    cid_deathCertData.Add(cid, data);
                }

                if (!name_deathCertData.ContainsKey(data.name + data.surname))
                {
                    name_deathCertData.Add(data.name + data.surname, data);
                }
            }

            foreach (HealthCareData data in deathFromHealthData)
            {
                if (!cid_deathCertData.ContainsKey(data.cid) && !name_deathCertData.ContainsKey(data.name + data.lname))
                {
                    DeathCertData deathFromHealth = new DeathCertData();
                    deathFromHealth.seq        = data.seq;
                    deathFromHealth.area       = "-";
                    deathFromHealth.province   = "-";
                    deathFromHealth.hospcode   = data.hospcode;
                    deathFromHealth.hospname   = "-";
                    deathFromHealth.systemcode = "-";
                    deathFromHealth.hn         = data.pid;
                    deathFromHealth.prename    = data.prename;
                    deathFromHealth.name       = data.name;
                    deathFromHealth.surname    = data.lname;
                    deathFromHealth.cid        = data.cid;
                    deathFromHealth.gender     = data.sex;
                    deathFromHealth.birthdate  = data.birthdate;
                    deathFromHealth.age        = data.age_at_service + "";
                    deathFromHealth.nonthai    = "-";
                    deathFromHealth.nation     = "-";
                    deathFromHealth.race       = "-";
                    deathFromHealth.deathdate  = convertDateToDeathCert(data.date_serv);
                    deathFromHealth.deathtime  = convertTimeToDeathCert(data.time_serv);
                    deathFromHealth.checkdate  = "-";
                    deathFromHealth.checktime  = "-";
                    deathFromHealth.deathcause = data.icd10_external_cause;
                    deathFromHealth.deathcheck = data.icd10_external_cause;

                    deathFromDeathCertData.Add(deathFromHealth);
                    addtextLn(data.name + " " + data.lname);
                }
            }

            exportlinkData();
        }
        private void mappingData()
        {
            deathcertIndex = Utils.setupDataDic(deathCertHeader);

            for (int index = 0; index < deathList.Count; index++)
            {
                DeathCertData deathCertData = new DeathCertData();
                String        line          = deathList[index];
                string[]      data          = line.Split(',');
                deathCertData = putDeathCertData(deathCertData, data);
                deathcertlist.Add(deathCertData);
            }
        }
        private void filterDeathByTraffic()
        {
            DeathCertData deathCertData = null;

            for (int index = 0; index < deathcertlist.Count; index++)
            {
                deathCertData = deathcertlist[index];
                if (deathCertData.deathcheck.Equals("ตายโดยอุบัติเหตุจราจร"))
                {
                    deathTrafficlist.Add(deathCertData);
                }
            }
            addtextLn("Total DeathCert from Traffic Injury: " + deathTrafficlist.Count());
        }