public int AddPaso(smp_pasos sp)
{
int regs = 0;
try
{
using (var context = new MttoAppEntities())
{
context.smp_pasos.Add(sp);
regs = context.SaveChanges();
}
}
catch (DbEntityValidationException ee)
{
foreach (var eve in ee.EntityValidationErrors)
{
System.Windows.Forms.MessageBox.Show("Entity of type " + eve.Entry.Entity.GetType().Name
+ " in state " + eve.Entry.State + " has the following validation errors:");
foreach (var ve in eve.ValidationErrors)
{
System.Windows.Forms.MessageBox.Show("- Property: " + ve.PropertyName + ", Error: " + ve.ErrorMessage);
}
}
}
catch (Exception e)
{
MessageBox.Show("Excepción al agregar paso a paso: " + e.ToString(), "Atención", MessageBoxButton.OK, MessageBoxImage.Error);
}
return(regs);
}
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 AddEntryMtto(CalendarioPm cal)
{
int regs = 0;
try
{
using (var context = new MttoAppEntities())
{
context.calendarioPM.Add(new calendarioPM()
{
id_componente = cal.id_componente,
id_ewo = cal.id_ewo,
tipo_mantenimiento = cal.id_tipo_mtto,
semana = cal.semana,
year = cal.year,
observaciones = cal.observaciones,
user_id = cal.user_id,
creado = DateTime.Now
});
regs = context.SaveChanges();
}
}
catch (Exception e)
{
MessageBox.Show("Excepción al agregar entrada mtto: " + 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 AddPorque(porques porque)
{
int regs = 0;
try
{
using (var context = new MttoAppEntities())
{
context.porques.Add(porque);
regs = context.SaveChanges();
}
}
catch (Exception e)
{
MessageBox.Show("Excepción al agregar porque: " + e.ToString(), "Atención", MessageBoxButton.OK, MessageBoxImage.Error);
}
return(regs);
}
public int AddSmpUtil(smp_util smpU)
{
int res = 0;
try
{
using (var context = new MttoAppEntities())
{
context.smp_util.Add(smpU);
res = context.SaveChanges();
}
}
catch (Exception e)
{
MessageBox.Show("Excepción al agregar smp util: " + e.ToString(), "Atención", MessageBoxButton.OK, MessageBoxImage.Error);
}
return(res);
}
public int AddAccion(lista_acciones la)
{
int regs = 0;
try
{
using (var context = new MttoAppEntities())
{
context.lista_acciones.Add(la);
regs = context.SaveChanges();
}
}
catch (Exception e)
{
MessageBox.Show("Excepción al agregar lista de acciones: " + e.ToString(), "Atención", MessageBoxButton.OK, MessageBoxImage.Error);
}
return(regs);
}
public int AddPasoSop(sop_pasos sp)
{
int regs = 0;
try
{
using (var context = new MttoAppEntities())
{
context.sop_pasos.Add(sp);
regs = context.SaveChanges();
}
}
catch (Exception e)
{
MessageBox.Show("Excepción al agregar paso a paso sop: " + e.ToString(), "Atención", MessageBoxButton.OK, MessageBoxImage.Error);
}
return(regs);
}
public int AddRepuestoUtilizado(repuestos_utilizados ru)
{
int regs = 0;
try
{
using (var context = new MttoAppEntities())
{
context.repuestos_utilizados.Add(ru);
regs = context.SaveChanges();
}
}
catch (Exception e)
{
MessageBox.Show("Excepción al agregar repuestos utilizados: " + e.ToString(), "Atención", MessageBoxButton.OK, MessageBoxImage.Error);
}
return(regs);
}
public int DeleteComponentesByConjunto(int id_conjunto)
{
int regs = 0;
try
{
//1. Get row from DB
using (var context = new MttoAppEntities())
{
context.componentes.RemoveRange(context.componentes.Where(x => x.id_conjunto == id_conjunto));
context.SaveChanges();
}
}
catch (Exception e)
{
MessageBox.Show("Excepción al eliminar componente por conjunto: " + e.ToString(), "Atención", MessageBoxButton.OK, MessageBoxImage.Error);
}
return(regs);
}
public int AddComponente(Componentes comp)
{
int regs = 0;
try
{
using (var context = new MttoAppEntities())
{
context.componentes.Add(new componentes()
{
Id = comp.id,
codigo_fabricante = comp.codigo_fabricante,
codigo_sap = comp.codigo_sap,
clase = comp.clase,
descripcion = comp.descripcion,
ubicacion_almacen = comp.ubicacion_almacen,
proveedor = comp.proveedor,
estrategia_mtto = comp.codigo_estrategia_mtto,
id_smp = comp.id_smp,
duracion_estandar = comp.duracion_estandar,
estado_equipo = comp.estado_equipo,
frecuencia_pm = comp.frecuencia_pm,
tipo_frecuencia_pm = comp.tipo_frecuencia_pm,
estandar_am = comp.estandar_am,
frecuencia_am = comp.frecuencia_am,
tipo_frecuencia_am = comp.tipo_frecuencia_am,
n_matriz_qp = comp.n_matriz_qp,
n_matriz_qm = comp.n_matriz_qm,
n_kaizen = comp.n_kaizen,
tipo_kaizen = comp.tipo_kaizen,
image_path = comp.image_path,
id_conjunto = comp.id_conjunto,
smp_file = comp.smp_file
});
regs = context.SaveChanges();
}
}
catch (Exception e)
{
MessageBox.Show("Excepción al agregar componente: " + e.ToString(), "Atención", MessageBoxButton.OK, MessageBoxImage.Error);
}
return(regs);
}
public int AddSmp(smp smp)
{
int id = 0;
try
{
using (var context = new MttoAppEntities())
{
context.smp.Add(smp);
context.SaveChanges();
id = smp.Id;
}
}
catch (Exception e)
{
MessageBox.Show("Excepción al agregar smp: " + e.ToString(), "Atención", MessageBoxButton.OK, MessageBoxImage.Error);
}
return(id);
}
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 AddLine(lineas lin)
{
int regs = 0;
try
{
using (var context = new MttoAppEntities())
{
context.lineas.Add(new lineas()
{
id_planta = lin.id_planta, nombre = lin.nombre, image_path = lin.image_path
});
regs = context.SaveChanges();
}
}
catch (Exception e)
{
MessageBox.Show("Excepción al agregar línea: " + e.ToString(), "Atención", MessageBoxButton.OK, MessageBoxImage.Error);
}
return(regs);
}
public int AddMachine(Machines maq)
{
int regs = 0;
try
{
using (var context = new MttoAppEntities())
{
context.maquinas.Add(new maquinas()
{
id_planta = maq.id_planta, nombre = maq.nombre, foto_path = maq.foto, id_linea = maq.id_linea
});
regs = context.SaveChanges();
}
}
catch (Exception e)
{
MessageBox.Show("Excepción al agregar maquina: " + 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 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 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 AddSistema(Sistemas sis)
{
int regs = 0;
try
{
using (var context = new MttoAppEntities())
{
context.sistemas.Add(new sistemas()
{
id_maquina = sis.id_machine,
Nombre = sis.nombre,
image_path = sis.image_path
});
regs = context.SaveChanges();
}
}
catch (Exception e)
{
MessageBox.Show("Excepción al agregar sistema: " + e.ToString(), "Atención", MessageBoxButton.OK, MessageBoxImage.Error);
}
return(regs);
}
public int EditSmpComponents(Conjuntos cnt)
{
int regs = 0;
try
{
//1. Get row from DB
using (var context = new MttoAppEntities())
{
var come = context.componentes.Where(s => s.id_conjunto == cnt.id).ToList();
come.ForEach(x => x.id_smp = cnt.id_smp);
//context.Entry(come).State = System.Data.Entity.EntityState.Modified;
regs = context.SaveChanges();
}
}
catch (Exception e)
{
MessageBox.Show("Excepción al asignar SMP a todos los componentes: " + e.ToString(), "Atención", MessageBoxButton.OK, MessageBoxImage.Error);
}
return(regs);
}
public int AddTool(Herramientas herr)
{
int regs = 0;
try
{
using (var context = new MttoAppEntities())
{
context.herramientas.Add(new herramientas()
{
herramienta = herr.herramienta,
tipo = herr.tipo,
image_path = herr.imagen_name
});
regs = context.SaveChanges();
}
}
catch (Exception e)
{
MessageBox.Show("Excepción al agregar herramienta: " + 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);
}
public int AddConjunto(Conjuntos con)
{
int regs = 0;
try
{
using (var context = new MttoAppEntities())
{
context.conjuntos.Add(new conjuntos()
{
id_sistema = con.id_sistema,
nombre = con.nombre,
image_path = con.image_path,
id_smp = con.id_smp
});
regs = context.SaveChanges();
}
}
catch (Exception e)
{
MessageBox.Show("Excepción al agregar conjunto: " + e.ToString(), "Atención", MessageBoxButton.OK, MessageBoxImage.Error);
}
return(regs);
}