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());
}
}
