/// <summary> /// Function for Getting Latest Video. /// </summary> /// <param name="objWebstatics"></param> public List<TributeLatest> GetLatestVideos(object[] objTributeLatest) { TributeLatest objTribute = (TributeLatest)objTributeLatest[0]; List<TributeLatest> objtribInfo = new List<TributeLatest>(); try { if (!Equals(objTribute, null)) { object[] objParam = { objTribute.TributeId, objTribute.CreationDate, objTribute.SecondDate }; DataSet dsTribute = GetDataSet("usp_GetLatestVideo", objParam); if (dsTribute.Tables[0].Rows.Count > 0) { foreach (DataRow dr in dsTribute.Tables[0].Rows) { TributeLatest objTribute_ = new TributeLatest(); objTribute_.UserId = int.Parse(dr["Userid"].ToString()); objTribute_.FirstName = dr["FirstName"].ToString(); objTribute_.VideoCaption = dr["VideoCaption"].ToString(); objTribute_.VideoTypeId = dr["VideoTypeId"].ToString(); objTribute_.VideoUrl = dr["VideoUrl"].ToString(); objTribute_.VideoDesc = dr["Message"].ToString(); objTribute_.Type_ = dr["Type"].ToString(); objTribute_.ID = int.Parse(dr["ID"].ToString()); objTribute_.VideoTributeUrl = dr["TributeVideoId"].ToString(); //Added by Gaurav Puri on 16-May-2008 objTribute_.Mode = dr["MODE"].ToString(); objtribInfo.Add(objTribute_); objTribute_ = null; } } } return objtribInfo; } catch (Exception ex) { Errors obj = new Errors(); obj.ErrorMessage = ex.ToString(); objTribute.CustomError = obj; return objtribInfo; } }
/// <summary> /// LHK: get all latest date to traverse get latest activities /// </summary> /// <param name="tributeId"></param> /// <returns></returns> public List<DateTime> GetAllLatestDates(int tributeId) { List<DateTime> objListDatetime = new List<DateTime>(); TributeLatest objTribute = new TributeLatest(); if (tributeId > 0) { objTribute.TributeId = tributeId; DateTime objDateToday = new DateTime(); objDateToday = DateTime.Now; objTribute.CreationDate = objDateToday; object[] objParam = { objTribute.TributeId, objTribute.CreationDate}; DataSet dsTribute = GetDataSet("usp_GetAllLatestDates", objParam); if (dsTribute.Tables[0].Rows.Count > 0) { foreach (DataRow dr in dsTribute.Tables[0].Rows) { DateTime objDate = new DateTime(); DateTime.TryParse(dr["CreatedDate"].ToString(), out objDate); objListDatetime.Add(objDate); } } } return objListDatetime; }