public int GetReadEnquiryCount(long managerId, HandlerStatusEnum handlerStatus) { using (var session = GetSession()) { return(session.QueryOver <Enquiry>().Where(m => m.IsDeleted == Utils.CoreDefaultValue.False) .And(m => m.HandlerStatus == handlerStatus) .And(m => m.ReceiverId == managerId || m.HandlerId == managerId).RowCount()); } }
public static PageModel <Enquiry> GetEnquiryPages(string email, long managerId, long languageId, long intentId, long useDefinedId, HandlerStatusEnum handlerStatus, int pageindex, int pageSize) { int totalCount = 0; IList <Enquiry> enquiries = enquiryRepository.GetEnquirysByStatus(email, managerId, languageId, intentId, useDefinedId, handlerStatus, pageindex, pageSize, out totalCount); return(new PageModel <Enquiry>(enquiries, pageindex, pageSize, totalCount)); }
public static int GetReadEnquiryCount(long managerId, HandlerStatusEnum handlerStatus) { return(enquiryRepository.GetReadEnquiryCount(managerId, handlerStatus)); }
public IList <Enquiry> GetEnquirysByStatus(string email, long managerId, long languageId, long intentId, long useDefinedId, HandlerStatusEnum handlerStatus, int pageindex, int pageSize, out int totalCount) { using (var session = GetSession()) { var query = session.QueryOver <Enquiry>().Where(m => m.IsDeleted == Utils.CoreDefaultValue.False) .And(m => m.ReceiverId == managerId || m.HandlerId == managerId) .And(m => m.HandlerStatus == handlerStatus); if (!string.IsNullOrEmpty(email)) { query = query.And(m => m.PurchaserEmail == email); } if (languageId != 0) { query = query.And(m => m.LanguageId == languageId); } if (intentId != 0) { query = query.And(m => m.IntentionId == intentId); } if (useDefinedId != 0) { query = query.And(m => m.UserDefinedId == useDefinedId); } totalCount = query.RowCount(); return(query.OrderBy(m => m.Id).Desc.Take(pageSize) .Skip((pageindex - 1) * pageSize) .List()); } }