<% ''''''''''''''''''''''''''''''''''''''''''''''''''''''''''''''''''''''''''''''''' ' EZScheduler is copyright 2007 by Steve Frazier ' http://www.aspjunction.com ' http://www.htmljunction.com ' ' This program is free software; you can redistribute it and/or ' modify it under the terms of the GNU General Public License ' as published by the Free Software Foundation; either version 2 ' of the License, or (at your option) any later version. ' ' This program is distributed in the hope that it will be useful, ' but WITHOUT ANY WARRANTY; without even the implied warranty of ' MERCHANTABILITY or FITNESS FOR A PARTICULAR PURPOSE. See the ' GNU General Public License for more details. ' ' You should have received a copy of the GNU General Public License ' along with this program; if not, write to the Free Software ' Foundation, Inc., 51 Franklin Street, Fifth Floor, Boston, MA 02110-1301, USA. ' ' Instructions and installaion can be found in the readme.txt or readme.htm files. '''''''''''''''''''''''''''''''''''''''''''''''''''''''''''''''''''''''''''''''''' If Trim(Request.QueryString("delete")) = "yes" Then Set rsDelete = Server.CreateObject("ADODB.Recordset") rsDelete.Open "tbl_calendar", objConn, 3, 3, &H0002 rsDelete.Filter = "SchedID = " & Request.QueryString("schedID") If not rsDelete.EOF Then rsDelete.Delete Else Response.Write "No Event to Delete" End If rsDelete.Close Set rsDelete = Nothing End If If Trim(Request.QueryString("schedule")) = "now" Then strSchedDate = CDate(Request.Form("mcount") & "/" & Request.Form("dcount") & "/" & Request.Form("ycount")) strSQL = "INSERT INTO tbl_calendar ([schDate],[event],[text]) VALUES ('"&strSchedDate&"',"&_ "'"&rplStringIn(Request.Form("event"))&"','"&rplStringIn(Request.Form("comments"))&"')" objConn.Execute strSQL End If %> iInvest ::calendar::
 
 

 
 
<% If IsDate(Trim(Request.QueryString("sDate"))) Then datSDate = CDate(Trim(Request.QueryString("sDate"))) ElseIf IsDate(Trim(Request.QueryString("date"))) Then datSDate = CDate(Trim(Request.QueryString("date"))) Else datSDate = date End If If IsDate(Trim(Request.QueryString("date"))) Then dDate = CDate(Trim(Request.QueryString("date"))) Else dDate = Date End If 'Now we've got the date. Now get Days in the choosen month and the day of the week it starts on. iDIM = GetDaysInMonth(Month(dDate), Year(dDate)) iDOW = GetWeekdayMonthStartsOn(dDate) %>
<% ' Write spacer cells at beginning of first row if month doesn't start on a Sunday. If iDOW <> 1 Then Response.Write vbTab & "" & vbCrLf iPosition = 1 Do While iPosition < iDOW Response.Write vbTab & vbTab & "" & vbCrLf iPosition = iPosition + 1 Loop End If ' Write days of month in proper day slots iCurrent = 1 iPosition = iDOW Set rsCal = Server.CreateObject("ADODB.Recordset") strSQL = "SELECT * FROM tbl_calendar WHERE schDate = #"&datSDate&"# ORDER BY schDate ASC;" rsCal.Open strSQL, objConn, 3, 3, &H0001 Do While iCurrent <= iDIM ' If we're at the begginning of a row then write TR If iPosition = 1 Then Response.Write vbTab & "" & vbCrLf End If If Not rsCal.EOF Or rsCal.BOF Then Else rsCal.MoveFirst End If sDate = CDate(Month(dDate) & "/" & iCurrent & "/" & Year(dDate)) blnDBDate = schedCheck(sDate) If blnDBDate Then 'highlight users scheduled dates Response.Write vbTab & vbTab & "" & vbCrLf ElseIf Cdate(DateSerial(year(dDate),month(dDate),iCurrent)) = date Then 'highlight todays date Response.Write vbTab & vbTab & "" & vbCrLf Else 'Rest of the days in the month Response.Write " " & vbCrLf End If ' If we're at the endof a row then write /TR If iPosition = 7 Then Response.Write vbTab & "" & vbCrLf iPosition = 0 End If ' Increment variables iCurrent = iCurrent + 1 iPosition = iPosition + 1 Loop ' Write spacer cells at end of last row if month doesn't end on a Saturday. If iPosition <> 1 Then Do While iPosition <= 7 Response.Write vbTab & vbTab & "" & vbCrLf iPosition = iPosition + 1 Loop Response.Write vbTab & "" & vbCrLf End If %>
  <%= MonthName(Month(dDate)) & " " & Year(dDate) %>  
