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(); }