public UniversalEntity RetrieveDevicesByID(int id) { WPDeviceDAO entDAO = new WPDeviceDAO(); sc = new SqlCommand("RetrieveDevicesByID"); sc.CommandType = CommandType.StoredProcedure; sc.Parameters.Add("@id", id); return(entDAO.retrieveEntity(sc)); }
public UniversalEntity RetrieveDevicesByNameAndType(int type, string title) { WPDeviceDAO entDAO = new WPDeviceDAO(); sc = new SqlCommand("RetrieveDevicesByNameAndType"); sc.CommandType = CommandType.StoredProcedure; sc.Parameters.Add("@type", type); if (!string.IsNullOrEmpty(title)) { sc.Parameters.Add("@Title", title); } else { sc.Parameters.Add("@Title", DBNull.Value); } return(entDAO.retrieveEntity(sc)); }