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>());
        }
Exemple #2
0
 public static IList <ConsumableUsage> GetConsumableUsageByTestArea(int testAreaId, QuanifyConsumableBasedOnEnum qcb, int insId)
 {
     return(DaoFactory.GetDaoFactory().CreateConsumableUsageDao().GetConsumableUsage(testAreaId, qcb, insId));
 }