public bool DeleteAppointment(ref AppointmentBDO app, ref string message) { message = "Doctor deleted successfully"; var ret = true; using (var PHEntities = new PublicHospitalEntities()) { var appId = app.id; var appointmentInDb = (from a in PHEntities.Appointment where a.id == appId select a).FirstOrDefault(); if (appointmentInDb != null) { PHEntities.Appointment.Remove(appointmentInDb); var num = PHEntities.SaveChanges(); if (num != 1) { ret = false; } } else { ret = false; message = "Appointment not found"; } return ret; } }
public bool InsertAdmin(ref AdminBDO adminBDO, ref string massage) { massage = "Admin inserted successfully"; var ret = true; Password passObj = new Password(); string[] passAndSalt = passObj.getFullyHash(adminBDO.pass); using (var PHEntities = new PublicHospitalEntities()) { PHEntities.Admin.Add(new Admin { id = GetNextID(), firstName = adminBDO.firstName, lastName = adminBDO.lastName, city = adminBDO.city, street = adminBDO.street, streetNr = adminBDO.streetNr, phoneNr = adminBDO.phoneNr, zip = adminBDO.zip, login = adminBDO.login, pass = passAndSalt[0], salt = passAndSalt[1] }); var num = PHEntities.SaveChanges(); if (num != 1) { ret = false; massage = "Admin was not inserted"; } } return ret; }
public bool UpdatePatient(ref PatientBDO patientBDO, ref string massage) { massage = "Patient updated successfully"; var ret = true; using (var PHEntites = new PublicHospitalEntities()) { var patientId = patientBDO.id; var patientInDb = (from a in PHEntites.Patient where a.id == patientId select a).FirstOrDefault(); if (patientInDb == null) { throw new Exception("No patient with id " + patientBDO.id); } patientInDb.firstName = patientBDO.firstName; patientInDb.lastName = patientBDO.lastName; patientInDb.city = patientBDO.city; patientInDb.zip = patientBDO.zip; patientInDb.street = patientBDO.street; patientInDb.streetNr = patientBDO.streetNr; patientInDb.phoneNr = patientBDO.phoneNr; patientInDb.dateOfBirth = patientBDO.dateOfBirth; //without username and pass PHEntites.Patient.Attach(patientInDb); PHEntites.Entry(patientInDb).State = System.Data.Entity.EntityState.Modified; var num = PHEntites.SaveChanges(); if (num != 1) { ret = false; massage = "Patient was not updated"; } } return ret; }
public bool InsertVisit(ref VisitBDO VisitBDO, ref string massage) { massage = "Visit inserted successfully"; var ret = true; using (var PHEntities = new PublicHospitalEntities()) { PHEntities.Visit.Add(new Visit { Ap_Id = VisitBDO.id, advice = VisitBDO.advice, symptom = VisitBDO.symptom, patientProblem = VisitBDO.patientProblem, rowVersion = VisitBDO.rowVersion }); var num = PHEntities.SaveChanges(); if (num != 1) { ret = false; massage = "Visit was not inserted"; } } return ret; }
public bool UpdateAdmin(ref AdminBDO adminBDO, ref string massage) { massage = "Admin updated successfully"; var ret = true; using (var PHEntites = new PublicHospitalEntities()) { var adminId = adminBDO.id; var adminInDb = (from a in PHEntites.Admin where a.id == adminId select a).FirstOrDefault(); if (adminInDb == null) { throw new Exception("No admin with id " + adminBDO.id); } adminInDb.firstName = adminBDO.firstName; adminInDb.lastName = adminBDO.lastName; adminInDb.city = adminBDO.city; adminInDb.zip = adminBDO.zip; adminInDb.street = adminBDO.street; adminInDb.streetNr = adminBDO.streetNr; adminInDb.phoneNr = adminBDO.phoneNr; //without username and pass PHEntites.Admin.Attach(adminInDb); PHEntites.Entry(adminInDb).State = System.Data.Entity.EntityState.Modified; var num = PHEntites.SaveChanges(); if (num != 1) { ret = false; massage = "Admin was not updated"; } } return ret; }
public bool UpdateVisit(ref VisitBDO VisitBDO) { var ret = true; using (var PHEntites = new PublicHospitalEntities()) { var VisitId = VisitBDO.id; var VisitInDb = (from a in PHEntites.Visit where a.Ap_Id == VisitId select a).FirstOrDefault(); if (VisitInDb == null) { throw new Exception("No Visit with id " + VisitBDO.id); } VisitInDb.Ap_Id = VisitBDO.id; VisitInDb.advice = VisitBDO.advice; VisitInDb.symptom = VisitBDO.symptom; VisitInDb.patientProblem = VisitBDO.patientProblem; VisitInDb.rowVersion = VisitBDO.rowVersion; //without username and pass PHEntites.Visit.Attach(VisitInDb); PHEntites.Entry(VisitInDb).State = System.Data.Entity.EntityState.Modified; var num = PHEntites.SaveChanges(); VisitBDO.rowVersion = VisitInDb.rowVersion; if (num != 1) { ret = false; } } return ret; }
public bool InsertPatient(ref PatientBDO patientBDO, ref string massage) { massage = "Patient inserted successfully"; var ret = true; Password passObj = new Password(); string[] passAndSalt = passObj.getFullyHash(patientBDO.pass); using (var PHEntities = new PublicHospitalEntities()) { PHEntities.Patient.Add(new Patient { id = GetNextID(), firstName = patientBDO.firstName, lastName = patientBDO.lastName, city = patientBDO.city, street = patientBDO.street, streetNr = patientBDO.streetNr, phoneNr = patientBDO.phoneNr, zip = patientBDO.zip, login = patientBDO.login, dateOfBirth = patientBDO.dateOfBirth, rowVersion = patientBDO.RowVersion, pass = passAndSalt[0], salt = passAndSalt[1] }); var num = PHEntities.SaveChanges(); if (num != 1) { ret = false; massage = "Patient was not inserted"; } } return ret; }
private string setSessionIdDB(string idd, int type) { string sessionID = getSessionID(); int changes = 0; using (var PHEntities = new PublicHospitalEntities()) { int id = 0; Int32.TryParse(idd, out id); switch (type) { case 0: var admin = (from a in PHEntities.Admin where a.id == id select a).FirstOrDefault(); admin.sessionID = sessionID; changes = PHEntities.SaveChanges(); break; case 1: var doctor = (from a in PHEntities.Doctor where a.id == id select a).FirstOrDefault(); doctor.sessionID = sessionID; changes = PHEntities.SaveChanges(); break; case 2: var patient = (from a in PHEntities.Patient where a.id == id select a).FirstOrDefault(); patient.sessionID = sessionID; changes = PHEntities.SaveChanges(); break; } if (changes != 1) sessionID = null; } return sessionID; }
public bool Updateappointment(ref AppointmentBDO appointmentBDO, ref string massage) { massage = "appointment updated successfully"; var ret = true; using (var PHEntites = new PublicHospitalEntities()) { var appointmentId = appointmentBDO.id; var appointmentInDb = (from a in PHEntites.Appointment where a.id == appointmentId select a).FirstOrDefault(); if (appointmentInDb == null) { throw new Exception("No appointment with id " + appointmentBDO.id); } appointmentInDb.id = appointmentBDO.id; appointmentInDb.time = appointmentBDO.time.Date; appointmentInDb.serviceType = appointmentBDO.serviceType; appointmentInDb.idPatient = appointmentBDO.patient.id; appointmentInDb.idDoctor = appointmentBDO.patient.id; appointmentInDb.rowVersion = appointmentBDO.rowVersion; PHEntites.Appointment.Attach(appointmentInDb); PHEntites.Entry(appointmentInDb).State = System.Data.Entity.EntityState.Modified; var num = PHEntites.SaveChanges(); appointmentBDO.rowVersion = appointmentInDb.rowVersion; if (num != 1) { ret = false; massage = "appointment was not updated"; } } return ret; }
public bool InsertAppointment(ref AppointmentBDO appointmentBDO, ref string massage) { massage = "Appointment inserted successfully"; var ret = true; using (var PHEntities = new PublicHospitalEntities()) { PHEntities.Appointment.Add(new Appointment { id = appointmentBDO.id, time = appointmentBDO.time, serviceType = appointmentBDO.serviceType, idPatient = appointmentBDO.patient.id, idDoctor = appointmentBDO.doctor.id, rowVersion = appointmentBDO.rowVersion }); var num = PHEntities.SaveChanges(); if (num != 1) { ret = false; massage = "Appointment was not inserted"; } } return ret; }