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()) { dCatDrone drone = new dCatDrone { brand = txtBrand.Text, model = txtModel.Text, costUsd = decimal.Parse(txtCostUSD.Text), flightTime = Int32.Parse(txtFlightTime.Text) }; ctx.dCatDrones.InsertOnSubmit(drone); ctx.SubmitChanges(); } this.BindGrid(); } else { lblMensaje.Text = "Favor de introducir los campos requeridos."; } }
protected bool ValidaUser() { try { using (DroidikaContextDataContext dbContext = new DroidikaContextDataContext()) { dAdministrator admin = dbContext.dAdministrators.Where(x => x.email == txtUsr.Text && x.password == txtPwd.Text).SingleOrDefault(); if (admin == null) { LabelMsg.Text = "Usuario incorrecto"; Session["Name"] = ""; } else { Session["Name"] = admin.fstName + " " + admin.lstName; Session["ID"] = admin.id; Session["Login"] = true; txtUsr.Text = ""; txtPwd.Text = ""; LabelMsg.Visible = true; LabelMsg.Text = ""; Response.Redirect("Drones.aspx"); } } } catch (Exception ex) { LabelMsg.Visible = true; LabelMsg.Text = ex.Message; } return true; }
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.idCamera == idCatCam select c).FirstOrDefault(); cam.brand = brand; cam.model = model; cam.costUsd = decimal.Parse(costUsd); ctx.SubmitChanges(); } GridView1.EditIndex = -1; this.BindGrid(); }
protected void btnAccion_Click(object sender, EventArgs e) { try { if (idPilot > 0) { using (DroidikaContextDataContext context = new DroidikaContextDataContext()) { dPilot piloto = (from p in context.dPilots where p.id == idPilot select p).FirstOrDefault(); name = piloto.fstName + " " + piloto.lstName; } } //rvCertificado.Reset(); rvCertificado.LocalReport.ReportPath = "Certificado.rdlc"; rvCertificado.LocalReport.Refresh(); } catch (Exception ex){ } }
private void BindGrid() { //Select * from dPilots y asignalo al datagrid using (DroidikaContextDataContext context = new DroidikaContextDataContext()) { GV_Pilots.DataSource = from p in context.dPilots select p; GV_Pilots.DataBind(); } }
private void BindGrid() { using (DroidikaContextDataContext ctx = new DroidikaContextDataContext()) { GridView1.DataSource = from drones in ctx.dCatDrones select drones; GridView1.DataBind(); } }
private void BindGrid() { using (DroidikaContextDataContext context = new DroidikaContextDataContext()) { GridView1.DataSource = from cams in context.dCatCameras select cams; GridView1.DataBind(); } }