public IList <ConsumableUsage> GetConsumableUsage(int testAreaId, QuanifyConsumableBasedOnEnum qcbEnum, int insId) { string hql = "from ConsumableUsage cu where cu.TestingAreaId = :tid and cu.QuanifyBasedOn = :qcb and cu.Instrument.Id = :insid"; ISession session = NHibernateHelper.OpenSession(); IQuery q = session.CreateQuery(hql); q.SetInt32("tid", testAreaId); q.SetString("qcb", qcbEnum.ToString()); q.SetInt32("insid", insId); return(q.List <ConsumableUsage>()); }
public static IList <ConsumableUsage> GetConsumableUsageByTestArea(int testAreaId, QuanifyConsumableBasedOnEnum qcb, int insId) { return(DaoFactory.GetDaoFactory().CreateConsumableUsageDao().GetConsumableUsage(testAreaId, qcb, insId)); }