public List <LayananModel> ListData(LayananListDataType listType) { List <LayananModel> retVal = null; string sSql = @" SELECT fs_kd_layanan, fs_nm_layanan, fb_popular FROM ta_layanan"; switch (listType) { case LayananListDataType.All: break; case LayananListDataType.Popular: sSql += @" WHERE fb_popular = 1"; break; case LayananListDataType.NotPopular: sSql += @" WHERE fb_popular = 0"; break; default: break; } sSql += @" ORDER BY fs_nm_layanan "; using (SqlConnection conn = new SqlConnection(_connString)) using (SqlCommand cmd = new SqlCommand(sSql, conn)) { conn.Open(); SqlDataReader dr = cmd.ExecuteReader(); if (dr.HasRows) { retVal = new List <LayananModel>(); while (dr.Read()) { LayananModel item = new LayananModel(); item.Kode = dr["fs_kd_layanan"].ToString(); item.Nama = dr["fs_nm_layanan"].ToString(); item.IsPopular = dr.GetBoolean(dr.GetOrdinal("fb_popular")); retVal.Add(item); } } } return(retVal); }
public List <LayananModel> ListData(LayananListDataType listType) { return(_layananDal.ListData(listType)); }
public void LayananDal_ListData_Suucced_Test(LayananListDataType type) { List <LayananModel> dummy = layananDal.ListData(type); }
public List <LayananModel> ListData(LayananListDataType listType) { List <LayananModel> retVal = _layananBL.ListData(listType); return(retVal); }