public void Save(UserNameImageList userNameImageList)
{
UserNameImageList userNameImageListNonDefault = new UserNameImageList(userNameImageList.UniqueID);
foreach (NameImage nameImageItem in userNameImageList.Items)
{
bool foundDefault = false;
foreach (NameImage defaultNameImageItem in DefaultIconsList.Instance.DefaultIcons)
{
if ((nameImageItem.Name == defaultNameImageItem.Name) &&
(nameImageItem.ImageLocation == defaultNameImageItem.ImageLocation))
{
foundDefault = true;
break;
}
}
if (!foundDefault)
{
userNameImageListNonDefault.Items.Add(nameImageItem);
}
}
mUserNameImageListDAL.Save(userNameImageListNonDefault);
}
public void LoadToImageList(UserNameImageList userNameImageList, UInt64 uniqueID, int index)
{
SqlDataReader sqlReader = null;
SqlCommand sqlCommand = null;
try
{
sqlCommand = new SqlCommand("select * from UserNameImages where UserUniqueID = @1", mSqlConnection);
SqlParameter sqlParameter = new SqlParameter("@1", SqlDbType.BigInt);
sqlParameter.Value = uniqueID;
sqlCommand.Parameters.Add(sqlParameter);
sqlReader = sqlCommand.ExecuteReader();
userNameImageList.UniqueID = uniqueID;
userNameImageList.LastDALChange = DateTime.Now.Ticks;
while (sqlReader.Read())
{
Int64 lastDALChange = Convert.ToInt64(sqlReader["LastDALChange"].ToString());
userNameImageList.LastDALChange = (lastDALChange < userNameImageList.LastDALChange) ? lastDALChange : userNameImageList.LastDALChange;
NameImage newNameImage = new NameImage(sqlReader["Name"].ToString(), sqlReader["ImageLocation"].ToString(), int.Parse(sqlReader["Value"].ToString()));
newNameImage.IsDefault = false;
userNameImageList.Items.Insert(index++, newNameImage);
}
}
catch (Exception exception)
{
throw exception;
}
finally
{
sqlReader.Close();
}
}
public void SetDefaultList(UserNameImageList userNameImageList)
{
userNameImageList.Items.Clear();
foreach (NameImage nameImageItem in DefaultIconsList.Instance.DefaultIcons)
{
nameImageItem.IsDefault = true;
userNameImageList.Items.Add(nameImageItem);
}
}
// Exceptions:
// System.ArgumentException:
// resourceBase is null when loading UserNameImageList
// Load Failed
public void Load(UserNameImageList userNameImageList)
{
try
{
Load(userNameImageList, userNameImageList.UniqueID);
}
catch
{
throw new System.ArgumentException("Load Failed", "userNameImageList");
}
}
public void Save(UserNameImageList userNameImageList)
{
if (userNameImageList.IsNull)
{
throw new System.ArgumentException("userNameImageList is null", "userNameImageList");
}
else
{
UpdateInternal(userNameImageList);
}
}
// Exceptions:
// System.ArgumentException:
// Load Failed
public void Load(UserNameImageList userNameImageList, UInt64 uniqueID)
{
SetDefaultList(userNameImageList);
userNameImageList.Items.Sort();
try
{
mUserNameImageListDAL.LoadToImageList(userNameImageList, uniqueID, 0);
}
catch
{
throw new System.ArgumentException("Load Failed", "userNameImageList");
}
}
private void InitMembers()
{
mCurrentUser = (UserBase)Session["CurrentUser"];
if (mCurrentUser != null)
{
if (!mCurrentUser.IsNull)
{
mCurrentEvent = (EventBase)Session["CurrentEvent"];
if (mCurrentEvent != null)
{
if (mCurrentEvent.IsNull)
{
mCurrentEvent = null;
}
}
mCurrentUserNameImageList = (UserNameImageList)Session["CurrentUserNameImageList"];
if (mCurrentUserNameImageList != null)
{
if (mCurrentEvent.IsNull)
{
mCurrentUserNameImageList = null;
}
}
if (mCurrentUserNameImageList == null)
{
mCurrentUserNameImageList = new UserNameImageList(mCurrentUser.UniqueID);
mUserNameImageListBO.Load(mCurrentUserNameImageList);
Session["CurrentUserNameImageList"] = mCurrentUserNameImageList;
}
mHoldingsInfoBO = (HoldingsInfoBO)Session["HoldingsInfoBO"];
if (mHoldingsInfoBO == null)
{
mHoldingsInfoBO = new HoldingsInfoBO();
Session["HoldingsInfoBO"] = mHoldingsInfoBO;
}
}
else
{
mCurrentUser = null;
}
}
mIsInit = true;
}
public void ClearValues(UserNameImageList userNameImageList)
{
userNameImageList.UniqueID = 0;
userNameImageList.Items.Clear();
}
/*public bool IsLatest(UserNameImageList userNameImageList)
* {
* return mUserNameImageListDAL.IsLatest(userNameImageList);
* }*/
public void GetLatest(UserNameImageList userNameImageList)
{
//if(!mUserNameImageListDAL.IsLatest(userNameImageList))
Load(userNameImageList);
}
protected void UpdateInternal(UserNameImageList userNameImageList)
{
try
{
UserNameImageList savedNameImageList = new UserNameImageList(userNameImageList.UniqueID);
LoadToImageList(savedNameImageList, userNameImageList.UniqueID, savedNameImageList.Items.Count);
userNameImageList.LastDALChange = DateTime.Now.Ticks;
// Remove items that are not in the list
foreach (NameImage savedNameImageItem in savedNameImageList.Items)
{
bool removedItem = true;
foreach (NameImage nameImageItem in userNameImageList.Items)
{
if ((nameImageItem.Name == savedNameImageItem.Name) &&
(nameImageItem.ImageLocation == savedNameImageItem.ImageLocation))
{
removedItem = false;
break;
}
}
if (removedItem)
{
SqlCommand sqlCommand = new SqlCommand("delete from UserNameImages where " +
"Name=@Name and " +
"UserUniqueID= '" + userNameImageList.UniqueID.ToString() + "' and " +
"ImageLocation= '" + savedNameImageItem.ImageLocation + "';");
SqlParameter sqlParameter = new SqlParameter("@Name", SqlDbType.NVarChar);
sqlParameter.Value = savedNameImageItem.Name;
sqlCommand.Parameters.Add(sqlParameter);
sqlCommand.Connection = mSqlConnection;
int lineRemoved = sqlCommand.ExecuteNonQuery();
if (lineRemoved != 1)
{
throw new System.ArgumentException("delete from UserNameImages UserUniqueID=" + userNameImageList.UniqueID.ToString() + " failed", "userNameImageList.UniqueID");
}
}
}
// Add new Items
foreach (NameImage nameImageItem in userNameImageList.Items)
{
bool foundSaved = false;
foreach (NameImage savedNameImageItem in savedNameImageList.Items)
{
if ((nameImageItem.Name == savedNameImageItem.Name) &&
(nameImageItem.ImageLocation == savedNameImageItem.ImageLocation))
{
foundSaved = true;
break;
}
}
if (!foundSaved)
{
SqlCommand sqlCommand = new SqlCommand("Insert Into UserNameImages" +
" (UserUniqueID, LastDALChange, Name, ImageLocation, Value) values ('" +
userNameImageList.UniqueID.ToString() + "', '" +
userNameImageList.LastDALChange.ToString() + "', " +
"@Name, '" +
nameImageItem.ImageLocation + "', '" +
nameImageItem.Value.ToString() + "');");
SqlParameter sqlParameter = new SqlParameter("@Name", SqlDbType.NVarChar);
sqlParameter.Value = nameImageItem.Name;
sqlCommand.Parameters.Add(sqlParameter);
sqlCommand.Connection = mSqlConnection;
int lineInserted = sqlCommand.ExecuteNonQuery();
if (lineInserted != 1)
{
throw new System.ArgumentException("Insert Into UserNameImages UserUniqueID=" + userNameImageList.UniqueID.ToString() + " failed", "userNameImageList.UniqueID");
}
}
}
}
catch (Exception exception)
{
throw exception;
}
}
