public Hospital GetHospitalDetailsFromDB(int userid, int hospitalid)
{
using (var context = new assignmentEntities())
{
hospitals h = context.hospitals.FirstOrDefault(x => x.userid == userid && x.hospitalid == hospitalid);
if (h != null)
{
return(new Hospital()
{
status = 1,
HospitalId = h.hospitalid,
UserId = h.userid,
Address = h.address,
Email = h.email,
HospitalName = h.hospitalname,
Phone1 = h.phone1,
Phone2 = h.phone2,
IsPrimary = h.isprimary
});
}
else
{
return(new Hospital()
{
status = -1
});
}
}
}
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 List <Hospital> GetHospitalsFromDB(int userid)
{
using (var context = new assignmentEntities())
{
return(context.hospitals.Where(x => x.userid == userid).Select(x => new Hospital()
{
HospitalId = x.hospitalid,
UserId = x.userid,
Address = x.address,
Email = x.email,
HospitalName = x.hospitalname,
Phone1 = x.phone1,
Phone2 = x.phone2,
IsPrimary = x.isprimary
}).ToList());
}
}
public List <Hospital> GetAllHospitalsFromDB()
{
using (var context = new assignmentEntities())
{
return(context.hospitals.Select(x => new Hospital()
{
hospitalid = x.hospitalid,
userid = x.userid,
address = x.address,
email = x.email,
hospitalname = x.hospitalname,
phone1 = x.phone1,
phone2 = x.phone2,
isprimary = x.isprimary
}).ToList());
}
}
public Hospital GetHospitalDetailsFromDB(int userid, int hospitalid)
{
using (var context = new assignmentEntities())
{
hospitals h = context.hospitals.FirstOrDefault(x => x.userid == userid && x.hospitalid == hospitalid);
return(new Hospital()
{
hospitalid = h.hospitalid,
userid = h.userid,
address = h.address,
email = h.email,
hospitalname = h.hospitalname,
phone1 = h.phone1,
phone2 = h.phone2,
isprimary = h.isprimary
});
}
}
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);
}
}
}