// [Authorize]
public IHttpActionResult GetPatientbyID(int id)
{
tblPatients tblPatient = _patientRepository.GetPatientbyID(id);
if (tblPatient == null)
{
throw new ApiDataException(1002, "No patient found for this id.", HttpStatusCode.InternalServerError);
}
return(Ok(tblPatient));
}
public bool SendRefEMail(string recipient, int npinum, int patientId, int noteId)
{
bool isMessageSent = true;
//Intialise Parameters
// string aa = "appdatafiles\\EasyDoc\\D1\\121-108590_ALINA_YELIZAROV_PPOC_1_11-21-2017_5-19-2019-6-41-26-PM_RefSigned.pdf";
tblPatients patientNotes = _unitOfWork.PatientEntityRepo.Get(o => o.Prowid == patientId).FirstOrDefault();
tblReferrerSign _ReferralSign = _unitOfWork.ReferrerSignRepo.Get(o => o.NPINumber == npinum &&
o.PTrowid == patientId && o.Docrowid == noteId
).FirstOrDefault();
var smtpEmail = Convert.ToString(ConfigurationManager.AppSettings["SMTPEmail"]);
var smtpPassword = Convert.ToString(ConfigurationManager.AppSettings["SMTPPassword"]);
try
{
byte[] pdfBytes = CloudeStoreg.ByteFromFile(_ReferralSign.PDFName);
MailMessage mail = new MailMessage();
SmtpClient SmtpServer = new SmtpClient("smtp.gmail.com");
string filename = "Sign Notes " + DateTime.Now.ToString("yyyyMMdd_hhss") + ".pdf";
mail.From = new MailAddress(smtpEmail);
mail.To.Add(recipient);
mail.Subject = "Referral Notes PDF for " + patientNotes.LastName + ", " + patientNotes.FirstName;
mail.Body = "Sign note Attchment - " + patientNotes.LastName + ", " + patientNotes.FirstName;;
var memStream = new MemoryStream(pdfBytes);
memStream.Position = 0;
var contentType = new System.Net.Mime.ContentType(System.Net.Mime.MediaTypeNames.Application.Pdf);
var reportAttachment = new Attachment(memStream, contentType);
reportAttachment.ContentDisposition.FileName = filename;
mail.Attachments.Add(reportAttachment);
SmtpServer.Port = 587;
SmtpServer.Credentials = new System.Net.NetworkCredential(smtpEmail, smtpPassword);
SmtpServer.EnableSsl = true;
SmtpServer.Send(mail);
}
catch (Exception ex)
{
isMessageSent = false;
}
return(isMessageSent);
}
public JArray GetMedicalNcessityNotes(int patientId, int NoteId)
{
JObject jResponse = new JObject();
string NoteType = string.Empty;
string NoteTypeDec = string.Empty;
JArray jsonPatient = new JArray();
Team.Rehab.DataModel.RehabEntities rehab = new RehabEntities();
try
{
//MedicalNecessityNotes msNote = new MedicalNecessityNotes();
TPatientRespository objTrepo = new TPatientRespository(_unitOfWork);
tblDocMaster patientNotes = _unitOfWork.DocMasterRepo.Get(o => o.PTrowid == patientId && o.Docrowid == NoteId).FirstOrDefault();
tblPatients patient = _unitOfWork.PatientEntityRepo.Get(o => o.Prowid == patientId).FirstOrDefault();
jsonPatient = objTrepo.GetPatientList(patient.FirstName, patient.LastName, patient.BirthDate, "");
//MSDateOfServiceEntity dateOfService = msNote.GetMSDateOfService(patientId, NoteId, NoteType);
//MSHints msHints = msNote.GetHints(patientId, NoteId, NoteType);
//List<MSFunctionalCharEntity> MSFunctionalCharEntity = msNote.GetFunctChar( patientId, NoteId, NoteType);
if (patientNotes != null)
{
NoteType = patientNotes.NoteType;
if (NoteType == "PPOC")
{
NoteTypeDec = "Initial Eval";
CCDAGeneration.InitialEval _iniEval = new CCDAGeneration.InitialEval();
jResponse = _iniEval.ConvertInitialEval(patientId, NoteId, NoteType);
}
if (NoteType == "PPOC2")
{
NoteTypeDec = "Initial Eval2";
CCDAGeneration.InitialEval _iniEval = new CCDAGeneration.InitialEval();
jResponse = _iniEval.ConvertInitialEval(patientId, NoteId, NoteType);
// jResponse =
//new JObject(
// new JProperty(NoteTypeDec + " note is under construction"
// ));
}
if (NoteType == "PPOCRE")
{
NoteTypeDec = "Re-Eval";
CCDAGeneration.InitialEval _iniEval = new CCDAGeneration.InitialEval();
jResponse = _iniEval.ConvertInitialEval(patientId, NoteId, NoteType);
}
if (NoteType == "PTREAT")
{
NoteTypeDec = "Daily Note";
NoteTypeDec = "Medical Necessity";
CCDAGeneration.DailyNotes _dailyNotes = new CCDAGeneration.DailyNotes();
jResponse = _dailyNotes.ConvertDailyNote(patientId, NoteId, NoteType);
// jResponse =
//new JObject(
// new JProperty(NoteTypeDec + " is under construction"
// ));
}
if (NoteType == "PMN")
{
NoteTypeDec = "Medical Necessity";
CCDAGeneration.MedicalNecessity _patientDemographics = new CCDAGeneration.MedicalNecessity();
jResponse = _patientDemographics.MedicalNecessityToCCDA(patientId, NoteId, NoteType);
}
if (NoteType == "PDIS")
{
NoteTypeDec = "Discharge";
jResponse =
new JObject(
new JProperty(NoteTypeDec + " note is under construction"
));
}
if (NoteType == "PCOMM")
{
NoteTypeDec = "Communication";
CCDAGeneration.Communication _comm = new CCDAGeneration.Communication();
jResponse = _comm.ConvertCommunication(patientId, NoteId, NoteType);
}
if (NoteType == "PMV")
{
NoteTypeDec = "Missed";
jResponse =
new JObject(
new JProperty(NoteTypeDec + " note is under construction"
));
}
if (NoteType == "PFCE")
{
NoteTypeDec = "PFCE";
jResponse =
new JObject(
new JProperty(NoteTypeDec + " note is under construction"
));
}
}
else
{
jResponse =
new JObject(
new JProperty("No record found"
));
}
}
catch (Exception ex)
{
throw ex;
}
jsonPatient.Add(jResponse);
return(jsonPatient);
// return jResponse;
}
/// <summary>
/// Creates a product
/// </summary>
/// <param name="productEntity"></param>
/// <returns></returns>
public int CreateDTPatient(int incommingMsgID, string userID, string status, int attachmentID)
{
try
{
tblPatients patient = new tblPatients();
tblReferrer referrerRecord = new tblReferrer();
tblRefAddr referrerAddr = new tblRefAddr();
// tbl_DT_Incoming_Message_Individual_Attachments tblAttachment = new tbl_DT_Incoming_Message_Individual_Attachments();
tbl_DT_PatientReferral_Processed processedPatient = new tbl_DT_PatientReferral_Processed();
var incomingMessagPprocessEntity = (from p in _unitOfWork.DT_Incoming_MessageRepo.Get()
join e in _unitOfWork.DT_Individial_AttachRepo.Get()
on p.ID equals e.InComingMessageID
where p.ID == incommingMsgID && e.ID == attachmentID
select new DT_IncomingMessagOperationEntity
{
FileData = e.FileData,
EmailID = p.From
}).ToList().FirstOrDefault();
var DT_Referrer = (from p in _unitOfWork.DT_Referrer_EmailsRepo.Get()
where p.DT_Email_Address == incomingMessagPprocessEntity.EmailID
select p.Institute_ID).FirstOrDefault();
string xmlString = incomingMessagPprocessEntity.FileData.ToString();
//referrer = _unitOfWork.DT_Referrer_EmailsRepo.Get(o => o.Institute_ID == PatientWIP.Institute_ID).FirstOrDefault();
using (StreamReader reader = new StreamReader(GenerateStreamFromString(xmlString), Encoding.Unicode))
{
string oldstr = "xmlns=\"urn:hl7-org:v3\"";
string oldstr1 = "xmlns:sdtc=\"urn:hl7-org:sdtc\"";
xmlString = xmlString.Replace(oldstr, "");
xmlString = xmlString.Replace(oldstr1, "");
XmlDocument xmlDoc = new XmlDocument();
xmlDoc.LoadXml(xmlString);
var nameNode = xmlDoc.SelectNodes("ClinicalDocument/recordTarget/patientRole/patient/name");
var DOBNode = xmlDoc.SelectNodes("ClinicalDocument/recordTarget/patientRole/patient");
var CityNode = xmlDoc.SelectNodes("ClinicalDocument/recordTarget/patientRole/addr");
var referrerNode = xmlDoc.SelectNodes("ClinicalDocument/legalAuthenticator/assignedEntity/assignedPerson/name");
var referrerAddrNode = xmlDoc.SelectNodes("ClinicalDocument/legalAuthenticator/assignedEntity/addr");
var referrerPhoneNode = xmlDoc.SelectNodes("ClinicalDocument/legalAuthenticator/assignedEntity/telecom");
XmlNodeList xnListtelecom = xmlDoc.SelectNodes("/ClinicalDocument/recordTarget/patientRole/telecom");
////ClinicalDocument//recordTarget//patientRole//patientRole//name
foreach (XmlNode subNode in nameNode)
{
patient.FirstName = subNode["given"].InnerText;
patient.LastName = subNode["family"].InnerText;
patient.NickName = patient.FirstName;
}
foreach (XmlNode subNode in referrerNode)
{
string given2 = string.Empty;
if (subNode["given"].NextSibling != null)
{
given2 = subNode["given"].NextSibling.InnerText.ToStringOrEmpty();
}
referrerRecord.FirstName = subNode["given"].InnerText.ToStringOrEmpty() + " " + given2;
referrerRecord.LastName = subNode["family"].InnerText.ToStringOrEmpty();
referrerRecord.PrintName = subNode["family"].InnerText.ToStringOrEmpty() + ", " + subNode["given"].InnerText.ToStringOrEmpty() + " " + given2 + subNode["suffix"].InnerText.ToStringOrEmpty();
referrerRecord.Credentials = subNode["suffix"].InnerText.ToStringOrEmpty();
}
referrerRecord.ReferralType = "DT";
referrerRecord.SendPOCBy = "DT";
referrerRecord.createdby = "DT-Load";
referrerRecord.createdts = DateTime.Now;
referrerRecord.updatedby = "DT-Load";
referrerRecord.updatedts = DateTime.Now;
referrerRecord.NoFax = false;
referrerRecord.ReferralInstitute = DT_Referrer;
referrerRecord.Title = "Dr";
referrerRecord.NPINumber = "";
referrerRecord.Email = incomingMessagPprocessEntity.EmailID;
foreach (XmlNode subNode in DOBNode)
{
patient.BirthDate = subNode["birthTime"].Attributes["value"].Value;
DateTime dt;
if (DateTime.TryParseExact(patient.BirthDate.ToString(), "yyyyMMdd",
CultureInfo.InvariantCulture,
DateTimeStyles.None, out dt))
{
//Console.WriteLine(dt);
// patient.BirthDate = dt.ToString();
patient.BirthDate = dt.ToShortDateString();
}
string gender = subNode["administrativeGenderCode"].Attributes["code"].Value;
if (gender.ToLower() == "f")
{
patient.Gender = "Female";
}
patient.Title = "Miss";
if (gender.ToLower() == "m")
{
patient.Gender = "Male";
}
patient.Title = "MR";
}
foreach (XmlNode subNode in CityNode)
{
patient.City = subNode["city"].InnerText;
patient.State = subNode["state"].InnerText;
patient.Address1 = subNode["streetAddressLine"].InnerText;
patient.ZipCode = subNode["postalCode"].InnerText;
}
foreach (XmlNode subNode in referrerAddrNode)
{
referrerAddr.City = subNode["city"].InnerText;
referrerAddr.State = subNode["state"].InnerText;
referrerAddr.StreetAddress = subNode["streetAddressLine"].InnerText;
referrerAddr.ZipCode = subNode["postalCode"].InnerText;
referrerAddr.startdt = DateTime.Now;
referrerAddr.enddt = DateTime.Now;
referrerAddr.createdby = "DT-Load";
referrerAddr.createdts = DateTime.Now;
referrerAddr.updatedby = "DT-Load";
referrerAddr.updatedts = DateTime.Now;
}
foreach (XmlNode xn in referrerPhoneNode)
{
if (xn.Attributes[0].Value == "WP")
{
var ph = xn.Attributes[1].Value.Replace("-", "").Replace("(", "").Replace(")", "");
referrerAddr.PhoneNo = ph.ToStringOrEmpty().Length > 0 ? ph.Substring(6) : "";
}
}
referrerAddr.FaxNo = "";
DateTime NowTime = DateTime.Now;
int M_Current_Day = NowTime.Day; // Current Date with Day Display
int M_Current_Month = Convert.ToInt32(DateTime.Today.Month); //Current Month as a Single Integer Display
int CurrentYear = DateTime.Today.Year; // Display Year as Integer
patient.ReferralDate = DateTime.Now.ToShortDateString(); //**what is referral date?
patient.updatedts = DateTime.Now.ToShortDateString().StringToDate();
patient.createdts = DateTime.Now.ToShortDateString().StringToDate();
//patient.ReferralDate = CurrentYear.ToString()+M_Current_Month.ToString()+M_Current_Day.ToString(); //need to find referral date.
// patient.ReferralSource = incomingMessagPprocessEntity.EmailID == null ? "noemail" : incomingMessagPprocessEntity.EmailID.Substring(0, 9);
// patient.HomePh = "000000000"; //need to find patient phone.
foreach (XmlNode xn in xnListtelecom)
{
if (xn.Attributes[0].Value == "HP")
{
patient.HomePh = xn.Attributes[1].Value.ToStringOrEmpty().Length > 0 ? xn.Attributes[1].Value.Substring(4) : "";
}
if (xn.Attributes[0].Value == "WP")
{
patient.WorkPh = xn.Attributes[1].Value.ToStringOrEmpty().Length > 0 ? xn.Attributes[1].Value.Substring(4) : "";
}
if (xn.Attributes[0].Value == "MC")
{
patient.CellPh = xn.Attributes[1].Value.ToStringOrEmpty().Length > 0 ? xn.Attributes[1].Value.Substring(4) : "";
}
}
//patient.ClinicNo = 7;
using (RehabEntities rehab = new RehabEntities())
{
var clinicnumber = (from inc in rehab.tbl_DT_ClinicUserMapping where inc.EmailId == incomingMessagPprocessEntity.EmailID.ToString() select inc.ClinicNo).FirstOrDefault();
if (clinicnumber == null)
{
patient.ClinicNo = Convert.ToInt16(clinicnumber);
}
else
{
patient.ClinicNo = 0;
}
}
}
using (var scopeCreate = new TransactionScope())
{
_unitOfWork.ReferrerRepo.Insert(referrerRecord);
_unitOfWork.Save();
referrerAddr.Rrowid = referrerRecord.Rrowid;
_unitOfWork.RefAddrRepo.Insert(referrerAddr);
_unitOfWork.Save();
patient.ReferralSource = referrerRecord.Rrowid.ToStringOrEmpty();
_unitOfWork.PatientEntityRepo.Insert(patient);
_unitOfWork.Save();
ImportPatient(patient.Prowid, incommingMsgID, userID, status, attachmentID);
scopeCreate.Complete();
return(patient.Prowid);
}
}
catch (Exception ex)
{
throw;
}
}
