// GET: Marka
public ActionResult Index(string Kategori) // Marka?Kategori=Otomobil&Marka=Audi
{
Procedures procedures = new Procedures();
prc_MODEL_ARAC_LIST prms = new prc_MODEL_ARAC_LIST
{
katAdi = Kategori
};
var marList = procedures.KATEGORI_ARAC_LIST(prms);
return(View(marList));
}
public List <MODEL_ARAC_LIST> KATEGORI_ARAC_LIST(prc_MODEL_ARAC_LIST v)
{
//GET_KATEGORI_ARAC @katAdi
if (v == null)
{
throw new ArgumentNullException("Storre Procedur:GET_KATEGORI_ARAC parametreleri Null olamaz");
}
var prm1 = new SqlParameter("@katAdi", v.katAdi);
using (var dataContext = new DataContext())
{
var sqlQery = dataContext.Database.SqlQuery <MODEL_ARAC_LIST>("GET_KATEGORI_ARAC @katAdi", prm1).ToList();
return(sqlQery);
}
}
