566984 PayrollSystem2

Completado Publicado May 19, 2012 Pagado a la entrega
Completado Pagado a la entrega

Hello again Nick, sorry I'm getting this late in the week to you, but I've been swamped like before. I'm sure you've gotten the message about commenting about the specific segments of code for future programmers understanding what is going on. Here is the new deliverable instructions according to Felicia:

1. Open Microsoft Visual [url removed, login to view] 2008.

2. Open the PayrollSystem website.

3. Download the [url removed, login to view] file in cloud server secondary folder. Save it on your local computer. Add it to the PayrollSystem website as follows: In Visual Studio, in the Solution Explorer, click Website, Add Existing Item, then navigate to the [url removed, login to view] file you downloaded and click the Add button.

4. Click View Server Explorer to create a new connection to the PayrollSystem_DB.MDB.

5. When the Server Explorer toolbox appears, click the Connect to Database button.

See pic1***

6. When the Add Connection dialog appears, click the Change button. In the "Change Data Source" dialog, select MS Access Database File; Uncheck Always use this Selection; then click OK.

See pic2***

Click the Browse button to navigate to the [url removed, login to view] file in your website folder, then click "Open". (NOTE: Be sure you select the [url removed, login to view] file in your PayrollSystem website folder, not the one you originally downloaded from Doc Sharing!) Click Test Connection. You should receive a message that the test connection succeeded. Click OK to acknowledge the message, then click "OK" again to close the Add Connection dialog.

7. The [url removed, login to view] should be added to the Server Explorer. Expand the database, then expand the Tables entry under the database until you see tblUserActivity. Leave the Server Explorer window open for now as you will be returning to it in a moment.

See pic3***

8. Create a new dataset by selecting Website Add New Item. Under Templates, select the Dataset item. Enter [url removed, login to view] for the name. Click Add.

9. If the following message appears, select Yes. You want to make this dataset available to your entire website.

See pic4***

