/// <summary>
/// Method to create photo album
/// </summary>
/// <param name="objPhotoAlbum">Filled PhotoAlbum entity</param>
/// <param name="objPhotoList">List of filled Photo entity</param>
public int CreatePhotoAlbum(PhotoAlbum objPhotoAlbum, List<Photos> objPhotoList)
{
PhotoResource objPhotoResource = new PhotoResource();
object photoAlbumId = 0;
object[] param = { objPhotoAlbum };
using (TransactionScope trans = new TransactionScope())
{
photoAlbumId = objPhotoResource.AddPhotoAlbum(param);
if (!Equals(photoAlbumId, null))
{
if (int.Parse(photoAlbumId.ToString()) > 0)
AddPhotos(objPhotoList, int.Parse(photoAlbumId.ToString()));
else
return int.Parse(photoAlbumId.ToString());
}
//Transaction Commited
trans.Complete();
}
return int.Parse(photoAlbumId.ToString());
}
public int CreatePhotoAlbum(PhotoAlbum objPhotoAlbum)
{
PhotoResource objPhotoResource = new PhotoResource();
object photoAlbumId = 0;
object[] param = { objPhotoAlbum };
using (TransactionScope trans = new TransactionScope())
{
photoAlbumId = objPhotoResource.AddPhotoAlbum(param);
//Transaction Commited
trans.Complete();
}
return int.Parse(photoAlbumId.ToString());
}
public void IsUserOwnerTest()
{
UserInfoManager target = new UserInfoManager(); // TODO: Initialize to an appropriate value
//UserAdminOwnerInfo objUserInfo = null; // TODO: Initialize to an appropriate value
bool expected = true; // TODO: Initialize to an appropriate value
bool actual;
UserAdminOwnerInfo objUserInfo = new UserAdminOwnerInfo();
int UserId = InsertDummyUser("tj_op");
objUserInfo.UserId = UserId;
//Find Tributes for User ID
int tributeId = 0;
GetMyTributes _objtribute = new GetMyTributes();
_objtribute.UserId = UserId;
object[] _param = { _objtribute, 0, 1, 1 };
if (_objtribute.CustomError == null)
{
List<GetMyTributes> Mytributes = new List<GetMyTributes>();
Mytributes = target.GetMyTributes(_param);
Assert.AreEqual(true, Mytributes.Count > 0);
tributeId = Mytributes[0].TributeId;
}
objUserInfo.TributeId = tributeId;
//FINd Photo Album ID for Tribute id
object[] objParam = { tributeId };
DataSet dsPhotoAlbumList = GetDataSet("usp_GetPhotoAlbumListInTribute", objParam);
List<PhotoAlbum> objListOfPhotoAlbum = new List<PhotoAlbum>();
//to fill records in the Photo Gallery list
if (dsPhotoAlbumList.Tables[0].Rows.Count > 0)
{
foreach (DataRow dr in dsPhotoAlbumList.Tables[0].Rows)
{
PhotoAlbum objAlbum = new PhotoAlbum();
objAlbum.PhotoAlbumId = int.Parse(dr["PhotoAlbumId"].ToString());
objListOfPhotoAlbum.Add(objAlbum);
objAlbum = null;
}
}
int PhotoAlbumId = 0;
if (objListOfPhotoAlbum.Count > 0)
{
PhotoAlbumId = objListOfPhotoAlbum[0].PhotoAlbumId;
}
//Get Photo id in PhotoAlbumId/////////////
List<Photos> objListPhotos = new List<Photos>();
try
{
object[] objParam1 = {PhotoAlbumId,
1,
1,
"ASC"
};
DataSet dsPhotos = GetDataSet("usp_GetPhotos", objParam1);
int totalRecords = 0;
//objGetPhotos.SortOrder
if (dsPhotos.Tables[0].Rows.Count > 0)
{
DataRow dr = dsPhotos.Tables[0].Rows[0];
totalRecords = int.Parse(dr["TotalRecords"].ToString());
}
//to fill records in the Photo list
if (dsPhotos.Tables[1].Rows.Count > 0)
{
foreach (DataRow dr in dsPhotos.Tables[1].Rows)
{
Photos objPhoto = new Photos();
objPhoto.PhotoId = int.Parse(dr["UserPhotoId"].ToString());
objPhoto.PhotoAlbumId = int.Parse(dr["PhotoAlbumId"].ToString());
objPhoto.PhotoImage = dr["PhotoImage"].ToString();
objPhoto.CommentCount = int.Parse(dr["CommentCount"].ToString());
objPhoto.CreatedDate = DateTime.Parse(dr["CreatedDate"].ToString());
objPhoto.TotalRecords = totalRecords;
objListPhotos.Add(objPhoto);
objPhoto = null;
}
}
}
catch (Exception ex)
{
throw ex;
}
//////////////////////////////////////////
objUserInfo.TypeId = objListPhotos[0].PhotoId;
objUserInfo.TypeName = "ManagePhoto";
actual = target.IsUserOwner(objUserInfo);
Assert.AreEqual(expected, actual);
//Assert.Inconclusive("Verify the correctness of this test method.");
}
/// <summary>
/// Method to get the count for number of photos in the selected album
/// </summary>
/// <param name="objPhotoAlbumId">PhotoAlbum entity containing PhotoAlbumId</param>
/// <returns>Object containing count for number of photos in album.</returns>
public object GetPhotoCount(PhotoAlbum objPhotoAlbumId)
{
return FacadeManager.PhotoManager.GetPhotoCount(objPhotoAlbumId);
}
/// <summary>
/// Method to get subject for email on adding album.
/// </summary>
/// <param name="objComment"></param>
/// <returns>Subject of email in string format.</returns>
private string GetEmailSubject(PhotoAlbum objAlbum)
{
return objAlbum.UserName + " added a new photo album on Your Tribute...";
}
/// <summary>
/// Method to update photo album details
/// </summary>
/// <param name="objVid">Filled photo album entity</param>
public object UpdatePhotoAlbumDetails(PhotoAlbum objPhotoAlbum)
{
PhotoResource objPhotoResource = new PhotoResource();
object[] param = { objPhotoAlbum };
using (TransactionScope trans = new TransactionScope())
{
//return objPhotoResource.UpdatePhotoAlbumDetails(param);
object objReturn = objPhotoResource.UpdatePhotoAlbumDetails(param);
//Transation Commited
trans.Complete();
return objReturn;
}
}
/// <summary>
/// Method to send email to the list of users on adding photo album.
/// </summary>
/// <param name="objUsers">User Info entity containing User name and email address</param>
public void SendEmail(List<UserInfo> objUsers, string strAdded, PhotoAlbum objPhotoAlbum)
{
EmailMessages objEmail = EmailMessages.Instance;
foreach (UserInfo obj in objUsers)
{
StringBuilder sbToEmail = new StringBuilder();
sbToEmail.Append(obj.UserEmail);
sbToEmail.Append(",");
//if (strAdded == "PhotoAlbum")
objEmail.SendMessages("Your Tribute<" + WebConfig.NoreplyEmail + ">", sbToEmail.ToString(), GetEmailSubject(objPhotoAlbum), GetEmailBody(obj, strAdded, objPhotoAlbum), EmailMessages.TextFormat.Html.ToString());
//else
// objEmail.SendMessages("" + WebConfig.NotificationEmail + "", sbToEmail.ToString(), "New Photo(s)", GetEmailBody(obj, strAdded), EmailMessages.TextFormat.Html.ToString());
}
}
/// <summary>
/// Method to get the count for number of photos in the selected album.
/// </summary>
/// <param name="objPhotoAlbumId">PhotoAlbum entity containing PhotoAlbumId</param>
/// <returns>Object containing count for number of photos in album.</returns>
public object GetPhotoCount(PhotoAlbum objPhotoAlbumId)
{
PhotoResource objPhotoResource = new PhotoResource();
object[] param = { objPhotoAlbumId };
return objPhotoResource.GetPhotoCountForAlbum(param);
}
/// <summary>
/// Method to delete photo album.
/// </summary>
/// <param name="objPhoto">Filled photo album entity.</param>
public void DeletePhotoAlbum(PhotoAlbum objPhotoAlbum)
{
FacadeManager.PhotoManager.DeletePhotoAlbum(objPhotoAlbum);
}
public int CreatePhotoAlbum(PhotoAlbum objPhotoAlbum)
{
return FacadeManager.PhotoManager.CreatePhotoAlbum(objPhotoAlbum);
}
/// <summary>
/// Method to create photo album and add photos to it.
/// </summary>
/// <param name="objPhotoAlbum">Filled PhotoAlbum entity.</param>
/// <param name="objPhotoList">Filled list of Photos.</param>
public int CreateAlbumAndSavePhotos(PhotoAlbum objPhotoAlbum, List<Photos> objPhotoList)
{
return FacadeManager.PhotoManager.CreatePhotoAlbum(objPhotoAlbum, objPhotoList);
}
/// <summary>
/// Method to update photo album details.
/// </summary>
/// <param name="objPhoto">Filled photo album entity.</param>
public object UpdatePhotoAlbum(PhotoAlbum objPhotoAlbum)
{
return FacadeManager.PhotoManager.UpdatePhotoAlbumDetails(objPhotoAlbum);
}
/// <summary>
/// Sends email when a new photo album is created
/// </summary>
/// <param name="objPhotoAlbum"></param>
public void SendPhotoAlbumEmail(PhotoAlbum objPhotoAlbum)
{
FacadeManager.PhotoManager.SendPhotoAlbumEmail(objPhotoAlbum);
}
/// <summary>
/// Method to get the list of photo albums for the tribute.
/// </summary>
/// <param name="objPhotoAlbum">PhotoAlbum entity containing tribute id, page number and page size.</param>
/// <returns>List of photo albums.</returns>
public List<PhotoAlbum> GetPhotoGalleryRecords(PhotoAlbum objPhotoAlbum)
{
return FacadeManager.PhotoManager.GetPhotoGalleryRecords(objPhotoAlbum);
}
/// <summary>
/// Method to delete photo album
/// </summary>
/// <param name="objVid">Filled photo album Entity</param>
public void DeletePhotoAlbum(PhotoAlbum objPhotoAlbum)
{
PhotoResource objPhotoResource = new PhotoResource();
object[] param = { objPhotoAlbum };
using (TransactionScope trans = new TransactionScope())
{
objPhotoResource.DeletePhotoAlbum(param);
//Transaction Commited
trans.Complete();
}
}
/// <summary>
/// Method to get the list of photo albums
/// </summary>
/// <param name="objPhotoAlbum">PhotoAlbum entity containing TributeId</param>
/// <returns>List of filled PhotoAlbum entity</returns>
public List<PhotoAlbum> GetPhotoAlbumList(PhotoAlbum objPhotoAlbum)
{
PhotoResource objPhotoResource = new PhotoResource();
object[] param = { objPhotoAlbum };
return objPhotoResource.GetPhotoAlbumList(param);
}
public bool IsAllowedPhotoCheck(int _photoAlbumId)
{
bool isAllowedPhotoCheck = false;
PhotoAlbum objPAlbum = new PhotoAlbum();
if (_photoAlbumId > 0)
{
objPAlbum.PhotoAlbumId = _photoAlbumId;
try
{
object[] objparam = { objPAlbum.PhotoAlbumId
};
DataSet dsIsAllowed = GetDataSet("usp_IsAllowedPhotoCheck", objparam);
if (dsIsAllowed.Tables[0].Rows.Count > 0)
{
foreach (DataRow dr in dsIsAllowed.Tables[0].Rows)
{
bool.TryParse(dr["IsAllowed"].ToString(), out isAllowedPhotoCheck);
}
}
}
catch (System.Data.SqlClient.SqlException sqlEx)
{
if (sqlEx.Number >= 50000)
{
Errors objError = new Errors();
objError.ErrorMessage = sqlEx.Message;
return isAllowedPhotoCheck;
}
}
}
return isAllowedPhotoCheck;
}
/// <summary>
/// Method to get the list of photo albums
/// </summary>
/// <param name="objPhotoAlbum">PhotoAlbum entity containing TributeId, pagesize and page number</param>
/// <returns>List of filled PhotoAlbum entity</returns>
public List<PhotoAlbum> GetPhotoGalleryRecords(PhotoAlbum objPhotoAlbum)
{
PhotoResource objPhotoResource = new PhotoResource();
object[] param = { objPhotoAlbum };
return objPhotoResource.GetPhotoGalleryRecords(param);
}
public int GetPackIdonPhotoAlbumId(int photoAlbumId)
{
int packId = 0;
PhotoAlbum objPAlbum = new PhotoAlbum();
if (photoAlbumId > 0)
{
objPAlbum.PhotoAlbumId = photoAlbumId;
try
{
object[] objparam = { objPAlbum.PhotoAlbumId
};
DataSet dsIsAllowed = GetDataSet("usp_GetPackIdonPhotoAlbumId", objparam);
if (dsIsAllowed.Tables[0].Rows.Count > 0)
{
foreach (DataRow dr in dsIsAllowed.Tables[0].Rows)
{
int.TryParse(dr["PackageId"].ToString(), out packId);
}
}
}
catch (System.Data.SqlClient.SqlException sqlEx)
{
if (sqlEx.Number >= 50000)
{
Errors objError = new Errors();
objError.ErrorMessage = sqlEx.Message;
return packId;
}
}
}
return packId;
}
public void SendPhotoAlbumEmail(PhotoAlbum objPhotoAlbum)
{
//to send mail
TributeResource objTribute = new TributeResource();
Tributes objTrib = new Tributes();
objTrib.TributeId = int.Parse(objPhotoAlbum.UserTributeId.ToString());
objTrib.TypeDescription = objPhotoAlbum.ModuleTypeName;
object[] paramTrib = { objTrib };
List<UserInfo> objUser = objTribute.GetTributeAdministrators(paramTrib);
if (objUser.Count > 0)
{
SendEmail(objUser, "PhotoAlbum", objPhotoAlbum);
}
//Function to send the mail to the list of users who have added the Tribute in their list of favourites
List<UserInfo> objUserFav = objTribute.GetFavouriteTributeUsers(paramTrib);
if (objUserFav.Count > 0)
{
//As per discussion with Rupendra: will send the mail in "To" field.
//ie a comma separated list of users in the "to" field
SendEmail(objUserFav, "PhotoAlbum", objPhotoAlbum);
}
}
/// <summary>
/// Method to get the details of photo album.
/// </summary>
/// <param name="objPhotoGallery">Object containing PhotoAlbum entity for PhotoAlbumId</param>
/// <returns>PhotoAlbumDetails.</returns>
public PhotoAlbum GetPhotoAlbumDetail(object[] objPhotoAlbumId)
{
try
{
Photos objPhotoAlbum = (Photos)objPhotoAlbumId[0];
PhotoAlbum objPhotoAlbumDetails = new PhotoAlbum();
if (!Equals(objPhotoAlbum, null))
{
object[] objParam = { objPhotoAlbum.PhotoAlbumId };
DataSet dsPhotoAlbumDetail = GetDataSet("usp_GetPhotoAlbumDetails", objParam);
//to fill records in the Video Gallery list
if (dsPhotoAlbumDetail.Tables[0].Rows.Count > 0)
{
foreach (DataRow dr in dsPhotoAlbumDetail.Tables[0].Rows)
{
objPhotoAlbumDetails.PhotoAlbumId = int.Parse(dr["PhotoAlbumId"].ToString());
objPhotoAlbumDetails.PhotoAlbumCaption = dr["PhotoAlbumCaption"].ToString();
objPhotoAlbumDetails.PhotoAlbumDesc = dr["PhotoAlbumDesc"].ToString();
objPhotoAlbumDetails.UserTributeId = int.Parse(dr["UserTributeId"].ToString());
objPhotoAlbumDetails.UserId = int.Parse(dr["UserId"].ToString());
objPhotoAlbumDetails.UserName = dr["UserName"].ToString();
objPhotoAlbumDetails.PhotoCount = int.Parse(dr["PhotoCount"].ToString());
objPhotoAlbumDetails.CreatedBy = int.Parse(dr["CreatedBy"].ToString());
objPhotoAlbumDetails.CreatedDate = DateTime.Parse(dr["CreatedDate"].ToString());
}
}
}
return objPhotoAlbumDetails;
}
catch (Exception ex)
{
throw ex;
}
}
/// <summary>
/// Method to get the body part of email on adding photos only.
/// </summary>
/// <param name="objUserInfo">Filled User Info entity</param>
/// <returns>HTML string of body part</returns>
private string GetEmailBody(UserInfo objUserInfo, string strAdded, PhotoAlbum objAlbum)
{
StringBuilder sbBody = new StringBuilder();
sbBody.Append("<font style='font-size: 12px; font-family:Lucida Sans;'><p>" + objAlbum.UserName);
sbBody.Append(" added a new photo album in the ");
sbBody.Append(objAlbum.TributeName + " " + objAlbum.TributeType + " Tribute.</p>");
sbBody.Append("<p>To view the photo album, follow the link below:");
sbBody.Append("<br/>");
string strLink = "http://" + objAlbum.TributeType.Replace("New Baby", "newbaby").ToLower() + "." + WebConfig.TopLevelDomain + "/" + objAlbum.TributeUrl + "/photoalbum.aspx" + "?PhotoAlbumId=" + objAlbum.PhotoAlbumId;
//sbBody.Append("<a href='http://" + objAlbum.PathToVisit + "/Photo/PhotoAlbum.aspx" + "?PhotoAlbumId=" + objAlbum.PhotoAlbumId + "&TributeId=" + objAlbum.UserTributeId + "&TributeName=" + objAlbum.TributeName + "&TributeType=" + objAlbum.TributeType + "&TributeUrl=" + objAlbum.TributeUrl + "&mode=link'>" + "Click here to visit the link</a>");
//sbBody.Append("<a href='http://" + objAlbum.TributeType + "." + WebConfig.TopLevelDomain + "/" + objAlbum.TributeUrl + "/photoalbum.aspx" + "?PhotoAlbumId=" + objAlbum.PhotoAlbumId + "'>" + "Click here to visit the link</a>");
sbBody.Append("<a href='" + strLink + "'>" + strLink + "</a></p>");
sbBody.Append("<p>---<br/>");
sbBody.Append("Your Tribute Team</p></font>");
return sbBody.ToString();
}
/// <summary>
/// Method to get the list of photo album for the selected tribute
/// </summary>
/// <param name="objPhotoGallery">Object containing PhotoAlbum entity for tributeid</param>
/// <returns>List of PhotoAlbum entity.</returns>
public List<PhotoAlbum> GetPhotoAlbumList(object[] objPhotoAlbumList)
{
try
{
PhotoAlbum objPhotoAlbum = (PhotoAlbum)objPhotoAlbumList[0];
List<PhotoAlbum> objListOfPhotoAlbum = new List<PhotoAlbum>();
//VideoGallery objVideoGal = (VideoGallery)objVideoGallery[0];
//List<VideoGallery> objListVideo = new List<VideoGallery>();
if (!Equals(objPhotoAlbum, null))
{
object[] objParam = { objPhotoAlbum.UserTributeId };
DataSet dsPhotoAlbumList = GetDataSet("usp_GetPhotoAlbumListInTribute", objParam);
//to fill records in the Photo Gallery list
if (dsPhotoAlbumList.Tables[0].Rows.Count > 0)
{
foreach (DataRow dr in dsPhotoAlbumList.Tables[0].Rows)
{
PhotoAlbum objAlbum = new PhotoAlbum();
objAlbum.PhotoAlbumId = int.Parse(dr["PhotoAlbumId"].ToString());
objAlbum.PhotoAlbumCaption = dr["PhotoAlbumCaption"].ToString();
objListOfPhotoAlbum.Add(objAlbum);
objAlbum = null;
}
}
}
return objListOfPhotoAlbum;
}
catch (Exception ex)
{
throw ex;
}
}
/// <summary>
/// Method to get the list of photo album for the selected tribute
/// </summary>
/// <param name="objPhotoGallery">Object containing PhotoAlbum entity for tributeid, page size and page number</param>
/// <returns>List of PhotoAlbum entity.</returns>
public List<PhotoAlbum> GetPhotoGalleryRecords(object[] objPhotoGallery)
{
try
{
PhotoAlbum objPhotoAlbum = (PhotoAlbum)objPhotoGallery[0];
List<PhotoAlbum> objListPhotoAlbum = new List<PhotoAlbum>();
//VideoGallery objVideoGal = (VideoGallery)objVideoGallery[0];
//List<VideoGallery> objListVideo = new List<VideoGallery>();
if (!Equals(objPhotoAlbum, null))
{
object[] objParam = {objPhotoAlbum.UserTributeId,
objPhotoAlbum.PageSize,
objPhotoAlbum.PageNumber
};
DataSet dsPhotoGallery = GetDataSet("usp_GetPhotoGallery", objParam);
//to fill records in the Photo Gallery list
if (dsPhotoGallery.Tables[0].Rows.Count > 0)
{
foreach (DataRow dr in dsPhotoGallery.Tables[0].Rows)
{
PhotoAlbum objAlbum = new PhotoAlbum();
objAlbum.PhotoAlbumId = int.Parse(dr["PhotoAlbumId"].ToString());
objAlbum.UserTributeId = int.Parse(dr["UserTributeId"].ToString());
objAlbum.PhotoAlbumCaption = dr["PhotoAlbumCaption"].ToString();
objAlbum.PhotoImage = dr["PhotoImage"].ToString();
objAlbum.CreatedBy = int.Parse(dr["CreatedBy"].ToString());
objAlbum.CreatedDate = DateTime.Parse(dr["CreatedDate"].ToString());
objAlbum.CreationDate = DateTime.Parse(dr["CreatedDate"].ToString()).ToString("MMMM dd, yyyy");
objAlbum.ModificationDate = dr["ModifiedDate"] == DBNull.Value ? string.Empty : DateTime.Parse(dr["ModifiedDate"].ToString()).ToString("MMMM dd, yyyy");
//objAlbum.ModifiedDate = dr["ModifiedDate"].ToString() != null ? DateTime.Parse(dr["ModifiedDate"].ToString()).ToString("MMMM dd, yyyy") : null;
objAlbum.PhotoCount = int.Parse(dr["PhotoCount"].ToString());
objAlbum.UserName = dr["UserName"].ToString();
objAlbum.CommentCount = int.Parse(dr["CommentCount"].ToString());
objAlbum.TotalRecords = int.Parse(dr["TotalRecords"].ToString());
objListPhotoAlbum.Add(objAlbum);
objAlbum = null;
}
}
}
return objListPhotoAlbum;
}
catch (Exception ex)
{
throw ex;
}
}
/// <summary>
/// Method to get the list of photoalbums.
/// </summary>
/// <param name="objPhotoAlbum">PhotoAlbum entity containing TributeId.</param>
/// <returns>List of PhotoAlbums.</returns>
public List<PhotoAlbum> GetPhotoAlbumList(PhotoAlbum objPhotoAlbum)
{
return FacadeManager.PhotoManager.GetPhotoAlbumList(objPhotoAlbum);
}
