protected void OnRowUpdating(object sender, GridViewUpdateEventArgs e) { GridViewRow row = GV_Pilots.Rows[e.RowIndex]; int idPilot = Convert.ToInt32(GV_Pilots.DataKeys[e.RowIndex].Values[0]); string mail = (row.FindControl("txtEmail") as TextBox).Text; string name = (row.FindControl("txtFstName") as TextBox).Text; string lstName = (row.FindControl("txtLstName") as TextBox).Text; string cert = (row.FindControl("txtCert") as TextBox).Text; string flightTime = (row.FindControl("txtTVuelo") as TextBox).Text; string certDate = (row.FindControl("txtCertDate") as TextBox).Text; using (DroidikaContextDataContext ctx = new DroidikaContextDataContext()) { dPilot pil = (from p in ctx.dPilots where p.id == idPilot select p).FirstOrDefault(); pil.email = mail; pil.fstName = name; pil.lstName = lstName; pil.certificate = char.Parse(cert); pil.flightTime = Int32.Parse(flightTime); pil.certificateDate = DateTime.Parse(certDate); ctx.SubmitChanges(); } GV_Pilots.EditIndex = -1; this.BindGrid(); }
protected void Insert(object sender, EventArgs e) { lblMensaje.Text = ""; if (txtBrand.Text != "" && txtCostUSD.Text != "" && txtModel.Text != "") { using (DroidikaContextDataContext ctx = new DroidikaContextDataContext()) { dCatCamera cam = new dCatCamera { brand = txtBrand.Text, model = txtModel.Text, costUsd = decimal.Parse(txtCostUSD.Text), }; ctx.dCatCameras.InsertOnSubmit(cam); ctx.SubmitChanges(); } txtBrand.Text = ""; txtCostUSD.Text = ""; txtModel.Text = ""; this.BindGrid(); } else { lblMensaje.Text = "Favor de introducir los campos requeridos."; } }
protected void OnRowDeleting(object sender, GridViewDeleteEventArgs e) { int idCatCam = Convert.ToInt32(GridView1.DataKeys[e.RowIndex].Values[0]); using (DroidikaContextDataContext ctx = new DroidikaContextDataContext()) { dCatCamera cam = (from c in ctx.dCatCameras where c.id == idCatCam select c).FirstOrDefault(); ctx.dCatCameras.DeleteOnSubmit(cam); ctx.SubmitChanges(); } this.BindGrid(); }
protected void Insert(object sender, EventArgs e) { using (DroidikaContextDataContext ctx = new DroidikaContextDataContext()) { dCatCamera cam = new dCatCamera { brand = txtBrand.Text, model = txtModel.Text, costUsd = decimal.Parse(txtCostUSD.Text), }; ctx.dCatCameras.InsertOnSubmit(cam); ctx.SubmitChanges(); } this.BindGrid(); }
protected void OnRowUpdating(object sender, GridViewUpdateEventArgs e) { GridViewRow row = GridView1.Rows[e.RowIndex]; int idCatCam = Convert.ToInt32(GridView1.DataKeys[e.RowIndex].Values[0]); string brand = (row.FindControl("txtBrand") as TextBox).Text; string model = (row.FindControl("txtModel") as TextBox).Text; string costUsd = (row.FindControl("txtCostUSD") as TextBox).Text; using (DroidikaContextDataContext ctx = new DroidikaContextDataContext()) { dCatCamera cam = (from c in ctx.dCatCameras where c.id == idCatCam select c).FirstOrDefault(); cam.brand = brand; cam.model = model; cam.costUsd = decimal.Parse(costUsd); ctx.SubmitChanges(); } GridView1.EditIndex = -1; this.BindGrid(); }