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