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