public List <NhanSuGridObject> GetAll(NhanSuTableGridRequest request)
{
using (IDbConnection db = new SqlConnection(Connections.Connection))
{
DynamicParameters parameters = new DynamicParameters();
parameters.Add("@MaNhanSu", request.MaNhanSu);
parameters.Add("@Ten", request.Ten);
parameters.Add("@GioiTinh", request.GioiTinh);
parameters.Add("@NgaySinh", request.NgaySinh);
parameters.Add("@Anh", request.Anh);
parameters.Add("@NgayVaoNganh", request.NgayVaoNganh);
parameters.Add("@DiaChiNr", request.DiaChiNr);
parameters.Add("@DiaChiCq", request.DiaChiCq);
parameters.Add("@Dienthoai", request.DienThoai);
parameters.Add("@MaPhong", request.MaPhong);
parameters.Add("@PageIndex", request.PageIndex);
parameters.Add("@PageSize", request.PageSize);
var list = db.Query <NhanSuGridObject>("SearchallNhanSu", parameters, null, true, null, CommandType.StoredProcedure).AsList <NhanSuGridObject>();
return(list);
}
}
public JsonResult getAllSearch([FromBody] NhanSuTableGridRequest request)
{
return(Json(nhansuRepo.GetAll(request)));
}
