protected void btnSubmit_ServerClick(object sender, EventArgs e)
{
// create variables
String fname = ""; String lname = ""; String phone = ""; String Street = "";
String City = ""; String State = ""; String zip = "";
String EmergConFName = ""; String EmergConLName = ""; String EmergConRelationship = ""; String EmergConEmail = ""; String EmergConPhone = "";
String Allergies = ""; String Limitations = ""; String DoB = "";
// test if input was entered for each textBox and store in variables
String empty = Request.Form["txtFname"];
if (empty != null)
{
fname = Request.Form["txtFname"].ToString();
}
empty = Request.Form["txtLname"];
if (empty != null)
{
lname = Request.Form["txtLname"].ToString();
}
empty = Request.Form["txtPhoneNum"];
if (empty != null)
{
phone = Request.Form["txtPhoneNum"].ToString();
}
empty = Request.Form["txtStreet"];
if (empty != null)
{
Street = Request.Form["txtStreet"].ToString();
}
empty = Request.Form["txtCity"];
if (empty != null)
{
City = Request.Form["txtCity"].ToString();
}
if (Request.Form["ddlState"] != null)
{
State = Request.Form["ddlState"].ToString();
}
empty = Request.Form["txtZip"];
if (empty != null)
{
zip = Request.Form["txtZip"].ToString();
if (zip.Length != 5)
{
MessageBox.Show("Error - Please Enter 5 Digit Zip Code");
return;
}
}
empty = Request.Form["txtDoB"];
if (empty != null)
{
DoB = Request.Form["txtDoB"].ToString();
}
empty = Request.Form["txtEmergFName"];
if (empty != null)
{
EmergConFName = Request.Form["txtEmergFName"].ToString();
}
empty = Request.Form["txtEmergLName"];
if (empty != null)
{
EmergConLName = Request.Form["txtEmergLName"].ToString();
}
empty = Request.Form["txtEmergRelationship"];
if (empty != null)
{
EmergConRelationship = Request.Form["txtEmergRelationship"].ToString();
}
empty = Request.Form["txtEmergPhone"];
if (empty != null)
{
EmergConPhone = Request.Form["txtEmergPhone"].ToString();
}
empty = Request.Form["txtEmergEmail"];
if (empty != null)
{
EmergConEmail = Request.Form["txtEmergEmail"].ToString();
}
empty = Request.Form["txtAllergies"];
if (empty != null)
{
Allergies = Request.Form["txtAllergies"].ToString();
}
empty = Request.Form["txtLimitations"];
if (empty != null)
{
Limitations = Request.Form["txtLimitations"].ToString();
}
// retrieve current user's email
String email = System.Web.HttpContext.Current.User.Identity.Name;
EditProfile updateProfile = new EditProfile(fname, lname, Street, City, State, zip, phone, DoB, EmergConFName, EmergConLName, EmergConPhone, EmergConEmail, EmergConRelationship, Allergies, Limitations);
sc.Open();
SqlCommand update = new SqlCommand();
update.CommandText = "Update Member SET FirstName = @fname, LastName = @lname, Phone = @Phone, DateOfBirth =@DoB";
update.CommandText += ", Street = @Street, CityCounty = @city, State_ = @state, ZipCode = @Zip, EmergencyContactFirstName = @emergFName";
update.CommandText += ", EmergencyContactLastName = @EmergLName, EmergencyContactEmail = @emergEmail, EmergencyContactPhone = @EmergPhone, EmergencyContactRelationship = @EmergRelationship";
update.CommandText += ", Allergies = @Allergies, Limitations = @Limitations Where Email = @Email";
update.Connection = sc;
// test input variable before inserting
if (fname != "")
{
update.Parameters.AddWithValue("@fname", updateProfile.getFName());
}
else
{
update.Parameters.AddWithValue("@fname", DBNull.Value);
}
if (lname != "")
{
update.Parameters.AddWithValue("@lname", updateProfile.getLName());
}
else
{
update.Parameters.AddWithValue("@lname", DBNull.Value);
}
if (phone != "")
{
update.Parameters.AddWithValue("@Phone", updateProfile.getPhone());
}
else
{
update.Parameters.AddWithValue("@Phone", DBNull.Value);
}
if (DoB != "")
{
update.Parameters.AddWithValue("@DoB", updateProfile.getDoB());
}
else
{
update.Parameters.AddWithValue("@DoB", DBNull.Value);
}
if (City != "")
{
update.Parameters.AddWithValue("@city", updateProfile.getCity());
}
else
{
update.Parameters.AddWithValue("@city", DBNull.Value);
}
if (Street != "")
{
update.Parameters.AddWithValue("@Street", updateProfile.getStreet());
}
else
{
update.Parameters.AddWithValue("@Street", DBNull.Value);
}
if (State != "")
{
update.Parameters.AddWithValue("@state", updateProfile.getState());
}
else
{
update.Parameters.AddWithValue("@state", DBNull.Value);
}
if (zip != "")
{
update.Parameters.AddWithValue("@Zip", updateProfile.getZip());
}
else
{
update.Parameters.AddWithValue("@Zip", DBNull.Value);
}
if (EmergConFName != "")
{
update.Parameters.AddWithValue("@emergFName", updateProfile.getEmergencyFirstName());
}
else
{
update.Parameters.AddWithValue("@emergFName", DBNull.Value);
}
if (EmergConLName != "")
{
update.Parameters.AddWithValue("@EmergLName", updateProfile.getEmergencyLastName());
}
else
{
update.Parameters.AddWithValue("@EmergLName", DBNull.Value);
}
if (EmergConEmail != "")
{
update.Parameters.AddWithValue("@emergEmail", updateProfile.getEmergencyEmail());
}
else
{
update.Parameters.AddWithValue("@emergEmail", DBNull.Value);
}
if (EmergConPhone != "")
{
update.Parameters.AddWithValue("@EmergPhone", updateProfile.getEmergencyPhone());
}
else
{
update.Parameters.AddWithValue("@EmergPhone", DBNull.Value);
}
if (EmergConRelationship != "")
{
update.Parameters.AddWithValue("@EmergRelationship", updateProfile.getRelationship());
}
else
{
update.Parameters.AddWithValue("@EmergRelationship", DBNull.Value);
}
if (Allergies != "")
{
update.Parameters.AddWithValue("@Allergies", updateProfile.getAllergies());
}
else
{
update.Parameters.AddWithValue("@Allergies", DBNull.Value);
}
if (Limitations != "")
{
update.Parameters.AddWithValue("@Limitations", updateProfile.getLimitations());
}
else
{
update.Parameters.AddWithValue("@Limitations", DBNull.Value);
}
update.Parameters.AddWithValue("@Email", email);
update.ExecuteNonQuery();
sc.Close();
MessageBox.Show("Success! Your profile has been updated!");
Response.Redirect("ApplicantPortal.aspx");
}
