Nhibernat and avg

Question

Coward 0 Newbie Poster

14 Years Ago

hi all
i want create Query with Nhibernate
i problem with average time the object
my code :

public static int GetInboxFaultsCount(int InboxId, FaultState State)
        {
            Criteria criteria = new Criteria();
            criteria.Query = "select count(distinct fault) from IFault fault inner join fault.ReceiversInbox inbox where inbox.Id=:id and fault.State =:state AND (not exists (from fault.Results fr where fr.SendState=1 AND fr.OwnerFixUnit.Inbox.id=:id))";
            criteria.Parameters.Add("state", State);
            criteria.Parameters.Add("id", InboxId);
            DataFacade dFacade = new DataFacade();
            return dFacade.GetCount(criteria);
        }

asp.net

1 Contributor
1 Reply
132 Views
6 Hours Discussion Span
Latest Post 14 Years Ago Latest Post by Coward

Reply to this topic

Be a part of the DaniWeb community

We're a friendly, industry-focused community of developers, IT pros, digital marketers, and technology enthusiasts meeting, networking, learning, and sharing knowledge.

Coward 0 Newbie Poster · Answer 1 · 2009-05-05T20:03:38+00:00

sry correct code :

public static int GetAvgTime(int InboxId, DateTime StartTime, DateTime EndTime)
        {
            Criteria criteria = new Criteria();
            criteria.Query = "select avg(result.FixTime-flt.CreateTime )from Fault flt join flt.ReceivedFaults inbox join FaultResult result.Results where result.State != SentToAnotherUnit AND flt.Stat=FaultState AND inbox.Id= :InboxId";
            criteria.Parameters.Add("Id", InboxId);
            criteria.Parameters.Add("id", InboxId);
            DataFacade dFacade = new DataFacade();
            return dFacade.GetCount(criteria);

        }