Ejemplo n.º 1
0
 public static BOContact GetByUserID(long userID)
 {
     logger.Trace("GetByUserID");
     BOContact BusinessObject = null;
     SqlConnection con = new SqlConnection(GetConnectionString());
     con.Open();
     try
     {
         SqlCommand cmd = new SqlCommand("P_Contact_GetByUserID", con);
         cmd.CommandType = CommandType.StoredProcedure;
         SetInt64Parameter(cmd.Parameters, "@userID", userID, false);
         SqlDataReader rdr = cmd.ExecuteReader(CommandBehavior.SingleResult);
         try
         {
             if (rdr.Read())
             {
                 BusinessObject = new BOContact(rdr);
                 return BusinessObject;
             }
         }
         finally
         {
             rdr.Close();
         }
     }
     finally
     {
         con.Close();
     }
     return BusinessObject;
 }
 public BOContactComparer(BOContact.Columns column, BOContact.SortDirections direction)
 {
     _column = column;
     _direction = direction;
 }