public CheckupLabResult ByGetCheckupLab(string hn, DateTime startDate, DateTime endDate, string enCurrent = "")//add enCurrent suriya 30/06/2017
{
try
{
string enHomer = string.Empty;//add suriya 30/06/2017
using (Service.WS_TrakcareCls ws = new Service.WS_TrakcareCls())
{
//add suriya 30/06/2017
if (enCurrent.ToUpper().Contains("I"))
{
DataTable ENDetails = ws.GetEPIRowIDByEN(enCurrent);
enHomer = ENDetails.Rows[0]["PAADM_HomerID"].ToString();
}
System.Threading.Thread.CurrentThread.CurrentCulture
= System.Globalization.CultureInfo.CreateSpecificCulture("en-US");
//end suriya 30/06/2017
var RawMateWS = ws.GetCheckupLab(hn, startDate.ToString("yyyy-MM-dd"), endDate.ToString("yyyy-MM-dd")).AsEnumerable();
// var RawMateWS = ws.GetCheckupLab(hn, "2018-02-01", endDate.ToString("yyyy-MM-dd")).AsEnumerable();
var RawMateGroups = RawMateWS.Where(x => x.Field <string>("EPI_NO").Split(new string[] { "," }, StringSplitOptions.RemoveEmptyEntries).Count() > 0)
.GroupBy(x => x.Field <string>("EPI_NO").Split(new string[] { "," }, StringSplitOptions.RemoveEmptyEntries)[0]).ToList();
var result = ws.GetPTInfoByHN(hn).AsEnumerable()
.Select(x => new CheckupLabResult
{
hn = hn,
sex = x.Field <string>("CTSEX_Code"),
dob = x.Field <DateTime>("PAPMI_DOB")
}).FirstOrDefault();
if (result != null)
{
using (InhCheckupDataContext cdc = new InhCheckupDataContext())
{
//var DateRaw = RawMateGroups.Select(z => z.Field<string>("EPIVISDateOfCollection") );
result.episodes = RawMateGroups.Select(x => new Episode
{
//en = x.Key, del suriya 30/06/2017
en = enHomer == x.Key ? enCurrent : x.Key, //add suriya 30/06/2017
//labdates = x.GroupBy(y => new DateTime(
// Convert.ToInt32( y.Field<string>("EPIVISDateOfCollection").Substring(0, 4) ),
// Convert.ToInt32( y.Field<string>("EPIVISDateOfCollection").Substring(5, 2) ),
// Convert.ToInt32( y.Field<string>("EPIVISDateOfCollection").Substring(8, 2) ) )
//2017-07-19
// change EPIVISDateOfCollection -> DTE_OF_RCV artist.su 24/08/2017
//labdates = x.GroupBy(y => new DateTime(
// Convert.ToInt32(y.Field<string>("DTE_OF_RCV").Substring(0, 4) == "1840" ? y.Field<string>("EPIVISDateOfCollection").Substring(0, 4) : y.Field<string>("DTE_OF_RCV").Substring(0, 4)),
// Convert.ToInt32(y.Field<string>("DTE_OF_RCV").Substring(0, 4) == "1840" ? y.Field<string>("EPIVISDateOfCollection").Substring(5, 2) : y.Field<string>("DTE_OF_RCV").Substring(5, 2)),
// Convert.ToInt32(y.Field<string>("DTE_OF_RCV").Substring(0, 4) == "1840" ? y.Field<string>("EPIVISDateOfCollection").Substring(8, 2) : y.Field<string>("DTE_OF_RCV").Substring(8, 2))
// )
// labdates = x.GroupBy(y => new DateTime(Convert.ToInt32("2017"), Convert.ToInt32("07"), Convert.ToInt32("19"))
//2017-10-30 labdate แก้ 1840 / lab ผิดพลาด
labdates = x.GroupBy(y => new DateTime(
Convert.ToInt32(y.Field <string>("VISTSDateOfReceive").Substring(0, 4)),
Convert.ToInt32(y.Field <string>("VISTSDateOfReceive").Substring(5, 2)),
Convert.ToInt32(y.Field <string>("VISTSDateOfReceive").Substring(8, 2)))
).Select(y => new LabDate
{
labdate = y.Key,
labs = (from lab in y
join mhs in new LabClass.MappingLocationCls().Mapping()
on lab.Field <string>("CTHOS_CDE") equals mhs.subcode into l
from m in l.DefaultIfEmpty()
select new Lab
{
rowid = lab.Field <string>("EPVISVisitNumber"),
age = lab.Field <string>("EPVIS_AGE") == null
? (int?)null
: !IsNumeric(lab.Field <string>("EPVIS_AGE"))
? (int?)null
: Convert.ToInt32(lab.Field <string>("EPVIS_AGE")),
headcode = lab.Field <string>("CTTS_CDE"),
headdesc = lab.Field <string>("CTTS_NME"),
code = lab.Field <string>("CTTC_CDE"),
labname = lab.Field <string>("CTTC_DES"),
//valuenumber = (string.IsNullOrWhiteSpace(lab.Field<string>("TST_DTA")) || string.IsNullOrEmpty(lab.Field<string>("TST_DTA"))) && string.IsNullOrEmpty(lab.Field<string>("VISTD_CMM"))
// ? null
// : string.IsNullOrEmpty(lab.Field<string>("VISTD_CMM")) == false ? lab.Field<string>("VISTD_CMM").Trim()
// : string.IsNullOrWhiteSpace(lab.Field<string>("TST_DTA")) || string.IsNullOrEmpty(lab.Field<string>("TST_DTA")) ? null
// : lab.Field<string>("TST_DTA").Trim().Substring(0, 1) == "."
// ? "0" + lab.Field<string>("TST_DTA").Trim()
// : lab.Field<string>("TST_DTA").Trim(),
// var tmbLength = tmbPlus < 1 && tmbDiv < 1 ? value.Length - 3 :
// tmbPlus > 1 ? value.Length - tmbPlus :
// tmbDiv > 1 ? value.Length - tmbDiv : value.Length - 3;
// var tmbReturn = value.Substring(3, tmbLength);
valuenumber = string.IsNullOrWhiteSpace(lab.Field <string>("TST_DTA")) || string.IsNullOrEmpty(lab.Field <string>("TST_DTA"))
? null
: lab.Field <string>("TST_DTA").Trim().Substring(0, 1) == "."
? "0" + lab.Field <string>("TST_DTA").Trim()
: lab.Field <string>("TST_DTA").Trim().Contains("<.")
? lab.Field <string>("TST_DTA").Trim().Replace("<.", "<0.")
: lab.Field <string>("TST_DTA").Trim().Contains(">.")
? lab.Field <string>("TST_DTA").Trim().Replace(">.", ">0.")
: lab.Field <string>("TST_DTA").Trim().Substring(0, 1).IsNormalized() == false
? lab.Field <string>("TST_DTA").Trim().Substring(1, lab.Field <string>("TST_DTA").Trim().Length - 1)
: lab.Field <string>("TST_DTA").Trim(),
valuestring = lab.Field <string>("RSL") == null && lab.Field <string>("TST_DTA") == null
? null
: string.IsNullOrEmpty(lab.Field <string>("RSL")) == false ? lab.Field <string>("RSL").Trim()
: string.IsNullOrEmpty(lab.Field <string>("TST_DTA")) == false ? lab.Field <string>("TST_DTA").Trim()
: string.IsNullOrEmpty(lab.Field <string>("RSL")) ? null
: lab.Field <string>("RSL").Trim(),
unit = lab.Field <string>("CTTC_UNT"),
range = lab.Field <string>("NML"),
hl = lab.Field <string>("HL") == "H" ? 1 : lab.Field <string>("HL") == "L" ? -1 : 0,
frs = lab.Field <string>("CTTC_RSL_FMT") == null ? -1
: lab.Field <string>("CTTC_RSL_FMT").Contains("N") ? 1
: lab.Field <string>("CTTC_RSL_FMT") == "S" ? 2
: lab.Field <string>("CTTC_RSL_FMT") == "X" ? 0
: -1,
seq = lab.Field <string>("Sequen") == null || lab.Field <string>("Sequen") == ""
? (int?)null
: !IsNumeric(lab.Field <string>("Sequen")) ? (int?)null
: Convert.ToInt32(lab.Field <string>("Sequen")),
location = lab.Field <string>("CTHOS_CDE"),
status = lab.Field <string>("Status") == "Executed" ? 'E'
: lab.Field <string>("Status") == "D/C (Discontinued)" ? 'D'
: 'I',
mhs_id = m == null ? (int?)null : m.mainid,
mhs_ename = m == null ? null : m.maindesc,
mhs_tname = m == null ? null : m.maindesc
}).ToList()
}).ToList()
}).ToList();
}
}
return(result);
}
}
catch (Exception ex)
{
Class.globalCls.MessageError("GetCheckupLabCls", "ByGetCheckupLab", ex.Message);
throw ex;
}
}
public bool GetInfo(int tpr_id)
{
try
{
using (InhCheckupDataContext cdc = new InhCheckupDataContext())
{
trn_patient_regi patient_regis = cdc.trn_patient_regis.Where(x => x.tpr_id == tpr_id).FirstOrDefault();
string hn = patient_regis.trn_patient.tpt_hn_no;
using (Service.WS_TrakcareCls ws_trak = new Service.WS_TrakcareCls())
{
var info = ws_trak.GetPTInfoByHN(hn).AsEnumerable()
.Select(x => new
{
PAPMI_No = x.Field <string>("PAPMI_No"),
PAPMI_DOB = x.Field <DateTime>("PAPMI_DOB"),
PAPMI_Name = x.Field <string>("PAPMI_Name"),
PAPMI_Name2 = x.Field <string>("PAPMI_Name2"),
PAPMI_Name3 = x.Field <string>("PAPMI_Name3"),
PAPMI_Name5 = x.Table.Columns.Contains("PAPMI_Name5") ? x.Field <string>("PAPMI_Name5") : "",
PAPMI_Name6 = x.Table.Columns.Contains("PAPMI_Name6") ? x.Field <string>("PAPMI_Name6") : "",
PAPMI_Name7 = x.Table.Columns.Contains("PAPMI_Name7") ? x.Field <string>("PAPMI_Name7") : "",
PAPER_PrefLanguage_DR = x.Field <int>("PAPER_PrefLanguage_DR"),
PAPER_AgeYr = x.Field <string>("PAPER_AgeYr"),
PAPER_AgeMth = x.Field <string>("PAPER_AgeMth"),
PAPER_AgeDay = x.Field <string>("PAPER_AgeDay"),
TTL_Desc = x.Field <string>("TTL_Desc"),
CTSEX_Code = x.Field <string>("CTSEX_Code"),
CTSEX_Desc = x.Field <string>("CTSEX_Desc"),
PAPMI_DOB1 = x.Field <DateTime>("PAPMI_DOB1"),
PAPMI_DOB_TEXT = x.Field <string>("papmi_dob_text"),
PAPER_StName = x.Field <string>("PAPER_StName"),
CTZIP_Code = x.Field <string>("CTZIP_Code"),
CTZIP_Desc = x.Field <string>("CTZIP_Desc"),
CTNAT_Desc = x.Field <string>("CTNAT_Desc"),
//addby Artist 18/01/2016
Area = x.Field <string>("Area"),
City = x.Field <string>("City"),
Province = x.Field <string>("Province")
}).FirstOrDefault();
string[] dobText = info.PAPMI_DOB_TEXT.Split('-');
string dobString = "";
if (dobText.Count() == 3)
{
dobString = dobText[2] + "/" + dobText[1] + "/" + dobText[0];
}
patient_regis.trn_patient.tpt_dob_text = dobString;
patient_regis.trn_patient.tpt_hn_no = info.PAPMI_No;
patient_regis.trn_patient.tpt_dob = info.PAPMI_DOB;
patient_regis.trn_patient.tpt_pre_name = info.TTL_Desc;
patient_regis.trn_patient.tpt_first_name = info.PAPMI_Name;
patient_regis.trn_patient.tpt_last_name = info.PAPMI_Name2;
patient_regis.trn_patient.tpt_gender = info.CTSEX_Code == "M" ? 'M' : 'F';
patient_regis.trn_patient.tpt_nation_desc = info.CTNAT_Desc;
//addby Artist 18/01/2016
patient_regis.tpr_main_address = info.PAPER_StName;
patient_regis.tpr_main_tumbon = info.Area;
patient_regis.tpr_main_amphur = info.City;
patient_regis.tpr_main_province = info.Province;
patient_regis.tpr_other_address = info.PAPER_StName;
patient_regis.tpr_other_tumbon = info.Area;
patient_regis.tpr_other_amphur = info.City;
patient_regis.tpr_other_province = info.Province;
//
patient_regis.tpr_main_zip_code = info.CTZIP_Code;
patient_regis.tpr_other_zip_code = info.CTZIP_Code;
patient_regis.trn_patient.tpt_en_name1 = info.PAPMI_Name5;
patient_regis.trn_patient.tpt_en_name2 = info.PAPMI_Name6;
patient_regis.trn_patient.tpt_en_name3 = info.PAPMI_Name7;
//update image add by m 08/05/2017 dd/mm/yyyy
patient_regis.trn_patient.tpt_image = new APITrakcare.GetPatientImageCls().GetImageByWS(info.PAPMI_No);
try
{
string tname = string.IsNullOrEmpty(info.TTL_Desc) ? "" : info.TTL_Desc.Trim();
string fname = string.IsNullOrEmpty(info.PAPMI_Name) ? "" : " " + info.PAPMI_Name.Trim();
string mname = string.IsNullOrEmpty(info.PAPMI_Name3) ? "" : " " + info.PAPMI_Name3.Trim();
string lname = string.IsNullOrEmpty(info.PAPMI_Name2) ? "" : " " + info.PAPMI_Name2.Trim();
string fullname = (tname + fname + mname + lname).Trim();
patient_regis.trn_patient.tpt_fullname = fullname;
patient_regis.trn_patient.tpt_othername = fullname;
}
catch (Exception ex)
{
try
{
string tname = string.IsNullOrEmpty(info.TTL_Desc) ? "" : info.TTL_Desc.Trim();
string fname = string.IsNullOrEmpty(info.PAPMI_Name) ? "" : " " + info.PAPMI_Name.Trim();
string lname = string.IsNullOrEmpty(info.PAPMI_Name2) ? "" : " " + info.PAPMI_Name2.Trim();
string fullname = (tname + fname + lname).Trim();
patient_regis.trn_patient.tpt_othername = fullname;
}
catch
{
}
Program.MessageError("GetDataFromTrakCare", "tpt_fullname", ex, false);
}
cdc.SubmitChanges();
}
}
return(true);
}
catch
{
}
return(false);
}