public int CallProcedureInformarEjecucion(int?id, string mensaje, ObjectParameter error) { using (CalicoEntities context = new CalicoEntities()) { return(context.INTERFAZ_InformarEjecucion(id, mensaje, error)); } }
public List <tblInformePedido> FindInformes(String emplazamiento, String[] almacenes, String[] tipos, int tipoProceso) { try { using (CalicoEntities context = new CalicoEntities()) { var query = (from R in context.tblInformePedido join P in context.tblProceso on R.ipec_proc_id equals P.proc_id //where R.ipec_proc_id == tipoProceso JHV where P.proc_tipoProceso == tipoProceso && R.ipec_emplazamiento == emplazamiento && almacenes.Contains(R.ipec_almacen) && tipos.Contains(R.ipec_tipo) select R).Include(D => D.tblInformePedidoDetalle); Console.WriteLine("Query: " + @"(from R in context.tblInformePedido join P in context.tblProceso on R.ipec_proc_id equals P.proc_id where P.proc_tipoProceso == tipoProceso && R.ipec_emplazamiento == emplazamiento && almacenes.Contains(R.ipec_almacen) && tipos.Contains(R.ipec_tipo) select R).Include(D => D.tblInformePedidoDetalle)"); return(query.ToList <tblInformePedido>()); } } catch (Exception e) { Console.WriteLine(e.Message); } return(null); }
public int CallProcedure(int?tipoProceso, int?tipoMensaje) { using (CalicoEntities context = new CalicoEntities()) { return(context.INTERFAZ_CrearProceso(tipoProceso, tipoMensaje)); } }
public bool Save(tblProducto obj) { using (CalicoEntities context = new CalicoEntities()) { try { context.tblProducto.Add(obj); context.SaveChanges(); } catch (DbEntityValidationException e) { foreach (var eve in e.EntityValidationErrors) { foreach (var ve in eve.ValidationErrors) { Console.Error.WriteLine("- Property: \"{0}\", Error: \"{1}\"", ve.PropertyName, ve.ErrorMessage); } } return(false); } catch (DbUpdateException dbe) { Console.WriteLine("Error insertando el producto: " + dbe.Message); } catch (Exception ee) { Console.WriteLine("Error desconocido insertando el producto: " + ee.Message); } return(true); } }
public int CallProcedureArchivarInformePedido(int?id, ObjectParameter error) { using (CalicoEntities context = new CalicoEntities()) { return(context.INTERFAZ_ArchivarInformePedido(id, error)); } }
public BIANCHI_PROCESS FindById(int id) { using (CalicoEntities entities = new CalicoEntities()) { return(entities.BIANCHI_PROCESS.Find(id)); } }
/// <summary> /// Verifica que no se haya procesado esta recepcion con anterioridad /// </summary> /// <param name="emplaz"></param> /// <param name="alm"></param> /// <param name="cod"></param> /// <param name="numero"></param> /// <returns>Retorna TRUE si ya fue procesada esta Recepcion</returns> public bool IsAlreadyProcess(String emplaz, String alm, String cod, String numero) { using (CalicoEntities context = new CalicoEntities()) { int count = context.tblRecepcion .Where(x => x.recc_emplazamiento == emplaz && x.recc_almacen == alm && x.recc_trec_codigo == cod && x.recc_numero == numero) .Count <tblRecepcion>(); if (count == 0) { count += context.tblHistoricoRecepcion .Where(x => x.hrec_emplazamiento == emplaz && x.hrec_almacen == alm && x.hrec_trec_codigo == cod && x.hrec_numero == numero) .Count <tblHistoricoRecepcion>(); } else { return(true); } return(count > 0); } }
public DbSet <BIANCHI_PROCESS> FindAll() { using (CalicoEntities context = new CalicoEntities()) { return(context.Set <BIANCHI_PROCESS>()); } }
public tblSubCliente FindById(int id) { using (CalicoEntities context = new CalicoEntities()) { return(context.tblSubCliente.Find(id)); } }
public List <tblInformeRecepcion> FindInformes(String emplazamiento, String[] almacenes, String[] tipos) { try { using (CalicoEntities context = new CalicoEntities()) { var query = (from R in context.tblInformeRecepcion where R.irec_emplazamiento == emplazamiento && almacenes.Contains(R.irec_almacen) && tipos.Contains(R.irec_tipo) select R).Include(D => D.tblInformeRecepcionDetalle); Console.WriteLine("Query: (from R in context.tblInformeRecepcion" + "where R.irec_emplazamiento == emplazamiento " + "&& almacenes.Contains(R.irec_almacen) " + "&& tipos.Contains(R.irec_tipo) " + "select R).Include(D => D.tblInformeRecepcionDetalle);"); return(query.ToList <tblInformeRecepcion>()); } } catch (Exception e) { Console.WriteLine(e.Message); } return(null); }
public int CallProcedureArchivarInformeRecepcion(Nullable <int> id, ObjectParameter error) { using (CalicoEntities context = new CalicoEntities()) { return(context.INTERFAZ_ArchivarInformeRecepcion(id, error)); } }
public DateTime?getProcessDate(string interfaz) { using (CalicoEntities context = new CalicoEntities()) { var result = context.BIANCHI_PROCESS.Where(bp => bp.interfaz == interfaz).FirstOrDefault <BIANCHI_PROCESS>(); return(result.fecha_ultima); } }
public DbSet <tblSubCliente> FindAll() { using (CalicoEntities context = new CalicoEntities()) { /* Obtengo todos los registros de la tabla de esta manera */ var rows = context.Set <tblSubCliente>(); return(rows); } }
public bool Save(tblSubCliente obj) { using (CalicoEntities context = new CalicoEntities()) { context.tblSubCliente.Add(obj); context.SaveChanges(); } return(true); }
public BIANCHI_PROCESS findByName(string interfaz) { using (CalicoEntities context = new CalicoEntities()) { var query = from BP in context.BIANCHI_PROCESS where BP.interfaz == interfaz select BP; return(query.FirstOrDefault <BIANCHI_PROCESS>()); } }
public void Delete(int id) { using (CalicoEntities context = new CalicoEntities()) { tblSubCliente obj = new tblSubCliente { subc_proc_id = id }; context.tblSubCliente.Attach(obj); context.tblSubCliente.Remove(obj); context.SaveChanges(); } }
public void Delete(int id) { using (CalicoEntities context = new CalicoEntities()) { BIANCHI_PROCESS obj = new BIANCHI_PROCESS { id = id }; context.BIANCHI_PROCESS.Attach(obj); context.BIANCHI_PROCESS.Remove(obj); context.SaveChanges(); } }
public bool validarSiPuedoProcesar(string interfaz) { using (CalicoEntities context = new CalicoEntities()) { var result = context.BIANCHI_PROCESS.Where(bp => bp.interfaz == interfaz).FirstOrDefault <BIANCHI_PROCESS>(); if (result == null) { return(true); } return(!Constants.ESTADO_EN_CURSO.Equals(result.estado)); } }
public void Update(BIANCHI_PROCESS obj) { using (CalicoEntities context = new CalicoEntities()) { var result = context.BIANCHI_PROCESS.Find(obj.id); if (result == null) { return; } context.Entry(result).CurrentValues.SetValues(obj); context.SaveChanges(); } }
public void Update(tblSubCliente obj) { using (CalicoEntities context = new CalicoEntities()) { var result = context.tblSubCliente.Find(obj.subc_proc_id); if (result == null) { return; } context.Entry(result).CurrentValues.SetValues(obj); context.SaveChanges(); } }
public bool Save(BIANCHI_PROCESS obj) { try { using (CalicoEntities context = new CalicoEntities()) { context.BIANCHI_PROCESS.Add(obj); context.SaveChanges(); } } catch (Exception e) { Console.WriteLine(e.Message); return(false); } return(true); }
public bool Save(tblSubCliente obj) { try { using (CalicoEntities context = new CalicoEntities()) { context.tblSubCliente.Add(obj); context.SaveChanges(); } } catch (Exception e) { Console.WriteLine(e.Message); return(false); } return(true); }
public bool updateEnCurso(string interfaz) { using (CalicoEntities context = new CalicoEntities()) { var query = from BP in context.BIANCHI_PROCESS where BP.interfaz == interfaz select BP; var result = query.FirstOrDefault <BIANCHI_PROCESS>(); if (result == null) { return(false); } result.estado = Constants.ESTADO_EN_CURSO; context.Entry(result); context.SaveChanges(); return(true); } }
public bool IsAlreadyProcess(String alm, String tipo, String letra, String sucursal, decimal numero) { using (CalicoEntities context = new CalicoEntities()) { bool existTblPedido = context.tblPedido.Any((x => x.pedc_almacen == alm && x.pedc_tped_codigo == tipo && x.pedc_letra == letra && x.pedc_sucursal == sucursal && x.pedc_numero == numero)); bool existTblHistPedido = context.tblHistoricoPedido.Any((x => x.hpec_almacen == alm && x.hpec_tped_codigo == tipo && x.hpec_letra == letra && x.hpec_sucursal == sucursal && x.hpec_numero == numero)); return(existTblPedido || existTblHistPedido); } }
public void LockRow(int id) { this.entity = new CalicoEntities(); this.scope = this.entity.Database.BeginTransaction(); this.entity.Database.ExecuteSqlCommand("SELECT * FROM BIANCHI_PROCESS WITH (ROWLOCK, UPDLOCK) where id = " + id); }