public IList <DoctorEntity> SelectByLastname(String lastname)
{
gsbEntities context = new gsbEntities();
IList <DoctorEntity> listDoctorsEntity = new List <DoctorEntity>();
IList <doctors> docs = (from d in context.doctors where d.lastname == lastname select d).ToList();
DoctorEntity doctorEntity = null;
foreach (doctors doc in docs)
{
doctorEntity = new DoctorEntity();
doctorEntity.Id = doc.id;
doctorEntity.FirstName = doc.firstname;
doctorEntity.LastName = doc.lastname;
doctorEntity.Address = doc.address;
doctorEntity.Phone = doc.phone;
doctorEntity.Specialty = doc.specialty;
doctorEntity.Department = doc.department;
listDoctorsEntity.Add(doctorEntity);
}
return(listDoctorsEntity);
}
public void Insert(DoctorEntity doctorEntity)
{
gsbEntities context = new gsbEntities();
doctors doctor = new doctors();
doctor.firstname = doctorEntity.FirstName;
doctor.lastname = doctorEntity.LastName;
doctor.address = doctorEntity.Address;
doctor.phone = doctorEntity.Phone;
doctor.specialty = doctorEntity.Specialty;
doctor.department = doctorEntity.Department;
context.doctors.Add(doctor);
context.SaveChanges();
}