protected void Button1_Click(object sender, EventArgs e) { if (Page.IsValid) { if (Session["sessThisDaysWorkout"] != null) { thisDaysWorkout = (DailyWorkout)Session["sessThisDaysWorkout"]; } thisDaysWorkout.TrainingDate = Convert.ToDateTime(txtEntryDate.Text); thisDaysWorkout.WorkoutType = ddlWorkoutTypes.SelectedValue; thisDaysWorkout.TotalMilesRun = txtTotalMilesRun.Text; thisDaysWorkout.QualityMilesRun = txtQualityMilesRun.Text; int tempBikeMins = (Convert.ToInt32(ddlMinsBike.SelectedValue)) + (Convert.ToInt32(ddlHrsBike.SelectedValue) * 60); thisDaysWorkout.BikeMins = Convert.ToString(tempBikeMins); int tempSwimMins = (Convert.ToInt32(ddlMinsSwim.SelectedValue)) + (Convert.ToInt32(ddlHrsSwim.SelectedValue) * 60); thisDaysWorkout.SwimMins = Convert.ToString(tempSwimMins); thisDaysWorkout.OverallWorkoutDescription = txtWorkoutDesc.Text; if (thisDaysWorkout.insertOrUpdateFlag == "Update") { WorkoutObjectDB.UpdateWorkoutDay(thisDaysWorkout); } //SqlDataSource3.Update(); else { WorkoutObjectDB.InsertWorkoutDay(thisDaysWorkout); } //SqlDataSource2.Insert(); //SqlDataSource3.Insert(); lblTrainingInfoUpdate.Text = "Training database was successfully updated for " + txtEntryDate.Text; //thisDaysWorkout = new DailyWorkout(); Session.Remove("sessThisDaysWorkout"); // Write thisDaysWorkout to Session State thisDaysWorkout = WorkoutDB.RetrieveScreenFields(Convert.ToDateTime(txtEntryDate.Text), Page.User.Identity.Name); PopulateScreenFields(thisDaysWorkout); // Write thisDaysWorkout to Session State Session["sessThisDaysWorkout"] = thisDaysWorkout; } }
protected void btnUpdate_Click(object sender, EventArgs e) { if (Page.IsValid) { myWorkoutType = new WorkoutType(); myWorkoutType.UserEmail = Page.User.Identity.Name; myWorkoutType.TypeOfWorkout = txtNewWorkoutType.Text; if (WorkoutObjectDB.InsertWorkoutType(myWorkoutType) == 1) { ; //all good } //SqlDataSource2.Insert(); //SqlDataSource1.Insert(); lblUpdateStatus.Text = "New Workout Type \"" + txtNewWorkoutType.Text + "\" has been successfully added"; } }