public HomeIndexViewModel CreateModel(string search)
{
using (var _context = new OnlineshoppingDBEntities())
{
SqlParameter[] param = new SqlParameter[]
{
new SqlParameter("@searchText", search ?? (object)DBNull.Value)
};
//SqlParameter param = null;
//SqlParameter param = new SqlParameter("@searchText", search ?? (object)DBNull.Value);
//IEnumerable<tblProduct> lst = _context.Database.SqlQuery<tblProduct>("GetSearch @searchText", param);
IEnumerable <tblProduct> lst = repositoryProduct.spCall("GetSearch @searchText", param);
return(new HomeIndexViewModel
{
lstproducts = lst.ToList()
});
}
}
public Repository(OnlineshoppingDBEntities db)
{
this._Context = db;
_dSet = _Context.Set <T>();
}
