public ActionResult CreateRoute(RouteViewModel inputData)
{
using (HomecareDBEntities db = new HomecareDBEntities())
{
var caretakerIdToDb = db.Caretakers
.FirstOrDefault(ci => ci.caretaker_name == inputData.caretaker)
.id_caretaker;
var addressIdToDb = db.Patients
.FirstOrDefault(ai => ai.cpr == inputData.patientCpr).fk_address_patient;
var arrivalToDb = inputData.date.TimeOfDay;
var dateToDb = inputData.date.Date;
var route = new Route
{
arrival = arrivalToDb,
date = dateToDb,
fk_caretaker_route = caretakerIdToDb,
fk_address_route = addressIdToDb
};
db.Routes.Add(route);
db.SaveChanges();
};
return(View());
}
public ActionResult PatientDetails(int?id)
{
if (id == null)
{
return(new HttpStatusCodeResult(HttpStatusCode.BadRequest));
}
HomecareDBEntities db = new HomecareDBEntities();
Patient patient = db.Patients.Find(id);
if (patient == null)
{
return(HttpNotFound());
}
Address address = db.Addresses.Find(patient.fk_address_patient);
Phone phone = db.Phones.Find(patient.fk_phone_patient);
City city = db.Cities.Find(address.fk_city_address);
PatientViewModel pvm = new PatientViewModel
{
name = patient.patient_name,
cpr = patient.cpr,
relativePhonenumber = patient.relative_phonenumber,
roadname = address.road_name,
number = address.number,
cityName = city.city_name,
zipCode = city.zipcode,
phonenumber = phone.phone_number,
};
return(View(pvm));
}
/*public ActionResult PatientList ()
* {
* using (HomecareDBEntities db = new HomecareDBEntities())
* {
* return View(db.Patients.ToList());
* }
* }*/
public ActionResult PatientView()
{
using (HomecareDBEntities db = new HomecareDBEntities())
{
return(View(db.PatientViews.ToList()));
}
}
public ActionResult EditPatient(PatientViewModel pvm, int?id)
{
if (ModelState.IsValid)
{
HomecareDBEntities db = new HomecareDBEntities();
Patient patient = db.Patients.Find(id);
Phone phone = db.Phones.Find(patient.fk_phone_patient);
Address address = db.Addresses.Find(patient.fk_address_patient);
City city = db.Cities.Find(address.fk_city_address);
phone.phone_number = pvm.phonenumber;
city.city_name = pvm.cityName;
city.zipcode = pvm.zipCode;
address.road_name = pvm.roadname;
address.number = pvm.number;
patient.patient_name = pvm.name;
patient.cpr = pvm.cpr;
patient.relative_phonenumber = pvm.relativePhonenumber;
db.SaveChanges();
return(RedirectToAction("PatientList"));
}
return(View());
}
public ActionResult CreatePatient(PatientViewModel inputData)
{
if (ModelState.IsValid)
{
using (HomecareDBEntities db = new HomecareDBEntities())
{
var c = new City
{
city_name = inputData.cityName,
zipcode = inputData.zipCode
};
db.Cities.Add(c);
db.SaveChanges();
var phone = new Phone
{
phone_number = inputData.phonenumber,
};
db.Phones.Add(phone);
var cityId = db.Cities.FirstOrDefault(ci => ci.city_name == inputData.cityName).id_city;
var address = new Address
{
road_name = inputData.roadname,
number = inputData.number,
fk_city_address = cityId
};
db.Addresses.Add(address);
db.SaveChanges();
var addressId = db.Addresses
.FirstOrDefault(ai =>
ai.road_name == inputData.roadname &&
ai.number == inputData.number)
.id_address;
var phoneId = db.Phones.FirstOrDefault(pi => pi.phone_number == inputData.phonenumber).id_phone;
var p = new Patient
{
patient_name = inputData.name,
cpr = inputData.cpr,
relative_phonenumber = inputData.relativePhonenumber,
fk_address_patient = addressId,
fk_phone_patient = phoneId
};
db.Patients.Add(p);
db.SaveChanges();
}
ModelState.Clear();
ViewBag.Message = inputData.name + " was created";
}
return(View());
}
public ActionResult CreateCaretaker(CaretakerViewModel inputData)
{
if (ModelState.IsValid)
{
using (HomecareDBEntities db = new HomecareDBEntities())
{
var userRights = new User_Rights
{
user_rights_type = inputData.user_rights
};
db.User_Rights.Add(userRights);
db.SaveChanges();
var userRightsID = db.User_Rights.FirstOrDefault(ur => ur.user_rights_type == inputData.user_rights).id_user_rights;
var userLogin = new Login
{
username = inputData.username,
password = inputData.password,
fk_user_rights_login = userRightsID
};
db.Logins.Add(userLogin);
db.SaveChanges();
var phonenumber = new Phone
{
phone_number = inputData.phonenumber
};
db.Phones.Add(phonenumber);
db.SaveChanges();
var loginID = db.Logins.FirstOrDefault(login => login.username == inputData.username).id_login;
var phoneID = db.Phones.FirstOrDefault(phone => phone.phone_number == inputData.phonenumber).id_phone;
var caretaker = new Caretaker
{
caretaker_name = inputData.name,
fk_login_caretaker = loginID,
fk_phone_caretaker = phoneID
};
db.Caretakers.Add(caretaker);
db.SaveChanges();
}
ModelState.Clear();
ViewBag.Message = inputData.name + " was created";
}
return(View());
}
public async Task <ActionResult> Login(LoginViewModel model, string returnUrl)
{
if (!ModelState.IsValid)
{
return(View(model));
}
//db.Phones.FirstOrDefault(pi => pi.phone_number == inputData.phonenumber).id_phone;
using (HomecareDBEntities db = new HomecareDBEntities())
{
var userLogin = db.Logins.SingleOrDefault(x => x.username == model.Email && x.password == model.Password);
if (userLogin != null)
{
Session["username"] = model.Email;
return(RedirectToAction("Index", "Home", new { username = model.Email }));
}
else
{
return(View());
}
}
// This doesn't count login failures towards account lockout
// To enable password failures to trigger account lockout, change to shouldLockout: true
//var result = await SignInManager.PasswordSignInAsync(model.Email, model.Password, model.RememberMe, shouldLockout: false);
//switch (result)
//{
// case SignInStatus.Success:
// return RedirectToLocal(returnUrl);
// case SignInStatus.LockedOut:
// return View("Lockout");
// case SignInStatus.RequiresVerification:
// return RedirectToAction("SendCode", new { ReturnUrl = returnUrl, RememberMe = model.RememberMe });
// case SignInStatus.Failure:
// default:
// ModelState.AddModelError("", "Invalid login attempt.");
// return View(model);
//}
}
public ActionResult DeletePatient(int id)
{
HomecareDBEntities db = new HomecareDBEntities();
Patient patient = db.Patients.Find(id);
Address address = db.Addresses.Find(patient.fk_address_patient);
City city = db.Cities.Find(address.fk_city_address);
Phone phone = db.Phones.Find(patient.fk_phone_patient);
db.Patients.Remove(patient);
db.Addresses.Remove(address);
//db.Cities.Remove(city);
db.Phones.Remove(phone);
db.SaveChanges();
return(RedirectToAction("PatientList"));
}
public ActionResult RouteList()
{
HomecareDBEntities db = new HomecareDBEntities();
return(View(db.Routes.ToList()));
}
