public override void Fill(System.Data.IDataReader dr)
{
base.FillInternal(dr);
_KeyID = Null.SetNullInteger(dr["KeyID"]);
_PortalID = Null.SetNullInteger(dr["PortalID"]);
if (!(Convert.IsDBNull(dr["Months"])))
{
_Months = new MonthArray(Convert.ToInt16(dr["Months"]));
}
else
{
_Months = MonthArray.Null;
}
if (!(Convert.IsDBNull(dr["Days"])))
{
_Days = new DayArray(Convert.ToInt32(dr["Days"]));
}
else
{
_Days = DayArray.Null;
}
if (!(Convert.IsDBNull(dr["DaysofWeek"])))
{
_DaysofWeek = new DayofWeekArray(Convert.ToByte(dr["DaysofWeek"]));
}
else
{
_DaysofWeek = DayofWeekArray.Null;
}
string currentYear = DateTime.Now.Year.ToString();
if (!(Convert.IsDBNull(dr["StartDate"])))
{
_StartDate = new DateInteger(Convert.ToInt32(dr["StartDate"]));
}
if (!(Convert.IsDBNull(dr["EndDate"])))
{
_EndDate = new DateInteger(Convert.ToInt32(dr["EndDate"]));
}
if (!(Convert.IsDBNull(dr["StartTime"])))
{
_StartTime = Convert.ToInt32(dr["StartTime"]);
}
if (!(Convert.IsDBNull(dr["EndTime"])))
{
_EndTime = Convert.ToInt32(dr["EndTime"]);
}
_CategoryID = Null.SetNullInteger(dr["CategoryID"]);
_Category = Null.SetNullString(dr["Category"]);
_GroupID = Null.SetNullInteger(dr["GroupID"]);
_GroupName = Null.SetNullString(dr["GroupName"]);
_ProfilePropertyValue = Null.SetNullString(dr["ProfilePropertyValue"]);
_Disabled = Null.SetNullBoolean(dr["Disabled"]);
_Title = Null.SetNullString(dr["Title"]);
_DesktopHTML = Null.SetNullString(dr["DesktopHTML"]);
_DesktopSummary = Null.SetNullString(dr["DesktopSummary"]);
}
private object GetNullDateInteger(DateInteger value)
{
if (value.IsNull)
{
return(DBNull.Value);
}
else
{
return(value.Value);
}
}
public string GetDateSpanString(DateInteger StartDate, DateInteger EndDate)
{
if (StartDate.IsNull || EndDate.IsNull)
{
return(string.Empty);
}
else
{
string startDateString = StartDate.ToString("MMM dd");
string endDateString = EndDate.ToString("MMM dd");
return(startDateString + "-" + endDateString);
}
}
public override void UpdateContent(int KeyID, int ModuleID, int PortalID, int ContentItemID, MonthArray Months, DayArray Days, DayofWeekArray DaysofWeek, DateInteger StartDate, DateInteger EndDate, int StartTime, int EndTime, int CategoryID, int GroupID, string ProfilePropertyValue, bool Disabled, string Title, string DesktopHtml, string DesktopSummary, int UserID)
{
SqlHelper.ExecuteNonQuery(ConnectionString, GetFullyQualifiedName("UpdateContent"), KeyID, ModuleID, PortalID, GetNull(ContentItemID), GetNullMonthArray(Months), GetNullDayArray(Days), GetNullDayofWeekArray(DaysofWeek), GetNullDateInteger(StartDate), GetNullDateInteger(EndDate), GetNullTime(StartTime), GetNullTime(EndTime), GetNull(CategoryID), GetNull(GroupID), GetNull(ProfilePropertyValue), Disabled, GetNull(Title), DesktopHtml, GetNull(DesktopSummary), UserID);
}
public override int AddContent(int ModuleID, int PortalID, MonthArray Months, DayArray Days, DayofWeekArray DaysofWeek, DateInteger StartDate, DateInteger EndDate, int StartTime, int EndTime, int CategoryID, int GroupID, string ProfilePropertyValue, bool Disabled, string Title, string DesktopHtml, string DesktopSummary, int UserID)
{
return(Convert.ToInt32(SqlHelper.ExecuteScalar(ConnectionString, GetFullyQualifiedName("AddContent"), ModuleID, PortalID, GetNullMonthArray(Months), GetNullDayArray(Days), GetNullDayofWeekArray(DaysofWeek), GetNullDateInteger(StartDate), GetNullDateInteger(EndDate), GetNullTime(StartTime), GetNullTime(EndTime), GetNull(CategoryID), GetNull(GroupID), GetNull(ProfilePropertyValue), Disabled, GetNull(Title), DesktopHtml, GetNull(DesktopSummary), UserID)));
}
public override IDataReader FindContents(int ModuleID, MonthArray Months, DayArray Days, DayofWeekArray DaysofWeek, DateInteger StartDate, DateInteger EndDate, int StartTime, int EndTime, int CategoryID, int GroupID, string ProfilePropertyValue, bool IncludeDisabled)
{
return(SqlHelper.ExecuteReader(ConnectionString, GetFullyQualifiedName("FindContents"), ModuleID, GetNullMonthArray(Months, true), GetNullDayArray(Days, true), GetNullDayofWeekArray(DaysofWeek, true), GetNullDateInteger(StartDate), GetNullDateInteger(EndDate), GetNullTime(StartTime), GetNullTime(EndTime), GetNull(CategoryID), GetNull(GroupID), GetNull(ProfilePropertyValue), IncludeDisabled));
}
public bool IsWithinDates(DateTime currentDate)
{
DateInteger today = new DateInteger(currentDate, false);
return(today.IsBetween(StartDate, EndDate));
}
private void Page_Load(object sender, System.EventArgs e)
{
int i = -1;
string content = string.Empty;
string title = string.Empty;
DateTime todayAdjusted = Utilities.GetCurrentPortalTime();
if (MyConfiguration.EnableUserTimeConversion)
{
todayAdjusted = Utilities.ConvertPortalToUserTime(todayAdjusted);
}
try
{
ContentDejourController cdc = new ContentDejourController();
if (!(string.IsNullOrEmpty(Request.QueryString["KeyID"])))
{
int keyID = 0;
if (int.TryParse(Request.QueryString["KeyID"], out keyID))
{
CurrentItem = cdc.GetContent(keyID, ModuleId);
}
}
if (CurrentItem.KeyID == -1)
{
switch (MyConfiguration.SelectBy)
{
case Enums.SelectBy.Month:
Months = (new MonthArray()).AddMonth(todayAdjusted.Month);
break;
case Enums.SelectBy.DayofMonth:
Days = (new DayArray()).AddDay(todayAdjusted.Day);
break;
case Enums.SelectBy.DayofYear:
Days = new DayArray(todayAdjusted.DayOfYear | DayArray.ModeFlag);
break;
case Enums.SelectBy.MonthAndDayofMonth:
Months = (new MonthArray()).AddMonth(todayAdjusted.Month);
Days = (new DayArray()).AddDay(todayAdjusted.Day);
break;
case Enums.SelectBy.DayofWeek:
DaysofWeek = (new DayofWeekArray()).AddDay(Convert.ToInt32(todayAdjusted.DayOfWeek));
break;
case Enums.SelectBy.MonthAndDayofWeek:
Months = (new MonthArray()).AddMonth(todayAdjusted.Month);
DaysofWeek = (new DayofWeekArray()).AddDay(Convert.ToInt32(todayAdjusted.DayOfWeek));
break;
case Enums.SelectBy.TimeSpan:
Time = Convert.ToInt32(todayAdjusted.TimeOfDay.TotalMinutes);
break;
case Enums.SelectBy.DateSpan:
Today = new DateInteger(todayAdjusted.Date, false);
break;
case Enums.SelectBy.DateAndTimeSpan:
Today = new DateInteger(todayAdjusted.Date, false);
Time = Convert.ToInt32(todayAdjusted.TimeOfDay.TotalMinutes);
break;
case Enums.SelectBy.Random:
//Do nothing as they will be handled below
break;
}
if (!(string.IsNullOrEmpty(MyConfiguration.ProfilePropertyName)))
{
string tmp = null;
if (UserId == -1)
{
tmp = "<Unauthenticated>";
}
else
{
ProfilePropertyDefinition ppd = UserInfo.Profile.GetProperty(MyConfiguration.ProfilePropertyName);
if (ppd == null)
{
tmp = string.Empty;
}
else
{
tmp = ppd.PropertyValue;
if (tmp == null)
{
if (string.IsNullOrEmpty(ppd.DefaultValue))
{
tmp = "<Default>";
}
else
{
tmp = ppd.DefaultValue;
}
}
}
}
ProfilePropertyValue = tmp;
}
if (!(string.IsNullOrEmpty(Request.QueryString["GroupId"])))
{
int.TryParse(Request.QueryString["GroupId"], out _GroupID);
}
if (MyConfiguration.MultipleHandling == Enums.MultipleHandling.TimeSpan)
{
Time = Convert.ToInt32(todayAdjusted.TimeOfDay.TotalMinutes);
}
// get ContentDejourInfo object(s)
ContentsDejour = cdc.GetContents(ModuleId, Months, Days, DaysofWeek, Today, Time, MyConfiguration.CategoryID, GroupID, ProfilePropertyValue, MyConfiguration.IncludeDisabled);
if (ContentsDejour.Count > 1)
{
int minViews = int.MaxValue;
int leastViewed = 0;
switch (MyConfiguration.MultipleHandling)
{
case Enums.MultipleHandling.Random:
i = (new Random()).Next(0, ContentsDejour.Count);
break;
case Enums.MultipleHandling.First:
i = 0;
break;
case Enums.MultipleHandling.Sequential:
case Enums.MultipleHandling.LeastViewed:
System.Web.HttpCookie cookie = Request.Cookies["ContentDejour" + TabModuleId.ToString()];
int[] views = new int[ContentsDejour.Count + 1];
if (cookie != null)
{
i = int.Parse(cookie.Values["LastViewed"]);
for (int j = 0; j < ContentsDejour.Count; j++)
{
string v = cookie.Values[j.ToString()];
if (string.IsNullOrEmpty(v))
{
views[j] = 0;
}
else
{
views[j] = int.Parse(v);
}
if (views[j] < minViews)
{
leastViewed = j;
minViews = views[j];
}
}
}
if (MyConfiguration.MultipleHandling == Enums.MultipleHandling.Sequential)
{
i = (i + 1) % ContentsDejour.Count;
}
else
{
i = leastViewed;
}
views[i]++;
cookie = new HttpCookie("ContentDejour" + TabModuleId.ToString());
cookie.Values["LastViewed"] = i.ToString();
for (int j = 0; j < views.Length; j++)
{
cookie.Values[j.ToString()] = views[j].ToString();
}
cookie.Expires = todayAdjusted.Date.AddMinutes(Convert.ToDouble(ContentsDejour[i].EndTime));
Response.Cookies.Add(cookie);
break;
case Enums.MultipleHandling.Last:
i = ContentsDejour.Count - 1;
break;
case Enums.MultipleHandling.TimeSpan:
ContentsDejour.Sort(new ContentDejourInfoComparer("TimeDuration ASC"));
i = 0;
break;
}
}
else if ((ContentsDejour.Count == 1) && ContentsDejour[0].IsWithinTimeSpan(todayAdjusted.TimeOfDay))
{
i = 0;
}
}
else
{
ContentsDejour.Add(CurrentItem);
if (ContentsDejour.Count == 1)
{
i = 0;
}
}
if (i == -1)
{
if (MyConfiguration.HideWhenNoContent && !IsEditable)
{
ContainerControl.Visible = false;
}
else
{
lnkEdit.Visible = false;
divContent.InnerHtml = LocalizeSharedResource("NO_CONTENT");
}
}
else
{
KeyID = ContentsDejour[i].KeyID;
title = Server.HtmlDecode(ContentsDejour[i].Title);
content = HttpUtility.HtmlDecode(ContentsDejour[i].DesktopHTML);
TokenReplace tr = null;
if (MyConfiguration.ReplaceTokens)
{
tr = new TokenReplace(ContentsDejour[i]);
tr.ModuleId = ModuleId;
tr.AccessingUser = UserInfo;
tr.DebugMessages = !(PortalSettings.UserMode == PortalSettings.Mode.View);
content = tr.ReplaceEnvironmentTokens(content);
title = tr.ReplaceEnvironmentTokens(title);
}
// set edit link
if (IsEditable)
{
lnkEdit.NavigateUrl = EditUrl("KeyID", KeyID.ToString());
lnkEdit.Visible = true;
}
else
{
lnkEdit.Visible = false;
}
// add content to module
divContent.InnerHtml = Globals.ManageUploadDirectory(content, PortalSettings.HomeDirectory);
// replace module title if so specified in settings
if (MyConfiguration.ReplaceTitle && !(string.IsNullOrEmpty(title)))
{
ModuleConfiguration.ModuleTitle = title;
}
}
}
catch (Exception exc)
{
Exceptions.ProcessModuleLoadException(this, exc);
}
}
public System.Collections.Generic.List <ContentDejourInfo> FindContents(int ModuleId, MonthArray Months, DayArray Days, DayofWeekArray DaysofWeek, DateInteger StartDate, DateInteger EndDate, int StartTime, int EndTime, int CategoryID, int GroupID, string ProfilePropertyValue, bool IncludeDisabled)
{
return(CBO.FillCollection <ContentDejourInfo>(DataProvider.Instance().FindContents(ModuleId, Months, Days, DaysofWeek, StartDate, EndDate, StartTime, EndTime, CategoryID, GroupID, ProfilePropertyValue, IncludeDisabled)));
}
public List <ContentDejourInfo> GetContents(int ModuleId, MonthArray Months, DayArray Days, DayofWeekArray DaysofWeek, DateInteger Today, int Time, int CategoryID, int GroupID, string ProfilePropertyValue, bool IncludeDisabled)
{
return(CBO.FillCollection <ContentDejourInfo>(DataProvider.Instance().GetContents(ModuleId, Months, Days, DaysofWeek, Today, Time, CategoryID, GroupID, ProfilePropertyValue, IncludeDisabled)));
}
public abstract void UpdateContent(int KeyID, int ModuleID, int PortalID, int ContentItemID, MonthArray Months, DayArray Days, DayofWeekArray DaysofWeek, DateInteger StartDate, DateInteger EndDate, int StartTime, int EndTime, int CategoryID, int GroupID, string ProfilePropertyValue, bool Disabled, string Title, string DesktopHtml, string DesktopSummary, int UserID);
public abstract IDataReader FindContents(int ModuleId, MonthArray Months, DayArray Days, DayofWeekArray DaysofWeek, DateInteger StartDate, DateInteger EndDate, int StartTime, int EndTime, int CategoryID, int GroupID, string ProfilePropertyValue, bool IncludeDisabled);
public abstract IDataReader GetContents(int ModuleId, MonthArray Months, DayArray Days, DayofWeekArray DaysofWeek, DateInteger Today, int Time, int CategoryID, int GroupID, string ProfilePropertyValue, bool IncludeDisabled);
