protected void Create_Click(object sender, EventArgs e) { // check if we have an ID for editing Int32 camperID = 0; if (!String.IsNullOrEmpty(Request.QueryString["camperID"])) { camperID = Convert.ToInt32(Request.QueryString["camperID"]); } //connect to db var conn = new muskokaEntities(); //use camper class to create a new camper object camperProfile c = new camperProfile(); //fill the properties of the new camper c.firstName = firstName.Text; c.lastName = lastName.Text; c.familyName = familyName.Text; c.rate = rate.Text; c.age = Convert.ToInt32(age.Text); c.address = address.Text; c.contactName = contactName.Text; c.contactRelation = contactRelation.Text; c.contactNumber = contactNumber.Text; c.importantNotes = impNotes.Text; //save the new object to the database if (camperID == 0) { conn.camperProfiles.Add(c); } else { c.camperID = camperID; conn.camperProfiles.Attach(c); conn.Entry(c).State = System.Data.Entity.EntityState.Modified; } conn.SaveChanges(); //redirect to the Index page Response.Redirect("Index.aspx?"); }
protected void grdCampers_RowDeleting(object sender, GridViewDeleteEventArgs e) { //function to delete a camper from the list of profiles // 1. determine row in the grid Int32 gridIndex = e.RowIndex; // 2. find the camper id value in the selected row Int32 camperID = Convert.ToInt32(grdCampers.DataKeys[gridIndex].Values["camperID"]); // 3. connect to db using (muskokaEntites db = new muskokaEntites()) { camperProfile camp = (from c in db.camperProfiles where c.ID == camperID select c).FirstOrDefault(); // 4. delete the selected camper db.camperProfiles.Remove(camp); db.SaveChanges(); // 5. referesh the grid getCampers(); } }