private long GetTotalRowsFilter(TourSearch valFilter)
{
long vResult = 0;
DataTable vDatainTable = new DataTable();
SQLToolsLibrary vSqlTools = new SQLToolsLibrary();
try {
if (valFilter.Categories == null)
{
valFilter.Categories = new string[0];
}
List <SqlParameter> vParameterList = new List <SqlParameter> {
new SqlParameter("@IdLanguage", valFilter.IdLanguage.ToString()),
new SqlParameter("@IdCity", valFilter.IdCity.ToString()),
new SqlParameter("@IdCurrency", valFilter.IdCurrency.ToString()),
new SqlParameter("@Categories", valFilter.Categories.Length > 0 ? string.Join(",", valFilter.Categories) : null),
new SqlParameter("@MinPrice", valFilter.MinPrice),
new SqlParameter("@MaxPrice", valFilter.MaxPrice),
new SqlParameter("@MinDuration", valFilter.MinDuration),
new SqlParameter("@MaxDuration", valFilter.MaxDuration),
new SqlParameter("@MinScore", valFilter.MinScore),
new SqlParameter("@MaxScore", valFilter.MaxScore)
};
TourResponse vModel = new TourResponse();
vDatainTable = vSqlTools.ExcecuteSelectWithStoreProcedure(vParameterList, "sp_Select_Tour_Filter_Total", vConnection);
vResult = DataTableToListFilterTotal(vDatainTable);
} catch (Exception vEx) {
string vMessage = vEx.Message;
}
return(vResult);
}
private long GetTotalRowsFilter(ActivitySearch valFilter)
{
long vResult = 0;
DataTable vDatainTable = new DataTable();
SQLToolsLibrary vSqlTools = new SQLToolsLibrary();
try {
if (valFilter.DateStart == DateTime.MinValue)
{
valFilter.DateStart = new DateTime(1753, 1, 1);
}
List <SqlParameter> vParameterList = new List <SqlParameter> {
new SqlParameter("@IdLanguage", valFilter.IdLanguage.ToString()),
new SqlParameter("@IdTour", valFilter.IdTour.ToString()),
new SqlParameter("@IdCurrency", valFilter.IdCurrency.ToString()),
new SqlParameter("@DateStart", valFilter.DateStart),
new SqlParameter("@MinimumPeople", valFilter.MinimumPeople),
new SqlParameter("@RowsPerPage", valFilter.RowsPerPage),
new SqlParameter("@PageNumber", valFilter.PageNumber)
};
TourResponse vModel = new TourResponse();
vDatainTable = vSqlTools.ExcecuteSelectWithStoreProcedure(vParameterList, "sp_Select_Activity_Filter_Total", vConnection);
vResult = DataTableToListFilterTotal(vDatainTable);
} catch (Exception vEx) {
string vMessage = vEx.Message;
}
return(vResult);
}
public string SelectByCity(TourSearch valFilter)
{
string vResult = string.Empty;
try {
DataTable vDatainTable = new DataTable();
SQLToolsLibrary vSqlTools = new SQLToolsLibrary();
if (valFilter.Categories == null)
{
valFilter.Categories = new string[0];
}
List <SqlParameter> vParameterList = new List <SqlParameter> {
new SqlParameter("@IdLanguage", valFilter.IdLanguage.ToString()),
new SqlParameter("@IdCity", valFilter.IdCity.ToString()),
new SqlParameter("@IdCurrency", valFilter.IdCurrency.ToString()),
new SqlParameter("@Categories", valFilter.Categories.Length > 0 ? string.Join(",", valFilter.Categories) : null),
new SqlParameter("@MinPrice", valFilter.MinPrice),
new SqlParameter("@MaxPrice", valFilter.MaxPrice),
new SqlParameter("@MinDuration", valFilter.MinDuration),
new SqlParameter("@MaxDuration", valFilter.MaxDuration),
new SqlParameter("@MinScore", valFilter.MinScore),
new SqlParameter("@MaxScore", valFilter.MaxScore),
new SqlParameter("@RowsPerPage", valFilter.RowsPerPage),
new SqlParameter("@PageNumber", valFilter.PageNumber)
};
TourResponse vModel = new TourResponse();
vDatainTable = vSqlTools.ExcecuteSelectWithStoreProcedure(vParameterList, "sp_Select_Tour_Filter", vConnection);
List <Tour> vDataTours = DataTableToListFilter(vDatainTable);
vModel.Tours = vDataTours;
vModel.TotalRows = GetTotalRowsFilter(valFilter);
if (vModel != null && vModel.Tours != null && vModel.Tours.Count > 0)
{
vResult = JsonConvert.SerializeObject(vModel, Formatting.Indented);
}
} catch (Exception vEx) {
string vMessage = vEx.Message;
vResult = string.Empty;
}
return(vResult);
}
