Пример #1
0
 public List <NguoiDungGridObject> GetAll(NguoiDungTableGridRequest request)
 {
     using (IDbConnection db = new SqlConnection(Connections.Connection))
     {
         DynamicParameters parameters = new DynamicParameters();
         parameters.Add("@TenTaiKhoan", request.TenTaiKhoan);
         parameters.Add("@MatKhau", request.MatKhau);
         parameters.Add("@KichHoat", request.KichHoat);
         parameters.Add("@MaNhanSu", request.MaNhanSu);
         parameters.Add("@PageIndex", request.PageIndex);
         parameters.Add("@PageSize", request.PageSize);
         var list = db.Query <NguoiDungGridObject>("SearchallNguoiDung", parameters, null, true, null, CommandType.StoredProcedure).AsList <NguoiDungGridObject>();
         return(list);
     }
 }
 public JsonResult getAllSearch([FromBody] NguoiDungTableGridRequest request)
 {
     return(Json(nguoidungRepo.GetAll(request)));
 }