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