//----------------------------------------------------------------- private List <Countries> Init(SqlCommand cmd) { SqlConnection con = db.GetConnection(); cmd.Connection = con; List <Countries> l_Countries = new List <Countries>(); try { con.Open(); SqlDataReader reader = cmd.ExecuteReader(); SmartDataReader smartReader = new SmartDataReader(reader); while (smartReader.Read()) { Countries m_Countries = new Countries(db.ConnectionString); m_Countries.CountryId = smartReader.GetInt16("CountryId"); m_Countries.CountryName = smartReader.GetString("CountryName"); m_Countries.CountryDesc = smartReader.GetString("CountryDesc"); m_Countries.IconPath = smartReader.GetString("IconPath"); m_Countries.DisplayOrder = smartReader.GetInt16("DisplayOrder"); m_Countries.CrUserId = smartReader.GetInt32("CrUserId"); m_Countries.CrDateTime = smartReader.GetDateTime("CrDateTime"); l_Countries.Add(m_Countries); } reader.Close(); return(l_Countries); } catch (SqlException err) { throw new ApplicationException("Data error: " + err.Message); } finally { db.closeConnection(con); } }
//-------------------------------------------------------------- public static List <Countries> Static_GetListOrderBy(string ConStr, string OrderBy) { Countries m_Countries = new Countries(ConStr); return(m_Countries.GetListOrderBy(OrderBy)); }