public static bool Login(String Username, String Password)
{
using (PatientDBContext patientDBContext = new PatientDBContext())
{
return(patientDBContext.Tbl_Users.Any(user => user.User_Name.Equals(Username, StringComparison.OrdinalIgnoreCase) && user.Password == Password));
}
}
//Delete patients of particular ID
public HttpResponseMessage Delete(int id)
{
try
{
using (PatientDBContext patientDBContext = new PatientDBContext())
{
var entity = patientDBContext.Tbl_Patients.FirstOrDefault(e => e.Patient_ID == id);
if (entity == null)
{
return(Request.CreateErrorResponse(HttpStatusCode.NotFound, "Employee with ID = " + id + "not found"));
}
else
{
patientDBContext.Tbl_Patients.Remove(entity);
patientDBContext.SaveChanges();
return(Request.CreateResponse(HttpStatusCode.OK));
}
}
}
catch (DbEntityValidationException ex)
{
return(Request.CreateErrorResponse(HttpStatusCode.BadRequest, ex));
}
}
public ActionResult PatientSearch(string searching, string sortOrder)
{
ViewBag.SurnameSortParm = String.IsNullOrEmpty(sortOrder) ? "surname_desc" : "";
ViewBag.NameSortParm = sortOrder == "name" ? "name_desc" : "name";
ViewBag.PeselSortParm = sortOrder == "pesel" ? "pesel_desc" : "pesel";
PatientDBContext patientContext = new PatientDBContext();
// kryteria wyszukiwania
var patientList = patientContext.Patients.Where(x => x.Pesel.Contains(searching) ||
x.Name.Contains(searching) ||
x.Surname.Contains(searching) ||
searching == null);
switch (sortOrder)
{
case "surname_desc": patientList = patientList.OrderByDescending(s => s.Surname); break;
case "name": patientList = patientList.OrderBy(s => s.Name); break;
case "name_desc": patientList = patientList.OrderByDescending(s => s.Name); break;
case "pesel": patientList = patientList.OrderBy(s => s.Pesel); break;
case "pesel_desc": patientList = patientList.OrderByDescending(s => s.Pesel); break;
default: patientList = patientList.OrderBy(s => s.Surname); break;
}
return(View(patientList.ToList()));
}
public static PatientDBContext CreateDBContext()
{
var config = InitConfiguration();
var conn = config.GetConnectionString("myDb");
var optionBuilder = new DbContextOptionsBuilder <PatientDBContext>();
optionBuilder.UseSqlServer(conn);
var _patientDBContext = new PatientDBContext(optionBuilder.Options);
return(_patientDBContext);
}
//update existing patient details
//@Path: api/patientdetails/{id}
public HttpResponseMessage Put(int id, [FromBody] Tbl_Patients patient_Details)
{
try
{
using (PatientDBContext patientDBContext = new PatientDBContext())
{
if (patient_Details != null)
{
var entity = patientDBContext.Tbl_Patients.FirstOrDefault(e => e.Patient_ID == id);
entity.Age = patient_Details.Age;
entity.BloodPressure = patient_Details.BloodPressure;
entity.BMI = patient_Details.BMI;
entity.BodyFat = patient_Details.BodyFat;
entity.BodyWater = patient_Details.BodyWater;
entity.BoneMass = patient_Details.BoneMass;
entity.ECG = patient_Details.ECG;
entity.EyeTest = patient_Details.EyeTest;
entity.Gender = patient_Details.Gender;
entity.HaemoglobinCount = patient_Details.HaemoglobinCount;
entity.MuscleMass = patient_Details.MuscleMass;
entity.Hip = patient_Details.Hip;
entity.Height = patient_Details.Height;
entity.ECG = patient_Details.ECG;
entity.IdealBodyWeight = patient_Details.IdealBodyWeight;
entity.Patient_Location = patient_Details.Patient_Location;
entity.Patient_Name = patient_Details.Patient_Name;
entity.ExaminedOn = patient_Details.ExaminedOn;
entity.SkinTest = patient_Details.SkinTest;
entity.SPO2 = patient_Details.SPO2;
entity.VaccinationHB = patient_Details.VaccinationHB;
entity.VaccinationTyphoid = patient_Details.VaccinationTyphoid;
entity.Waist = patient_Details.Waist;
entity.WaistHeightRatio = patient_Details.WaistHeightRatio;
entity.WaistHipRatio = patient_Details.WaistHipRatio;
patientDBContext.SaveChanges();
return(Request.CreateResponse(HttpStatusCode.OK, entity));
}
else
{
return(Request.CreateErrorResponse(HttpStatusCode.NotFound, "Patient with ID: " + patient_Details.Patient_ID + "not found to update"));
}
}
}
catch (DbEntityValidationException ex)
{
return(Request.CreateErrorResponse(HttpStatusCode.BadRequest, ex));
}
}
//Get all patient details
//@Path: api/patientdetails/
public HttpResponseMessage GetPatientDetails()
{
try
{
using (PatientDBContext patientDBContext = new PatientDBContext())
{
var entities = patientDBContext.Tbl_Patients.ToList();
return(Request.CreateResponse(HttpStatusCode.OK, entities));
}
}
catch (Exception e)
{
return(Request.CreateErrorResponse(HttpStatusCode.BadRequest, e));
}
}
private void AddTestData(PatientDBContext context)
{
context.Patients.Add(new Patient()
{
First_Name = "Kumar",
Last_Name = "Sankata",
Email = "*****@*****.**",
Created_At = DateTime.UtcNow,
Date_Of_Birth = Convert.ToDateTime("2000-1-1"),
Gender = "Male",
Id = new Guid("1f58b970-96f8-4976-b3eb-6b8caf02da7a"),
Is_Active = true,
Phone = "123456789"
});
context.SaveChanges();
}
private IPatientRepository GetPatientRepository()
{
var builder = new DbContextOptionsBuilder <PatientDBContext>();
builder.UseInMemoryDatabase("Patient");
var dbContextOptions = builder.Options;
var patientDBContext = new PatientDBContext(dbContextOptions);
patientDBContext.Database.EnsureDeleted();
patientDBContext.Database.EnsureCreated();
AddTestData(patientDBContext);
var patientRepository = new PatientRepository(patientDBContext);
return(patientRepository);
}
//Insert new patient details
//@Path: api/patientdetails/
public HttpResponseMessage Post([FromBody] Tbl_Patients patient_Details)
{
try
{
using (PatientDBContext patientDBContext = new PatientDBContext())
{
patientDBContext.Tbl_Patients.Add(patient_Details);
patientDBContext.SaveChanges();
var message = Request.CreateResponse(HttpStatusCode.Created, patient_Details);
message.Headers.Location = new Uri(Request.RequestUri + patient_Details.Patient_ID.ToString());
return(message);
}
}
catch (DbEntityValidationException e)
{
return(Request.CreateErrorResponse(HttpStatusCode.BadRequest, e));
}
}
//Get particular patient details using Patient_ID
//@Path: api/patientdetails/{id}
public HttpResponseMessage GetPatientDetail(int id)
{
try
{
using (PatientDBContext patientDBContext = new PatientDBContext())
{
var entities = patientDBContext.Tbl_Patients.FirstOrDefault(e => e.Patient_ID == id);
if (entities != null)
{
return(Request.CreateResponse(HttpStatusCode.OK, entities));
}
else
{
return(Request.CreateErrorResponse(HttpStatusCode.NotFound, "Patient with ID: " + id + " is not found"));
}
}
}
catch (Exception ex)
{
return(Request.CreateErrorResponse(HttpStatusCode.BadRequest, ex));
}
}
/// <summary>
/// Method to load initial data
/// </summary>
/// <param name="patientDBContext"></param>
public static void LoadPatientContextData(PatientDBContext patientDBContext)
{
var patientList = new List <Patient>();
patientDBContext.Patients.Add(
new Patient()
{
Id = Guid.NewGuid(),
First_Name = "Franks",
Last_Name = "Weiss",
Gender = "male",
Date_Of_Birth = Convert.ToDateTime("1997-11-08"),
Email = "*****@*****.**",
Phone = "02 94002366",
Is_Active = true,
Created_At = DateTime.UtcNow,
Updated_At = DateTime.UtcNow
});
patientDBContext.Patients.Add(
new Patient()
{
Id = Guid.NewGuid(),
First_Name = "Hull",
Last_Name = "Johnson",
Gender = "male",
Date_Of_Birth = Convert.ToDateTime("1970-06-26"),
Email = "*****@*****.**",
Phone = "02 94983574",
Is_Active = true,
Created_At = DateTime.UtcNow,
Updated_At = DateTime.UtcNow
});
patientDBContext.SaveChanges();
}
// This method gets called by the runtime. Use this method to configure the HTTP request pipeline.
public void Configure(IApplicationBuilder app, IHostingEnvironment env, PatientDBContext patientDBContext)
{
app.UseMvc();
LoadPatientData.LoadPatientContextData(patientDBContext);
}
public DiseasesController(PatientDBContext context)
{
_context = context;
}
public PatientRepository(PatientDBContext dbContext)
{
_dbContext = dbContext;
}
public MetaDatasController(PatientDBContext context)
{
_context = context;
}
public UsersController(PatientDBContext context)
{
_context = context;
}
public PatientApi(PatientDBContext sc, IMapper mapper)
{
patientDBContext = sc;
_mapper = mapper;
}
public PatientModelsController(PatientDBContext context)
{
_context = context;
}
public RecordsController(PatientDBContext context)
{
_context = context;
}