الأحد الإثنين الثلاثاء الأربعاء الخميس الجمعة السبت
 
" & vbcrlf Response.Write "" Response.Write "" & iCurrent & "" & iCurrent & "" & vbcrlf Response.Write " " & iCurrent & "
 
<% If strLetUsers Then %> <% End If %> <% Response.Write "" & strMSG & "

" & vbcrlf If rsCal.RecordCount > 0 AND rsCal.EOF Then rsCal.MoveFirst blnMCheck = schedMCheck(sDate) If blnMCheck Then Response.Write "
" & vbcrlf Response.Write " " & vbcrlf Response.Write " " & vbcrlf Response.Write " " & vbcrlf Response.Write " " & vbcrlf Response.Write " " & vbcrlf Response.Write " " & vbcrlf Response.Write " " & vbcrlf Response.Write "
" & vbcrlf Response.Write " الاحداث المسجلة لشهر "&MonthName(Month(dDate))&" "&Year(dDate)&"" & vbcrlf Response.Write "
" & vbcrlf Response.Write " " & vbcrlf Response.Write "
    " & vbcrlf Set rsMCal = Server.CreateObject("ADODB.Recordset") rsMCal.Open "tbl_calendar", objConn, 3, 3, &H0002 If Not rsMCal.EOF Then Do While Not rsMCal.EOF If Month(rsMCal("schDate")) = Month(sDate) Then Response.Write "
  1. " & vbcrlf Response.Write " " & vbcrlf Response.Write rsMCal("schDate") & ": " & rplStringOut(rsMCal("event")) & vbcrlf Response.Write " " & vbcrlf Response.Write "
  2. " & vbcrlf Response.Write "
    " & vbcrlf End If rsMCal.MoveNext Loop End If rsMCal.Close: Set rsMCal = Nothing Response.Write "
" & vbcrlf Response.Write "
" & vbcrlf Response.Write "
" & vbcrlf Response.Write "
" & vbcrlf End If If Trim(Request.QueryString("sched")) = "yes" Then %>
Event Name:
Date: <% selectDate() %>
Comments (You May Enter Up To 100 Characters) Characters Left
<% End If If Request.QueryString("view") = "yes" Then If rsCal.Recordcount = 0 Then Else rsCal.MoveFirst Do While NOT rsCal.EOF If NOT rsCal.EOF AND CDate(Trim(Request.QueryString("sdate"))) = CDate(Trim(rsCal("schDate"))) Then Response.Write "
الأحداث المسجلة بتاريخ "&Request.QueryString("sdate") & "
" Do While NOT rsCal.EOF If CDate(rsCal("schDate")) = CDate(Request.QueryString("sdate")) Then %>
التاريخ : <%= rsCal("schDate") %>
اسم الحدث : <%= rplStringOut(rsCal("event")) %>
التفاصيل : <%= rplStringOut(rsCal("text")) %>
<% If strLetUsers Then %> <% End If %>

<% End If rsCal.MoveNext Loop End If If rsCal.EOF Then exit do Else rsCal.MoveNext End If Loop End If End If rsCal.Close: Set rsCal = Nothing closeConn %>
 
 
 
Powered by Orange Studio