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); } }