public static MarkaList Liste(string param, string serial="")
{
try
{
SqlParameter[] parametre = new SqlParameter[]
{
new SqlParameter("@serial", serial),
new SqlParameter("@parametre ", param),
};
MarkaList markalar = new MarkaList();
using (SqlDataReader dr = SqlHelper.ExecuteReader("marka_SolPanelListeleme", parametre))
{
while (dr.Read())
{
markalar.Add(new Markalar(
dr.GetInt32(dr.GetOrdinal("id")),
dr.GetString(dr.GetOrdinal("marka_adi")).Trim()));
}
}
return markalar;
}
catch (Exception)
{
throw;
}
}
public static MarkaList dropDownListele()
{
try
{
SqlParameter parametre = new SqlParameter("@parametre","AdminDropDown");
using (SqlDataReader dr = SqlHelper.ExecuteReader("marka_Listele", parametre))
{
MarkaList markaTablo = new MarkaList();
while (dr.Read())
{
Markalar info = new Markalar(
dr.GetInt32(dr.GetOrdinal("id")),
dr.GetString(dr.GetOrdinal("marka_adi")));
markaTablo.Add(info);
}
return markaTablo;
}
}
catch (Exception)
{
throw;
}
}
