Devam Ediyor

519073 More Work On Maags Project

JOB 1. Correct Stored Procedure PlayerStatusForIDCoach on [url removed, login to view] project and send corrected stored procedure via email for upload to live database

1. Sign in as a superuser and create and individual client. Then assign an IDCoach to that player

2. Then sign in as that IDCoach

3. At the momment he will be able to see the new individual client on this page /IDCoach-ClubManager/[url removed, login to view]

4. But there is no sign of the new client on this page. /IDCoach-ClubManager/[url removed, login to view]

The task is to make all individual clients that are assigned to an iD coach show up on that ID Coaches status page

JOB 2 - Code 3 new Stored Procedures for [url removed, login to view] and send stored procedures via email for upload to live database

You need to add 3 more columns to your copy of [url removed, login to view]

1. ProcessReminderSent default=0

2. ProcessesSent default=0

3. PostMatchReminderSent default=0

Stored Procedure 1 - SendProcessReminder

Looks at each record in [url removed, login to view]

If in [url removed, login to view] its less than 24 hours until the date of the match AND isActive = 1 AND IsExpectedProcessCue = 1 AND ProcessReminder < 1 AND ((ProcessOne is NULL OR ="") OR (ProcessTwo is NULL OR ="") OR (ProcessThree is NULL OR =""))

THEN Return FirstName, Surname, ContactNumber, Email, Message (all from [url removed, login to view]) Date/time of Match, Opponent, Venue (from MasterMatch)

Stored Procedure 2 - SendProcesses

Looks at each record in [url removed, login to view]

If in [url removed, login to view] its less than 12 hours until the date of the match AND isActive = 1 AND IsExpectedProcessCue = 1 AND ProcessesSent < 1 AND ((ProcessOne has an entry) OR (ProcessTwo has an entry) OR (ProcessThree has an entry))

THEN Return FirstName, Surname, ContactNumber, Email, Message (all from [url removed, login to view]) Date/time of Match, Opponent, Venue (from MasterMatch), ProcessOne, ProcessTwo, ProcessThree

Stored Procedure 3 - SendPostMatchReminder

Looks at each record in [url removed, login to view]

If in [url removed, login to view] its more than 72 hours after the date of the match AND isActive = 1 AND IsExpectedPostMatch = 1 AND PostMatchReminderSent < 1 AND ((PrOne is NULL OR ="") OR (Good1 is NULL OR ="") OR Better1 is NULL OR =""))

THEN Return FirstName, Surname, ContactNumber, Email, Message (all from [url removed, login to view]) Date/time of Match, Opponent, Venue (from MasterMatch)

Beceriler: .NET, Her şey Kabul, ASP

Daha fazlasını görün: sign aspx, project co id, default email client, add up work hours, uk project, stored procedures, new venue, create venue, aspx send email, coaches, create database stored procedures, asp net client email, asp net time entry, date entry work, coach email, via status net, coaches database, live project net, time entry asp net, stored project, prone, status via net, aspx project, email copy work, date entry project

İşveren Hakkında:
( 9 değerlendirme ) London, United Kingdom

Proje NO: #2265007