/// <summary>
/// Method wich convert type SearchDataIn to SerachDataOut
/// </summary>
/// <param name="search"></param>
/// <returns>SearchDataOut</returns>
public SearchDataOut Parser(SearchDataIn search)
{
try
{
SearchDataOut sdo = new SearchDataOut();
sdo.ItemsPerPage = search.ItemsPerPage;
sdo.CurrentPage = search.CurrentPage;
sdo.OrderbyField = search.OrderbyField;
sdo.OrderBy = search.OrderByReverse;
sdo.InstanceName = string.IsNullOrEmpty(search.FilterByFields.InstanceName) ? null : search.FilterByFields.InstanceName;
sdo.HostName = string.IsNullOrEmpty(search.FilterByFields.HostName) ? null : search.FilterByFields.HostName;
sdo.Id = ConvertToNulable.ToNullableInt(search.FilterByFields.Id);
sdo.AddedFrom = ConvertToNulable.ToNullableDateTime(search.FilterByFields.AddedFrom);
sdo.AddedTo = ConvertToNulable.ToNullableDateTime(search.FilterByFields.AddedTo);
sdo.ModifiedFrom = ConvertToNulable.ToNullableDateTime(search.FilterByFields.ModifiedFrom);
sdo.ModifiedTo = ConvertToNulable.ToNullableDateTime(search.FilterByFields.ModifiedTo);
sdo.Status = ConvertToNulable.ToNullableInt(search.FilterByFields.Status);
sdo.RAM = ConvertToNulable.ToNullableInt(search.FilterByFields.RAM);
sdo.CPUCount = ConvertToNulable.ToNullableInt(search.FilterByFields.CPUCount);
sdo.UserName = string.IsNullOrWhiteSpace(search.FilterByFields.UserName) ? null : search.FilterByFields.UserName;
sdo.Version = string.IsNullOrEmpty(search.FilterByFields.Version) ? null : search.FilterByFields.Version;
return(sdo);
}
catch (Exception ex)
{
throw ex;
}
}
public Query Search <T>(SearchDataOut search)
{
Query query = new Query();
if (search == null)
{
throw new ArgumentException();
}
query.BuildStoredProcedureName <T>(StoredProcedureConstants.Search);
query.AddParameters(GetParametersFromObject(search));
return(query);
}
public Tuple <int, List <T> > Search(SearchDataOut search)
{
Query query = queryBuilder.Search <T>(search);
using (SqlConnection connection = connectionManager.GetOpenedRepositoryConnection())
{
QueryResult result = queryExecutor.Execute(query, connection);
int count = result.RowCount();
T inst = DataMapper.DataMapper.Map <T>(result);
List <T> genericList = DataMapper.DataMapper.MapList <T>(result);
var items = Tuple.Create(count, genericList);
return(items);
}
}