public int UpdateCalculoArquetipo(string codigo, string xmlOperation, double matRemoveWidth, double matRemoveThickness, double matRemoveDiameter, bool workGap, bool gapFixed, int idCalculoArquetipo)
{
try
{
using (var Conexion = new EntityOperaciones())
{
TBL_CALCULO_ARQUETIPO obj = Conexion.TBL_CALCULO_ARQUETIPO.Where(x => x.ID_CALCULO_ARQUETIPO == idCalculoArquetipo).FirstOrDefault();
obj.CODIGO = codigo;
obj.XML_OPERATION = xmlOperation;
obj.MAT_REMOVE_WIDTH = matRemoveWidth;
obj.MAT_REMOVE_THICKNESS = matRemoveThickness;
obj.MAT_REMOVE_DIAMETER = matRemoveDiameter;
obj.WORK_GAP = workGap;
obj.GAP_FIXED = gapFixed;
Conexion.Entry(obj).State = EntityState.Modified;
return(Conexion.SaveChanges());
}
}
catch (Exception)
{
throw;
}
}
public IList GetAllArquetipoCalculo()
{
try
{
using (var Conexion = new EntityOperaciones())
{
var lista = (from a in Conexion.Arquetipo
join b in Conexion.TBL_CALCULO_ARQUETIPO on a.Codigo equals b.CODIGO
join c in Conexion.TBL_CALCULO_DETALLE on a.Codigo equals c.CODIGO
where a.Activo == true
select new
{
a.Codigo,
a.DescripcionGeneral,
a.Activo
}).Distinct();
return(lista.ToList());
}
}
catch (Exception)
{
throw;
}
}
public int InsertCalculoArquetipo(string codigo, string xmlOperation, double matRemoveWidth, double matRemoveThickness, double matRemoveDiameter, bool workGap, bool gapFixed)
{
try
{
using (var Conexion = new EntityOperaciones())
{
TBL_CALCULO_ARQUETIPO obj = new TBL_CALCULO_ARQUETIPO();
obj.CODIGO = codigo;
obj.XML_OPERATION = xmlOperation;
obj.MAT_REMOVE_WIDTH = matRemoveWidth;
obj.MAT_REMOVE_THICKNESS = matRemoveThickness;
obj.MAT_REMOVE_DIAMETER = matRemoveDiameter;
obj.WORK_GAP = workGap;
obj.GAP_FIXED = gapFixed;
Conexion.TBL_CALCULO_ARQUETIPO.Add(obj);
return(Conexion.SaveChanges());
}
}
catch (Exception)
{
throw;
}
}
public IList GetAllOperaciones()
{
try
{
using (var Conexion = new EntityOperaciones())
{
var Lista = (from a in Conexion.OperacionesRouter
select a).ToList();
return(Lista);
}
}
catch (Exception)
{
return(null);
}
}
public int DeleteCalculoDetalle(int idCalculoDetalle)
{
try
{
using (var Conexion = new EntityOperaciones())
{
TBL_CALCULO_DETALLE obj = Conexion.TBL_CALCULO_DETALLE.Where(x => x.ID_CALCULO_DETALLE == idCalculoDetalle).FirstOrDefault();
Conexion.Entry(obj).State = EntityState.Deleted;
return(Conexion.SaveChanges());
}
}
catch (Exception)
{
throw;
}
}
public int DeleteCalculoArquetipo(int idCalculoArquetipo)
{
try
{
using (var Conexion = new EntityOperaciones())
{
TBL_CALCULO_ARQUETIPO obj = Conexion.TBL_CALCULO_ARQUETIPO.Where(x => x.ID_CALCULO_ARQUETIPO == idCalculoArquetipo).FirstOrDefault();
Conexion.Entry(obj).State = EntityState.Deleted;
return(Conexion.SaveChanges());
}
}
catch (Exception)
{
throw;
}
}
public int UpdateCalculoDetalle(string codigo, double ringWidth, double ringThickness, double ringDiameter, double ringGap, int idCalculoDetalle)
{
try
{
using (var Conexion = new EntityOperaciones())
{
TBL_CALCULO_DETALLE obj = Conexion.TBL_CALCULO_DETALLE.Where(x => x.ID_CALCULO_DETALLE == idCalculoDetalle).FirstOrDefault();
obj.CODIGO = codigo;
obj.RING_WIDTH = ringWidth;
obj.RING_THICKNESS = ringThickness;
obj.RING_DIAMETER = ringDiameter;
obj.RING_GAP = ringGap;
Conexion.Entry(obj).State = EntityState.Modified;
return(Conexion.SaveChanges());
}
}
catch (Exception)
{
throw;
}
}
public int InsertCalculoDetalle(string codigo, double ringWidth, double ringThickness, double ringDiameter, double ringGap)
{
try
{
using (var Conexion = new EntityOperaciones())
{
TBL_CALCULO_DETALLE obj = new TBL_CALCULO_DETALLE();
obj.CODIGO = codigo;
obj.RING_WIDTH = ringWidth;
obj.RING_THICKNESS = ringThickness;
obj.RING_DIAMETER = ringDiameter;
obj.RING_GAP = ringGap;
Conexion.TBL_CALCULO_DETALLE.Add(obj);
return(Conexion.SaveChanges());
}
}
catch (Exception)
{
throw;
}
}