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();
}
}
