public string GetProviderEmailById(int id)
{
using (var dataContext = new HealthReunionEntities())
{
return(dataContext.Providers.Find(id).Email);
}
}
public void AddPatient(Patient patient, string userName)
{
using (TransactionScope scope = new TransactionScope())
{
using (var dataContext = new HealthReunionEntities())
{
// Add provider enity
dataContext.Patients.Add(patient);
// Save changes so that it will insert records into database.
dataContext.SaveChanges();
var user = new User();
user.UserName = userName;
user.Password = "******";
user.PatientId = patient.PatientId;
// Add user entity
dataContext.Users.Add(user);
dataContext.SaveChanges();
// Complete the transaction if everything goes well.
scope.Complete();
}
}
}
public Document GetDocumentById(int documentId, string documentType)
{
using (var dataContext = new HealthReunionEntities())
{
return(dataContext.Documents.Where(d => d.DocumentId == documentId && d.DocumentType.Equals(documentType)).First());
}
}
public bool CheckIfProviderNameExists(string providerName)
{
using (var dataContext = new HealthReunionEntities())
{
return(dataContext.Providers.Where(p => p.ProviderName.Trim() == providerName).FirstOrDefault() != null);
}
}
public void AddPatient(Patient patient, string userName, string defaultPassword)
{
using (TransactionScope scope = new TransactionScope())
{
using (var dataContext = new HealthReunionEntities())
{
if (CheckIfUserNameExists(userName))
{
throw new Exception("User name already exist");
}
// Add provider enity
dataContext.Patients.Add(patient);
// Save changes so that it will insert records into database.
dataContext.SaveChanges();
var user = new User();
user.UserName = userName;
user.Password = defaultPassword;
user.PatientId = patient.PatientId;
user.IsDefaultPassword = true;
// Add user entity
dataContext.Users.Add(user);
dataContext.SaveChanges();
// Complete the transaction if everything goes well.
scope.Complete();
}
}
}
public List <Provider> GetAllProviders()
{
using (var dataContext = new HealthReunionEntities())
{
return(dataContext.Providers.ToList());
}
}
public string GetUserNameByPatientId(int patientID)
{
using (var dataContext = new HealthReunionEntities())
{
return(dataContext.Users.Where(p => p.PatientId == patientID).First().UserName);
}
}
public List <PatientDocumentsModel> GetDocuments(int patientId, int providerId)
{
var patientDocumentsList = new List <PatientDocumentsModel>();
using (var dataContext = new HealthReunionEntities())
{
var patientDocuments = (from doc in dataContext.Documents
join patient in dataContext.Patients
on doc.PatientId equals patient.PatientId
where doc.PatientId == patientId && doc.ProviderId == providerId
select new { Patients = patient, Documents = doc }).ToList();
foreach (var item in patientDocuments)
{
patientDocumentsList.Add(new PatientDocumentsModel
{
FirstName = item.Patients.FirstName,
LastName = item.Patients.LastName,
MiddleName = item.Patients.MiddleName,
DocumentId = item.Documents.DocumentId,
DocumentType = item.Documents.DocumentType,
PatientId = item.Documents.PatientId,
ProviderId = item.Documents.ProviderId,
CreationTime = item.Documents.CreationTime,
DocumentText = System.Text.Encoding.UTF8.GetString(item.Documents.Document1)
});
}
return(patientDocumentsList);
}
}
public int GetProviderIdForPatient(int patientID)
{
using (var dataContext = new HealthReunionEntities())
{
return(dataContext.Patients.Where(p => p.PatientId == patientID).First().ProviderId);
}
}
public Patient GetPatientById(int patientID)
{
using (var dataContext = new HealthReunionEntities())
{
return(dataContext.Patients.Where(p => p.PatientId == patientID).FirstOrDefault());
}
}
public List <Patient> GetAllPatients(int providerId)
{
using (var dataContext = new HealthReunionEntities())
{
return(dataContext.Patients.Where(p => p.ProviderId == providerId).ToList());
}
}
public bool CheckIfUserNameExists(string userName)
{
using (var dataContext = new HealthReunionEntities())
{
return(dataContext.Users.Where(u => u.UserName.Trim() == userName && u.PatientId == null).FirstOrDefault() != null);
}
}
public bool ValidateUser(string userName, string passWord, int providerID)
{
using (var dataContext = new HealthReunionEntities())
{
passWord = EncryptDecrypt.EncryptData(passWord, EncryptDecrypt.ReadCert());
return(dataContext.Users.Where(u => u.UserName.Trim() == userName && u.Password.Trim() == passWord && u.ProviderId == providerID).FirstOrDefault() != null);
}
}
public List <User> GetUsersByProviderId(int providerId)
{
using (var dataContext = new HealthReunionEntities())
{
return((from u in dataContext.Users
where u.ProviderId == providerId
select u).ToList());
}
}
public User GetUsersByPatientId(int patientId)
{
using (var dataContext = new HealthReunionEntities())
{
var user = (from u in dataContext.Users
where u.PatientId == patientId
select u).FirstOrDefault();
return(user);
}
}
public void AddDocuments(Document document)
{
using (var dataContext = new HealthReunionEntities())
{
// Add document entity
dataContext.Documents.Add(document);
// Save changes so that it will insert records into database.
dataContext.SaveChanges();
}
}
public void AddUser(User user)
{
using (var dataContext = new HealthReunionEntities())
{
user.Password = EncryptDecrypt.EncryptData(user.Password, EncryptDecrypt.ReadCert());
// Add user entity
dataContext.Users.Add(user);
// Save changes so that it will insert records into database.
dataContext.SaveChanges();
}
}
public void UpdatePassword(User user)
{
using (var dataContext = new HealthReunionEntities())
{
var original = dataContext.Users.Find(user.UserId);
if (original != null)
{
original.Password = EncryptDecrypt.EncryptData(user.Password, EncryptDecrypt.ReadCert());
}
dataContext.SaveChanges();
}
}
public void RemoveUser(int userId)
{
using (var dataContext = new HealthReunionEntities())
{
var user = dataContext.Users.Find(userId);
if (user != null)
{
dataContext.Users.Remove(user);
dataContext.SaveChanges();
}
}
}
public string GetEmailAddress(int patientID)
{
using (var dataContext = new HealthReunionEntities())
{
var patient = dataContext.Patients.Where(p => p.PatientId == patientID).FirstOrDefault();
if (patient != null)
{
return(patient.Email);
}
return(string.Empty);
}
}
public void UpdatePatient(Patient patient, string userName)
{
using (var dataContext = new HealthReunionEntities())
{
var patientToUpdate = dataContext.Patients.Where(p => p.PatientId == patient.PatientId && p.ProviderId == patient.ProviderId).First();
patientToUpdate.ProviderId = patient.PatientId;
patientToUpdate.MedicalRecordNumber = Guid.NewGuid();
patientToUpdate.LastName = patient.LastName.Trim();
patientToUpdate.FirstName = patient.FirstName.Trim();
patientToUpdate.MiddleName = patient.MiddleName.Trim();
patientToUpdate.DOB = patient.DOB;
patientToUpdate.Address = patient.Address.Trim();
patientToUpdate.Phone = patient.Phone.Trim();
patientToUpdate.Email = patient.Email.Trim();
patientToUpdate.City = patient.City.Trim();
patientToUpdate.State = patient.State.Trim();
patientToUpdate.Country = patient.Country;
patientToUpdate.IsActive = true;
dataContext.SaveChanges();
}
}
public void AddProviderWithDefaultUser(Provider provider, User user)
{
using (TransactionScope scope = new TransactionScope())
{
using (var dataContext = new HealthReunionEntities())
{
if (CheckIfUserNameExists(user.UserName))
{
throw new Exception("User name already exist");
}
if (CheckIfProviderNameExists(provider.ProviderName))
{
throw new Exception("Provider name already exist");
}
// Add provider enity
dataContext.Providers.Add(provider);
// Save changes so that it will insert records into database.
dataContext.SaveChanges();
user.ProviderId = provider.ProviderId;
user.Password = EncryptDecrypt.EncryptData(user.Password, EncryptDecrypt.ReadCert());
// Add user entity
dataContext.Users.Add(user);
dataContext.SaveChanges();
// Complete the transaction if everything goes well.
scope.Complete();
}
}
}
