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);
}
