예제 #1
0
        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);
        }
예제 #2
0
        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();
        }