public static IFutureValue <TValue> FutureValue <T, TValue>(this IQueryOver <T> query, IDatabaseProvider databaseProvider)
{
if (databaseProvider.SupportFuture)
{
return(query.FutureValue <TValue>());
}
return(new FunnelWebFutureValue <TValue>(query.SingleOrDefault <TValue>()));
}
/// <summary>
/// Firsts the specified query.
/// </summary>
/// <typeparam name="TReturn">The type of the return.</typeparam>
/// <typeparam name="TInput">The type of the input.</typeparam>
/// <param name="query">The query.</param>
/// <returns>First item.</returns>
/// <exception cref="EntityNotFoundException">If no items found.</exception>
public static TReturn First <TReturn, TInput>(this IQueryOver <TInput> query)
{
var viewModel = query.SingleOrDefault <TReturn>();
if (viewModel == null)
{
throw new EntityNotFoundException(typeof(TReturn), Guid.Empty);
}
return(viewModel);
}
public Peanut FindFromBill(Bill bill)
{
Require.NotNull(bill, "bill");
HibernateDelegate <Peanut> finder = delegate(ISession session) {
IQueryOver <Peanut, Peanut> queryOver = session.QueryOver <Peanut>();
queryOver.JoinQueryOver <Bill>(peanut => peanut.Bills).Where(peanutBill => peanutBill.Id == bill.Id);
return(queryOver.SingleOrDefault());
};
return(HibernateTemplate.Execute(finder));
}
private FlightUser Read(IQueryOver <FlightUser, FlightUser> query, bool readAuth)
{
FlightUser flightUser = query.SingleOrDefault();
if (flightUser == null)
{
throw new ArgumentException("[Usuários] User not founded");
}
if (readAuth && !String.IsNullOrEmpty(flightUser.Email))
{
flightUser.Auth0 = Task.Run(() => new Management(UnitOfWork.AppServices).ReadByEmailAsync(flightUser.Email)).Result;
}
return(flightUser);
}
public UserGroupMembership FindMembershipsByUserAndGroup(User user, UserGroup userGroup)
{
Require.NotNull(userGroup, "userGroup");
Require.NotNull(user, "user");
HibernateDelegate <UserGroupMembership> finder = delegate(ISession session) {
IQueryOver <UserGroupMembership, UserGroupMembership> queryOver = session.QueryOver <UserGroupMembership>();
queryOver
/*Mitgliedschaft des Nutzers*/
.Where(membership => membership.User == user)
/*In der Gruppe*/
.And(membership => membership.UserGroup == userGroup);
return(queryOver.SingleOrDefault());
};
return(HibernateTemplate.Execute(finder));
}
public IList <Enrollee> GetFamilyTreeByPolicyNumber(string policyNumber)
{
List <Enrollee> response = new List <Enrollee>();
if (!string.IsNullOrEmpty(policyNumber))
{
policyNumber = policyNumber.ToLower();
IQueryOver <Enrollee, Enrollee> enrollee = _session.QueryOver <Enrollee>().Where(x => x.Policynumber == policyNumber || x.Policynumber == policyNumber.ToUpper());
if (enrollee.RowCount() > 0)
{
Enrollee enrolleeObj = enrollee.SingleOrDefault();
//check if principal
if (enrolleeObj.Parentid > 0)
{
//child
//get the parent
Enrollee parent = GetEnrollee(enrolleeObj.Parentid);
IList <Enrollee> dependants = GetDependentsEnrollee(parent.Id);
response.Add(parent);
response.AddRange(dependants);
}
else
{
//parent
IList <Enrollee> dependants = GetDependentsEnrollee(enrolleeObj.Id);
response.Add(enrolleeObj);
response.AddRange(dependants);
}
}
}
return(response);
}
public VettingProtocol getVettingPRotocol(int id)
{
IQueryOver <VettingProtocol, VettingProtocol> query = _session.QueryOver <VettingProtocol>().Where(x => x.IsDeleted == false && x.Id == id);
return(query.SingleOrDefault());
}
public TResult Unique()
{
TResult _result = _query.SingleOrDefault <TResult>();
return(_result);
}
public ProviderRating GetProviderfeedback(int feedbackid)
{
IQueryOver <ProviderRating, ProviderRating> query = _session.QueryOver <ProviderRating>().Where(x => x.IsDeleted == false && x.Id == feedbackid);
return(query.SingleOrDefault());
}
public TResult Result <TResult>() where TResult : struct
{
return(_query.SingleOrDefault <TResult>());
}
