protected void LoadGlanceCalendar()
{
HttpCookie cookie = Request.Cookies["BrowserDate"];
Data dat = new Data(DateTime.Parse(cookie.Value.ToString().Replace("%20", " ").Replace("%3A", ":")));
int sun = 0;
int mon = 0;
int tues = 0;
int wed = 0;
int thurs = 0;
int fri = 0;
int sat = 0;
DataSet ds = dat.GetData("SELECT * FROM User_Calendar UC, Event_Occurance EO WHERE UC.EventID=EO.EventID AND UC.UserID="+Session["User"].ToString());
int subtraction = 0;
switch (DateTime.Parse(cookie.Value.ToString().Replace("%20", " ").Replace("%3A", ":")).DayOfWeek)
{
case DayOfWeek.Friday:
subtraction = 5;
break;
case DayOfWeek.Monday:
subtraction = 1;
break;
case DayOfWeek.Saturday:
subtraction = 6;
break;
case DayOfWeek.Sunday:
subtraction = 0;
break;
case DayOfWeek.Thursday:
subtraction = 4;
break;
case DayOfWeek.Tuesday:
subtraction = 2;
break;
case DayOfWeek.Wednesday:
subtraction = 3;
break;
default: break;
}
if(ds.Tables.Count > 0)
if (ds.Tables[0].Rows.Count > 0)
{
for (int i = 0; i < ds.Tables[0].Rows.Count; i++)
{
DateTime date = DateTime.Parse(ds.Tables[0].Rows[i]["DateTimeStart"].ToString());
switch (date.DayOfWeek)
{
case DayOfWeek.Friday:
if (dat.IsThisWeek(date))
fri++;
GlanceDay6.DATE = date;
break;
case DayOfWeek.Monday:
if (dat.IsThisWeek(date))
mon++;
GlanceDay2.DATE = date;
break;
case DayOfWeek.Saturday:
if (dat.IsThisWeek(date))
sat++;
GlanceDay7.DATE = date;
break;
case DayOfWeek.Sunday:
if (dat.IsThisWeek(date))
sun++;
GlanceDay1.DATE = date;
break;
case DayOfWeek.Thursday:
if (dat.IsThisWeek(date))
thurs++;
GlanceDay5.DATE = date;
break;
case DayOfWeek.Tuesday:
if (dat.IsThisWeek(date))
tues++;
GlanceDay3.DATE = date;
break;
case DayOfWeek.Wednesday:
if (dat.IsThisWeek(date))
wed++;
GlanceDay4.DATE = date;
break;
default: break;
}
}
}
if (sun == 0)
GlanceDay1.DATE = DateTime.Parse(cookie.Value.ToString().Replace("%20", " ").Replace("%3A", ":")).Subtract(TimeSpan.FromDays(subtraction));
GlanceDay1.NUM_OF_EVENTS = sun;
if (mon == 0)
GlanceDay2.DATE = DateTime.Parse(cookie.Value.ToString().Replace("%20", " ").Replace("%3A", ":")).Subtract(TimeSpan.FromDays(subtraction-1));
GlanceDay2.NUM_OF_EVENTS = mon;
if (tues == 0)
GlanceDay3.DATE = DateTime.Parse(cookie.Value.ToString().Replace("%20", " ").Replace("%3A", ":")).Subtract(TimeSpan.FromDays(subtraction-2));
GlanceDay3.NUM_OF_EVENTS = tues;
if (wed == 0)
GlanceDay4.DATE = DateTime.Parse(cookie.Value.ToString().Replace("%20", " ").Replace("%3A", ":")).Subtract(TimeSpan.FromDays(subtraction-3));
GlanceDay4.NUM_OF_EVENTS = wed;
if (thurs == 0)
GlanceDay5.DATE = DateTime.Parse(cookie.Value.ToString().Replace("%20", " ").Replace("%3A", ":")).Subtract(TimeSpan.FromDays(subtraction-4));
GlanceDay5.NUM_OF_EVENTS = thurs;
if (fri == 0)
GlanceDay6.DATE = DateTime.Parse(cookie.Value.ToString().Replace("%20", " ").Replace("%3A", ":")).Subtract(TimeSpan.FromDays(subtraction-5));
GlanceDay6.NUM_OF_EVENTS = fri;
if (sat == 0)
GlanceDay7.DATE = DateTime.Parse(cookie.Value.ToString().Replace("%20", " ").Replace("%3A", ":")).Subtract(TimeSpan.FromDays(subtraction-6));
GlanceDay7.NUM_OF_EVENTS = sat;
GlanceDay1.USER_ID = Session["User"].ToString();
GlanceDay2.USER_ID = Session["User"].ToString();
GlanceDay3.USER_ID = Session["User"].ToString();
GlanceDay4.USER_ID = Session["User"].ToString();
GlanceDay5.USER_ID = Session["User"].ToString();
GlanceDay6.USER_ID = Session["User"].ToString();
GlanceDay7.USER_ID = Session["User"].ToString();
}
protected void Page_Load(object sender, EventArgs e)
{
DayOfWeek theWeekDay = DayOfWeek.Friday;
switch (theDay)
{
case days.Sun:
theWeekDay = DayOfWeek.Sunday;
break;
case days.Mon:
theWeekDay = DayOfWeek.Monday;
break;
case days.Tues:
theWeekDay = DayOfWeek.Tuesday;
break;
case days.Wed:
theWeekDay = DayOfWeek.Wednesday;
break;
case days.Thurs:
theWeekDay = DayOfWeek.Thursday;
break;
case days.Fri:
theWeekDay = DayOfWeek.Friday;
break;
case days.Sat:
theWeekDay = DayOfWeek.Saturday;
break;
}
if (!IsPostBack)
{
string imageSrc = "";
string eventStr = "";
string thisDay = theDay.ToString();
HttpCookie cookie = Request.Cookies["BrowserDate"];
DateTime datNow = DateTime.Parse(cookie.Value.ToString().Replace("%20", " ").Replace("%3A", ":"));
Data dat = new Data(datNow);
int thisDayCount = 0;
DataView dvAll = dat.GetDataDV("SELECT DISTINCT EO.DateTimeStart AS TheDate, EO.EventID AS ID, E.Header FROM Events E, User_Calendar UC, Event_Occurance EO WHERE " +
"UC.EventID=EO.EventID AND EO.EventID=E.ID AND UC.UserID=" + Session["User"].ToString());
int subtraction = 0;
switch (datNow.DayOfWeek)
{
case DayOfWeek.Friday:
subtraction = 5;
break;
case DayOfWeek.Monday:
subtraction = 1;
break;
case DayOfWeek.Saturday:
subtraction = 6;
break;
case DayOfWeek.Sunday:
subtraction = 0;
break;
case DayOfWeek.Thursday:
subtraction = 4;
break;
case DayOfWeek.Tuesday:
subtraction = 2;
break;
case DayOfWeek.Wednesday:
subtraction = 3;
break;
default: break;
}
string toolTipText = "";
if (dvAll.Count > 0)
{
for (int i = 0; i < dvAll.Count; i++)
{
DateTime date2 = DateTime.Parse(dvAll[i]["TheDate"].ToString());
if (date2.DayOfWeek == theWeekDay)
{
if (dat.IsThisWeek(date2))
{
thisDayCount++;
toolTipText += "<div class=\"TextNormal\" style=\"clear: both;\"><a class=\"NavyLink12\" href=\"" + dat.MakeNiceName(dvAll[i]["Header"].ToString()) +
"_" + dvAll[i]["ID"].ToString() + "_Event\">" + dvAll[i]["Header"].ToString() + "</a> at " +
DateTime.Parse(dvAll[i]["TheDate"].ToString()).ToShortTimeString() + "</div>";
}
}
}
}
numberOfEvents = thisDayCount;
switch (numberOfEvents)
{
case 0:
imageSrc = "NewImages/GlanceCalendarOpen.png";
eventStr = "open";
break;
default:
imageSrc = "NewImages/GlanceCalendarOpen.png";
if (numberOfEvents == 1)
eventStr = numberOfEvents + " event";
else
eventStr = numberOfEvents + " events";
break;
}
if (datNow.DayOfWeek.ToString().Substring(0, 3) == theDay.ToString() ||
datNow.DayOfWeek.ToString().Substring(0, 4) == theDay.ToString() ||
datNow.DayOfWeek.ToString().Substring(0, 5) == theDay.ToString())
{
thisDay = "Today";
imageSrc = "NewImages/GlanceCalendarOrange.png";
}
string addStr = "";
if (toolTipText != "")
addStr = " style=\"text-decoration: underline;cursor: pointer;\"";
ImageLiteral.Text = "<div class=\"TextNormal\" id=\"theDay" + theDay.ToString() +
"\" style=\"font-size: 10px;float:left;margin-right:5px;" +
"width: 53px; height: 58px; background-image:url('" +
imageSrc + "'); font-weight: bold;\"><div style=\"padding-left:2px;\"> " +
thisDay + "</div><br/><div align=\"center\" " + addStr + ">" + eventStr + "</div></div>";
ImageLiteral.ID = "lit" + theDay.ToString();
if (toolTipText != "")
{
Telerik.Web.UI.RadToolTip tip = new Telerik.Web.UI.RadToolTip();
tip.Text = "<div style=\"padding: 10px;\">" + toolTipText + "</div>";
tip.Width = 200;
tip.TargetControlID = "theDay" + theDay.ToString();
tip.IsClientID = true;
tip.HideEvent = Telerik.Web.UI.ToolTipHideEvent.ManualClose;
tip.Animation = Telerik.Web.UI.ToolTipAnimation.None;
tip.Position = Telerik.Web.UI.ToolTipPosition.TopCenter;
tip.ShowEvent = Telerik.Web.UI.ToolTipShowEvent.OnClick;
tip.Skin = "Sunset";
ToolTipPanel.Controls.Add(tip);
tip.RelativeTo = Telerik.Web.UI.ToolTipRelativeDisplay.Element;
}
}
}
protected void LoadGlanceCalendar()
{
HttpCookie cookie = Request.Cookies["BrowserDate"];
Data dat = new Data(DateTime.Parse(cookie.Value.ToString().Replace("%20", " ").Replace("%3A", ":")));
int sun = 0;
int mon = 0;
int tues = 0;
int wed = 0;
int thurs = 0;
int fri = 0;
int sat = 0;
DataView dv = dat.GetDataDV("SELECT DISTINCT EO.DateTimeStart AS TheDate, EO.EventID AS ID FROM User_Calendar UC, Event_Occurance EO WHERE " +
"UC.EventID=EO.EventID AND UC.UserID="+Session["User"].ToString());
DataView dvGroupEventMessages = dat.GetDataDV("SELECT DISTINCT GEO.DateTimeStart AS TheDate, E.ID FROM GroupEvent_Members UC, "+
"GroupEvents E, " +
" GroupEvent_Occurance GEO WHERE GEO.GroupEventID=E.ID AND UC.GroupEventID=E.ID AND UC.Accepted = " +
"'True' AND UC.UserID=" + Session["User"].ToString());
DataView dvGroupEventMessagesNonMember = dat.GetDataDV("SELECT DISTINCT GEO.DateTimeStart AS TheDate, E.ID FROM "+
"User_GroupEvent_Calendar UC, GroupEvents E, GroupEvent_Occurance GEO WHERE UC.GroupEventID=E.ID "+
" AND UC.UserID=" + Session["User"].ToString() + " AND GEO.GroupEventID=E.ID ");
DataView dvAll = MergeDVTwoCol(dv, MergeDVTwoCol(dvGroupEventMessages, dvGroupEventMessagesNonMember));
int subtraction = 0;
switch (DateTime.Parse(cookie.Value.ToString().Replace("%20", " ").Replace("%3A", ":")).DayOfWeek)
{
case DayOfWeek.Friday:
subtraction = 5;
break;
case DayOfWeek.Monday:
subtraction = 1;
break;
case DayOfWeek.Saturday:
subtraction = 6;
break;
case DayOfWeek.Sunday:
subtraction = 0;
break;
case DayOfWeek.Thursday:
subtraction = 4;
break;
case DayOfWeek.Tuesday:
subtraction = 2;
break;
case DayOfWeek.Wednesday:
subtraction = 3;
break;
default: break;
}
if (dvAll.Count > 0)
{
for (int i = 0; i < dvAll.Count; i++)
{
DateTime date = DateTime.Parse(dvAll[i]["TheDate"].ToString());
switch (date.DayOfWeek)
{
case DayOfWeek.Friday:
if (dat.IsThisWeek(date))
fri++;
GlanceDay6.DATE = date;
break;
case DayOfWeek.Monday:
if (dat.IsThisWeek(date))
mon++;
GlanceDay2.DATE = date;
break;
case DayOfWeek.Saturday:
if (dat.IsThisWeek(date))
sat++;
GlanceDay7.DATE = date;
break;
case DayOfWeek.Sunday:
if (dat.IsThisWeek(date))
sun++;
GlanceDay1.DATE = date;
break;
case DayOfWeek.Thursday:
if (dat.IsThisWeek(date))
thurs++;
GlanceDay5.DATE = date;
break;
case DayOfWeek.Tuesday:
if (dat.IsThisWeek(date))
tues++;
GlanceDay3.DATE = date;
break;
case DayOfWeek.Wednesday:
if (dat.IsThisWeek(date))
wed++;
GlanceDay4.DATE = date;
break;
default: break;
}
}
}
if (sun == 0)
GlanceDay1.DATE = DateTime.Parse(cookie.Value.ToString().Replace("%20", " ").Replace("%3A", ":")).Subtract(TimeSpan.FromDays(subtraction));
GlanceDay1.NUM_OF_EVENTS = sun;
if (mon == 0)
GlanceDay2.DATE = DateTime.Parse(cookie.Value.ToString().Replace("%20", " ").Replace("%3A", ":")).Subtract(TimeSpan.FromDays(subtraction-1));
GlanceDay2.NUM_OF_EVENTS = mon;
if (tues == 0)
GlanceDay3.DATE = DateTime.Parse(cookie.Value.ToString().Replace("%20", " ").Replace("%3A", ":")).Subtract(TimeSpan.FromDays(subtraction-2));
GlanceDay3.NUM_OF_EVENTS = tues;
if (wed == 0)
GlanceDay4.DATE = DateTime.Parse(cookie.Value.ToString().Replace("%20", " ").Replace("%3A", ":")).Subtract(TimeSpan.FromDays(subtraction-3));
GlanceDay4.NUM_OF_EVENTS = wed;
if (thurs == 0)
GlanceDay5.DATE = DateTime.Parse(cookie.Value.ToString().Replace("%20", " ").Replace("%3A", ":")).Subtract(TimeSpan.FromDays(subtraction-4));
GlanceDay5.NUM_OF_EVENTS = thurs;
if (fri == 0)
GlanceDay6.DATE = DateTime.Parse(cookie.Value.ToString().Replace("%20", " ").Replace("%3A", ":")).Subtract(TimeSpan.FromDays(subtraction-5));
GlanceDay6.NUM_OF_EVENTS = fri;
if (sat == 0)
GlanceDay7.DATE = DateTime.Parse(cookie.Value.ToString().Replace("%20", " ").Replace("%3A", ":")).Subtract(TimeSpan.FromDays(subtraction-6));
GlanceDay7.NUM_OF_EVENTS = sat;
GlanceDay1.USER_ID = Session["User"].ToString();
GlanceDay2.USER_ID = Session["User"].ToString();
GlanceDay3.USER_ID = Session["User"].ToString();
GlanceDay4.USER_ID = Session["User"].ToString();
GlanceDay5.USER_ID = Session["User"].ToString();
GlanceDay6.USER_ID = Session["User"].ToString();
GlanceDay7.USER_ID = Session["User"].ToString();
}
