public static void RunListTest()
{
try
{
icdData = DataUtility.ReadFeedDataFileLines(@"F:\MyPKSolutions\TEST\IMEDEX\TestFiles\ICDData.txt");
System.Console.WriteLine("Contents of ICDData = ");
foreach (string line in icdData)
{
// Use a tab to indent each line of the file.
//Console.WriteLine("\t" + line);
Console.WriteLine(line);
}
ndcData = DataUtility.ReadFeedDataFileLines(@"F:\MyPKSolutions\TEST\IMEDEX\TestFiles\NDCData.txt");
List <string> ndcColumnNames = new List <string>()
{
"PA", "NDC", "AMT"
};
List <InputPatientNDC> ndcDataList = IMedXUtility.PrepareNDCEntries(ndcData, ndcColumnNames);
foreach (string line in ndcData)
{
// Use a tab to indent each line of the file.
//Console.WriteLine("\t" + line);
Console.WriteLine(line);
}
}
catch (Exception ex)
{
throw ex;
}
}
public static List <InputPatientNDC> GetPatientNDCDataList()
{
try
{
ndcData = DataUtility.ReadFeedDataFileLines(@"F:\MyPKSolutions\TEST\IMEDEX\TestFiles\NDCData.txt");
List <string> ndcColumnNames = new List <string>()
{
"PA", "NDC", "AMT"
};
List <InputPatientNDC> patientNDCDataList = IMedXUtility.PrepareNDCEntries(ndcData, ndcColumnNames);
return(patientNDCDataList);
}
catch (Exception ex)
{
throw ex;
}
}
public static List <InputPatientICD> GetPatientICDDataList()
{
try
{
icdData = DataUtility.ReadFeedDataFileLines(@"F:\MyPKSolutions\TEST\IMEDEX\TestFiles\ICDData.txt");
List <string> icdColumnNames = new List <string>()
{
"PA", "DOC", "ICD"
};
List <InputPatientICD> patientICDDataList = IMedXUtility.PrepareICDEntries(icdData, icdColumnNames);
return(patientICDDataList);
}
catch (Exception ex)
{
throw ex;
}
}
public IActionResult GetPatientDataCurrent([FromBody] InputRequestData reqData)
{
List <IMedXPatientData> patientdata = new List <IMedXPatientData>();
try
{
List <InputPatientICD> inputPatientICD = IMedXUtility.PrepareICDEntries(reqData.icdFeedData, reqData.icdColumnNames);
List <InputPatientNDC> inputPatientNDC = IMedXUtility.PrepareNDCEntries(reqData.ndcFeedData, reqData.ndcColumnNames);
patientdata = IMedXUtility.MergePatientData(inputPatientICD, inputPatientNDC);
return(Ok(patientdata));
}
catch (Exception ex)
{
return(BadRequest(ex.Message));
}
}
public static void RunDataTableTest()
{
List <string> icdData = DataUtility.ReadFeedDataFileLines(@"F:\MyPKSolutions\TEST\IMEDEX\TestFiles\ICDData.txt");
List <string> icdColumnNames = new List <string>()
{
"PA", "DOC", "ICD"
};
DataTable icdDataTab = DataUtility.BuildDataTableForTabbedData(icdData, "ICDCodes", icdColumnNames);
Console.WriteLine("The ICD Data in the table is as below");
Console.WriteLine("PA\tDOC\tICD");
for (int i = 0; i < icdDataTab.Rows.Count; i++)
{
DataRow dr = icdDataTab.Rows[i];
Console.WriteLine("{0}\t{1}\t{2}", dr["PA"], dr["DOC"], dr["ICD"]);
}
List <string> ndcData = DataUtility.ReadFeedDataFileLines(@"F:\MyPKSolutions\TEST\IMEDEX\TestFiles\NDCData.txt");
System.Console.WriteLine("Contents of NDCData ");
foreach (string line in ndcData)
{
// Use a tab to indent each line of the file.
//Console.WriteLine("\t" + line);
Console.WriteLine(line);
}
List <string> ndcColumnNames = new List <string>()
{
"PA", "NDC", "AMT"
};
//DataTable ndcDataTab = DataUtility.BuildDataTableForDelimitedData(ndcData, "NDCCodes", ndcColumnNames);
DataTable ndcDataTab = IMedXUtility.PrepareNDCDataTable(ndcData, ndcColumnNames);
Console.WriteLine("The NDC Data in the table is as below");
Console.WriteLine("MEM\tNDC\tAMT");
for (int i = 0; i < ndcDataTab.Rows.Count; i++)
{
DataRow dr = ndcDataTab.Rows[i];
Console.WriteLine("{0}\t{1}\t{2}", dr[0], dr[1], dr[2]);
}
}
static void Main(string[] args)
{
try
{
List <InputPatientICD> inputICDList = IMedXListTest.GetPatientICDDataList();
foreach (InputPatientICD p in inputICDList)
{
Console.WriteLine("{0}\t{1}\t{2}", p.PA, p.DOC, p.ICD);
}
List <InputPatientNDC> inputNDCList = IMedXListTest.GetPatientNDCDataList();
foreach (InputPatientNDC p in inputNDCList)
{
Console.WriteLine("{0}\t{1}\t{2}", p.PA, p.NDC, p.AMT);
}
List <IMedXModels.Input.IMedXPatientData> patientData = IMedXUtility.MergePatientData(inputICDList, inputNDCList);
foreach (var x in patientData)
{
Console.WriteLine("{0}\t{1}\t{2}\t{3}\t{4}", x.PA, x.DOC, x.ICD, x.NDC, x.AMT);
}
DataTable patdt = IMedXUtility.MakePatientDataTable(patientData);
string dataConnection = "Server=.\\SQLEXPRESS;Database=IMedXHR;Trusted_Connection=True";
List <string> patientDataColumns = new List <string>()
{
"PA", "DOC", "ICD", "NDC", "AMT", "CreatedDate"
};
DBConnectify.InsertBulk(patdt, dataConnection, "IMedXPatientData", patientDataColumns, patientDataColumns);
}
catch (Exception ex)
{
Console.WriteLine("Error: " + ex.Message);
}
Console.WriteLine("Press any key to exit.");
System.Console.ReadKey();
}
