public static void MapFromModel(this ICD10Code entity, ICD10CodeModel model)
{
entity.ICD10CodeId = model.ICD10CodeId;
entity.Text = model.Text;
entity.CreatedOn = model.CreatedOn;
entity.ModifiedOn = model.ModifiedOn;
}
public static ICD10CodeModel ToModel(this ICD10Code entity)
{
return(new ICD10CodeModel
{
ICD10CodeId = entity.ICD10CodeId,
Text = entity.Text,
CreatedOn = entity.CreatedOn,
ModifiedOn = entity.ModifiedOn
});
}
/// <summary>
/// Takes an EF Core Entity and maps the model to it
/// </summary>
/// <param name="model"></param>
/// <param name="entity"></param>
/// <returns></returns>
public static void MapFromModel(this IntakeForm entity, IntakeFormModel model)
{
if (entity == null)
{
entity = new IntakeForm();
}
//IntakeFormId = model.IntakeFormId don't map primary key from the model
entity.PatientId = model.PatientId;
entity.PhysicianId = model.PhysicianId;
entity.DocumentId = model.DocumentId;
entity.Status = model.Status;
entity.IntakeFormType = model.IntakeFormType;
entity.Product = model.Product;
entity.PhysicianNotes = model.PhysicianNotes;
entity.Duration = model.Duration;
entity.PhysicianPaid = model.PhysicianPaid;
entity.VendorBilled = model.VendorBilled;
entity.VendorPaid = model.VendorPaid;
entity.DeniedReason = model.DeniedReason;
entity.HCPCSCode = model.HCPCSCode;
entity.CreatedOn = model.CreatedOn;
entity.ModifiedOn = model.ModifiedOn;
if (entity.Questions == null)
{
entity.Questions = new List <Question>();
}
entity.Questions = model.Questions?.Select(questionsModel =>
{
var question = new Question();
question.MapFromModel(questionsModel, entity.IntakeFormId);
return(question);
}).ToList();
if (entity.ICD10Codes == null)
{
entity.ICD10Codes = new List <ICD10Code>();
}
entity.ICD10Codes = model.ICD10Codes?.Select(iCD10CodeModel =>
{
var icd10Code = new ICD10Code();
icd10Code.MapFromModel(iCD10CodeModel);
return(icd10Code);
}).ToList();
}
public static void ReadCsvIntoDatabase(IHostingEnvironment appEnvironment,
ICD10DbContext dbContext)
{
if (dbContext.Codes.Any())
{
return;
}
var rootDirectory = appEnvironment.ContentRootPath;
var csvFile = File.OpenRead(Path.Join(rootDirectory, "Data/CSV/codes.csv"));
TextReader textReader = new StreamReader(csvFile);
var csv = new CsvReader(textReader);
ConfigureCSVReader(csv);
try
{
var records = csv.GetRecords <dynamic>().ToList();
foreach (var r in records)
{
if ((records.IndexOf(r)) == 0)
{
continue;
}
var record = new Dictionary <string, object>(r);
var code = new ICD10Code();
string categoryCode = (string)record["Category Code"];
var dbCategory = dbContext.Categories.FirstOrDefault(c => c.Code.Equals(categoryCode));
code.Category = dbCategory;
code.DiagnosisCode = (string)record["Diagnosis Code"];
code.AbbreviatedDescription = (string)record["Abbreviated Description"];
code.FullDescription = (string)record["Full Description"];
dbContext.Codes.Add(code);
}
dbContext.SaveChanges();
}
catch (Exception ex)
{
Console.WriteLine(ex.Message);
}
}
