public DoctorsViewModel UpdateDoctors(int _id_doctor, DoctorsViewModel _doctor) { DoctorsEntity upd_doctor = new DoctorsEntity(); upd_doctor.Person.Name = _doctor.Name; upd_doctor.Person.Surname = _doctor.Surname; upd_doctor.Person.Address = _doctor.Address; upd_doctor.Person.Phone = _doctor.Phone; upd_doctor.Department.Name = _doctor.Department; new DoctorsRepository().Update(_id_doctor, upd_doctor); return(this.ReadOneDoctor(_id_doctor)); }
//--------------------------------------------------------------------- public DoctorsEntity Insert(DoctorsEntity _doctor) { string _procedure = "CRT_Doctors"; var(_connection, _command, _transaction) = new ConnectionManager().CreateConnection(_procedure); _command.Parameters.Add(new SqlParameter("@_name", _doctor.Person.Name)); _command.Parameters.Add(new SqlParameter("@_surname", _doctor.Person.Surname)); _command.Parameters.Add(new SqlParameter("@_address", _doctor.Person.Address)); _command.Parameters.Add(new SqlParameter("@_phone", _doctor.Person.Phone)); _command.Parameters.Add(new SqlParameter("@_depname", _doctor.Department.Name)); new ConnectionManager().ExecuteNonQuery(_connection, _command, _transaction); return(_doctor); }
public DoctorsViewModel InsertDoctors(DoctorsViewModel _doctor) { DoctorsEntity new_doctor = new DoctorsEntity(); new_doctor.Person = new PersonsEntity(); new_doctor.Person.Name = _doctor.Name; new_doctor.Person.Surname = _doctor.Surname; new_doctor.Person.Address = _doctor.Address; new_doctor.Person.Phone = _doctor.Phone; new_doctor.Department = new DepartmentsEntity(); new_doctor.Department.Name = _doctor.Department; new DoctorsRepository().Insert(new_doctor); return(this.ReadOneDoctor(0)); }
//--------------------------------------------------------------------- public DoctorsEntity ReadOne(int _id_doctor) { DoctorsEntity doctor = new DoctorsEntity(); const string _procedure = "READ_Doctors_one"; var(_connection, _command, _transaction) = new ConnectionManager().CreateConnection(_procedure); _command.Parameters.Add(new SqlParameter("@_id_doctor", _id_doctor)); using (_connection) { try { using (SqlDataReader _dataReader = _command.ExecuteReader()) { while (_dataReader.Read()) { DoctorsEntity _doctor = new DoctorsEntity { Id = _dataReader.GetInt32("id"), Removed = _dataReader.GetBoolean("removed"), IdPerson = _dataReader.GetInt32("id_person"), IdDepartment = _dataReader.GetInt32("id_department"), }; _doctor.Person = new PersonsRepository().ReadOne(_doctor.IdPerson); _doctor.Department = new DepartmentsRepository().ReadOne(_doctor.IdDepartment); _doctor.Specialties = new SpecialtiesRepository().ReadAllForDoctor(_doctor.Id); doctor = _doctor; } _dataReader.Close(); ////_transaction.Commit(); } } catch (Exception ex) { Debug.Write(ex.Message); ////_transaction.Rollback(); } } return(doctor); }