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