CIS407 Final

Need your ASSIGNMENT done? Use our essay writing service to score better and meet your deadline.


Order a Similar Paper Order a Different Paper

  

Question 3515 pts

(TCO 5, 6, 9) Discuss the importance of implementing transactions in web applications. Describe the COMMIT, and ROLLBACK command. In the following SaveEmployee function below, add code to insert the first name, last name, and pay rate into the tblEmployee table. In the database the column names are: FirstName, LastName, PayRate. Also, write the code to commit the transaction.
public static bool SaveEmployee(string Database, string FirstName, string LastName, string PayRate)
{
bool recordSaved;
try
{
OleDbTransaction myTransaction = null;
OleDbConnection conn = new OleDbConnection(“PROVIDER=Microsoft.ACE.OLEDB.12.0;” +”Data Source=” +Database);
conn.Open();
OleDbCommand command = conn.CreateCommand();
string strSQL;
 

myTransaction = conn.BeginTransaction();
command.Transaction = myTransaction;
 

// Write the code below to insert the first name, last name, and pay rate into the tblEmployee table
_____________________________________________________
 

// Add your comments here
command.CommandType = CommandType.Text;
command.CommandText = strSQL;
 

// Add your comments here
command.ExecuteNonQuery();
 

// Write the code below to commit the transaction
_______________________________________________________
 

// Add your comments here
conn.Close();
 

recordSaved = true;
}
catch (Exception ex)
{
myTransaction.Rollback();
 

recordSaved = false;
}
 

return recordSaved;
 

}

HTML EditorKeyboard Shortcuts

12pt

Paragraph

p

Question 3615 pts

(TCO 8, 9) Explain Secure Sockets Layer, authentication, and authorization. Discuss advantages of using validation controls and discuss the RequiredFieldValidator and the RegularExpressionValidator in particular.

   ?1??