public HealthAssessmentHeaderEditModel GetModel(long eventId, long customerId)
{
var eventData = _eventRepository.GetById(eventId);
var customer = _customerRepository.GetCustomer(customerId);
var eventCustomer = _eventCustomerRepository.Get(eventId, customerId);
var pcp = _primaryCarePhysicianRepository.Get(customerId);
var physicianName = string.Empty;
if (pcp != null && pcp.Name != null)
{
physicianName = pcp.Name.FullName;
}
var participationConsent = new ParticipationConsentModel();
var participationConsentMediaLocation = _mediaRepository.GetParticipationConsentSignatureLocation(eventId, customerId);
var participationConsentSignature = _participationConsentSignatureRepository.GetByEventCustomerId(eventCustomer.Id);
if (participationConsentSignature != null)
{
var signatureFileIds = new[] { participationConsentSignature.SignatureFileId, participationConsentSignature.InsuranceSignatureFileId };
var signatureFiles = _fileRepository.GetByIds(signatureFileIds);
var participationSignatreFile = signatureFiles.First(x => x.Id == participationConsentSignature.SignatureFileId);
participationConsent.SignatureImageUrl = participationConsentMediaLocation.Url + participationSignatreFile.Path;
participationConsent.ConsentSignedDate = participationConsentSignature.ConsentSignedDate.ToString("MM/dd/yyyy");
var insuranceSignatureFile = signatureFiles.First(x => x.Id == participationConsentSignature.InsuranceSignatureFileId);
participationConsent.InsuranceSignatureImageUrl = participationConsentMediaLocation.Url + insuranceSignatureFile.Path;
participationConsent.InsuranceConsentSignedDate = participationConsentSignature.InsuranceConsentSignedDate.ToString("MM/dd/yyyy");
}
return(new HealthAssessmentHeaderEditModel
{
CustomerId = customer.CustomerId,
CustomerName = customer.Name,
DateofBirth = customer.DateOfBirth,
EventDate = eventData.EventDate,
EventId = eventData.Id,
PhysicianName = physicianName,
ParticipationConsent = participationConsent
});
}
public static void Import_Consents(string connectionString, SessionSecurityTicket securityTicket)
{
string folder = Directory.GetParent(Directory.GetCurrentDirectory()).Parent.FullName;
string filePath = Path.Combine(folder, "Excel\\consents.xlsx");
bool hasHeader = true;
IFormatProvider culture = new System.Globalization.CultureInfo("de", true);
DataTable excelData = null;
Console.WriteLine("Loading data from excel...");
try
{
excelData = ExcelUtils.getDataFromExcelFileMM(filePath, hasHeader);
}
catch (Exception ex)
{
filePath = Path.Combine(folder, "Excel\\consents.xls");
excelData = ExcelUtils.getDataFromExcelFileMM(filePath, hasHeader);
}
List <ParticipationConsentModel> consents = new List <ParticipationConsentModel>();
int i = 1;
Console.WriteLine();
try
{
foreach (System.Data.DataRow item in excelData.Rows)
{
ParticipationConsentModel consent = new ParticipationConsentModel();
#region consent
consent.insurance_id = (string)item.ItemArray[0];
consent.bsnr = (string)item.ItemArray[1];
consent.start_date = DateTime.Parse((string)item.ItemArray[2]);
consent.isValid = true;
#endregion
consents.Add(consent);
Console.Write("\rConsent {0} of {1} validated.", i++, excelData.Rows.Count);
}
}
catch (Exception ex)
{
Console.Clear();
Console.Write(ex.StackTrace);
}
string file = ExportConsentsBeforeUpload.ExportConsentsBeforeUploadToDB(consents);
MemoryStream ms = new MemoryStream(File.ReadAllBytes(file));
Console.WriteLine("----- XLS created.");
if (consents.Any(vl => !vl.isValid))
{
Console.WriteLine("Data not valid, won't be saved.");
}
else
{
cls_Add_Consents_to_Patients.Invoke(connectionString, new P_PA_ACtP_1452()
{
consents = consents.Select(c =>
{
return(new P_PA_ACtP_1452a()
{
bsnr = c.bsnr,
insurance_id = c.insurance_id,
start_date = c.start_date
});
}).ToArray()
}, securityTicket);
}
}
