public bool GuardarVehículo(string placa, string marca, int modelo) { bool resultado = false; try { VEHICULO Carro = new VEHICULO(); Carro.Marca = marca; Carro.Modelo = modelo; Carro.NumeroPlaca = placa; db.VEHICULOS.Add(Carro); db.SaveChanges(); return(resultado = true); } catch (Exception ex) { return(resultado = false); throw; } return(resultado); }
public bool EliminarVehículo(string placa) { bool resultado = false; try { VEHICULO Carro = new VEHICULO(); Carro = (from A in db.VEHICULOS where A.NumeroPlaca == placa select A).First(); db.VEHICULOS.Remove(Carro); db.SaveChanges(); return(resultado = true); } catch (Exception ex) { return(resultado = false); throw; } return(resultado); }
protected void grvCursoDetalle_RowCommand(object sender, GridViewCommandEventArgs e) { if (e.CommandName == "Jusveh") { bool lActivo = false; // string ldoc = txtNumero.Text.Trim(); int indice = Convert.ToInt32(e.CommandArgument); GridViewRow row = grvCursoDetalle.Rows[indice]; int id_pregunta = row.DataItemIndex; int lid = Convert.ToInt32(row.Cells[2].Text); VEHICULO vehiculo = da.VEHICULO.SingleOrDefault(x => x.VEH_ID == lid); lActivo = Convert.ToBoolean(vehiculo.VEH_ESTADO); if (lActivo) { lActivo = false; } else { lActivo = true; } vehiculo = da.VEHICULO.SingleOrDefault(x => x.VEH_ID == lid); vehiculo.VEH_ESTADO = lActivo; da.SubmitChanges(); listarAuto(); } }
public bool ActualizarVehículo(string placa, string marca, int modelo) { bool resultado = false; try { VEHICULO Carro = new VEHICULO(); Carro = (from A in db.VEHICULOS where A.NumeroPlaca == placa select A).First(); Carro.Marca = marca; Carro.Modelo = modelo; db.SaveChanges(); return(resultado = true); } catch (Exception ex) { return(resultado = false); throw; } return(resultado); }
public ActionResult DeleteConfirmed(int id) { VEHICULO vEHICULO = db.VEHICULOes.Find(id); db.VEHICULOes.Remove(vEHICULO); db.SaveChanges(); return(RedirectToAction("Index")); }
public VEHICULO buscarPatente(String pat) { using (SRI contex = new SRI()) { VEHICULO lbuscar = new VEHICULO(); lbuscar = contex.VEHICULO.Where(a => a.PATENTE == pat).FirstOrDefault(); return(lbuscar); } }
public async Task <ActionResult> DeleteConfirmed(decimal id) { VEHICULO vEHICULO = await db.VEHICULO.FindAsync(id); db.VEHICULO.Remove(vEHICULO); await db.SaveChangesAsync(); return(RedirectToAction("Index")); }
public ActionResult EditaVehiculo(VEHICULO vehiculo) { if (ModelState.IsValid == true) { vehiculo.editaVehiculo(); return(RedirectToAction("Index")); } else { ViewBag.MenuPage = menu.listarMenu(Convert.ToInt16(Session["IdPerfil"])); return(View()); } }
public ActionResult Edit([Bind(Include = "IDVEHICULO,IDESTADOVEHICULO,IDMARCA,IDTIPOVEHICULO,PLACA,MOTOR,SERIE_VIN,MODELO,COLOR,TRANSMISION")] VEHICULO vEHICULO) { if (ModelState.IsValid) { db.Entry(vEHICULO).State = EntityState.Modified; db.SaveChanges(); return(RedirectToAction("Index")); } ViewBag.IDESTADOVEHICULO = new SelectList(db.ESTADOVEHICULOes, "IDESTADOVEHICULO", "DESCRIPCION", vEHICULO.IDESTADOVEHICULO); ViewBag.IDMARCA = new SelectList(db.MARCAs, "IDMARCA", "DESCRIPCION", vEHICULO.IDMARCA); ViewBag.IDTIPOVEHICULO = new SelectList(db.TIPOVEHICULOes, "IDTIPOVEHICULO", "DESCRIPCION", vEHICULO.IDTIPOVEHICULO); return(View(vEHICULO)); }
// GET: AreaGestion/VEHICULO/Details/5 public async Task <ActionResult> Details(decimal id) { if (id == null) { return(new HttpStatusCodeResult(HttpStatusCode.BadRequest)); } VEHICULO vEHICULO = await db.VEHICULO.FindAsync(id); if (vEHICULO == null) { return(HttpNotFound()); } return(View(vEHICULO)); }
public async Task <ActionResult> Edit([Bind(Include = "ID,PLACA,ID_LINEA,MODELO,NUMEROMOTOR,COLOR,ID_CLASE,ID_TIPOSERVICIO")] VEHICULO vEHICULO) { if (ModelState.IsValid) { db.Entry(vEHICULO).State = EntityState.Modified; await db.SaveChangesAsync(); return(RedirectToAction("Index")); } ViewBag.ID_CLASE = new SelectList(db.CLASEVEHICULO, "ID", "DESCRIPCION", vEHICULO.ID_CLASE); ViewBag.ID_LINEA = new SelectList(db.LINEA, "ID", "DESCRIPCION", vEHICULO.ID_LINEA); ViewBag.ID_TIPOSERVICIO = new SelectList(db.TIPOSERVICIO, "ID", "DESCRIPCION", vEHICULO.ID_TIPOSERVICIO); return(View(vEHICULO)); }
// GET: VEHICULOes/Details/5 public ActionResult Details(int?id) { if (id == null) { return(new HttpStatusCodeResult(HttpStatusCode.BadRequest)); } VEHICULO vEHICULO = db.VEHICULOes.Find(id); if (vEHICULO == null) { return(HttpNotFound()); } return(View(vEHICULO)); }
public string CrearVehiculo(string patente, int id_cliente, int marca_vehiculo, int tipo_vehiculo) { try { VEHICULO vehiculo = new VEHICULO(); VehiculosDAL vehiculosDAL = new VehiculosDAL(); if (patente != "") { if (id_cliente > -1) { if (marca_vehiculo > -1) { if (tipo_vehiculo > -1) { vehiculo.PATENTE = patente; vehiculo.CLIENTE_ID = id_cliente; vehiculo.MARCA_VEHICULO_ID = marca_vehiculo; vehiculo.TIPO_VEHICULO_ID = tipo_vehiculo; vehiculo.FECHA_CREACION = DateTime.Now; vehiculo.FECHA_ULTIMO_UPDATE = DateTime.Now; return(vehiculosDAL.CrearVehiculo(vehiculo)); } else { return("Indique un tipo de vehiculo"); } } else { return("Indique una marca"); } } else { return("Indique un cliente"); } } else { return("Indique una patente"); } } catch (Exception ex) { throw ex; } }
public string ActualizarVehiculo(int id_cliente, int marca_vehiculo, int tipo_vehiculo, int idvehiculo) { try { VEHICULO vehiculo = new VEHICULO(); VehiculosDAL vehiculosDAL = new VehiculosDAL(); if (idvehiculo > 0) { if (id_cliente > -1) { if (marca_vehiculo > -1) { if (tipo_vehiculo > -1) { vehiculo.ID = idvehiculo; vehiculo.CLIENTE_ID = id_cliente; vehiculo.MARCA_VEHICULO_ID = marca_vehiculo; vehiculo.TIPO_VEHICULO_ID = tipo_vehiculo; vehiculo.FECHA_ULTIMO_UPDATE = DateTime.Now; return(vehiculosDAL.ActualizarVehiculo(vehiculo)); } else { return("Indique un tipo de vehiculo"); } } else { return("Indique una marca"); } } else { return("Indique un cliente"); } } else { return("Debe seleccionar una vehiculo de la tabla de vahiculos"); } } catch (Exception ex) { throw ex; } }
public VEHICULO RetornarVehiculo(string placa) { VEHICULO Carro = new VEHICULO(); try { Carro = (from A in db.VEHICULOS where A.NumeroPlaca == placa select A).First(); return(Carro); } catch (Exception ex) { return(Carro = null); throw; } return(Carro); }
// GET: AreaGestion/VEHICULO/Edit/5 public async Task <ActionResult> Edit(decimal id) { if (id == null) { return(new HttpStatusCodeResult(HttpStatusCode.BadRequest)); } VEHICULO vEHICULO = await db.VEHICULO.FindAsync(id); if (vEHICULO == null) { return(HttpNotFound()); } ViewBag.ID_CLASE = new SelectList(db.CLASEVEHICULO, "ID", "DESCRIPCION", vEHICULO.ID_CLASE); ViewBag.ID_LINEA = new SelectList(db.LINEA, "ID", "DESCRIPCION", vEHICULO.ID_LINEA); ViewBag.ID_TIPOSERVICIO = new SelectList(db.TIPOSERVICIO, "ID", "DESCRIPCION", vEHICULO.ID_TIPOSERVICIO); return(View(vEHICULO)); }
// GET: VEHICULOes/Edit/5 public ActionResult Edit(int?id) { if (id == null) { return(new HttpStatusCodeResult(HttpStatusCode.BadRequest)); } VEHICULO vEHICULO = db.VEHICULOes.Find(id); if (vEHICULO == null) { return(HttpNotFound()); } ViewBag.IDESTADOVEHICULO = new SelectList(db.ESTADOVEHICULOes, "IDESTADOVEHICULO", "DESCRIPCION", vEHICULO.IDESTADOVEHICULO); ViewBag.IDMARCA = new SelectList(db.MARCAs, "IDMARCA", "DESCRIPCION", vEHICULO.IDMARCA); ViewBag.IDTIPOVEHICULO = new SelectList(db.TIPOVEHICULOes, "IDTIPOVEHICULO", "DESCRIPCION", vEHICULO.IDTIPOVEHICULO); return(View(vEHICULO)); }
public int crearVehiculo(String patente) { try { using (SRI con = new SRI()) { VEHICULO v = new VEHICULO(); v.ID_VEHICULO = retornarNuevoId(); v.PATENTE = patente; v.ID_TIPO_VEHICULO = 16; con.VEHICULO.AddObject(v); con.SaveChanges(); return((int)v.ID_VEHICULO); } } catch (Exception e) { return(0); } }
public bool guardar(String placa, String numero_puestos, String color, String valor_dia, int marca_id) { try { VEHICULO veh = new VEHICULO(); veh.PLACA = placa; veh.NPUERTAS = numero_puestos; veh.COLOR = color; veh.VALORDIA = valor_dia; veh.MARCA_ID = marca_id; db.VEHICULO.InsertOnSubmit(veh); db.SubmitChanges(); return(true); } catch (Exception ex) { return(false); } }
protected void grvCursoDetalle_RowCommand(object sender, GridViewCommandEventArgs e) { if (e.CommandName == "Jusveh") { bool lActivo = false; // string ldoc = txtNumero.Text.Trim(); int indice = Convert.ToInt32(e.CommandArgument); GridViewRow row = grvCursoDetalle.Rows[indice]; int id_pregunta = row.DataItemIndex; int lid = Convert.ToInt32(row.Cells[2].Text); VEHICULO vehiculo = da.VEHICULO.SingleOrDefault(x => x.VEH_ID == lid); lActivo = Convert.ToBoolean(vehiculo.VEH_ESTADO); if (lActivo) { lActivo = false; } else { lActivo = true; } vehiculo = da.VEHICULO.SingleOrDefault(x => x.VEH_ID == lid); vehiculo.VEH_ESTADO = lActivo; da.SubmitChanges(); listarAuto(); } if (e.CommandName == "EnviaMail") { int indice = Convert.ToInt32(e.CommandArgument); GridViewRow row = grvCursoDetalle.Rows[indice]; int id_pregunta = row.DataItemIndex; // int id = Convert.ToInt32(row.Cells[0].Text); int id = 0; string id1 = Convert.ToString(row.Cells[0].Text); string alumno = Convert.ToString(row.Cells[6].Text); string fatura = Convert.ToString(row.Cells[7].Text); string email = Convert.ToString(row.Cells[10].Text).ToLower(); /* enviarCorreo("*****@*****.**", alumno); * * lblMensaje.Visible = true; * lblMensaje.Text = "Se envío el mail a:" +alumno;*/ if (enviarCorreoHtml(alumno, email, fatura)) { ds.sp_abmRegistroNota_Con("ENVIADO", id, 0, "", "", "", "", 0, 0, 0, 0, false, 0, 0, 0, 0, false, 0, false, 0, false, 0, false, false, "", false, false, "", "", "", "", "", "", "", 0, "", 0, "", false, true); } } if (e.CommandName == "Confirmar") { lblMensaje.Text = "CONFIRMADO"; grvCursoDetalle.BackImageUrl = "~/images/iconos/45.ico"; int indice = Convert.ToInt32(e.CommandArgument); GridViewRow row = grvCursoDetalle.Rows[indice]; int id_pregunta = row.DataItemIndex; string alumno = Convert.ToString(row.Cells[6].Text); string fatura = Convert.ToString(row.Cells[7].Text); string email = Convert.ToString(row.Cells[10].Text).ToLower(); /* enviarCorreo("*****@*****.**", alumno); * * lblMensaje.Visible = true; * lblMensaje.Text = "Se envío el mail a:" +alumno;*/ /* enviarCorreoHtml(alumno, email, fatura);*/ } }
public void update(VEHICULO obj) { throw new NotImplementedException(); }
partial void DeleteVEHICULO(VEHICULO instance);
partial void UpdateVEHICULO(VEHICULO instance);
partial void InsertVEHICULO(VEHICULO instance);
private void detach_VEHICULO(VEHICULO entity) { this.SendPropertyChanging(); entity.SUCURSAL = null; }
private void attach_VEHICULO(VEHICULO entity) { this.SendPropertyChanging(); entity.SUCURSAL = this; }