C# MVC 6 Project - SQL, OAuth2, and IdentityUser Experience Required

Freelancer Project Scope of Work

I will provide a SQL Server 2014 Database and a Visual Studio 2015 project using DNX 4.5.1. The project is built on the SmartAdmin template ([url removed, login to view]). Please provide an estimate for time to complete. I will be continuing to develop another section of the website. What do you recommend for allowing us to collaborate/source control service?

Account Related Work

Much of this code is already written. It just needs to be updated as follows.

1. (Code partially written) Change [url removed, login to view] SendEmailAsync to send email using OAuth2 for Gmail instead of current username and password. I will provide OAuth2 credentials. Please see: [url removed, login to view] and [url removed, login to view]

2. Account Related Tasks

a. Can EF Migrations be done in MVC 6 yet? If so, change Model: ApplicationUser : IdentityUser to include the firstName, lastName, title, department, and id_org to add the fields to AspNetUsers table in database. If not, collect this info for user table.

b. (Code partially written) Fix Recaptcha on register page and forgot password pages. Most code is written

i. <div class="g-recaptcha" data-sitekey="XXXXXXXXXXXXXX"></div>

ii. In [url removed, login to view], see Register function—should check “g-recaptcha-response” response field from post and then check with RecaptchaWork function before allowing register or reset password.

c. (Code written) After registering, user must confirm email before logging in. Email is username to login.

d. (Code partially written) When logging in, make sure email is confirmed. If not, redirect to Error page saying password has not been confirmed. Add button to resend email confirmation.

e. (Code partially written) Forgot Password—add captcha, test email, when they click link, allow them to change password by typing in new password and confirm password. Redirect to login page

f. Upon every login, check AspNetUsers for null “title”. If null, redirect to Account Page.

g. If title is not null, check id_org. If null, redirect to Organization Page

h. Add first name, last name, and id_org to session string

New MVC Pages

3. Account Page

• Should use Smart Form Layouts (see Forms -> Smart Form Layouts)

• Should use Smart Form Validation with jquery validation (see Forms -> Smart Form Validation)

• Shows: first name, last name, organization, title, Role , email, and phone number

• AspNetUsers (database table): firstName, lastName, email, phoneNumber

• Role is a dropdown using Stored Procedure (SP) [getUserJobRoles] – value is id_jobrole, display is jobDesc )

• All fields must be entered and they should be checked using jquery validate and an AccountViewModel.

• Allow user to click edit button and update only: title, department, and phone number

4. Organization Page

• Should use Smart Form Layouts (see Forms -> Smart Form Layouts)

• Should use Smart Form Validation with jquery validation (see Forms -> Smart Form Validation)

• Shows: Organization Name, Mailing Address (use fields from address table—state is dropdown using states table), checkbox to use mailing address as billing address (If unchecked, brings up second set of address fields), and list of facilities on left side with preview of selected facility to the right.

• Organization must have a name, address, and must have at least 1 facility before they can go beyond this page.

• Facility contains: Name, CMS Facility ID (int(16)) , state dropdown, and checkbox to use parent organization’s mailing and billing addresses. If checkbox is unchecked, they can add mailing address address with checkbox to use their mailing address for billing address too. If that checkbox is uncheck, they can enter a separate billing address.

Tables: Organization Name, Address, facility, and States

More work to come…if this goes well.

I would like this work started ASAP. I expect it to be completed within 3 days. I expect this job will take 8-15 hours. The budget is <$400. More work will follow!

C# Programming Microsoft SQL Server MVC OAuth

Project ID: #9650680

About the project