Em Andamento

C#, [url removed, login to view] functions to display scheduler data

I need four C# ([url removed, login to view]) functions (see Deliverables):

1. private DataTable FormatDailySchedules(SqlDataReader ScheduleDataReader)

2. private DataTable FormatWeeklySchedules(SqlDataReader ScheduleDataReader)

3. private DataTable FormatMonthlySchedules(SqlDataReader ScheduleDataReader)

4. protected DataView(DataTime StartDate, DateTime EndDate, SqlDataReader ScheduleDataReader)

The [url removed, login to view] input form for the SQL data you'll be working with is VERY similiar to the WinXP/2000 Scheduler, to you can get a hint of the what the data means.

I need this stored Scheduler data translated so that it means something to the end user viewing all of his schedules. I will use the function you create to eventually bind to a DataGrid, and to a Calendar.

## Deliverables

Complete ownership and distribution copyrights to all work purchased.

I need four C# ([url removed, login to view]) functions:

1. private DataTable FormatDailySchedules(SqlDataReader ScheduleDataReader)

2. private DataTable FormatWeeklySchedules(SqlDataReader ScheduleDataReader)

3. private DataTable FormatMonthlySchedules(SqlDataReader ScheduleDataReader)

The outputted DataTables will contain the following transformed data:

ScheduleId

OrganizationalUnitID

ScheduleName

Description - for each ScheduleId, the outputted DataTable fields should be transformed into a readable format describing each Schedule such as "At 4:51 AM every Tue, starting 3/1/2003" or "At 9:30 PM on Day 7 of February and March, starting 9/2/2003". This is very similar to the schedule description in WinXP/2000 scheduler, (the [url removed, login to view] form input is much the same as this as well), so take your cues from there.

4. protected DataView(DataTime StartDate, DateTime EndDate, SqlDataReader ScheduleDataReader)

This DataView will bind to a Calendar. The DataView returned should contain the following fields:

ScheduleID

ScheduleName

StartDate

EndDate

As ScheduleDataReader is only a description of when the scheduled task can run, you must calculate all the start dates/times and end dates/times for each scheduleid within the Start/End times passed.

INPUT DATA DESCRIPTION(SqlDataReader ScheduleDataReader)

(I've included field descriptions and possible values):

[ScheduleID] [int] IDENTITY - (Identification field for the schedule),

[OccurancePatternID] [tinyint] - (values: 1=daily, 2=weekly, 3=monthly),

[StartTimeofDay] [datetime] - (values in format of: 1/1/1900 9:00:00 AM),

[EndTimeofDay] [datetime] - (values in format of: 1/1/1900 9:00:00 AM),

[Sunday] [bit] - (indicates whether the scheduled job runs on this day. values: 0 = unselected, 1 = selected. same for all the following bit fields),

[Monday] [bit] ,

[Tuesday] [bit] ,

[Wednesday] [bit] ,

[Thursday] [bit] ,

[Friday] [bit] ,

[Saturday] [bit] ,

[MonthlyOrdinal] [tinyint] (scheduled job runs on the x (M,Tu,W,Th,F,Sa, or Su) of the month. values: x = 1,2,3,4, or 5 (5 means the last (M,Tu,W,Th,F,Sa, or Su) of the month.)),

[MonthlyStartDate] [tinyint] (scheduled job runs on the x day of the month. values: x = 1 through 31),

[MonthlyEndDate] [tinyint] (not currently used, but column is still passed) ,

[ScheduleActive] [bit] (indicates whether the schedule is active (1) or not (0)) ,

[DateScheduleDisabled] [datetime] ,

[January] [bit] - (indicates whether the scheduled job runs on this month. values: 0 = unselected, 1 = selected. same for all the following bit fields), ,

[February] [bit] ,

[March] [bit] ,

[April] [bit] ,

[May] [bit] ,

[June] [bit] ,

[July] [bit] ,

[August] [bit] ,

[September] [bit] ,

[October] [bit] ,

[November] [bit] ,

[December] [bit] ,

[RecureDaily] [tinyint] - (indicates that the scheduled job repeats every x days),

[RecureWeekly] [tinyint] - (indicates that the scheduled job repeats every x weeks),

[FirstStartDate] [datetime] - (the first day the scheduled job is to start) ,

[ScheduleName] [varchar(100)] - ( the name of the schedule)

[OrganizationalUnitId] [int] - (the tree node the schedule is attached to)

## Platform

Windows 2000 Server.

.NET Runtime v. 1.1

[url removed, login to view]

C#

Habilidades: .NET, ASP, Programação C#, Engenharia, MySQL, PHP, Arquitetura de software, Teste de Software

Ver mais: month december, tree starting, tree node, scheduler job description, node job, node tree, net scheduler, june month, job asp net, january month, int v, get asp net, month january, c scheduler, bit tree, asp net job, sql data, it su, datagrid, use create task scheduler, create task scheduler, net private, net display, sql stored function, active net work

Acerca do Empregador:
( 172 comentários ) United States

ID do Projeto: #2964367

Premiar a:

s1301950

See private message.

$25.5 USD em 2 dias
(35 Avaliações)
5.3

3 freelancers estão ofertando em média $31 para este trabalho

ekam

See private message.

$34 USD in 2 dias
(111 Comentários)
5.7
magikcm

See private message.

$34 USD in 2 dias
(4 Comentários)
0.0