public bool Save_Changes() { // Go through the each repeater item for this week foreach (RepeaterItem item in rptThisWeek.Items) { TextBox txtPromiseDescription = ((TextBox)item.FindControl("twPromiseDescription")); CheckBox cbPromiseComplete = ((CheckBox)item.FindControl("twPromiseComplete")); Label lblPromiseID = ((Label)item.FindControl("twPromiseID")); int promiseID = Convert.ToInt32(lblPromiseID.Text); // See if the promise exists in the database var promises = from p in entities.Promises where p.PromiseID == promiseID select p; if (promises.Count() != 0) { // It does exist FRT.DAL.Promise promise = promises.First(); // If the new textbox is empty, delete the row if (txtPromiseDescription.Text == "") { entities.DeleteObject(promise); } else { // Otherwise update the promisedescription if (!promise.PromiseDescription.Equals(txtPromiseDescription.Text)) { promise.PromiseDescription = txtPromiseDescription.Text; } // If the promisecomplete has changed, update that too. if (!promise.PromiseComplete.Equals(cbPromiseComplete.Checked)) { promise.PromiseComplete = cbPromiseComplete.Checked; } } } else { // it doesn't exist. wtf?? } } // Save changes and refresh data entities.SaveChanges(); BindRepeaters(); // Always return true (we have the option to in the future return false for failure) return(true); }
protected void SaveGoals_Click(object sender, EventArgs e) { FRT.DAL.frtEntities entities = new FRT.DAL.frtEntities(); // Go through each of the items in the repeater and update foreach (RepeaterItem item in rptTrainingGoals.Items) { HiddenField lblGoalID = (HiddenField)item.FindControl("lblGoalID"); TextBox txtGoal = (TextBox)item.FindControl("txtGoal"); TextBox txtGoalURL = (TextBox)item.FindControl("txtGoalURL"); int goalID = Convert.ToInt32(lblGoalID.Value); // See if the goal exists in the database var goals = from g in entities.TrainingGoals where g.GoalID == goalID select g; if (goals.Count() != 0) { // It does exist FRT.DAL.TrainingGoal goal = goals.First(); // If the textbox is empty, delete the row if (txtGoal.Text.Equals("")) { entities.DeleteObject(goal); } else { // Otherwise update the goal goal.Goal = txtGoal.Text; goal.URL = txtGoalURL.Text; } } else { // it doesn't exist. wtf?? } } // Save changes and refresh data entities.SaveChanges(); RefreshTrainingGoals(); pnlTrainingGoals.Visible = false; }