public static string GetNetworkRoleByClub(ContentURI uri)
{
//called from client and must be set during async state management
string sClubNetworkRole = string.Empty;
if (uri.URIMember != null)
{
if (uri.URIMember.ClubInUse != null)
{
if (uri.URIMember.ClubInUse.AccountToNetwork != null)
{
AccountToNetwork clubNetwork
= uri.URIMember.ClubInUse
.AccountToNetwork.FirstOrDefault(n => n.NetworkId == uri.URINetwork.PKId);
if (clubNetwork != null)
{
sClubNetworkRole = clubNetwork.NetworkRole;
}
}
}
}
return(sClubNetworkRole);
}
private bool AddNetwork(List <ContentURI> addedURIs, List <AccountToNetwork> addedMs)
{
bool bHasSet = true;
string sParentNodeName = string.Empty;
int iParentId = 0;
foreach (ContentURI addedURI in addedURIs)
{
Helpers.GeneralHelpers.GetParentIdAndNodeName(addedURI, out iParentId, out sParentNodeName);
if (!string.IsNullOrEmpty(addedURI.ErrorMessage))
{
_dtoContentURI.ErrorMessage = DevTreks.Exceptions.DevTreksErrors.MakeStandardErrorMsg(
string.Empty, "INSERT_NOPARENT");
return(false);
}
//selections are made use base networks
if (addedURI.URINodeName == Networks.NETWORK_BASE_TYPES.networkbase.ToString() &&
_dtoContentURI.URINodeName == Networks.NETWORK_TYPES.networkaccountgroup.ToString())
{
var newAccountToNetwork = new AccountToNetwork
{
IsDefaultNetwork = false,
DefaultGetDataFromType = Networks.NETWORK_STOREDATA_TYPES.web.ToString(),
DefaultStoreDataAtType = Networks.NETWORK_STOREDATA_TYPES.web.ToString(),
NetworkRole = Members.MEMBER_ROLE_TYPES.contributor.ToString(),
AccountId = _dtoContentURI.URIId,
Account = null,
NetworkId = addedURI.URIId,
Network = null
};
_dataContext.AccountToNetwork.Add(newAccountToNetwork);
_dataContext.Entry(newAccountToNetwork).State = EntityState.Added;
addedMs.Add(newAccountToNetwork);
}
}
return(bHasSet);
}
public async Task <List <AccountToNetwork> > GetNetworkByClubIdAsync(
ContentURI uri, int accountId)
{
List <AccountToNetwork> colClubNetwork = new List <AccountToNetwork>();
if (accountId == 0)
{
//set default objects
AccountToNetwork aton = new AccountToNetwork(true);
colClubNetwork.Add(aton);
return(colClubNetwork);
}
Helpers.SqlIOAsync sqlIO = new Helpers.SqlIOAsync(uri);
SqlParameter[] colPrams =
{
sqlIO.MakeInParam("@AccountId", SqlDbType.Int, 4, accountId)
};
SqlDataReader dataReader = await sqlIO.RunProcAsync(
"0GetNetworksByClubId", colPrams);
if (dataReader != null)
{
using (dataReader)
{
while (await dataReader.ReadAsync())
{
AccountToNetwork aton = new AccountToNetwork(true);
aton.PKId = dataReader.GetInt32(0);
aton.IsDefaultNetwork = dataReader.GetBoolean(1);
aton.DefaultGetDataFromType = dataReader.GetString(2);
aton.DefaultStoreDataAtType = dataReader.GetString(3);
aton.NetworkRole = dataReader.GetString(4);
aton.AccountId = dataReader.GetInt32(5);
aton.NetworkId = dataReader.GetInt32(6);
aton.Account = new Account(true);
aton.Network = new Network(true);
aton.Network.PKId = dataReader.GetInt32(7);
aton.Network.NetworkName = dataReader.GetString(8);
aton.Network.NetworkURIPartName = dataReader.GetString(9);
aton.Network.NetworkDesc = dataReader.GetString(10);
aton.Network.AdminConnection = dataReader.GetString(11);
aton.Network.WebFileSystemPath = dataReader.GetString(12);
aton.Network.WebConnection = dataReader.GetString(13);
aton.Network.WebDbPath = dataReader.GetString(14);
aton.Network.NetworkClassId = dataReader.GetInt32(15);
aton.Network.NetworkClass = new NetworkClass();
aton.Network.GeoRegionId = dataReader.GetInt32(16);
//rest are not stored in db
aton.Network.IsDefault = aton.IsDefaultNetwork;
aton.Network.URIFull = string.Empty;
aton.Network.XmlConnection = string.Empty;
colClubNetwork.Add(aton);
}
}
}
else
{
//set default objects
AccountToNetwork aton = new AccountToNetwork(true);
colClubNetwork.Add(aton);
}
sqlIO.Dispose();
return(colClubNetwork);
}
