public void FilterCompaniesTable()
{
CompanySearchFilter filter = new CompanySearchFilter
{
Name = comp_name.Text,
Description = comp_desc.Text,
City = comp_city.Text,
Region = comp_region.Text,
Country = comp_country.Text,
ZipCode = comp_zipcode.Text,
IdDocument = comp_document.Text,
IdDocumentType = comp_document_type.Text
};
CompanyWSClient ws = new CompanyWSClient();
for (int indx = (companiesTable.RowCount * companiesTable.ColumnCount) - 1; indx >= companiesTable.ColumnCount; indx--)
{
companiesTable.Controls.RemoveAt(indx);
}
companiesTable.RowCount = 1;
editCompanyData[] data = ws.listCompaniesByFilter(new CompanyWS.Security {
BinarySecurityToken = authToken
},
new listCompaniesByFilter {
arg1 = filter
});
FillCompaniesTable(data);
}
public Result <CompanySummaryDto> GetCompanies(CompanySearchFilter companySearchFilter)
{
using (UnitOfWork unitOfWork = new UnitOfWork())
{
return(unitOfWork.CompanySummaries.Get(companySearchFilter, CompanyMappers.Instance.MapGetCompanies));
}
}
public Company[] FindCompaniesByFilter(CompanySearchFilter filter, Security Security)
{
ValidateSecurity(Security);
using (var ds = new DataService())
{
return(ds.getCompanyDAO().FindCompaniesByFilter(filter));
}
}
public IActionResult GetCompanies([FromBody] CompanySearchFilter searchFilter)
{
Result <CompanyModel> result = companyService.Get(searchFilter.OrganisationId.Value, searchFilter.SearchText, searchFilter.PageData);
companyService.MapRelativeLogoPaths(result.Items, configuration, HttpContext.Request.CurrentUrl());
return(Ok(result));
}
public HttpResponseMessage GetCompanies(CompanySearchFilter companySearchFilter)
{
companySearchFilter.UserId = UserId;
Result <CompanySummaryDto> result = companyManager.GetCompanies(companySearchFilter);
MapRelativeLogoPaths(result.Items);
return(Request.CreateResponse <Result <CompanySummaryDto> >(HttpStatusCode.OK, result));
}
public Result <CompanySummaryDto> Get(CompanySearchFilter companySearchFilter, Func <SqlDataReader, Result <CompanySummaryDto> > companyMapper)
{
List <SqlQueryParameter> sqlQueryParameters = GetPagedDataParameters(companySearchFilter.PageData);
sqlQueryParameters.Add(new SqlQueryParameter {
ParameterName = "UserId", ParameterDirection = DbParameterDirection.Input, ParamentType = CodeParameterType.Integer, ParameterValue = companySearchFilter.UserId
});
sqlQueryParameters.Add(new SqlQueryParameter {
ParameterName = "OrganisationId", ParameterDirection = DbParameterDirection.Input, ParamentType = CodeParameterType.Integer, ParameterValue = companySearchFilter.OrganisationId
});
sqlQueryParameters.Add(new SqlQueryParameter {
ParameterName = "SearchText", ParameterDirection = DbParameterDirection.Input, ParamentType = CodeParameterType.String, ParameterSize = 100, ParameterValue = companySearchFilter.SearchText
});
return(companyMapper(CommandTypeManager.ExecuteReader("CompaniesFetch", sqlQueryParameters.ToArray())));
}
public Company[] FindCompaniesByFilter(CompanySearchFilter filter)
{
return(new DataAccessImpl().FindCompaniesByFilter(filter, Security));
}
