public static int GetTotalOfAdvertisements(int zoneId, ADSearchType listType, string keyword)
{
return(dal.GetTotalOfAdvertisements());
}
public IList <AdvertisementInfo> GetAdvertisementList(int startRowIndexId, int maxNumberRows, int zoneId, ADSearchType listType, string keyword)
{
string str2;
Database database = DatabaseFactory.CreateDatabase();
IList <AdvertisementInfo> list = new List <AdvertisementInfo>();
string storedProcedureName = "PR_Common_GetList";
DbCommand storedProcCommand = database.GetStoredProcCommand(storedProcedureName);
switch (listType)
{
case ADSearchType.ADName:
str2 = " ADName LIKE '%" + DBHelper.FilterBadChar(keyword) + "%' ";
break;
case ADSearchType.Intro:
str2 = "ADIntro LIKE '%" + DBHelper.FilterBadChar(keyword) + "%' ";
break;
case ADSearchType.Zone:
str2 = " AdId IN (SELECT ADID FROM PE_Zone_Advertisement WHERE ZoneId = " + zoneId + ") ";
break;
default:
str2 = null;
break;
}
database.AddInParameter(storedProcCommand, "@StartRows", DbType.Int32, startRowIndexId);
database.AddInParameter(storedProcCommand, "@PageSize", DbType.Int32, maxNumberRows);
database.AddInParameter(storedProcCommand, "@SortColumn", DbType.String, "ADId");
database.AddInParameter(storedProcCommand, "@StrColumn", DbType.String, "*");
database.AddInParameter(storedProcCommand, "@Sorts", DbType.String, "DESC");
database.AddInParameter(storedProcCommand, "@Filter", DbType.String, str2);
database.AddInParameter(storedProcCommand, "@TableName", DbType.String, "PE_Advertisement");
database.AddOutParameter(storedProcCommand, "@Total", DbType.Int32, maxNumberRows);
using (NullableDataReader reader = new NullableDataReader(database.ExecuteReader(storedProcCommand)))
{
while (reader.Read())
{
list.Add(AdvertisementFromrdr(reader));
}
}
this.m_NumAdvertisements = (int)database.GetParameterValue(storedProcCommand, "@Total");
return(list);
}
public static IList <AdvertisementInfo> GetAdvertisementList(int startRowIndex, int maximumRows, int zoneId, ADSearchType listType, string keyword)
{
return(dal.GetAdvertisementList(startRowIndex, maximumRows, zoneId, listType, keyword));
}
