protected void signin_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 muskokaEntites(); //use camper class to create a new camper object registrationDate render = (from r in conn.registrationDates join cR in conn.camperRegistrations on r.ID equals cR.registrationDateID into rID from cR in rID join c in conn.camperProfiles on cR.camperID equals c.ID where c.ID == camperID && r.date == currentDate2.Text select r).FirstOrDefault(); //fill the properties of the camper time render.signedInBy = signedInBy.Text; render.signInTime = DateTime.Now.ToString("h:mm:ss tt"); conn.registrationDates.Attach(render); conn.Entry(render).State = System.Data.Entity.EntityState.Modified; conn.SaveChanges(); //redirect Response.Redirect("CamperAttendence.aspx"); }
protected void grdRegistration_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(grdRegistration.DataKeys[gridIndex].Values["camperID"]); var date = datebox1.Text; // 3. connect to db using (muskokaEntites db = new muskokaEntites()) { registrationDate camp = (from r in db.registrationDates join cR in db.camperRegistrations on r.ID equals cR.registrationDateID into rID from cR in rID join c in db.camperProfiles on cR.camperID equals c.ID where c.ID == camperID && r.date == date select r).FirstOrDefault(); // 4. delete the selected camper db.registrationDates.Remove(camp); db.SaveChanges(); // 5. referesh the grid getCampers(); } }
protected void submitPayment_Click(object sender, EventArgs e) { // connect using (muskokaEntites db = new muskokaEntites()) { // create new payment payment pay = new payment(); Int32 camperID = 0; // check for ID in url if (!String.IsNullOrEmpty(Request.QueryString["camperID"])) { //get the id from the url camperID = Convert.ToInt32(Request.QueryString["camperID"]); // get the payment pay = (from p in db.payments where p.camperID == camperID select p).FirstOrDefault(); } //fill properties to make a payment pay.date = payCalendar.Text; pay.amount = "$" + makePayment.Text; pay.paymentType = payType.SelectedItem.Text; pay.camperID = Convert.ToInt32(Request.QueryString["camperID"]); db.payments.Add(pay); db.SaveChanges(); // redirect Response.Redirect("Pay.aspx"); } }
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 muskokaEntites(); //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.ID = 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(); } }