public HomeViewModel()
{
ManufacturerVM = new ManufacturerVM();
WholesalerVM = new WholesalerVM();
PharmacyVM = new PharmacyVM();
PatientVM = new PatientVM();
}
public ActionResult Outpatients()
{
PatientRepository patientRepository = new PatientRepository();
List <Patient> patients = patientRepository.LoadAllOutPatients();
List <PatientVM> patientVMs = new List <PatientVM>();
foreach (Patient patient in patients)
{
PatientVM patientvm = new PatientVM();
patientvm.Id = patient.Id;
patientvm.FName = patient.FName;
patientvm.LName = patient.LName;
patientvm.PhoneNumber = patient.PhoneNumber;
patientvm.Address = patient.Address;
patientvm.MaritalStatus = patient.MaritalStatus;
patientvm.RegisterDate = patient.RegisterDate;
patientvm.LocalDoctorId = patient.LocalDoctorId;
patientvm.NextOfKinId = patient.NextOfKinId;
patientvm.Gender = patient.Gender;
patientvm.IsOutpatient = patient.IsOutpatient;
//This code will return only the name of the company which will be presented into the SHOW view
patientVMs.Add(patientvm);
}
PatientVM model = new PatientVM();
model.Patients = patientVMs;
return(View(model));
}
public void CreateTest()
{
PartialViewResult rv = (PartialViewResult)_controller.Create();
Assert.IsInstanceOfType(rv.Model, typeof(PatientVM));
PatientVM vm = rv.Model as PatientVM;
Patient v = new Patient();
v.ID = 92;
v.IdNumber = "9hTGN";
v.PhotoId = AddPhoto();
vm.Entity = v;
_controller.Create(vm);
using (var context = new DataContext(_seed, DBTypeEnum.Memory))
{
var data = context.Set <Patient>().FirstOrDefault();
Assert.AreEqual(data.ID, 92);
Assert.AreEqual(data.IdNumber, "9hTGN");
Assert.AreEqual(data.CreateBy, "user");
Assert.IsTrue(DateTime.Now.Subtract(data.CreateTime.Value).Seconds < 10);
}
}
public ActionResult Create(PatientVM patient)
{
try
{
if (ModelState.IsValid)
{
IBL bL = new BlClass();
Dictionary <string, string> errorMessege = bL.PersonValidation(patient.Current);
if (errorMessege.Count == 0)
{
bL.AddPatient(patient.Current);
ViewBag.TitlePopUp = "עבר בהצלחה";
ViewBag.Message = "המטופל.ת התווספ.ה בהצלחה למאגר המטופלים";
return(View("Index", new PatientModel().getPatientVms()));
}
foreach (var item in errorMessege)
{
ModelState.AddModelError(item.Key, item.Value);
}
}
return(View(patient));
}
catch (Exception ex)
{
ViewBag.TitlePopUp = "שגיאה";
ViewBag.Message = ex.Message;
return(View("Index", new PatientModel().getPatientVms()));
}
}
public IEnumerable <PatientVM> GetPatientBCT(string search)
{
using (IDbConnection connection = mySqlConnection)
{
var data = new List <PatientVM>();
var p = new DynamicParameters();
p.Add("@Search_Data", search);
var patients = connection.QueryAsync <PatientData>("GetPatient", p, commandType: CommandType.StoredProcedure).Result.ToList();
foreach (var pt in patients)
{
var ptvm = new PatientVM();
var patient = new BasePatientVM()
{
HN = pt.HN,
TitleName = pt.TitileName,
FirstName = pt.FirstName,
MiddleName = pt.MiddleName,
LastName = pt.LastName,
DOB = pt.DOB,
SexCode = pt.SexCode,
SexDesc = pt.SexDesc,
IDCard = pt.IDCard
};
ptvm.Patient = patient;
ptvm.SCT_HN = pt.SCT_HN;
data.Add(ptvm);
}
return(data);
}
}
public ActionResult AddPatient([Bind(Include = "FirstName,LastName,Email,ContactNo")] PatientVM pvm)
{
PatientsBL pbl = new PatientsBL(context);
DoctorsBL dbl = new DoctorsBL(context);
if (!ModelState.IsValid)
{
ViewBag.error = true;
return(PartialView("~/Areas/Doctors/Views/Partials/AddPatientPartial.cshtml", pvm));
}
else
{
//Patient newPatient = pvm.mapPatientDataFromVM();
Patient p = new Patient();
p.Email = pvm.Email;
p.PatientSince = DateTime.Now;
p.FirstName = pvm.FirstName;
p.LastName = pvm.LastName;
p.Contact = pvm.ContactNo;
p.Doctor = dbl.getByUN(User.Identity.Name);
p.Supervisor = dbl.getByUN(User.Identity.Name).DocID;
pbl.insertPatient(p);
ViewBag.dataSaved = true;
return(PartialView("~/Areas/Doctors/Views/Partials/AddPatientPartial.cshtml", pvm));
}
}
private PatientVM GetPatientBCTByHN(string hn)
{
try
{
using (IDbConnection connection = mySqlConnection)
{
var p = new DynamicParameters();
p.Add("@Search_Data", hn);
var pt = connection.QueryAsync <PatientData>("GetPatient", p, commandType: CommandType.StoredProcedure).Result.FirstOrDefault();
var ptvm = new PatientVM();
var patient = new BasePatientVM()
{
HN = pt.HN,
TitleName = pt.TitileName,
FirstName = pt.FirstName,
MiddleName = pt.MiddleName,
LastName = pt.LastName,
DOB = pt.DOB,
SexCode = pt.SexCode,
SexDesc = pt.SexDesc,
IDCard = pt.IDCard
};
ptvm.Patient = patient;
ptvm.SCT_HN = pt.SCT_HN;
return(ptvm);
}
}
catch (Exception)
{
return(new PatientVM());
}
}
public ActionResult RegisterPatientDetails(PatientVM details)
{
if (details != null && details.DocumentUpload != null)
{
string path = "";
string newImageName = DateTime.Now.Day + "_" + Path.GetFileName(details.DocumentUpload.FileName);
path = HttpContext.Server.MapPath("~/UserData/PatientDoc//" + newImageName);
details.DocumentUpload.SaveAs(path);
details.DocumentPath = newImageName;
}
var userDetails = this._managePatient.RegisterPatientDetails(details);
if (userDetails)
{
this.TempData["SucessAlert"] = "1";
}
else
{
this.TempData["SucessAlert"] = "0";
}
return(RedirectToAction("Index", "Home", new
{
Area = "",
message = this.TempData["SucessAlert"]
}));
}
public void DeleteTest()
{
Patient v = new Patient();
using (var context = new DataContext(_seed, DBTypeEnum.Memory))
{
v.ID = 92;
v.IdNumber = "9hTGN";
v.PhotoId = AddPhoto();
context.Set <Patient>().Add(v);
context.SaveChanges();
}
PartialViewResult rv = (PartialViewResult)_controller.Delete(v.ID.ToString());
Assert.IsInstanceOfType(rv.Model, typeof(PatientVM));
PatientVM vm = rv.Model as PatientVM;
v = new Patient();
v.ID = vm.Entity.ID;
vm.Entity = v;
_controller.Delete(v.ID.ToString(), null);
using (var context = new DataContext(_seed, DBTypeEnum.Memory))
{
Assert.AreEqual(context.Set <Patient>().Count(), 1);
}
}
public ActionResult UpdatePatient([FromBody] PatientVM value)
{
var data = _mapper.Map <Patient>(value);
_dataService.UpdatePatient(data);
return(Response());
}
public List <PatientVM> GetAllPatients()
{
List <PatientVM> patients = new List <PatientVM>();
PatientVM patient = null;
try
{
string connString = ConfigurationManager.ConnectionStrings["Test"].ConnectionString;
using (SqlConnection con = new SqlConnection(connString))
{
con.Open();
SqlCommand command = new SqlCommand();
StringBuilder builder = new StringBuilder();
builder.Append("SELECT * FROM dbo.Patient");
command.CommandText = builder.ToString();
command.Connection = con;
using (SqlDataAdapter adapter = new SqlDataAdapter(command))
{
DataTable table = new DataTable();
adapter.Fill(table);
var records = table.Select();
foreach (var row in records)
{
patient = new PatientVM();
patient.Id = Convert.ToInt64(row["Id"]);
patient.FirstName = row["FirstName"] as string;
patient.LastName = row["LastName"] as string;
patient.Gender = row["Gender"] as string;
patient.Address = row["Address"] as string;
patient.Phone = row["Phone"] as string;
patient.Email = row["Email"] as string;
patient.PatientID = row["PatientID"] as string;
patient.BirthDate = row["BirthDate"] as string;
patient.Status = row["Status"] as string;
patient.RegistrationDate = row["RegistrationDate"] as string;
patient.MaritalStatus = row["MaritalStatus"] as string;
patients.Add(patient);
}
}
}
}
catch (SqlException oe)
{
ExceptionBag bag = new ExceptionBag();
bag.Message = oe.Message;
bag.Date = DateTime.Now.ToString("dd-MM-yyyy HH:mm:ss");
bag.ExecutingOperation = "GetAllPatients";
bag.InnerException = oe.InnerException == null ? string.Empty : oe.InnerException.ToString();
ExceptionLogger.LogToFileAsync(bag);
}
return(patients);
}
public UsersManagement()
{
InitializeComponent();
DataContext = new PatientVM();
Patient.Content = new PatientManagement();
Staff.Content = new StaffManagement();
Practitioner.Content = new PractitionerManagement();
}
// GET: Registration
public ActionResult PatientList()
{
try
{
string authId = User.Identity.Name;
string userAccount = context.Users.Where(q => q.Id.ToString() == authId).SingleOrDefault().Email;
ViewBag.UserEmail = userAccount;
// patients (and users) from database with values
List <Patient> patients = context.Patients.ToList();
// goes to view. now it's empty
List <PatientVM> patientsVM = new List <PatientVM>();
// assign each patient data from db to patientsVM(list)
foreach (var p in patients)
{
// assigning required field
PatientVM patientVM = new PatientVM
{
Id = p.Id,
FullName = p.FirstName + " " + p.LastName,
Gender = p.Gender,
Address1 = String.IsNullOrEmpty(p.Address1)? "N/A" : p.Address1,
Address2 = String.IsNullOrEmpty(p.Address2) ? "N/A" : p.Address2,
City = String.IsNullOrEmpty(p.City) ? "N/A" : p.City,
Province = String.IsNullOrEmpty(p.Province) ? "N/A" : p.Province,
Postal = String.IsNullOrEmpty(p.PostalCode) ? "N/A" : p.PostalCode
};
// assign if patient has an User account
if (p.User != null)
{
patientVM.Email = p.User.Email;
patientVM.UserId = p.User.Id;
}
else
{
patientVM.Email = "N/A";
}
ViewBag.AdminEmail = "Logged in as " + DisplayAdminEmail();
patientsVM.Add(patientVM);
}
return(View(patientsVM.OrderBy(q => q.FullName)));
}
catch (Exception e)
{
ViewBag.ExceptionMessage = e.Message;
}
return(View("~/Views/Errors/Details.cshtml"));
}
public ActionResult Index(string PatientName, PatientVM patient)
{
using (var db = new DataContext())
{
var JoinData = (from s1 in db.Patients join s2 in db.Appointments on s1.PatientID equals s2.PatientID where s1.PatientName.Contains(PatientName) select new PatientVM {
Patients = s1, Appointments = s2
}).ToList();
return(View(JoinData));
}
}
public ActionResult Edit(PatientVM model)
{
model.Base = new ViewModelBase(PushState, "/Patients/Edit/" + model.ID, "Patient/Case Entry", "/Patients/Search");
if (!model.ID.HasValue)
{
model.ViewHelper.IsNewPatientEntry = true;
}
model.ViewHelper.GuardianRelationships = repository.GetGuardianRelationships();
model.ViewHelper.Insurances = repository.GetInsuranceList();
return(SaveFullAction(model, model.ViewHelper, "Search", "Edit", "ErrorPartial", () => repository.SavePatient(model)));
}
public static PatientDTO MapToPatientDTO(PatientVM patient)
{
return(new MapperConfiguration(cfg => cfg.CreateMap <PatientVM, PatientDTO>()
.ForMember(dest => dest.PatientId, opt => opt.MapFrom(src => src.PatientId))
.ForMember(dest => dest.FirstName, opt => opt.MapFrom(src => src.FirstName))
.ForMember(dest => dest.LastName, opt => opt.MapFrom(src => src.LastName))
.ForMember(dest => dest.Patronymic, opt => opt.MapFrom(src => src.Patronymic))
.ForMember(dest => dest.IIN, opt => opt.MapFrom(src => src.IIN))
.ForMember(dest => dest.PhoneNumber, opt => opt.MapFrom(src => src.PhoneNumber))
.ForMember(dest => dest.Address, opt => opt.MapFrom(src => src.Address))
).CreateMapper().Map <PatientVM, PatientDTO>(patient));
}
public ActionResult Create()
{
var model = new PatientVM
{
Base = new ViewModelBase(PushState, "/Patients/Create", "Patient/Case Entry")
};
model.ViewHelper.IsNewPatientEntry = true;
model.ViewHelper.GuardianRelationships = repository.GetGuardianRelationships();
model.ViewHelper.Insurances = repository.GetInsuranceList();
return(GetView("Edit", model));
}
private async void ConsumeButton_ClickAsync(object sender, RoutedEventArgs e)
{
ViewModel = DataContext as PatientVM;
var fxn = new ConsumeFunction();
fxn.TokenId = string.IsNullOrEmpty(tokenId.Text) || string.IsNullOrWhiteSpace(tokenId.Text) ? BigInteger.Parse(tokenId.Text) : new BigInteger(new Random().Next(10, 1000));
fxn.PatientAddress = ViewModel.SetUp.Accounts.four.Address;
fxn.Patient = Convert.ToByte(3);
await ViewModel.ConsumptionCommand(fxn);
await UpdateTracking();
}
public async Task <ActionResult <Patient> > CreatePatient(PatientVM newPatientVM)
{
if (!ModelState.IsValid)
{
return(BadRequest(ModelState));
}
var newPatient = await _repository.CreatePatient(newPatientVM);
if (newPatient == null)
{
ModelState.AddErrorMessage("Unable to create Patient");
return(BadRequest(ModelState));
}
return(Ok(newPatient));
}
public IActionResult OnGet(int?id)
{
PatientObj = new PatientVM
{
Patient = new Patient(),
SpeciesList = _unitOfWork.Species.GetSpeciesListForDropDown()
};
if (id != null)
{
PatientObj.Patient = _unitOfWork.Patient.GetFirstOrDefault(s => s.Id == id);
if (PatientObj == null)
{
return(NotFound());
}
}
return(Page());
}
/// <summary>
/// Adds or edits an Patient
/// </summary>
/// <param name="id">User id</param>
/// <returns>add or edit view</returns>
public ActionResult AddOrEditPatient(string id)
{
int userId = Convert.ToInt32(id);
PatientVM patientDetails;
if (userId == 0)
{
patientDetails = new PatientVM();
return(this.PartialView("AddOrEditPatient", patientDetails));
}
else
{
patientDetails = this._managePatient.GetPatientById(userId);
return(this.PartialView("AddOrEditPatient", patientDetails));
}
}
public IEnumerable <PatientVM> Get()
{
List <PatientVM> lstPatientVM = new List <PatientVM>();
using (PatientDemographicDBEntities entities = new PatientDemographicDBEntities())
{
// return entities.Patients.ToList();
foreach (Patient patient in entities.Patients)
{
string xmlPatientDetails = patient.Patient_Details;
Object obj = Utility.ObjectToXML(xmlPatientDetails, typeof(PatientVM));
PatientVM patientVM = (PatientVM)obj;
lstPatientVM.Add(patientVM);
}
}
return(lstPatientVM.ToList());
}
public ActionResult DeleteConfirmation()
{
try
{
Guid id = new Guid(User.Identity.Name);
if (String.IsNullOrWhiteSpace(id.ToString()))
{
return(RedirectToAction("Index"));
}
User u = context.Users.SingleOrDefault(q => q.Id == id);
Patient p = context.Patients.SingleOrDefault(q => q.UserId == id);
if (p != null)
{
// assigining value from db to VM
PatientVM patientVM = new PatientVM
{
FullName = p.FirstName + " " + p.LastName,
};
if (p.User != null)
{
patientVM.Email = p.User.Email;
}
ViewBag.Id = id;
ViewBag.AdminEmail = DisplayPatientName(p);
return(View(patientVM));
}
return(RedirectToAction("Index"));
}
catch (Exception e)
{
ViewBag.ExceptionMessage = e.Message;
}
return(View("~/Views/Errors/Details.cshtml"));
}
public ActionResult SavePatientDetails(PatientVM details)
{
var returnResult = "";
int?result = -1;
if (details != null)
{
var userDetails = this._managePatient.SavePatientDetails(details);
if (userDetails != null)
{
if (details.UserID == 0)
{
this.TempData["SucessAlert"] = "1";
}
else if (details.UserID > 0)
{
this.TempData["SucessAlert"] = "2";
}
}
else
{
this.TempData["SucessAlert"] = "0";
}
if (this.Session["UserRoleCode"] != null)
{
if (this.Session["UserRoleCode"].ToString() == Enum.GetName(typeof(CommonClass.UserRole), CommonClass.UserRole.OPTR))
{
return(this.RedirectToAction("Index", "Operator", new { area = "Operator", tab = "PatientList" }));
}
else if (Session["UserRoleCode"].ToString() == Enum.GetName(typeof(CommonClass.UserRole), CommonClass.UserRole.PTNT))
{
return(this.RedirectToAction("Index", "Patient", new { area = "Patient", tab = "PatientList" }));
}
}
}
return(this.RedirectToAction("Index", "Operator", new { area = "Operator", tab = "Dashboard" }));
}
public void EditTest()
{
Patient v = new Patient();
using (var context = new DataContext(_seed, DBTypeEnum.Memory))
{
v.ID = 55;
v.PatientName = "YwcJC";
v.IdNumber = "HxDBfg9Ar";
context.Set <Patient>().Add(v);
context.SaveChanges();
}
PartialViewResult rv = (PartialViewResult)_controller.Edit(v.ID.ToString());
Assert.IsInstanceOfType(rv.Model, typeof(PatientVM));
PatientVM vm = rv.Model as PatientVM;
v = new Patient();
v.ID = vm.Entity.ID;
v.PatientName = "sH3P";
v.IdNumber = "BlwN4UFY";
vm.Entity = v;
vm.FC = new Dictionary <string, object>();
vm.FC.Add("Entity.ID", "");
vm.FC.Add("Entity.PatientName", "");
vm.FC.Add("Entity.IdNumber", "");
_controller.Edit(vm);
using (var context = new DataContext(_seed, DBTypeEnum.Memory))
{
var data = context.Set <Patient>().FirstOrDefault();
Assert.AreEqual(data.PatientName, "sH3P");
Assert.AreEqual(data.IdNumber, "BlwN4UFY");
Assert.AreEqual(data.UpdateBy, "user");
Assert.IsTrue(DateTime.Now.Subtract(data.UpdateTime.Value).Seconds < 10);
}
}
public ActionResult Create(PatientVM vm)
{
if (!ModelState.IsValid)
{
return(PartialView(vm));
}
else
{
vm.DoAdd();
if (!ModelState.IsValid)
{
vm.DoReInit();
return(PartialView(vm));
}
else
{
return(FFResult().CloseDialog().RefreshGrid());
}
}
}
public ActionResult Edit(PatientVM vm)
{
if (!ModelState.IsValid)
{
return(PartialView(vm));
}
else
{
vm.DoEdit();
if (!ModelState.IsValid)
{
vm.DoReInit();
return(PartialView(vm));
}
else
{
return(FFResult().CloseDialog().RefreshGridRow(vm.Entity.ID));
}
}
}
public ActionResult Create(PatientVM model)
{
//Creating a Company object from the CompanyVM
Patient patient = new Patient();
patient.FName = model.FName;
patient.LName = model.LName;
patient.Address = model.Address;
patient.PhoneNumber = model.PhoneNumber;
patient.Gender = model.Gender;
patient.MaritalStatus = model.MaritalStatus;
patient.RegisterDate = model.RegisterDate;
patient.LocalDoctorId = model.LocalDoctorId;
patient.NextOfKinId = model.NextOfKinId;
patient.IsOutpatient = model.IsOutpatient;
//Create a CompanyRepo for saving
PatientRepository patientRepository = new PatientRepository();
patientRepository.SavePatient(patient);
return(RedirectToAction("Index"));
}
public async Task <ActionResult> Create(PatientVM model)
{
if (ModelState.IsValid)
{
db.Addresses.Add(new Address
{
Street_Number = model.Address.Street_Number,
City = model.Address.City,
Country = model.Address.Country,
Province = model.Address.Province,
Route = model.Address.Route,
ZipCode = model.Address.ZipCode
});
await db.SaveChangesAsync();
var patientAddress = await db.Addresses.OrderByDescending(a => a.Id)
.FirstOrDefaultAsync();
db.Patients.Add(new Patient
{
FirstName = model.FirstName,
Surname = model.Surname,
Address = patientAddress,
ContactNumber = model.ContactNumber,
AddressId = patientAddress.Id,
Age = model.Age,
Email = model.Email,
Password = model.Password,
isActive = true,
isLoyal = false
});
await db.SaveChangesAsync();
return(RedirectToAction("Index"));
}
return(View(model));
}
public ActionResult DeleteUser(Guid id) // id in users table
{
try
{
if (String.IsNullOrWhiteSpace(id.ToString()))
{
return(RedirectToAction("PatientList"));
}
User u = context.Users.SingleOrDefault(q => q.Id == id);
Patient p = context.Patients.SingleOrDefault(q => q.UserId == id);
if (p != null)
{
// assigining value from db to VM
PatientVM patientVM = new PatientVM
{
FullName = p.FirstName + " " + p.LastName,
};
if (p.User != null)
{
patientVM.Email = p.User.Email;
}
ViewBag.Id = id;
ViewBag.AdminEmail = "Logged in as " + DisplayAdminEmail();
return(View(patientVM));
}
return(RedirectToAction("PatientList"));
}
catch (Exception e)
{
ViewBag.ExceptionMessage = e.Message;
}
return(View("~/Views/Errors/Details.cshtml"));
}
