public List <HistoricView> GetHistoricPrices(int priceBaseId)
{
PriceBase pb = ControllerManager.PriceBase.GetById(priceBaseId);
if (pb == null)
{
return(null);
}
ICriteria crit = GetCriteria();
crit.Add(Expression.Eq("Product", pb.Product));
crit.Add(Expression.Eq("Provider", pb.Provider));
ProjectionList pl = Projections.ProjectionList();
pl.Add(Projections.Distinct(Projections.Property("PriceList")));
pl.Add(Projections.Property("TimeStamp.ModifiedOn"));
crit.SetProjection(pl);
crit.AddOrder(new Order("TimeStamp.ModifiedOn", true));
IList lst = crit.List();
List <HistoricView> hv = new List <HistoricView>();
foreach (object[] arr in lst)
{
hv.Add(new HistoricView(StringFormat.MilliTimeStamp((DateTime)arr[1]), Convert.ToDecimal(arr[0])));
}
return(hv);
}
