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