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;
}
