private static List <DbStudy> GetStudiesForCase(string caseid)
{
List <DbStudy> studies = new List <DbStudy>();
APetaPoco.SetConnectionString("cn1");
var bm = APetaPoco.PpRetrieveList <DbStudy>("Studies", string.Format("[case_id] = '{0}'", caseid));
if (bm.Success)
{
studies = (List <DbStudy>)bm.Data;
foreach (var s in studies)
{
bm = APetaPoco.PpRetrieveList <DbSeries>("Series", string.Format("[case_id] = '{0}' AND [study_uid] = '{1}'", caseid, s.study_uid));
if (bm.Success)
{
var series = (List <DbSeries>)bm.Data;
s.series = series;
}
}
return(studies);
}
else
{
return(null);
}
}
static void Debug()
{
//AUP.UploadZip("44186", "47777", @"d:\temp\1.3.12.2.1107.5.1.4.65115.3000001603240736279390001264491.zip", "henryknipe", "20160411091821_henryknipe", "1.3.12.2.1107.5.8.9.13.26.65.26.126.218.77882191");
APetaPoco.SetConnectionString("cn1");
var bm = APetaPoco.PpRetrieveOne <DbCase>("Cases", "[case_id] = '20160607180814_frank'");
var pcase = (DbCase)bm.Data;
bm = APetaPoco.PpRetrieveList <DbStudy>("Studies", "[case_id] = '20160607180814_frank'");
pcase.study_list = (List <DbStudy>)bm.Data;
foreach (var st in pcase.study_list)
{
bm = APetaPoco.PpRetrieveList <DbSeries>("Series", "[case_id] = '20160607180814_frank' AND [study_uid] = '" + st.study_uid + "'");
st.series = (List <DbSeries>)bm.Data;
//ADCM.DownloadStudy(st);
LOG.Write("Converting DCM to PNG...");
AIMG.MultiFrameProcess(st);
bool convertComplete = AIMG.ConvertDcmToPng(st);
//if (!convertComplete)
//{
// ACASE.ClearCaseFiles(pcase);
// throw new Exception("Unable to convert study to PNG");
//}
LOG.Write("Completed image conversion");
LOG.Write("Optimizing PNG's for study...");
AIMG.OptiPng(st);
LOG.Write("Completed optimization.");
//AIMG.ZipSeries(st);
}
//ACASE.ProcessCase(pcase);
}
public static CFG GetConfigData()
{
CFG cfg = new CFG();
cfg.ConnectionString = ConfigurationManager.ConnectionStrings["cn1"].ToString();
if (!string.IsNullOrEmpty(cfg.ConnectionString))
{
APetaPoco.SetConnectionString("cn1");
cfg.SiteApi = GetSiteApiDetails();
var bm = APetaPoco.PpRetrieveList <Node>("PACS");
if (bm.Success)
{
cfg.Nodes = (List <Node>)bm.Data;
}
}
return(cfg);
}
public static List <DbCase> GetPendingCases()
{
APetaPoco.SetConnectionString("cn1");
var bm = APetaPoco.PpRetrieveList <DbCase>("Cases", "[Status] = 'PENDING'");
if (bm.Success)
{
var list = (List <DbCase>)bm.Data;
foreach (var c in list)
{
c.study_list = GetStudiesForCase(c.case_id);
}
return(list);
}
else
{
return(null);
}
}
private static DbStudy GetStudy(string condition)
{
APetaPoco.SetConnectionString("cn1");
var bm = APetaPoco.PpRetrieveOne <DbStudy>("Studies", condition);
if (!bm.Success)
{
throw new Exception("Unable to get Study based on condition: " + condition);
}
var dbs = (DbStudy)bm.Data;
bm = APetaPoco.PpRetrieveList <DbSeries>("Series", condition);
if (bm.Success)
{
var series = (List <DbSeries>)bm.Data;
dbs.series = series;
}
return(dbs);
}
