public RecordFileSystem GetRecord(RecordFileSystem record)
{
RecordFileSystem result = new RecordFileSystem();
try
{
using (var context = new ApplicationContext())
{
var query = from pt in context.RecordFile
where pt.Id.Equals(record.Id) && pt.PatientId.Equals(record.PatientId)
select pt;
var medicalRecord = query.Select(p => p).FirstOrDefault();
//account found
if (medicalRecord != null)
{
result.FileContents = medicalRecord.FileContents;
}
}
}
catch (Exception err)
{
new LogHelper().LogMessage("PatientData.GetRecord : " + err);
}
return(result);
}
public int StoreRecordToDB(RecordFileSystem fileSystem, PatientRecordModel patientRecord)
{
var client = new RestClient(ConstantHelper.AppSettings.BackEndUrl);
RestRequest request = new RestRequest(ConstantHelper.API.PatientRecord.StoreRecordToDB, Method.POST);
request.RequestFormat = DataFormat.Json;
request.AddBody(fileSystem);
IRestResponse <int> response = client.Execute <int>(request);
int result = response.Data;
int secondResult = 0;
if (result != 0)
{
request = new RestRequest(ConstantHelper.API.Appointment.CloseAppointment, Method.POST);
request.RequestFormat = DataFormat.Json;
request.AddBody(patientRecord);
IRestResponse <int> response2 = client.Execute <int>(request);
secondResult = response.Data;
}
return(secondResult);
}
public ActionResult ViewRecord(string recordId, string patientId)
{
RecordFileSystem record = new RecordFileSystem();
record.Id = Guid.Parse(recordId);
record.PatientId = Guid.Parse(patientId);
PatientProcess process = new PatientProcess();
RecordFileSystem result = new RecordFileSystem();
result = process.GetRecord(record);
if (result != null)
{
if (result.FileContentsString != null)
{
result.FileContents = Convert.FromBase64String(result.FileContentsString);
FileContentResult fileResult = new FileContentResult(result.FileContents, ConstantHelper.AppSettings.RecordFileType);
return(fileResult);
}
return(new HttpNotFoundResult("Record Not Found!"));
}
else
{
return(new HttpNotFoundResult("Record Not Found!"));
}
}
public int StoreRecordToDB(RecordFileSystem fileSystem)
{
int result = 0;
PractitionerData data = new PractitionerData();
result = data.StoreRecordToDB(fileSystem);
return(result);
}
public int StoreRecordToDB(RecordFileSystem fileSystem)
{
int result = 0;
if (fileSystem != null)
{
PractitionerBusiness businessLayer = new PractitionerBusiness();
result = businessLayer.StoreRecordToDB(fileSystem);
}
return(result);
}
public RecordFileSystem GetRecord(RecordFileSystem record)
{
RecordFileSystem result = new RecordFileSystem();
if (record != null)
{
PractitionerBusiness businessLayer = new PractitionerBusiness();
result = businessLayer.GetRecord(record);
result.FileContents = null;
}
return(result);
}
public ActionResult NewPatientRecord(NewPatientRecordViewModel vm)
{
PractitionerProcess process = new PractitionerProcess();
vm.NewPatientRecord.MedicineDropDown = process.GetMedicinesDropDown(vm.PractitionerDetails);
var test = vm.NewPatientRecord.MedicineDropDown[vm.NewPatientRecord.MedicinesId1];
if ((vm.NewPatientRecord.AllergicBool.Equals("No")) || ((vm.NewPatientRecord.AllergicBool.Equals("Yes") && !String.IsNullOrEmpty(vm.NewPatientRecord.AllergicType))))
{
//Conversion to pdf
var viewToString = RenderViewToString(ControllerContext, "~/Views/Shared/RecordTemplate.cshtml", vm, false);
FileContentResult fileResult = new FileContentResult(PdfSharpConvert(viewToString), ConstantHelper.AppSettings.RecordFileType);
RecordFileSystem fileRecord = new RecordFileSystem();
fileRecord.Id = vm.NewPatientRecord.RecordId;
fileRecord.FileContents = fileResult.FileContents;
fileRecord.FileDownloadname = DateTime.Now.ToString("dd-MM-yyyy") + "-" + vm.PractitionerDetails.CompanyId + ".pdf";
//Continue call to API
vm.NewPatientRecord.CompanyId = vm.PractitionerDetails.CompanyId;
int returnResult = process.StoreRecordToDB(fileRecord, vm.NewPatientRecord);
if (returnResult != 0)
{
//return fileResult;
return(Content(@"<body>
<script type='text/javascript'>
if(confirm('Patient Record updated successfully. Press Ok to close current tab.')){ window.close(); window.opener.location.reload(); };
</script>
</body> "));
}
else
{
return(Content(@"<body>
<script type='text/javascript'>
if(confirm('Fail to insert record to database. Press ok to go back.')){ window.history.back(); };
</script>
</body> "));
}
}
else
{
//Stop, return error
return(Json(new { status = "Error", message = "Allergic selected is Yes. The textbox below it cannot be empty." }));
}
//return View(vm);
}
public RecordFileSystem GetRecord(RecordFileSystem record)
{
var client = new RestClient(ConstantHelper.AppSettings.BackEndUrl);
RestRequest request = new RestRequest(ConstantHelper.API.PatientRecord.PatientGetRecord, Method.POST);
request.RequestFormat = DataFormat.Json;
request.AddBody(record);
IRestResponse <RecordFileSystem> response = client.Execute <RecordFileSystem>(request);
RecordFileSystem result = new RecordFileSystem();
result = response.Data;
return(result);
}
public RecordFileSystem GetRecord(RecordFileSystem record)
{
PatientData dataLayer = new PatientData();
RecordFileSystem result = new RecordFileSystem();
result = dataLayer.GetRecord(record);
if (result != null)
{
if (result.FileContents != null)
{
result.FileContentsString = Convert.ToBase64String(result.FileContents);
}
}
return(result);
}
public RecordFileSystem GetRecord(RecordFileSystem record)
{
var client = new RestClient(ConstantHelper.AppSettings.BackEndUrl);
RestRequest request = new RestRequest(ConstantHelper.API.PatientRecord.PractitionerGetRecord, Method.POST);
request.RequestFormat = DataFormat.Json;
request.AddBody(record);
IRestResponse <RecordFileSystem> response = client.Execute <RecordFileSystem>(request);
//byte[] bytes = client.DownloadData(request);
RecordFileSystem result = new RecordFileSystem();
//result.FileContents = bytes;
result = response.Data;
return(result);
}
public NewPatientRecordViewModel CreateNewRecord(PatientRecordModel vm)
{
NewPatientRecordViewModel result = new NewPatientRecordViewModel();
PractitionerData practitionerData = new PractitionerData();
PatientData patientData = new PatientData();
//Retrieve practitioner and company information
PractitionerBaseViewModel practitionerId = new PractitionerBaseViewModel();
practitionerId.AccId = vm.PractitionerId;
result.PractitionerDetails = practitionerData.GetProfile(practitionerId);
// Retrieve patient information
result.PatientDetails = patientData.PatientProfile(vm.PatientId);
vm.CreatedOn = DateTime.UtcNow;
RecordFileSystem fileRecord = new RecordFileSystem();
fileRecord.ContentType = ConstantHelper.AppSettings.RecordFileType;
fileRecord.FileContents = new byte[1];
fileRecord.FileDownloadname = DateTime.Now.Date.ToString() + "-" + result.PractitionerDetails.CompanyId;
fileRecord.PatientId = result.PatientDetails.AccId;
fileRecord.PractitionerId = result.PractitionerDetails.AccId;
//Get medicines list in the company
result.NewPatientRecord = practitionerData.GetMedicinesList(result.PractitionerDetails.CompanyId);
result.NewPatientRecord.AppointmentId = vm.AppointmentId;
result.NewPatientRecord.PatientId = vm.PatientId;
result.NewPatientRecord.PractitionerId = vm.PractitionerId;
//Creating a record in the database
result.NewPatientRecord.RecordId = practitionerData.CreatePatientRecord(fileRecord);
return(result);
}
