public ActionResult ModelDetay(string Kategori, string Marka, string Model) { Procedures procedures = new Procedures(); prc_MODEL_DETAY prms = new prc_MODEL_DETAY { katAdi = Kategori, marAdi = Marka, modAdi = Model }; var modList = procedures.MODEL_DETAY_SAYFASI(prms); return(View(modList)); }
public List <MODEL_DETAY> MODEL_DETAY_SAYFASI(prc_MODEL_DETAY v) { //GET_MODEL_DETAY @katAdi, @marAdi, modAdi if (v == null) { throw new ArgumentNullException("Storre Procedur:GET_MODEL_DETAY parametreleri Null olamaz"); } var prm1 = new SqlParameter("@katAdi", v.katAdi); var prm2 = new SqlParameter("@marAdi", v.marAdi); var prm3 = new SqlParameter("@modAdi", v.modAdi); using (var dataContext = new DataContext()) { var sqlQery = dataContext.Database.SqlQuery <MODEL_DETAY>("GET_MODEL_DETAY @katAdi, @marAdi, @modAdi", prm1, prm2, prm3).ToList(); return(sqlQery); } }