public int countBand(BandQuery bandQuery)
{
var bands = ProductBandsDao.Query();
if (bandQuery == null)
{
bandQuery = new BandQuery();
}
if (!string.IsNullOrWhiteSpace(bandQuery.BandName))
{
bands = bands.Where(p => p.BandName.Contains(bandQuery.BandName.Trim()));
}
if (!string.IsNullOrWhiteSpace(bandQuery.EnglishName))
{
bands = bands.Where(p => p.EnglishName.Contains(bandQuery.EnglishName.Trim()));
}
if (!string.IsNullOrWhiteSpace(bandQuery.EnglishFirstChar))
{
bands = bands.Where(p => p.EnglishFirstChar.Contains(bandQuery.EnglishFirstChar.Trim()));
}
int count = bands.Count();
return(count);
}
public List <Band> GetBandList(BandQuery bandQuery)
{
var bands = ProductBandsDao.Query();
if (bandQuery == null)
{
bandQuery = new BandQuery();
}
if (!string.IsNullOrWhiteSpace(bandQuery.BandName))
{
bands = bands.Where(p => p.BandName.Contains(bandQuery.BandName.Trim()));
}
if (!string.IsNullOrWhiteSpace(bandQuery.EnglishName))
{
bands = bands.Where(p => p.EnglishName.Contains(bandQuery.EnglishName.Trim()));
}
if (!string.IsNullOrWhiteSpace(bandQuery.EnglishFirstChar))
{
bands = bands.Where(p => p.EnglishFirstChar.Contains(bandQuery.EnglishFirstChar.Trim()));
}
bands = bands.OrderBy(m => m.CreatedOn).Skip(bandQuery.start).Take(bandQuery.length);
return(bands != null?bands.ToList() : new List <Band>());
}
public JsonResult GetBandList(BandQuery query)
{
var bandlist = ProductBandService.GetBandList(query);
int count = ProductBandService.countBand(query);
var tableData = new
{
draw = query.draw,
recordsTotal = count,
recordsFiltered = count,
data = bandlist
};
return(Json(tableData, JsonRequestBehavior.AllowGet));
}
