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