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