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