public ActionResult VolumeList(KendoGridRequest request = null)
{
if (Request.HttpMethod.ToUpper() == "GET")
{
return(View());
}
// Fetch the data
using (var context = new KendoGridDataContext(ExigoDAL.Sql()))
{
var results = context.Query(request, @"
SELECT
pv.PeriodID
,p.StartDate
,p.EndDate
,p.PeriodDescription
,pv.PaidRankID
,PaidRankDescription = ''
,pv.Volume1
,pv.Volume2
,pv.Volume3
FROM
PeriodVolumes pv
INNER JOIN Periods p
ON p.PeriodID = pv.PeriodID
INNER JOIN Ranks r
ON r.RankID = pv.PaidRankID
WHERE
pv.CustomerID = @customerid
AND pv.PeriodTypeID = @periodtypeid
AND p.StartDate <= @startdate
", new
{
customerid = Identity.Current.CustomerID,
periodtypeid = PeriodTypes.Default,
startdate = DateTime.Now.ToCST()
});
// get the translated paid rank description
foreach (var item in results.Data)
{
item.PaidRankDescription = CommonResources.Ranks(item.PaidRankID, CommonResourceFormat.Default);
}
return(results);
}
}
