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