// GET: Model
public ActionResult Index(string Kategori, string Marka)
{
Procedures procedures = new Procedures();
prc_MODEL_MARKA_ARAC_LIST prms = new prc_MODEL_MARKA_ARAC_LIST
{
katAdi = Kategori,
marAdi = Marka
};
var marList = procedures.KATEGORI_MARKA_MODEL_LIST(prms);
return(View(marList));
}
//public DataContext dataContext { get { return new DataContext(); } }
public List <MODEL_MARKA_ARAC_LIST> KATEGORI_MARKA_MODEL_LIST(prc_MODEL_MARKA_ARAC_LIST v)
{
//GET_KATEGORI_MARKA_MODEL @katAdi, @marAdi
if (v == null)
{
throw new ArgumentNullException("Storre Procedur:GET_KATEGORI_MARKA_MODEL parametreleri Null olamaz");
}
var prm1 = new SqlParameter("@katAdi", v.katAdi);
var prm2 = new SqlParameter("@marAdi", v.marAdi);
using (var dataContext = new DataContext())
{
var sqlQery = dataContext.Database.SqlQuery <MODEL_MARKA_ARAC_LIST>("GET_KATEGORI_MARKA_MODEL @katAdi, @marAdi", prm1, prm2).ToList();
return(sqlQery);
}
}