10. If the TableAdapter Configuration Wizard dialog appears, click Cancel. (We will be configuring a Data Adapter for this dataset later in C# code, so we do not need to run this wizard.)

11. Drag-and-drop the tblUserActivity table from the Server Explorer window into the dsUserActivity dataset in the editor window.

NOTE: If you see a message that says your connection uses a local data file that is not in the current project, which indicates you, did not select the correct [url removed, login to view] file when you created your data connection. To fix this problem, click No, then right-click on [url removed, login to view] in the Server Explorer window and choose Modify Connection. Click the Browse button, navigate to the [url removed, login to view] file that is in your PayrollSystem website folder, and click Open. Test the connection, then click OK.

12. Click the Save icon on the toolbar to save the [url removed, login to view] dataset.

(You can now close the Server Explorer window if you wish.)

13. Create a new class to contain the C# code that will access this dataset. To do so, click Website, Add New Item. In the Add New Item dialog, select the Class template, and enter clsDataLayer for the name. Make sure the Language is set to Visual C#. Click "Add".

14. If the following message appears, select Yes. You want to make this class available to everything in your solution.

See pic5***

15. Add the following to the top of your class, below any other using statements created for you by Visual Studio:

// Add your comments here

using [url removed, login to view];

using [url removed, login to view];

using [url removed, login to view];

16. Add the following three functions inside the squiggly braces for the "public class clsDataLayer" class, above the beginning of the "public clsDataLayer()" constructor:

// This function gets the user activity from the tblUserActivity

public static dsUserActivity GetUserActivity(string Database)

{

// Add your comments here

dsUserActivity DS;

OleDbConnection sqlConn;

OleDbDataAdapter sqlDA;

// Add your comments here

sqlConn = new OleDbConnection("PROVIDER=Microsoft.Jet.OLEDB.4.0;" +

"Data Source=" + Database);

// Add your comments here

sqlDA = new OleDbDataAdapter("select * from tblUserActivity", sqlConn);

// Add your comments here

DS = new dsUserActivity();

// Add your comments here

[url removed, login to view]([url removed, login to view]);

// Add your comments here

return DS;

}

// This function saves the user activity

public static void SaveUserActivity(string Database, string FormAccessed)

{

// Add your comments here

OleDbConnection conn = new OleDbConnection("PROVIDER=Microsoft.Jet.OLEDB.4.0;" +

"Data Source=" + Database);

[url removed, login to view]();

OleDbCommand command = [url removed, login to view]();

string strSQL;

strSQL = "Insert into tblUserActivity (UserIP, FormAccessed) values ('" +

GetIP4Address() + "', '" + FormAccessed + "')";

[url removed, login to view] = [url removed, login to view];

[url removed, login to view] = strSQL;

[url removed, login to view]();

[url removed, login to view]();

}

// This function gets the IP Address

public static string GetIP4Address()

{

string IP4Address = [url removed, login to view] ;

foreach (IPAddress IPA in

[url removed, login to view]([url removed, login to view])) {

if ([url removed, login to view]() == "InterNetwork") {

IP4Address = [url removed, login to view]();

break;

}

}

if (IP4Address != [url removed, login to view]) {

return IP4Address;

}

foreach (IPAddress IPA in [url removed, login to view]([url removed, login to view]())) {

if ([url removed, login to view]() == "InterNetwork") {

IP4Address = [url removed, login to view]();

break;

}

}

return IP4Address;

}

STEP 2: frmUserActivity, frmPersonnel, frmMain (10 points)

18. Create a new Web form called frmUserActivity. Switch to Design Mode and add a Label and GridView (found under the Toolbox, Data tab) having the following properties:

Property Value

Label - Text User Activity

GridView - (ID) grdUserActivity

19. Go to the Page_Load method and add the following code:

if (![url removed, login to view]) {

// Declares the DataSet

dsUserActivity myDataSet = new dsUserActivity();

// Fill the dataset with what is returned from the function

myDataSet = [url removed, login to view]([url removed, login to view]("[url removed, login to view]"));

// Sets the DataGrid to the DataSource based on the table

[url removed, login to view] = [url removed, login to view]["tblUserActivity"];

// Binds the DataGrid

[url removed, login to view]();

}

20. Open the frmMain form, add a new link button and image button to point to the new frmUserActivity. Find an image to use for the image button and add the new option as View User Activity.

21. Go to the frmMain Page_Load and add the following code:

// Add your comments here

[url removed, login to view]([url removed, login to view]("[url removed, login to view]"), "frmPersonnel");

22. On the frmUserActivity form, add the CoolBiz logo hyperlinked logo at the top of the page so that when clicked the user is returned to frmMain.

23. In the Solution Explorer, right click on the [url removed, login to view] form and select Set As Start Page. Run your project. When you open the project, a record should be saved in the tblUserActivity table with the IP address, form name accessed (frmPersonnel), and the date accessed. When you click the View Activity button, you should see at least one record with this information.

24. You will now add server side validation code to the frmPersonnel page. Currently, when the Submit button is pressed, the frmPersonnelVerified page is displayed. This is because the frmPersonnelVerified page is set as the Submit button's PostBackUrl property. Instead of having the page go directly to the frmPersonnelVerified page when the Submit button is pressed, we want to do some server side validation. If any of the validation rules fail, we will redisplay the frmPersonnel page with the fields in question highlighted in yellow with an error message displayed.

First, it is important to understand what is currently happening when the submit button is pressed. This is causing a postback of the form to the frmPersonnelVerified form. When this postback happens, all of the data in the fields on the frmPersonnel form are sent to the frmPersonnelVerified form as name value pairs. In the Page_Load code of frmPersonnelVerified these values are picked up from the Request object and displayed. Each name value pair will be in the Request object as the ID of the control containing the value and the value itself. We can pass data between pages by using Session state instead. In order to do validation on the values but still have the values visible on the frmPersonnelVerified page, we will need to change not only the PostBack URL of the frmPersonnel page but also how the frmPersonnelVerified form is getting the data – it will need to get it from Session state rather than from the Request object.

Make the following changes:

1. Clear the Submit button PostBackURLProperty on the frmPersonnel form.

2. In the btnSubmit_Click event handler get each value from the data entry fields and set Session state items for each.

3. Change the frmPersonnelVerified code behind to get the values from the Session state items you created in the previous step.

When you are done with these steps, you should be able to enter data on the frmPersonnel data entry form and then click the Submit button. The frmPersonnelVerified page should then be displayed with the values that were in the data entry fields on frmPersonnel.

Make sure this is all working before proceeding to the next steps.

25. Add a label to the frmPersonnel form with an ID of lblError. Do not place the label to the right or left of any of the controls on the form. Add it below the controls or above the controls. The text property of this label should be set to an empty string.

26. Add code to perform server side validation in response to the submit button being clicked. Here are the business rules we want to enforce (remember this will be server C# code in the frmPersonnel code behind): Fields may not be empty or filled with spaces. If any field is empty, turn that field background color to yellow and add to/create an error message to be shown in the error label. The end date must be greater than the start date. If the end date is less than the start date, turn both date fields yellow and add to/create an error message to be shown in the error label. If all fields validate properly then the session state items should be set properly and the user should see the frmPersonnelVerified form with all the values displayed.

27. Programming Hints: To set a value in session state do the following:

Session["txtFirstName"] = [url removed, login to view];

28. "txtFirstName" is the key and [url removed, login to view] is the value.

29. To get this same value back from the session we use the key and the Session object as follows:

Session["txtLastName"].ToString()

30. There is a Trim method on the string object that will automatically remove spaces from the beginning and end of a string. Remember, you can turn an object like a Session item object into a string using the Convert class or just using it's ToString() method.

31. You may want to create variables to work with for validation rather than using the Request item objects directly.

32. To turn a string into a DateTime object you can use the DateTime method Parse. If you had a date value stored in a string called strDate, you could turn it into a DateTime object like this:

DateTime myDateTimeObject = [url removed, login to view](strDate);

33. You can compare two DateTime objects by using the [url removed, login to view] method. If you had two DateTime objects called dt1 and dt2 you can check to see if dt1 is greater than dt2 by doing this:

if ([url removed, login to view](dt1,dt2) > 0)

34. [url removed, login to view] will return a 0 if the two dates are equal, a 1 if dt1 is greater than dt2, and a -1 if dt1 is less than dt2.

35. If you put in an invalid date for either of the date fields, you will get an exception/server error when trying to parse the values. We will address this in a later lab – for now make sure you enter valid dates (valid meaning a date in the form of mm/dd/yyyy).

36. If I had a TextBox control that was called txtAge and you wanted to set it's background color you could do this:

[url removed, login to view] = [url removed, login to view];

37. Remember to clear the PostBackURL property of the submit button!

STEP 3: Verify and submit (10 points)

28. Run your project. When you open the project, and go to the main menu form a record should be saved in the tblUserActivity table with the IP address, form name accessed (frmPersonnel), and the date accessed. When you click the View Activity button you should see at least one record with this information. The validation and error display should work for entering data. All navigation and hyperlinks should work.

Once you have verified that, your good to go. Good luck.

.NET ASP Entrada de datos Diseño gráfico Diseño de íconos Diseño de logotipos Microsoft Access Odd Jobs PHP Plantillas Gestión de páginas web

Nº del proyecto: #2312947

Sobre el proyecto

1 propuesta Proyecto remoto Activo Jul 11, 2012

Adjudicado a:

ranjitsinha

Ready to do it. Thanks.

$60 USD en 1 día
(201 comentarios)
5.7