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