public int DeleteHospitalFromDB(int userid, int hospitalid)
{
using (var context = new assignmentEntities())
{
var deletedHospital = context.hospitals.FirstOrDefault(x => x.userid == userid && x.hospitalid == hospitalid);
if (deletedHospital != null)
{
context.hospitals.Remove(deletedHospital);
return(context.SaveChanges());
}
else
{
return(-1);
}
}
}
public int AddHospitalToDB(Hospital hospital)
{
using (var context = new assignmentEntities())
{
context.hospitals.Add(new hospitals()
{
userid = hospital.UserId,
address = hospital.Address,
email = hospital.Email,
hospitalname = hospital.HospitalName,
phone1 = hospital.Phone1,
phone2 = hospital.Phone2,
isprimary = hospital.IsPrimary
});
return(context.SaveChanges());
}
}
public int UpdateHospitalToDB(Hospital hospital)
{
using (var context = new assignmentEntities())
{
var updatedHospital = context.hospitals.FirstOrDefault(x => x.userid == hospital.UserId && x.hospitalid == hospital.HospitalId);
if (updatedHospital != null)
{
updatedHospital.address = hospital.Address;
updatedHospital.email = hospital.Email;
updatedHospital.hospitalname = hospital.HospitalName;
updatedHospital.phone1 = hospital.Phone1;
updatedHospital.phone2 = hospital.Phone2;
updatedHospital.isprimary = hospital.IsPrimary;
return(context.SaveChanges());
}
else
{
return(-1);
}
}
}