// Method to delete customers
protected void btnDelete_Click(object sender, EventArgs e)
{
// Set to false to ensure completion
bool userUpdateError = false;
// Mine is in App_Data
string tempPath = Server.MapPath("~/App_Data/Users.accdb");
clsDataLayer myDataLayer = new clsDataLayer(tempPath);
// Try-catch statement to delete users
try
{
myDataLayer.DeleteUser(txtUsername.Text, txtCity.Text,
txtState.Text, txtFavLang.Text, txtWorstLang.Text, txtLastProgram.Text);
}
// Error details for syntax, spelling or run-time issues.
catch (Exception error)
{
userUpdateError = true;
string message = "Error updating customer, please check form data. ";
Master.UserFeedBack.Text = message + error.Message;
}
// If no errors, success has been made
if (!userUpdateError)
{
// Wipes the controls so another update can be made
ClearInputs(Page.Controls);
Master.UserFeedBack.Text = "Customer Updated Successfully.";
}
// Necessary for displaying the info for the table "Customers in Database"
BindCustomerGridView();
}
/// DELETE USER
// btnDeleteUser method
protected void btnDeleteUser_Click(object sender, EventArgs e)
{
// bool for delete error
bool userDeleteError = false;
// path for database
string tempPath = Server.MapPath("~/App_Data/dsProgramaholics.mdb");
clsDataLayer myDataLayer = new clsDataLayer(tempPath);
// try block to update customer
try
{
myDataLayer.DeleteUser(Convert.ToInt32(userID.Text));
}
catch (Exception error)
{
userDeleteError = true;
string message = "Error deleting user. Please check your form data. ";
Master.UserFeedBack.Text = message + error.Message;
} // end catch
// if no error update feedback text to display success message
if (!userDeleteError)
{
ClearInput(Page.Controls);
Master.UserFeedBack.Text = "Customer Updated Succesfully.";
} // end if
} // end delete
