public int DeleteEntry(CalendarioPm cal)
{
calendarioPM cald;
int regs = 0;
try
{
//1. Get row from DB
using (var context = new MttoAppEntities())
{
cald = context.calendarioPM.Where(s => s.Id == cal.id).FirstOrDefault();
}
//save modified entity using new Context
using (var context = new MttoAppEntities())
{
//3. Mark entity as deleted
context.Entry(cald).State = System.Data.Entity.EntityState.Deleted;
//4. call SaveChanges
regs = context.SaveChanges();
}
}
catch (Exception e)
{
MessageBox.Show("Excepción al eliminar Entrada (CalPM): " + e.ToString(), "Atención", MessageBoxButton.OK, MessageBoxImage.Error);
}
return(regs);
}
public int EditComponente(Componentes com)
{
componentes come;
int regs = 0;
try
{
//1. Get row from DB
using (var context = new MttoAppEntities())
{
come = context.componentes.Where(s => s.Id == com.id).FirstOrDefault();
}
//2. change data in disconnected mode (out of ctx scope)
if (come != null)
{
come.codigo_fabricante = com.codigo_fabricante;
come.codigo_sap = com.codigo_sap;
come.descripcion = com.descripcion;
come.ubicacion_almacen = com.ubicacion_almacen;
come.clase = com.clase;
come.proveedor = com.proveedor;
come.estrategia_mtto = com.codigo_estrategia_mtto;
come.id_smp = com.id_smp;
come.frecuencia_pm = com.frecuencia_pm;
come.tipo_frecuencia_pm = com.tipo_frecuencia_pm;
come.duracion_estandar = com.duracion_estandar;
come.estado_equipo = com.estado_equipo;
come.estandar_am = com.estandar_am;
come.frecuencia_am = com.frecuencia_am;
come.tipo_frecuencia_am = com.tipo_frecuencia_am;
come.n_matriz_qp = com.n_matriz_qp;
come.n_matriz_qm = com.n_matriz_qm;
come.tipo_kaizen = com.tipo_kaizen;
come.n_kaizen = com.n_kaizen;
come.image_path = com.image_path;
come.id_conjunto = com.id_conjunto;
come.smp_file = com.smp_file;
}
//save modified entity using new Context
using (var context = new MttoAppEntities())
{
//3. Mark entity as modified
context.Entry(come).State = System.Data.Entity.EntityState.Modified;
//4. call SaveChanges
regs = context.SaveChanges();
}
}
catch (Exception e)
{
MessageBox.Show("Excepción al editar componente: " + e.ToString(), "Atención", MessageBoxButton.OK, MessageBoxImage.Error);
}
return(regs);
}
public int EditEntry(CalendarioPm cal)
{
calendarioPM cale;
int regs = 0;
try
{
//1. Get row from DB
using (var context = new MttoAppEntities())
{
cale = context.calendarioPM.Where(s => s.Id == cal.id).FirstOrDefault();
}
//2. change data in disconnected mode (out of ctx scope)
if (cale != null)
{
cale.id_componente = cal.id_componente;
cale.id_ewo = cal.id_ewo;
cale.tipo_mantenimiento = cal.id_tipo_mtto;
cale.semana = cal.semana;
cale.year = cal.year;
cale.observaciones = cal.observaciones;
}
//save modified entity using new Context
using (var context = new MttoAppEntities())
{
//3. Mark entity as modified
context.Entry(cale).State = System.Data.Entity.EntityState.Modified;
//4. call SaveChanges
regs = context.SaveChanges();
}
}
catch (Exception e)
{
MessageBox.Show("Excepción al editar entrada (CalPM): " + e.ToString(), "Atención", MessageBoxButton.OK, MessageBoxImage.Error);
}
return(regs);
}
public int EditConjunto(Conjuntos con)
{
conjuntos conje;
int regs = 0;
try
{
//1. Get row from DB
using (var context = new MttoAppEntities())
{
conje = context.conjuntos.Where(s => s.Id == con.id).FirstOrDefault();
}
//2. change data in disconnected mode (out of ctx scope)
if (conje != null)
{
conje.nombre = con.nombre;
conje.image_path = con.image_path;
conje.id_sistema = con.id_sistema;
conje.id_smp = con.id_smp;
}
//save modified entity using new Context
using (var context = new MttoAppEntities())
{
//3. Mark entity as modified
context.Entry(conje).State = System.Data.Entity.EntityState.Modified;
//4. call SaveChanges
regs = context.SaveChanges();
}
}
catch (Exception e)
{
MessageBox.Show("Excepción al editar conjunto: " + e.ToString(), "Atención", MessageBoxButton.OK, MessageBoxImage.Error);
}
return(regs);
}
public int EditTecnico(tecnicos tec)
{
tecnicos tece;
int regs = 0;
try
{
//1. Get row from DB
using (var context = new MttoAppEntities())
{
tece = context.tecnicos.Where(s => s.Id == tec.Id).FirstOrDefault();
}
//2. change data in disconnected mode (out of ctx scope)
if (tece != null)
{
tece.usuario = tec.usuario;
tece.password = tec.password;
tece.id_rol = tec.id_rol;
tece.activo = tec.activo;
}
//save modified entity using new Context
using (var context = new MttoAppEntities())
{
//3. Mark entity as modified
context.Entry(tece).State = System.Data.Entity.EntityState.Modified;
//4. call SaveChanges
regs = context.SaveChanges();
}
}
catch (Exception e)
{
MessageBox.Show("Excepción al editar técnico: " + e.ToString(), "Atención", MessageBoxButton.OK, MessageBoxImage.Error);
}
return(regs);
}
public int EditLinea(lineas lin)
{
lineas line;
int regs = 0;
try
{
//1. Get row from DB
using (var context = new MttoAppEntities())
{
line = context.lineas.Where(s => s.id == lin.id).FirstOrDefault();
}
//2. change data in disconnected mode (out of ctx scope)
if (line != null)
{
line.nombre = lin.nombre;
line.image_path = lin.image_path;
line.id_planta = lin.id_planta;
}
//save modified entity using new Context
using (var context = new MttoAppEntities())
{
//3. Mark entity as modified
context.Entry(line).State = System.Data.Entity.EntityState.Modified;
//4. call SaveChanges
regs = context.SaveChanges();
}
}
catch (Exception e)
{
MessageBox.Show("Excepción al editar linea: " + e.ToString(), "Atención", MessageBoxButton.OK, MessageBoxImage.Error);
}
return(regs);
}
public int DeleteConjunto(Conjuntos con)
{
conjuntos cond;
int regs = 0;
try
{
//1. Get row from DB
using (var context = new MttoAppEntities())
{
cond = context.conjuntos.Where(s => s.Id == con.id).FirstOrDefault();
}
//save modified entity using new Context
using (var context = new MttoAppEntities())
{
//3. Mark entity as deleted
context.Entry(cond).State = System.Data.Entity.EntityState.Deleted;
//4. call SaveChanges
regs = context.SaveChanges();
if (regs > 0)
{
//BORRAR IMAGEN
File.Delete(Global.DIRECTORIO_IMAGENES + @"\" + cond.image_path);
}
}
//BORRAR COMPONENTES DEL CONJUNTO
DeleteComponentesByConjunto(con.id);
}
catch (Exception e)
{
MessageBox.Show("Excepción al eliminar conjunto: " + e.ToString(), "Atención", MessageBoxButton.OK, MessageBoxImage.Error);
}
return(regs);
}
public int EditSistema(Sistemas sis)
{
sistemas sise;
int regs = 0;
try
{
//1. Get row from DB
using (var context = new MttoAppEntities())
{
sise = context.sistemas.Where(s => s.Id == sis.id).FirstOrDefault();
}
//2. change data in disconnected mode (out of ctx scope)
if (sise != null)
{
sise.Nombre = sis.nombre;
sise.image_path = sis.image_path;
sise.id_maquina = sis.id_machine;
}
//save modified entity using new Context
using (var context = new MttoAppEntities())
{
//3. Mark entity as modified
context.Entry(sise).State = System.Data.Entity.EntityState.Modified;
//4. call SaveChanges
regs = context.SaveChanges();
}
}
catch (Exception e)
{
MessageBox.Show("Excepción al editar sistema: " + e.ToString(), "Atención", MessageBoxButton.OK, MessageBoxImage.Error);
}
return(regs);
}
public int EditMaquina(Machines maq)
{
maquinas maqe;
int regs = 0;
try
{
//1. Get row from DB
using (var context = new MttoAppEntities())
{
maqe = context.maquinas.Where(s => s.Id == maq.id).FirstOrDefault();
}
//2. change data in disconnected mode (out of ctx scope)
if (maqe != null)
{
maqe.nombre = maq.nombre;
maqe.foto_path = maq.foto;
maqe.id_linea = maq.id_linea;
}
//save modified entity using new Context
using (var context = new MttoAppEntities())
{
//3. Mark entity as modified
context.Entry(maqe).State = System.Data.Entity.EntityState.Modified;
//4. call SaveChanges
regs = context.SaveChanges();
}
}
catch (Exception e)
{
MessageBox.Show("Excepción al editar maquina: " + e.ToString(), "Atención", MessageBoxButton.OK, MessageBoxImage.Error);
}
return(regs);
}
public int DeleteSistema(Sistemas sis)
{
sistemas sisd;
int regs = 0;
try
{
//1. Get row from DB
using (var context = new MttoAppEntities())
{
sisd = context.sistemas.Where(s => s.Id == sis.id).FirstOrDefault();
}
//save modified entity using new Context
using (var context = new MttoAppEntities())
{
//3. Mark entity as deleted
context.Entry(sisd).State = System.Data.Entity.EntityState.Deleted;
//4. call SaveChanges
regs = context.SaveChanges();
if (regs > 0)
{
//BORRAR IMAGEN
File.Delete(Global.DIRECTORIO_IMAGENES + @"\" + sisd.image_path);
}
}
}
catch (Exception e)
{
MessageBox.Show("Excepción al eliminar sistema: " + e.ToString(), "Atención", MessageBoxButton.OK, MessageBoxImage.Error);
}
return(regs);
}
public int EditPaso(PasoaPaso sp)
{
smp_pasos spe;
int regs = 0;
try
{
//1. Get row from DB
using (var context = new MttoAppEntities())
{
spe = context.smp_pasos.Where(s => s.Id == sp.Id).FirstOrDefault();
}
//2. change data in disconnected mode (out of ctx scope)
if (spe != null)
{
spe.id_smp = sp.id_smp;
}
//save modified entity using new Context
using (var context = new MttoAppEntities())
{
//3. Mark entity as modified
context.Entry(spe).State = System.Data.Entity.EntityState.Modified;
//4. call SaveChanges
regs = context.SaveChanges();
}
}
catch (Exception e)
{
MessageBox.Show("Excepción al editar paso a paso: " + e.ToString(), "Atención", MessageBoxButton.OK, MessageBoxImage.Error);
}
return(regs);
}
public int EditRep(Repuestos rep)
{
repuestos_utilizados repe;
int regs = 0;
try
{
//1. Get row from DB
using (var context = new MttoAppEntities())
{
repe = context.repuestos_utilizados.Where(s => s.Id == rep.Id).FirstOrDefault();
}
//2. change data in disconnected mode (out of ctx scope)
if (repe != null)
{
repe.image_path = rep.imagen_name;
}
//save modified entity using new Context
using (var context = new MttoAppEntities())
{
//3. Mark entity as modified
context.Entry(repe).State = System.Data.Entity.EntityState.Modified;
//4. call SaveChanges
regs = context.SaveChanges();
}
}
catch (Exception e)
{
MessageBox.Show("Excepción al editar repuesto: " + e.ToString(), "Atención", MessageBoxButton.OK, MessageBoxImage.Error);
}
return(regs);
}