public ActionResult BuscarCliente(string cliente)
{
List <ClienteResponse> listadoCliente = new List <ClienteResponse>();
try
{
using (var db = new CursoMVCEntities())
{
listadoCliente = db.Database
.SqlQuery <ClienteResponse>("EXEC dbo.spBuscarCliente {0}", cliente)
.ToList();
}
}
catch (Exception ex)
{
throw ex;
}
return(Json(listadoCliente, JsonRequestBehavior.AllowGet));
}
// GET: User
public ActionResult Index()
{
List <UserTableViewModel> lista = null;
using (CursoMVCEntities db = new CursoMVCEntities())
{
lista = db.user
.Where(x => x.idState == 1)
.Select(x => new UserTableViewModel
{
Email = x.email,
Id = x.id,
Edad = x.edad
})
.OrderBy(x => x.Email)
.ToList();
}
return(View(lista));
}
