protected string GetItemHoldingHTMLStr(HoldingsInfo holdingsInfo) { string fullName = "Still Needed"; if (holdingsInfo.HoldingUser.UniqueID != 0) { if (!holdingsInfo.HoldingUser.IsLoaded()) { holdingsInfo.HoldingUser = GetUserBase(holdingsInfo.HoldingUser.UniqueID); } if (mCurrentUser.UniqueID == holdingsInfo.HoldingUser.UniqueID) { fullName = "Me"; } else { fullName = holdingsInfo.HoldingUser.FirstName + " " + holdingsInfo.HoldingUser.LastName; } } return("<div class=\"myItemHoldings\" id=\"itemHoldings_" + holdingsInfo.UniqueID.ToString() + "\" onclick=\"ItemHoldingsClicked('" + holdingsInfo.UniqueID.ToString() + "','" + fullName + "');\"" + "onmouseover=\"this.style.background='#B0E0E6'\" onmouseout=\"ItemHoldingsMouseOut('" + holdingsInfo.UniqueID.ToString() + "');\"" + "><span> " + fullName + "</span></div>"); }
public string AddEmptyItemHolding(string uniqueID) { if (!mIsInit) { InitMembers(); } if (mCurrentEvent == null) { return("Event is not Loaded"); } // Force Reload ItemBase itemBase = new ItemBase(UInt64.Parse(uniqueID)); mItemBaseBO.Load(itemBase); if (itemBase == null) { return("Could not find Item"); } HoldingsInfo newDefaultHolding = new HoldingsInfo(); newDefaultHolding.ItemOwner = itemBase; mHoldingsInfoBO.Save(newDefaultHolding); itemBase.HoldingsInfo.Add(newDefaultHolding); AddItemToPool(itemBase); return(""); }
// Exceptions: // System.ArgumentException: // holdingsInfo is null when saving HoldingsInfo public void Save(HoldingsInfo holdingsInfo) { if (holdingsInfo.IsNull) { SaveInternal(holdingsInfo); return; //throw new System.ArgumentException("holdingsInfo is null when saving HoldingsInfo", "holdingsInfo"); } if (HoldingsInfoExists(holdingsInfo.UniqueID)) { HoldingsInfo upToDateItemBase = new HoldingsInfo(); try { Load(upToDateItemBase, holdingsInfo.UniqueID); } catch { SaveInternal(holdingsInfo); return; } if (holdingsInfo.CompareTo(upToDateItemBase) != 0) { UpdateInternal(holdingsInfo); } } else { SaveInternal(holdingsInfo); } }
public string AcceptInvite(string uniqueID) { if (!mIsInit) { InitMembers(); } if (mCurrentUser == null) { return("User is not Loaded"); } UInt64 uID = UInt64.Parse(uniqueID); mEventsInvitationsBO.AcceptInvitation(uID, mCurrentUser.Email); EventBase eventBase = GetEventBase(uID); // Add Holding Info HoldingsInfo holdingsInfo = new HoldingsInfo(); holdingsInfo.HoldingUser = mCurrentUser; holdingsInfo.HoldingUserPermissions = EHoldingPermissions.eParticipator; holdingsInfo.EventOwner = eventBase; mHoldingsInfoBO.Save(holdingsInfo); eventBase.HoldingsInfo.Add(holdingsInfo); mCurrentUser.Events.Add(eventBase); return(""); }
public string AddItemEvent( string itemName, string iconLocation, int itemValue) { if (!mIsInit) { InitMembers(); } if (mCurrentEvent == null) { return("Event is not Loaded"); } ItemBase newItemBase = new ItemBase(0, mCurrentEvent, mCurrentUser, new NameImage(itemName, iconLocation)); newItemBase.Value = itemValue; mItemBaseBO.Save(newItemBase); AddItemToPool(newItemBase); mCurrentEvent.ItemChildren.Add(newItemBase); HoldingsInfo newDefaultHolding = new HoldingsInfo(); newDefaultHolding.ItemOwner = newItemBase; mHoldingsInfoBO.Save(newDefaultHolding); newItemBase.HoldingsInfo.Add(newDefaultHolding); return(GetItemBaseHTMLString(newItemBase)); }
public HoldingsInfo DeleteHolding(EventBase eventOwner, ItemBase itemOwner, HoldingsInfo holdingsInfo) { mHoldingsInfoBO.Save(holdingsInfo); itemOwner.HoldingsInfo.Add(holdingsInfo); return(holdingsInfo); }
public bool IsLatest(HoldingsInfo holdingsInfo) { HoldingsInfo upToDateHoldingsInfo = new HoldingsInfo(); Load(upToDateHoldingsInfo, holdingsInfo.UniqueID); return(upToDateHoldingsInfo.LastDALChange == holdingsInfo.LastDALChange); }
public void Delete(HoldingsInfo holdingsInfo) { if (!holdingsInfo.IsLoaded()) { Load(holdingsInfo); } mHoldingsInfoDAL.Delete(holdingsInfo); }
public HoldingsInfo AddHolding(EventBase eventOwner, ItemBase itemOwner) { HoldingsInfo holdingsInfo = new HoldingsInfo(0, eventOwner, itemOwner); mHoldingsInfoBO.Save(holdingsInfo); itemOwner.HoldingsInfo.Add(holdingsInfo); return(holdingsInfo); }
// Exceptions: // System.ArgumentException: // HoldingInfo already exists public void AddHoldingInfo(UserBase userBase, HoldingsInfo holdingInfo) { if (userBase.HoldingsInfo.Contains(holdingInfo)) { throw new System.ArgumentException("ParticpantInfo already exists", "holdingInfo"); } userBase.HoldingsInfo.Add(holdingInfo); userBase.OnPropertyChanged("UserBase.HoldingsInfo.Changed"); }
// Exceptions: // System.ArgumentException: // Load Failed public void Load(HoldingsInfo holdingsInfo, UInt64 uniqueID) { try { mHoldingsInfoDAL.Load(holdingsInfo, uniqueID); } catch { throw new System.ArgumentException("Load Failed", "holdingsInfo"); } }
protected void UpdateInternal(HoldingsInfo holdingsInfo) { try { holdingsInfo.LastDALChange = DateTime.Now.Ticks; SqlCommand sqlCommand = new SqlCommand("Update HoldingsInfo set " + "LastDALChange='" + holdingsInfo.LastDALChange.ToString() + "'," + "HoldingUserUniqueID='" + holdingsInfo.HoldingUser.UniqueID.ToString() + "'," + "EHoldingPermissions='" + holdingsInfo.HoldingUserPermissions.ToString() + "'," + "EventOwnerUniqueID='" + holdingsInfo.EventOwner.UniqueID.ToString() + "'," + "ItemOwnerUniqueID='" + holdingsInfo.ItemOwner.UniqueID.ToString() + "'," + "AllowOverBooking='" + holdingsInfo.AllowOverBooking.ToString() + "'," + "Scalable='" + holdingsInfo.Scalable.ToString() + "'," + "NeedsOwnerApprovel='" + holdingsInfo.NeedsOwnerApprovel.ToString() + "'," + "EHoldingApprovel='" + holdingsInfo.HoldingApprovel.ToString() + "' " + "Where UniqueID='" + holdingsInfo.UniqueID.ToString() + "'"); sqlCommand.Connection = mSqlConnection; int lineInserted = sqlCommand.ExecuteNonQuery(); if (lineInserted != 1) { throw new System.ArgumentException("Update Into HoldingsInfo Where UniqueID=" + holdingsInfo.UniqueID.ToString() + " failed", "UniqueID"); } foreach (UserPermission userPermission in holdingsInfo.UserPermissions) { sqlCommand = new SqlCommand("Update UserPermission set " + "UserBaseUniqueID='" + userPermission.UserBase.UniqueID.ToString() + "'," + "EHoldingPermission='" + userPermission.HoldingPermission.ToString() + "' " + "Where HoldingInfoUniqueID='" + holdingsInfo.UniqueID.ToString() + "'"); sqlCommand.Connection = mSqlConnection; lineInserted = sqlCommand.ExecuteNonQuery(); if (lineInserted != 1) { throw new System.ArgumentException("Update Into HoldingsInfo Where UniqueID=" + holdingsInfo.UniqueID.ToString() + " failed", "UniqueID"); } } } catch (Exception exception) { throw exception; } }
// Exceptions: // System.ArgumentException: // ParticpantInfo not found // Could not remove ParticpantInfo public void RemoveHoldingInfo(UserBase userBase, HoldingsInfo holdingInfo) { if (!userBase.HoldingsInfo.Contains(holdingInfo)) { throw new System.ArgumentException("ParticpantInfo not found", "holdingInfo"); } userBase.HoldingsInfo.Remove(holdingInfo); if (userBase.HoldingsInfo.Contains(holdingInfo)) { throw new System.ArgumentException("Could not remove ParticpantInfo", "holdingInfo"); } userBase.OnPropertyChanged("UserBase.HoldingsInfo.Changed"); }
// Exceptions: // System.ArgumentException: // holdingsInfo is null when loading HoldingsInfo // Load Failed public void Load(HoldingsInfo holdingsInfo) { try { if (holdingsInfo.IsNull) { throw new System.ArgumentException("holdingsInfo is null when loading HoldingsInfo", "holdingsInfo"); } Load(holdingsInfo, holdingsInfo.UniqueID); } catch { throw new System.ArgumentException("Load Failed", "holdingsInfo"); } }
// Exceptions: // System.ArgumentException: public void Delete(HoldingsInfo holdingsInfo) { if (holdingsInfo.IsNull) { throw new System.ArgumentException("holdingsInfo is null when removing HoldingsInfo", "holdingsInfo"); } if (HoldingsInfoExists(holdingsInfo.UniqueID)) { DeleteInternal(holdingsInfo); } else { throw new System.ArgumentException("holdingsInfo does not exists while removing HoldingsInfo", "holdingsInfo"); } }
public string RemoveFriendFromEvent(string uniqueID) { if (!mIsInit) { InitMembers(); } if (!IsPermitted(EHoldingPermissions.eController)) { return("User does not have permission"); } if (mCurrentEvent == null) { return("Event is not Loaded"); } UInt64 uID = UInt64.Parse(uniqueID); HoldingsInfo holdingsInfo = null; foreach (HoldingsInfo tmpHoldingsInfo in mCurrentEvent.HoldingsInfo) { if (tmpHoldingsInfo.HoldingUser.UniqueID == uID) { holdingsInfo = tmpHoldingsInfo; break; } } if (holdingsInfo == null) { return("Friend not found in this event"); } mCurrentEvent.HoldingsInfo.Remove(holdingsInfo); try { mHoldingsInfoBO.Delete(holdingsInfo); } catch { return("Failed to remove friend from event"); } return("success"); }
protected void SaveInternal(HoldingsInfo holdingsInfo) { try { holdingsInfo.LastDALChange = DateTime.Now.Ticks; SqlCommand sqlCommand = new SqlCommand("Insert Into HoldingsInfo" + " (LastDALChange, HoldingUserUniqueID, EHoldingPermissions, EventOwnerUniqueID, ItemOwnerUniqueID, AllowOverBooking, Scalable, NeedsOwnerApprovel, EHoldingApprovel) values ('" + holdingsInfo.LastDALChange.ToString() + "', '" + holdingsInfo.HoldingUser.UniqueID.ToString() + "', '" + holdingsInfo.HoldingUserPermissions.ToString() + "', '" + holdingsInfo.EventOwner.UniqueID.ToString() + "', '" + holdingsInfo.ItemOwner.UniqueID.ToString() + "', '" + holdingsInfo.AllowOverBooking.ToString() + "', '" + holdingsInfo.Scalable.ToString() + "', '" + holdingsInfo.NeedsOwnerApprovel.ToString() + "', '" + holdingsInfo.HoldingApprovel.ToString() + "');" + "SELECT SCOPE_IDENTITY()"); sqlCommand.Connection = mSqlConnection; holdingsInfo.UniqueID = Convert.ToUInt64(sqlCommand.ExecuteScalar()); foreach (UserPermission userPermission in holdingsInfo.UserPermissions) { sqlCommand = new SqlCommand("Insert Into UserPermission" + " (HoldingInfoUniqueID, UserBaseUniqueID, EHoldingPermission) values ('" + holdingsInfo.UniqueID.ToString() + "', '" + userPermission.UserBase.UniqueID.ToString() + "', '" + userPermission.HoldingPermission.ToString() + "');"); sqlCommand.Connection = mSqlConnection; int lineInserted = sqlCommand.ExecuteNonQuery(); if (lineInserted != 1) { throw new System.ArgumentException("Insert Into UserPermission UniqueID=" + holdingsInfo.UniqueID.ToString() + " failed", "userPermission"); } } } catch (Exception exception) { throw exception; } }
// Exceptions: // System.ArgumentException: // Load Failed // currentUser is to check validation protected void LoadInternal(EventBase eventBase, UserBase currentUser, bool loadChildren) { try { mEventBaseDAL.Load(eventBase, eventBase.UniqueID); mEventTimeInfoBO.Load(eventBase.EventTimeInfo); mEventLocationBO.Load(eventBase.EventLocation); mResourceDescriptionBO.Load(eventBase.ResourceDescription); if (loadChildren) { List <UInt64> uniqueIDs = mEventBaseDAL.GetChildrenUniqueIDs(eventBase.UniqueID); foreach (UInt64 tempUniqueID in uniqueIDs) { EventBase childEventBase = new EventBase(tempUniqueID); Load(childEventBase, currentUser); eventBase.EventChildren.Add(childEventBase); } uniqueIDs = mItemBaseDAL.GetChildrenUniqueIDsByEventParent(eventBase.UniqueID); foreach (UInt64 tempUniqueID in uniqueIDs) { ItemBase childItemBase = new ItemBase(tempUniqueID); mItemBaseBO.Load(childItemBase); eventBase.ItemChildren.Add(childItemBase); } uniqueIDs = mHoldingsInfoBO.GetUniqueIDsByEventOwner(eventBase.UniqueID); foreach (UInt64 tempUniqueID in uniqueIDs) { HoldingsInfo holdingsInfo = new HoldingsInfo(tempUniqueID); mHoldingsInfoBO.Load(holdingsInfo); // Should I load it here?? eventBase.HoldingsInfo.Add(holdingsInfo); } } } catch { throw new System.ArgumentException("Load Failed", "eventBase"); } }
public string AddFriendToEvent(string uniqueID) { if (!mIsInit) { InitMembers(); } if (!IsPermitted(EHoldingPermissions.eController)) { return("User does not have permission"); } if (mCurrentEvent == null) { return("Event is not Loaded"); } if (mCurrentUser == null) { return("User is not Loaded"); } UserBase friendUserBase = GetUserBase(UInt64.Parse(uniqueID)); foreach (HoldingsInfo tmpHoldingsInfo in mCurrentEvent.HoldingsInfo) { if (tmpHoldingsInfo.HoldingUser.UniqueID == friendUserBase.UniqueID) { return(friendUserBase.FirstName + " " + friendUserBase.LastName + " is alread in this event"); } } HoldingsInfo holdingsInfo = new HoldingsInfo(); holdingsInfo.HoldingUser = friendUserBase; holdingsInfo.EventOwner = mCurrentEvent; holdingsInfo.UserPermissions.Add(new UserPermission(holdingsInfo.UniqueID, friendUserBase, EHoldingPermissions.eParticipator)); mHoldingsInfoBO.Save(holdingsInfo); mCurrentEvent.HoldingsInfo.Add(holdingsInfo); return(EventFriendHTMLStr(friendUserBase.UniqueID, friendUserBase.FirstName + " " + friendUserBase.LastName)); }
// Exceptions: // System.ArgumentException: // Load Failed protected void LoadInternal(ItemBase itemBase, bool loadChildren) { try { List <UInt64> uniqueIDs; //ClearValues(itemBase); Not sure why I did this mItemBaseDAL.Load(itemBase, itemBase.UniqueID); try { mResourceDescriptionBO.Load(itemBase.ResourceDescription); } catch { itemBase.ResourceDescription = new ResourceDescription(itemBase.UniqueID); mResourceDescriptionBO.Save(itemBase.ResourceDescription); } if (loadChildren) { uniqueIDs = mItemBaseDAL.GetChildrenUniqueIDsByEventParent(itemBase.UniqueID); foreach (UInt64 childUniqueID in uniqueIDs) { ItemBase childItemBase = new ItemBase(childUniqueID); Load(childItemBase); itemBase.ItemChildren.Add(childItemBase); } } uniqueIDs = mHoldingsInfoBO.GetUniqueIDsByItemOwner(itemBase.UniqueID); foreach (UInt64 holdingsUniqueID in uniqueIDs) { HoldingsInfo holdingsInfo = new HoldingsInfo(holdingsUniqueID); // mHoldingsInfoBO.Load(holdingsInfo); // No Need to load yet... itemBase.HoldingsInfo.Add(holdingsInfo); } } catch { throw new System.ArgumentException("Load Failed", "itemBase"); } }
protected void DeleteInternal(HoldingsInfo holdingsInfo) { try { SqlCommand sqlCommand; int lineRemoved; foreach (UserPermission userPermission in holdingsInfo.UserPermissions) { sqlCommand = new SqlCommand("delete from UserPermission where " + "HoldingInfoUniqueID = '" + holdingsInfo.UniqueID.ToString() + "';"); sqlCommand.Connection = mSqlConnection; lineRemoved = sqlCommand.ExecuteNonQuery(); if (lineRemoved != 1) { throw new System.ArgumentException("Delete from UserPermission Where HoldingInfoUniqueID=" + holdingsInfo.UniqueID.ToString() + " failed", "UniqueID"); } } holdingsInfo.LastDALChange = DateTime.Now.Ticks; sqlCommand = new SqlCommand("delete from HoldingsInfo where " + "UniqueID = '" + holdingsInfo.UniqueID.ToString() + "';"); sqlCommand.Connection = mSqlConnection; lineRemoved = sqlCommand.ExecuteNonQuery(); if (lineRemoved != 1) { throw new System.ArgumentException("Delete from HoldingsInfo Where UniqueID=" + holdingsInfo.UniqueID.ToString() + " failed", "UniqueID"); } } catch (Exception exception) { throw exception; } }
public void ClearValues(HoldingsInfo holdingsInfo) { holdingsInfo.UniqueID = 0; holdingsInfo.HoldingUser = new UserBase(); holdingsInfo.EventOwner = new EventBase(); holdingsInfo.ItemOwner = new ItemBase(); holdingsInfo.UserPermissions.Clear(); holdingsInfo.HoldingTypes.Clear(); holdingsInfo.AllowOverBooking = false; holdingsInfo.Scalable = false; holdingsInfo.NeedsOwnerApprovel = false; holdingsInfo.HoldingApprovel = EHoldingApprovel.eHoldingApprovelNull; // Incase mNeedsOwnerApprovel is true }
public void Load(HoldingsInfo holdingsInfo, UInt64 uniqueID) { SqlDataReader sqlReader = null; SqlCommand sqlCommand = null; try { sqlCommand = new SqlCommand("select * from HoldingsInfo where UniqueID = @1", mSqlConnection); SqlParameter sqlParameter = new SqlParameter("@1", SqlDbType.BigInt); sqlParameter.Value = uniqueID; sqlCommand.Parameters.Add(sqlParameter); sqlReader = sqlCommand.ExecuteReader(); if (!sqlReader.Read()) { throw new System.ArgumentException("holdingsInfo with UniqueID=" + uniqueID.ToString() + " was not found", "uniqueID"); } holdingsInfo.UniqueID = uniqueID; holdingsInfo.LastDALChange = Convert.ToInt64(sqlReader["LastDALChange"].ToString()); holdingsInfo.HoldingUser = new UserBase(Convert.ToUInt64(sqlReader["HoldingUserUniqueID"].ToString())); holdingsInfo.HoldingUserPermissions = (EHoldingPermissions)Enum.Parse(typeof(EHoldingPermissions), sqlReader["EHoldingPermissions"].ToString()); holdingsInfo.EventOwner = new EventBase(Convert.ToUInt64(sqlReader["EventOwnerUniqueID"].ToString())); holdingsInfo.ItemOwner = new ItemBase(Convert.ToUInt64(sqlReader["ItemOwnerUniqueID"].ToString())); holdingsInfo.AllowOverBooking = Convert.ToBoolean(sqlReader["AllowOverBooking"].ToString()); holdingsInfo.Scalable = Convert.ToBoolean(sqlReader["Scalable"].ToString()); holdingsInfo.NeedsOwnerApprovel = Convert.ToBoolean(sqlReader["NeedsOwnerApprovel"].ToString()); holdingsInfo.HoldingApprovel = (EHoldingApprovel)Enum.Parse(typeof(EHoldingApprovel), sqlReader["EHoldingApprovel"].ToString()); if (sqlReader.Read()) { throw new ArgumentException("Multiple UniqueID=" + uniqueID.ToString() + " were found in HoldingsInfo", "uniqueID"); } sqlReader.Close(); sqlCommand = new SqlCommand("select * from UserPermission where HoldingInfoUniqueID = @1", mSqlConnection); sqlParameter = new SqlParameter("@1", SqlDbType.BigInt); sqlParameter.Value = uniqueID; sqlCommand.Parameters.Add(sqlParameter); sqlReader = sqlCommand.ExecuteReader(); /*if(!sqlReader.Read()) * { * throw new System.ArgumentException("UserPermission with HoldingInfoUniqueID=" + uniqueID.ToString() + " was not found", "uniqueID"); * }*/ if (sqlReader != null) { while (sqlReader.Read()) { UserPermission userPermission = new UserPermission(uniqueID); userPermission.UserBase = new UserBase(Convert.ToUInt64(sqlReader["UserBaseUniqueID"].ToString())); userPermission.HoldingPermission = (EHoldingPermissions)Enum.Parse(typeof(EHoldingPermissions), sqlReader["EHoldingPermission"].ToString()); holdingsInfo.UserPermissions.Add(userPermission); } } } catch (Exception exception) { throw exception; } finally { sqlReader.Close(); } }
public void Save(HoldingsInfo holdingsInfo) { mHoldingsInfoDAL.Save(holdingsInfo); }