public void Dispose()
{
if (db != null)
{
db.Database.Connection.Close();
db = null;
}
}
public static bool isAuthorized(int?roleId)
{
bool ans = false;
using (HITProjectData_Fall17Entities1 db = new HITProjectData_Fall17Entities1())
{
user u = db.users.Find(GetUserID());
if (u.roleId <= roleId)
{
ans = true;
}
}
return(ans);
}
public ActionResult Index()
{
try
{
using (HITProjectData_Fall17Entities1 db = new HITProjectData_Fall17Entities1())
{
user account = db.users.Find(UserAccount.GetUserID());
if (account.role.title == "Disabled")
{
ViewBag.isDisabled = true;
}
}
}
catch (Exception e) {
//Add an error message here later
Console.WriteLine(e.Message);
}
return(View());
}
public ActionResult SignIn(FormCollection form, string ReturnUrl)
{
using (HITProjectData_Fall17Entities1 db = new HITProjectData_Fall17Entities1())
{
var userEmail = form["email"];
List <userAccount> accountList = db.userAccounts.Where(u => u.userName == userEmail).ToList();
//Verify list returned an account.
if (accountList.Any())
{
userAccount uA = accountList[0];
string str = UserAccount.HashSHA1(form["password"] + uA.userGuid);
if (str == uA.passwordHash)
{
user user = db.users.Find(uA.userId);
FormsAuthentication.SetAuthCookie(uA.userId.ToString(), false);
HttpCookie userRoleCookie = new HttpCookie("role");
userRoleCookie.Value = user.role.title;
Response.Cookies.Add(userRoleCookie);
HttpCookie userIdCookie = new HttpCookie("userId");
userIdCookie.Value = Convert.ToString(user.userId);
Response.Cookies.Add(userIdCookie);
if (ReturnUrl != null)
{
return(Redirect(ReturnUrl));
}
return(RedirectToAction("Index", "Home"));
}
TempData["error"] = "Sorry, invalid user credentials. Please try again";
ModelState.AddModelError("Password", "Incorrect password");
}
else
{
TempData["error"] = "Sorry, an account with that email was not found.";
logger.Info("User tried to login with an invalid email: " + userEmail);
}
}
return(View());
}
public ActionResult Create([Bind(Include = "birthRecordId,certiferName,certiferTitle,certiferDate,filedDate,paternityAck,ssnRequested,facilityId,birthFacility,homebirth,attendantName,attendantNpi,attendantTitle,motherTransferred,transferFacility,firstPrenatal,lastPrenatal,totalPrenatal,motherPreWeight,motherPostWeight,motherDeliveryWeight,hadWic,previousBirthLiving,previousBirthDead,lastLiveBirth,otherBirthOutcomes,lastOtherOutcome,cigThreeBefore,packThreeBefore,cigFirstThree,packFirstThree,cigSecondThree,packSecondThree,cigThirdTri,packThirdTri,paymentSource,dateLastMenses,diabetesPrepregnancy,diabetesGestational,hyperTensionPrepregnancy,hyperTensionGestational,hyperTensionEclampsia,prePreTerm,prePoorOutcome,resultInfertility,fertilityDrug,assistedTech,previousCesarean,previousCesareanAmount,gonorrhea,syphilis,chlamydia,hepB,hepC,cervicalCerclage,tocolysis,externalCephalic,preRuptureMembrane,preLabor,proLabor,inductionLabor,augmentationLabor,nonvertex,steroids,antibotics,chorioamnionitis,meconium,fetalIntolerance,epidural,unsuccessfulForceps,unsuccessfulVacuum,cephalic,breech,otherFetalPresentation,finalSpontaneous,finalForceps,finalVacuum,finalCesarean,finalTrialOfLabor,maternalTransfusion,perinealLaceration,rupturedUterus,hysterectomy,admitICU,unplannedOperating, birthWeight, fiveMinAgpar,tenMinAgpar,plurality,birthOrder,ventImmedite,ventSixHours,nicu,surfactant,neoNatalAntibotics,seizureDysfunction,birthInjury,anencephaly,meningomyelocele,cyanotic,cogenital,omphalocele,gastroschisis,limbReduction,cleftLip,cleftPalate,downConfirmed,downPending,suspectedConfirmed,suspectedPending,hypospadias,infantTransferred,infantLiving,breastFed,dateCreated,dateEdited,editedBy")] zz_birthRecord birthRecord, FormCollection form)
{
user account = newDB.users.Find(UserAccount.GetUserID());
if (ModelState.IsValid)
{
//Create Child Info
zz_patient child = new zz_patient();
child.firstName = form["childFirstName"];
child.middleName = form["childMiddleName"];
child.lastName = form["childLastName"];
child.suffix = form["childSuffix"];
child.birthTime = TimeSpan.Parse(form["timeOfBirth"]);
child.gender = form["genderList"];
child.birthDate = Convert.ToDateTime(form["childBirthDate"]);
child.birthFacility = form["facilityName"];
child.birthCity = form["childBirthLocation"];
child.birthCounty = form["childBirthCounty"];
child.birthWeight = Convert.ToInt32(form["birthWeight"]);
if (Request.Cookies["userId"] != null)
{
HttpCookie aCookie = Request.Cookies["userId"];
child.editedBy = Convert.ToInt32(Server.HtmlEncode(aCookie.Value));
}
child.dateCreated = DateTime.Now;
child.dateUpdated = DateTime.Now;
Random random = new Random();
int childMRN = random.Next(100000000, 999999999);
using (HITProjectData_Fall17Entities1 newDB = new HITProjectData_Fall17Entities1())
{
string randomNumberString = Convert.ToString(childMRN);
List <zz_patient> patients = newDB.zz_patient.Where(p => p.medicalRecordNumber == randomNumberString).ToList();
while (patients.Count > 0)
{
childMRN = random.Next(100000000, 999999999);
randomNumberString = Convert.ToString(childMRN);
patients = newDB.zz_patient.Where(p => p.medicalRecordNumber == randomNumberString).ToList();
}
}
child.medicalRecordNumber = Convert.ToString(childMRN);
//Add and save child to Database
newDB.zz_patient.Add(child);
newDB.SaveChanges();
//Mother info
int id = Convert.ToInt32(form["motherId"]);
zz_patient mother = newDB.zz_patient.Find(id);
mother.firstName = form["motherFirstName"];
mother.middleName = form["motherMiddleName"];
mother.lastName = form["motherLastName"];
mother.suffix = form["motherSuffix"];
mother.birthDate = Convert.ToDateTime(form["motherDOB"]);
mother.priorFirstName = form["motherPriorFirstName"];
mother.priorMiddleName = form["motherPriorMiddleName"];
mother.priorLastName = form["motherPriorLastName"];
mother.priorSuffix = form["motherPriorSuffix"];
mother.residenceState = form["state"];
mother.residenceCounty = form["motherCountry"];
mother.residenceCity = form["motherCity"];
mother.residenceStreetAddress = form["motherAddress"];
mother.residenceAptNo = form["motherAptNo"];
mother.residenceZip = form["motherZip"];
mother.inCity = Convert.ToBoolean(form["inCity"].Split(',')[0]);
newDB.Entry(mother).State = EntityState.Modified;
newDB.SaveChanges();
//Add Mother address to child
child.residenceState = form["state"];
child.residenceCounty = form["motherCountry"];
child.residenceCity = form["motherCity"];
child.residenceStreetAddress = form["motherAddress"];
child.residenceAptNo = form["motherAptNo"];
child.residenceAptNo = form["motherZip"];
newDB.Entry(child).State = EntityState.Modified;
newDB.SaveChanges();
//Father Information
zz_patient father = new zz_patient();
//If father information exists
//TODO add logic for father lookup
if (form["fatherFirstName"] != "")
{
father.firstName = form["fatherFirstName"];
father.middleName = form["fatherMiddleName"];
father.lastName = form["fatherLastName"];
father.suffix = form["fatherSuffix"];
father.birthDate = Convert.ToDateTime(form["fatherDOB"]);
father.birthState = form["fatherBirthplace"];
int fatherMRN = random.Next(100000000, 999999999);
using (HITProjectData_Fall17Entities1 newDB = new HITProjectData_Fall17Entities1())
{
string randomNumberString = Convert.ToString(fatherMRN);
List <zz_patient> patients = newDB.zz_patient.Where(p => p.medicalRecordNumber == randomNumberString).ToList();
while (patients.Count > 0)
{
fatherMRN = random.Next(100000000, 999999999);
randomNumberString = Convert.ToString(fatherMRN);
patients = newDB.zz_patient.Where(p => p.medicalRecordNumber == randomNumberString).ToList();
}
}
father.medicalRecordNumber = Convert.ToString(fatherMRN);
//Add and save father to Database
newDB.zz_patient.Add(father);
newDB.SaveChanges();
}
//Certifier information
birthRecord.certiferName = form["certifierName"];
birthRecord.certiferTitle = form["certifierTitleList"];
if (birthRecord.certiferTitle == "Other")
{
birthRecord.certiferTitle = form["certifierTitleOther"];
}
birthRecord.certiferDate = Convert.ToDateTime(form["dateCertified"]);
birthRecord.filedDate = Convert.ToDateTime(form["datedFiled"]);
//Mother2 Info
mother.mailingState = form["stateList"];
mother.mailingCity = form["motherMailingCity"];
mother.mailingStreetAddress = form["motherMailingAddress"];
mother.mailingAptNo = form["motherMailingAptNo"];
mother.mailingZip = form["motherMailingZip"];
mother.isMarried = Convert.ToBoolean(form["isMarried"].Split(',')[0]);
//TODO null check
mother.SSN = form["motherSSN"];
child.motherSSN = form["motherSSN"];
//TODO null check
if (form["fatherFirstName"] != "")
{
father.SSN = form["fatherSSN"];
child.fatherSSN = form["fatherSSN"];
newDB.Entry(father).State = EntityState.Modified;
}
newDB.Entry(child).State = EntityState.Modified;
newDB.Entry(mother).State = EntityState.Modified;
newDB.SaveChanges();
//Mother3 Info
mother.educationEarned = form["motherEducation"];
mother.hispanic = form["motherHispanic"];
if (mother.hispanic == "Yes, other Spanish/Hispanic/Latina")
{
mother.hispanic = "motherHispanicOther";
}
newDB.Entry(mother).State = EntityState.Modified;
newDB.SaveChanges();
zz_patientRace motherRace = new zz_patientRace();
motherRace.patientId = id;
motherRace.white = Convert.ToBoolean(form["motherWhite"].Split(',')[0]);
motherRace.black = Convert.ToBoolean(form["motherBlack"].Split(',')[0]);
motherRace.tribe = form["mothertribe"];
motherRace.asianIndian = Convert.ToBoolean(form["motherAsianIndian"].Split(',')[0]);
motherRace.chinese = Convert.ToBoolean(form["motherChinese"].Split(',')[0]);
motherRace.flipino = Convert.ToBoolean(form["motherFilipino"].Split(',')[0]);
motherRace.japanese = Convert.ToBoolean(form["motherJapanese"].Split(',')[0]);
motherRace.korean = Convert.ToBoolean(form["motherKorean"].Split(',')[0]);
motherRace.vietnamese = Convert.ToBoolean(form["motherVietnamese"].Split(',')[0]);
motherRace.otherAsian = form["motherOtherAsian"];
motherRace.hawaiian = Convert.ToBoolean(form["motherHawaiian"].Split(',')[0]);
motherRace.guamanian = Convert.ToBoolean(form["motherGuamanian"].Split(',')[0]);
motherRace.samoan = Convert.ToBoolean(form["motherSamoan"].Split(',')[0]);
motherRace.pacificIslander = form["motherOtherIslander"];
motherRace.other = form["motherOtherRace"];
newDB.zz_patientRace.Add(motherRace);
newDB.SaveChanges();
//Father 2 Information
if (form["fatherFirstName"] != "")
{
father.educationEarned = form["fatherEducation"];
father.hispanic = form["fatherHispanic"];
if (father.hispanic == "Yes, other Spanish/Hispanic/Latina")
{
father.hispanic = "fatherHispanicOther";
}
newDB.Entry(father).State = EntityState.Modified;
newDB.SaveChanges();
List <zz_patient> patients = newDB.zz_patient.Where(p => p.medicalRecordNumber == father.medicalRecordNumber).ToList();
zz_patientRace fatherRace = new zz_patientRace();
fatherRace.patientId = patients[0].patientId;
fatherRace.white = Convert.ToBoolean(form["fatherWhite"].Split(',')[0]);
fatherRace.black = Convert.ToBoolean(form["fatherBlack"].Split(',')[0]);
fatherRace.tribe = form["fatherTribe"];
fatherRace.asianIndian = Convert.ToBoolean(form["fatherAsianIndian"].Split(',')[0]);
fatherRace.chinese = Convert.ToBoolean(form["fatherChinese"].Split(',')[0]);
fatherRace.flipino = Convert.ToBoolean(form["fatherFilipino"].Split(',')[0]);
fatherRace.japanese = Convert.ToBoolean(form["fatherJapanese"].Split(',')[0]);
fatherRace.korean = Convert.ToBoolean(form["fatherKorean"].Split(',')[0]);
fatherRace.vietnamese = Convert.ToBoolean(form["fatherVietnamese"].Split(',')[0]);
fatherRace.otherAsian = form["fatherOtherAsian"];
fatherRace.hawaiian = Convert.ToBoolean(form["fatherHawaiian"].Split(',')[0]);
fatherRace.guamanian = Convert.ToBoolean(form["fatherGuamanian"].Split(',')[0]);
fatherRace.samoan = Convert.ToBoolean(form["fatherSamoan"].Split(',')[0]);
fatherRace.pacificIslander = form["fatherOtherIslander"];
fatherRace.other = form["fatherOtherRace"];
newDB.zz_patientRace.Add(fatherRace);
newDB.SaveChanges();
}
birthRecord.birthFacility = form["birthOccuredPlace"];
if (birthRecord.birthFacility == "Other")
{
birthRecord.birthFacility = form["birthOccuredPlaceOther"];
}
birthRecord.attendantTitle = form["attendantTitleList"];
if (birthRecord.attendantTitle == "Other")
{
birthRecord.attendantTitle = form["attendantNPIOther"];
}
birthRecord.noPrenatal = Convert.ToBoolean(form["noPrenatal"].Split(',')[0]);
if (birthRecord.noPrenatal == false)
{
birthRecord.firstPrenatal = Convert.ToDateTime(form["firstPrenatal"]);
birthRecord.lastPrenatal = Convert.ToDateTime(form["lastPrenatal"]);
}
mother.height = Convert.ToInt32(form["motherHeight"]);
birthRecord.lastLiveBirth = Convert.ToDateTime(form["lastLiveBirth"]);
birthRecord.lastOtherOutcome = Convert.ToDateTime(form["lastOtherOutcome"]);
birthRecord.paymentSource = form["paymentList"];
if (birthRecord.paymentSource == "Other")
{
birthRecord.paymentSource = form["paymentOther"];
}
birthRecord.dateLastMenses = Convert.ToDateTime(form["dateLastMenses"]);
birthRecord.infantLiving = form["infantLiving"];
newDB.Entry(mother).State = EntityState.Modified;
newDB.zz_birthRecord.Add(birthRecord);
newDB.SaveChanges();
//TODO add record to bridging table
//Add Mother
zz_record motherR = new zz_record();
var userId = Convert.ToInt32(Request.Cookies["userId"].Value);
List <user> users = newDB.users.Where(u => u.userId == userId).ToList();
motherR.hospitalId = users[0].hospitalId;
motherR.patientId = mother.patientId;
motherR.birthRecordId = birthRecord.birthRecordId;
newDB.zz_record.Add(motherR);
newDB.SaveChanges();
//Add Father
if (form["fatherFirstName"] != "")
{
zz_record fatherR = new zz_record();
fatherR.hospitalId = users[0].hospitalId;
fatherR.patientId = father.patientId;
fatherR.birthRecordId = birthRecord.birthRecordId;
newDB.zz_record.Add(fatherR);
newDB.SaveChanges();
}
//Add Child
zz_record childR = new zz_record();
childR.hospitalId = users[0].hospitalId;
childR.patientId = child.patientId;
childR.birthRecordId = birthRecord.birthRecordId;
newDB.zz_record.Add(childR);
newDB.SaveChanges();
logger.Info("User " + account.firstName + " " + account.lastName + " created birth record: " + birthRecord.birthRecordId);
return(RedirectToAction("Index"));
}
return(View(birthRecord));
}
public ActionResult PatientLookup(System.Web.Mvc.FormCollection form)
{
ViewBag.statusMessage = "";
using (HITProjectData_Fall17Entities1 newDB = new HITProjectData_Fall17Entities1())
{
List <patient_general_info> patientToCollection = new List <patient_general_info>();
patient_general_info patients = null;
string button = Request.Form["button"];
string mrn = Request.Form["mrn"];
string ssn = Request.Form["ssn1"];
string last = Request.Form["last"];
ViewBag.patient = ssn;
ViewBag.mrn = mrn;
if (mrn.Length < 1 && ssn.Length < 1)
{
if (last.Length < 1)
{
ViewBag.statusMessage = "Both fields were blank when the lookup was submitted";
}
else
{
patientToCollection = db.patient_general_info.Where(r => r.last_name.Contains(last)).ToList();
return(View("PatientResults", patientToCollection));
}
}
else if (mrn.Length > 0 && ssn.Length > 0)
{
ViewBag.statusMessage = "Data was contained in both input fields. Please look up a patient by MRN or SSN, not both.";
}
else if (mrn.Length > 5 && mrn.Length < 7)
{
patients = db.patient_general_info.Where(r => r.medical_record_number == mrn).FirstOrDefault();
if (patients != null)
{
if (patients.birth_date != null && patients.first_name != null)
{
patientToCollection.Add(patients);
return(View("PatientResults", patientToCollection));
}
else
{
ViewBag.patient = ssn;
return(View("Create"));
}
}
else
{
ViewBag.patientFound = false;
return(View());
}
}
else if (ssn.Length > 8 && ssn.Length < 10)
{
patients = db.patient_general_info.Where(r => r.social_security_number == ssn).FirstOrDefault();
if (patients != null)
{
if (patients.birth_date != null && patients.first_name != null)
{
patientToCollection.Add(patients);
ViewBag.patient = ssn;
return(View("PatientResults", patientToCollection));
}
else
{
ViewBag.patient = ssn;
return(View("Create"));
}
}
else
{
patient p = db.patients.Where(r => r.social_security_number == ssn).FirstOrDefault();
if (p != null)
{
ViewBag.patient = p.social_security_number;
ViewBag.mrn = p.medical_record_number;
return(View("Create"));
}
else
{
ViewBag.patientFound = false;
return(View());
}
}
}
else
{
ViewBag.statusMessage = "Please make sure that the input is the proper length. MRN(6) SSN(9)";
}
//Input not filled in.
return(View());
}
}
