public IList<GetTributesFeed> GetYourTributesFeed(object[] objparam) { List<GetTributesFeed> lstTributes = new List<GetTributesFeed>(); try { DataSet _objDataSet = GetDataSet("usp_GetYourTributesFeed", objparam); if (_objDataSet.Tables[0].Rows.Count > 0) { foreach (DataRow dr in _objDataSet.Tables[0].Rows) { GetTributesFeed objMyTributes = new GetTributesFeed(); objMyTributes.TributeId = int.Parse(dr["TributeId"].ToString()); objMyTributes.UserId = int.Parse(dr["UserTributeId"].ToString()); objMyTributes.TributeName = dr["TributeName"].ToString(); objMyTributes.TributeImage = dr["TributeImage"].ToString(); if (dr["Date1"].ToString() != null) objMyTributes.DOB = dr["Date1"].ToString(); objMyTributes.DOD = dr["Date2"].ToString(); objMyTributes.MessageWithoutHtml = dr["MessageWithoutHtml"].ToString(); if (!(string.IsNullOrEmpty(dr["ModifiedDate"].ToString()))) objMyTributes.ModifiedDate = DateTime.Parse(dr["ModifiedDate"].ToString()); objMyTributes.TypeDescription = dr["TypeDescription"].ToString(); objMyTributes.StartDate = DateTime.Parse(dr["StartDate"].ToString()); objMyTributes.TributeUrl = dr["TributeUrl"].ToString(); lstTributes.Add(objMyTributes); objMyTributes = null; } } return lstTributes; } catch (System.Data.SqlClient.SqlException sqlEx) { if (sqlEx.Number >= 50000) { Errors objError = new Errors(); objError.ErrorMessage = sqlEx.Message; GetTributesFeed objMyTributes = new GetTributesFeed(); objMyTributes.CustomError = objError; lstTributes.Add(objMyTributes); objMyTributes = null; } return lstTributes; } }
protected void Page_Load(object sender, EventArgs e) { //UserInfoResource objUserInfo = new UserInfoResource(); GetTributesFeed objtribute = new GetTributesFeed(); Users objUser = new Users(); if (Request.QueryString["userid"] != null) { #region Feed on UserId int.TryParse(Request.QueryString["userid"].Trim(), out userId); objtribute.UserId = userId; if (userId > 0) { objUser = _presenter.GetUserDetailsOnUserId(userId); } if ((objUser.UserType == 2) && (objUser.AtomEnabled.Equals(true))) { object[] param = { objtribute, 1, 1, 1000 }; if (objtribute.CustomError == null) { _presenter.GetTributesFeed(param); foreach (GetTributesFeed tribute in _objTributeList) { //DateTime TempModifiedDate = new DateTime(); if (tribute.ModifiedDate != null) { if (tribute.ModifiedDate > FeedUpdatedDate) FeedUpdatedDate = tribute.ModifiedDate; } } //objTributeList = objUserInfo.GetMyTributes(param); } GenerateFeed(_businessUserId ,userId, ObjTributeList); } #endregion } else { // for YourTributeFeed #region YourTributeFeed //fetching TributeName from Query string for search if (Request.QueryString["Search"] != null) { //to send null in case of no bussiness user id in url. int? BussUserId = null; if (Request.QueryString["BusinessUserId"] != null) int.TryParse(Request.QueryString["BusinessUserId"].ToString(), out _businessUserId); if (_businessUserId == 0 || _businessUserId < 0) _businessUserId = 0; else BussUserId = _businessUserId; //fetching CurrentPage from Query string for search if (Request.QueryString["Start"] != null) int.TryParse(Request.QueryString["Start"].ToString(), out _currentPage); if (_currentPage < 0) _currentPage = 0; //fetching PageSize from Query string for search if (Request.QueryString["PageSize"] != null) int.TryParse(Request.QueryString["PageSize"].ToString(), out _pageSize); if (_pageSize < 0) _pageSize = 0; //lhk: convert full text search into keyword search. _tributeName = "%" + Request.QueryString["Search"].ToString() + "%"; object[] objprm = { _tributeName, _tributeTypeId, BussUserId, _currentPage, _pageSize }; _presenter.GetYourTributeFeedOnTributeName(objprm); GenerateFeed(_businessUserId,userId, ObjTributeList); } else { //fetching BusinessUserId from Query string for search if (Request.QueryString["BusinessUserId"] != null) int.TryParse(Request.QueryString["BusinessUserId"].ToString(), out _businessUserId); if (_businessUserId == 0 || _businessUserId<0 ) _businessUserId = 0; //fetching CurrentPage from Query string for search if (Request.QueryString["Start"] != null) int.TryParse(Request.QueryString["Start"].ToString(), out _currentPage); //if (_currentPage == 0) // _currentPage = 0; if (_currentPage < 0) _currentPage = 0; //fetching PageSize from Query string for search if (Request.QueryString["PageSize"] != null) int.TryParse(Request.QueryString["PageSize"].ToString(), out _pageSize); //if (_pageSize == 0 ) // _pageSize = 0; if ( _pageSize < 0 ) _pageSize = 0; object[] objparam = { _businessUserId, _currentPage, _pageSize }; _presenter.GetYourTributesFeed(objparam); GenerateFeed(_businessUserId, userId, ObjTributeList); } #endregion } }
/// <summary> /// Method to get my tributes for Rss Feed. /// Added By: Laxman Hari Kulshrestha /// </summary> /// <param name="objUserAdmin">GetMyTributes containing UserId</param> /// <returns>List<GetMyTributes></returns> public List<GetTributesFeed> GetTributesFeed(object[] objValue) { int _packageId; GetTributesFeed objUserReg = (GetTributesFeed)objValue[0]; List<GetTributesFeed> lstTributes = new List<GetTributesFeed>(); try { object[] objParam = { objUserReg.UserId, int.Parse(objValue[1].ToString()), int.Parse(objValue[2].ToString()), int.Parse(objValue[3].ToString()) }; DataSet _objDataSet = GetDataSet("usp_GetTributesFeed", objParam); if (_objDataSet.Tables[0].Rows.Count > 0) { foreach (DataRow dr in _objDataSet.Tables[0].Rows) { GetTributesFeed objMyTributes = new GetTributesFeed(); objMyTributes.TributeId = int.Parse(dr["TributeId"].ToString()); objMyTributes.TributeName = dr["TributeName"].ToString(); objMyTributes.TributeImage = dr["TributeImage"].ToString(); if (dr["Date1"].ToString() != null) objMyTributes.DOB = dr["Date1"].ToString(); objMyTributes.DOD = dr["Date2"].ToString(); objMyTributes.MessageWithoutHtml = dr["MessageWithoutHtml"].ToString(); if (!(string.IsNullOrEmpty(dr["ModifiedDate"].ToString()))) objMyTributes.ModifiedDate = DateTime.Parse(dr["ModifiedDate"].ToString()); objMyTributes.TypeDescription = dr["TypeDescription"].ToString(); objMyTributes.StartDate = DateTime.Parse(dr["StartDate"].ToString()); if (dr["PackageId"] != null) { if (dr["Enddate"].ToString().Equals("Never")) { //LHK: 12/19/2011 Yt speedup Issue int.TryParse(dr["PackageId"].ToString(), out _packageId); switch (_packageId) { case 1: if (dr["TypeDescription"].ToString().ToLower().Equals("video")) objMyTributes.Enddate = "Video Tribute" + " (" + dr["Enddate"].ToString() + ")"; else objMyTributes.Enddate = "Memorial Tribute" + " (" + dr["Enddate"].ToString() + ")";// updated in yt phase 1 break; case 4: objMyTributes.Enddate = "Memorial Tribute" + " (" + dr["Enddate"].ToString() + ")";// updated in yt phase 1 break; case 6: objMyTributes.Enddate = "Premium Obituary" + " (" + dr["Enddate"].ToString() + ")"; //"Photo Tribute" + " (" + dr["Enddate"].ToString() + ")"; updated in phase 1 break; case 11: if (dr["TypeDescription"].ToString().ToLower().Equals("video")) objMyTributes.Enddate = "Video " + " (" + dr["Enddate"].ToString() + ")"; break; default: objMyTributes.Enddate = "Celebrate" + " (" + dr["Enddate"].ToString() + ")"; break; } } else { string[] date = dr["Enddate"].ToString().Split('/'); DateTime date2 = new DateTime(int.Parse(date[2]), int.Parse(date[0]), int.Parse(date[1])); if (date2 < DateTime.Now) { //LHK: 12/19/2011 Yt speedup Issue int.TryParse(dr["PackageId"].ToString(), out _packageId); switch (_packageId) { case 2: if (dr["TypeDescription"].ToString().ToLower().Equals("video")) objMyTributes.Enddate = "Video Tribute (Expired)"; else objMyTributes.Enddate = "Memorial Tribute (Expired)"; //Tribute (Expired)"; updated in yt phase 1 break; case 3: objMyTributes.Enddate = "Obituary (Lifetime)";// "Announce (Free)"; updated in yt phase 1 break; case 5: objMyTributes.Enddate = "Memorial Tribute (Expired)"; //Tribute (Expired)"; updated in yt phase 1 break; case 7: objMyTributes.Enddate = "Premium Obituary (Expired)"; //"Photo Tribute (Expired)"; updates in yt phase 1 break; case 8: objMyTributes.Enddate = "Obituary (Lifetime)";// "Announce (Free)"; updated in yt phase 1 break; case 9: if (dr["TypeDescription"].ToString().ToLower().Equals("video")) objMyTributes.Enddate = "Video Tribute (Expired)"; break; case 10: if (dr["TypeDescription"].ToString().ToLower().Equals("video")) objMyTributes.Enddate = "Video Tribute (Expired)"; break; case 12: if (dr["TypeDescription"].ToString().ToLower().Equals("video")) objMyTributes.Enddate = "Video (Expired)"; break; case 13: if (dr["TypeDescription"].ToString().ToLower().Equals("video")) objMyTributes.Enddate = "Video (Expired)"; break; case 14: if (dr["TypeDescription"].ToString().ToLower().Equals("video")) objMyTributes.Enddate = "Video (Expired)"; break; default: objMyTributes.ExpiredOn = date2.ToString("MMMM dd, yyyy"); break; } } else { //LHK: 12/19/2011 Yt speedup Issue int.TryParse(dr["PackageId"].ToString(), out _packageId); switch (_packageId) { case 2: if (dr["TypeDescription"].ToString().ToLower().Equals("video")) objMyTributes.Enddate = "Video Tribute" + " (" + dr["Enddate"].ToString() + ")"; else objMyTributes.Enddate = "Memorial Tribute" + " (" + dr["Enddate"].ToString() + ")"; // updated in yt phase 1 break; case 3: objMyTributes.Enddate = "Obituary (Lifetime)";// "Tribute Free Trial" + " (" + dr["Enddate"].ToString() + ")"; updated for phase 1 break; case 5: objMyTributes.Enddate = "Memorial Tribute" + " (" + dr["Enddate"].ToString() + ")";// updated in yt phase 1 break; case 7: objMyTributes.Enddate = "Premium Obituary" + " (" + dr["Enddate"].ToString() + ")"; //"Photo Tribute" + " (" + dr["Enddate"].ToString() + ")"; updated in phase 1 break; case 8: objMyTributes.Enddate = "Obituary (Lifetime)";// "Tribute Free Trial" + " (" + dr["Enddate"].ToString() + ")"; updated for phase 1 break; case 9: if (dr["TypeDescription"].ToString().ToLower().Equals("video")) objMyTributes.Enddate = "Video Tribute" + " (" + dr["Enddate"].ToString() + ")"; break; case 10: if (dr["TypeDescription"].ToString().ToLower().Equals("video")) objMyTributes.Enddate = "Video Tribute" + " (" + dr["Enddate"].ToString() + ")"; break; case 12: if (dr["TypeDescription"].ToString().ToLower().Equals("video")) objMyTributes.Enddate = "Video " + " (" + dr["Enddate"].ToString() + ")"; break; case 13: if (dr["TypeDescription"].ToString().ToLower().Equals("video")) objMyTributes.Enddate = "Video " + " (" + dr["Enddate"].ToString() + ")"; break; case 14: if (dr["TypeDescription"].ToString().ToLower().Equals("video")) objMyTributes.Enddate = "Video " + " (" + dr["Enddate"].ToString() + ")"; break; default: objMyTributes.ExpiredOn = date2.ToString("MMMM dd, yyyy"); break; } } } } objMyTributes.Visit = int.Parse(dr["Visit"].ToString()); objMyTributes.EmailAlert = bool.Parse(dr["EmailAlert"].ToString()); objMyTributes.Renewaldate = DateTime.Parse(dr["Renewaldate"].ToString()); objMyTributes.TributeUrl = dr["TributeUrl"].ToString(); lstTributes.Add(objMyTributes); objMyTributes = null; } } return lstTributes; } catch (System.Data.SqlClient.SqlException sqlEx) { if (sqlEx.Number >= 50000) { Errors objError = new Errors(); objError.ErrorMessage = sqlEx.Message; GetTributesFeed objMyTributes = new GetTributesFeed(); objMyTributes.CustomError = objError; lstTributes.Add(objMyTributes); objMyTributes = null; } return lstTributes; } }