//desplegar por id public Personal ObtenerPersonalById(int IDPersonal) { DatoPersonal datPersonal = new DatoPersonal(); //dos formas de hacerlo //LINQ Personal aut = new Personal(); aut = (from l in datPersonal.select_All_Personal() where l.IDPersonal == IDPersonal select l).FirstOrDefault(); return aut; //por medio del procedimiento almacenado //return datAuto.select_AutosbyId(IDAuto); }
public Personal select_AutosbyId(int IDPersonal) { // Autos ObjAuto = new Autos(); Personal ObjAuto = new Personal(); string StoredProcedure = "ObtenerPersonalByID"; using (DbConnection con = dpf.CreateConnection()) { con.ConnectionString = constr; using (DbCommand cmd = dpf.CreateCommand()) { cmd.Connection = con; cmd.CommandText = StoredProcedure; cmd.CommandType = CommandType.StoredProcedure; DbParameter param = cmd.CreateParameter(); param.DbType = DbType.Int32; param.ParameterName = "IDPersonal"; param.Value = IDPersonal; cmd.Parameters.Add(param); con.Open(); using (DbDataReader dr = cmd.ExecuteReader()) { if (dr.Read()) { ObjAuto = new Personal(IDPersonal, (string)dr["CIPersonal"], (string)dr["Nombre"], (string)dr["Apellido"] , (string)dr["Telefono"], (string)dr["Email"], (int)dr["IDArea"]); } } } } return ObjAuto; }