public async Task <Account> GetClubByIdAsync(ContentURI uri, int accountId)
{
AppHelpers.Accounts oClubHelper = new AppHelpers.Accounts();
Account club = await oClubHelper.GetClubByIdAsync(uri, accountId);;
return(club);
}
public async Task <List <AccountToAddIn> > GetAddInsByClubAsync(
ContentURI uri, int accountId)
{
AppHelpers.Accounts oClubHelper = new AppHelpers.Accounts();
List <AccountToAddIn> colClubAddIns
= await oClubHelper.GetAddInsByClubIdAsync(uri, accountId);
return(colClubAddIns);
}
public async Task <List <AccountToMember> > GetMemberByClubAsync(
ContentURI uri, int accountId)
{
AppHelpers.Accounts oClubHelper = new AppHelpers.Accounts();
List <AccountToMember> colClubToMember
= await oClubHelper.GetMemberByClubIdAsync(uri, accountId);
return(colClubToMember);
}
public async Task <List <AccountToNetwork> > GetNetworkByClubAsync(
ContentURI uri, int accountId)
{
AppHelpers.Accounts oClubHelper = new AppHelpers.Accounts();
List <AccountToNetwork> colClubNetwork
= await oClubHelper.GetNetworkByClubIdAsync(uri, accountId);
return(colClubNetwork);
}
public async Task <List <AccountToAudit> > GetClubLastEditedItemsAsync(
ContentURI uri, int accountId)
{
AppHelpers.Accounts oClubHelper = new AppHelpers.Accounts();
int iNumber = 5;
List <AccountToAudit> colClubAudits
= await oClubHelper.GetAuditsByClubIdAsync(uri, accountId, iNumber);
return(colClubAudits);
}
public async Task <AccountToMember> GetMemberByClubAsync(
ContentURI uri, int accountId, int memberId)
{
AppHelpers.Accounts oClubHelper = new AppHelpers.Accounts();
AccountToMember currentMember = new AccountToMember(true);
List <AccountToMember> colClubToMember
= await oClubHelper.GetMemberByClubIdAsync(uri, accountId);
if (colClubToMember != null)
{
currentMember = colClubToMember
.FirstOrDefault(cm => cm.AccountId == accountId && cm.MemberId == memberId);
}
return(currentMember);
}
public async Task <AccountToMember> GetDefaultClubByMemberAsync(
ContentURI uri, int memberId)
{
AppHelpers.Accounts oClubHelper = new AppHelpers.Accounts();
AccountToMember defaultClub = new AccountToMember(true);
List <AccountToMember> colClubToMember
= await oClubHelper.GetClubToMemberByMemberIdAsync(uri, memberId);
if (colClubToMember != null)
{
defaultClub = colClubToMember.FirstOrDefault(m => m.IsDefaultClub == true);
if (defaultClub != null)
{
defaultClub.ClubDefault = await GetClubByIdAsync(uri, defaultClub.AccountId);
}
}
return(defaultClub);
}
public async Task <bool> SetURILocals(ContentURI uri, bool saveInFileSystemContent)
{
bool bHasSet = true;
int iStartRow = uri.URIDataManager.StartRow;
int iPageSize = uri.URIDataManager.PageSize;
if (uri.URINodeName == Locals.LOCAL_TYPES.localaccountgroup.ToString())
{
var mc = await _dataContext.Account.SingleOrDefaultAsync(x => x.PKId == uri.URIId);
if (mc != null)
{
var qry = _dataContext
.AccountToLocal
.Where(a => a.AccountId == uri.URIId)
.Skip(iStartRow)
.Take(iPageSize);
//var qry = _dataContext
// .AccountToLocal
// .Where(a => a.Account.PKId == uri.URIId)
// .Skip(iStartRow)
// .Take(iPageSize);
if (qry != null)
{
mc.AccountToLocal = await qry.ToAsyncEnumerable().ToList();
if (mc.AccountToLocal != null)
{
uri.URIDataManager.RowCount = mc.AccountToLocal.Count;
//uri.URIDataManager.RowCount =
// _dataContext
// .AccountToLocal
// .Where(a => a.Account.PKId == uri.URIId)
// .Count();
}
}
else
{
uri.ErrorMessage = DevTreks.Exceptions.DevTreksErrors.MakeStandardErrorMsg(
string.Empty, "MODELHELPERS_CANTMAKEMODEL1");
}
uri.URIModels.Account = mc;
//// count the resource packs without loading them
//int total = await _dataContext.Entry(mc)
// .Collection(mcs => mcs.AccountToLocal)
// .Query().Cast<AccountToLocal>()
// .CountAsync();
//uri.URIDataManager.RowCount = total;
////paginate the collection
//var qry = _dataContext.Entry(mc)
// .Collection("AccountToLocal")
// .Query().Cast<AccountToLocal>()
// .Include("LinkedView")
// .OrderBy(m => m.LocalName)
// .Skip(iStartRow)
// .Take(iPageSize);
////set the data transfer objects
//if (total > 0)
//{
// mc.AccountToLocal = await qry.ToListAsync();
//}
//uri.URIModels.Account = mc;
//2.0.0 rc2 bug : qry stopped working with refactored accounttolocal
AppHelpers.Accounts oClubHelper = new AppHelpers.Accounts();
List <AccountToLocal> colClubLocals
= await oClubHelper.GetLocalsByClubIdAsync(uri, uri.URIId);
mc.AccountToLocal = colClubLocals;
if (mc.AccountToLocal != null)
{
uri.URIDataManager.RowCount = mc.AccountToLocal.Count;
}
uri.URIModels.Account = mc;
}
else
{
uri.ErrorMessage = DevTreks.Exceptions.DevTreksErrors.MakeStandardErrorMsg(
string.Empty, "MODELHELPERS_CANTMAKEMODEL");
}
}
else if (uri.URINodeName
== Locals.LOCAL_TYPES.local.ToString())
{
var qry = _dataContext
.AccountToLocal
.Where(r => r.PKId == uri.URIId);
if (qry != null)
{
uri.URIModels.AccountToLocal = await qry.FirstOrDefaultAsync();
}
else
{
uri.ErrorMessage = DevTreks.Exceptions.DevTreksErrors.MakeStandardErrorMsg(
string.Empty, "MODELHELPERS_CANTMAKEMODEL1");
}
}
if (string.IsNullOrEmpty(uri.ErrorMessage))
{
bHasSet = true;
}
return(bHasSet);
}
