public void ActualizaPeriodo(int BusinessUnit, int Periodo, int Estado, string Usuario)
{
using (SIACModeloDataContext dbContext = new SIACModeloDataContext())
{
dbContext.spUpdPeriodo(BusinessUnit, Periodo, Estado, Usuario);
}
}
public void GuardaConfiguracionSistema(int BusinessUnit, int SistemaId, string Proceso, string SourceId, string ApplJrnlId, string Source)
{
using (SIACModeloDataContext dbContext = new SIACModeloDataContext())
{
dbContext.spUpdConfiguracionSistema(BusinessUnit, SistemaId, Proceso, SourceId, ApplJrnlId, Source);
}
}
public SistemaObj AgregaSistema(SistemaObj sistema)
{
SistemaObj sistemaObj = null;
using (SIACModeloDataContext dbContext = new SIACModeloDataContext())
{
var sistemaAgregado = dbContext.spInsSistema(sistema.idSistema, sistema.Nombre);
foreach (var sys in sistemaAgregado)
{
sistemaObj = new SistemaObj()
{
idSistema = sys.idSistema,
Nombre = sys.Nombre
};
}
}
return(sistemaObj);
}
public BusinessEntities.Moneda AgregaMoneda(BusinessEntities.Moneda moneda)
{
BusinessEntities.Moneda monedaObj = null;
using (SIACModeloDataContext dbContext = new SIACModeloDataContext())
{
var monedas = dbContext.spInsMoneda(moneda.cveMoneda, moneda.Nombre);
foreach (var mon in monedas)
{
monedaObj = new BusinessEntities.Moneda()
{
idMoneda = mon.idMoneda,
Nombre = mon.Nombre,
cveMoneda = mon.cveMoneda
};
}
}
return(monedaObj);
}
public BusinessUnitObj ActualizaBusinessUnit(BusinessUnitObj businessUnit)
{
BusinessUnitObj buObj = null;
using (SIACModeloDataContext dbContext = new SIACModeloDataContext())
{
var bus = dbContext.spUpdBusinessUnit(businessUnit.BusinessUnit, businessUnit.Name, businessUnit.Currency, businessUnit.BusinessUnitPS);
foreach (var bu in bus)
{
buObj = new BusinessUnitObj()
{
BusinessUnit = int.Parse(bu.Code),
Name = bu.Name,
Currency = bu.Currency_Code,
BusinessUnitPS = bu.BusinessUnitPS.GetValueOrDefault(0)
};
}
}
return(buObj);
}
public List <BusinessEntities.Plaza> ObtienePlazas(int idPlaza)
{
List <BusinessEntities.Plaza> lstPlaza = new List <BusinessEntities.Plaza>();
BusinessEntities.Plaza plObj = null;
using (SIACModeloDataContext dbContext = new SIACModeloDataContext())
{
var plazas = dbContext.spSelPlaza(idPlaza);
foreach (var pl in plazas)
{
plObj = new BusinessEntities.Plaza()
{
IdPlaza = pl.idPlaza,
Descripcion = pl.Descripcion
};
lstPlaza.Add(plObj);
}
}
return(lstPlaza);
}
public List <BusinessEntities.SistemaObj> obtenerSistemas()
{
List <BusinessEntities.SistemaObj> lstSistema = new List <BusinessEntities.SistemaObj>();
BusinessEntities.SistemaObj sistemaObj = null;
using (SIACModeloDataContext dbContext = new SIACModeloDataContext())
{
var sistemas = dbContext.spSelSistemas();
foreach (var sis in sistemas)
{
sistemaObj = new SistemaObj()
{
idSistema = sis.idSistema,
Nombre = sis.Nombre
};
lstSistema.Add(sistemaObj);
}
}
return(lstSistema);
}
public SourceSistemaObj ObtieneSourceSistema(int BusinessUnit, int SistemaId)
{
SourceSistemaObj sourceObj = null;
using (SIACModeloDataContext dbContext = new SIACModeloDataContext())
{
var sourceDB = dbContext.spSelSourceApplJrnl(BusinessUnit, SistemaId);
foreach (var conf in sourceDB)
{
sourceObj = new SourceSistemaObj()
{
BusinessUnit = int.Parse(conf.BusinessUnit),
SistemaId = conf.idSistema,
SourceId = conf.SourceId.Trim(),
ApplJrnlId = conf.Appl_Jrnl_Id.Trim(),
Source = conf.Source.Trim()
};
}
}
return(sourceObj);
}
public List <BusinessEntities.Moneda> ObtieneMonedas()
{
List <BusinessEntities.Moneda> lstMonedas = new List <BusinessEntities.Moneda>();
BusinessEntities.Moneda monedaObj = null;
using (SIACModeloDataContext dbContext = new SIACModeloDataContext())
{
var monedas = dbContext.spSelMonedas();
foreach (var moneda in monedas)
{
monedaObj = new BusinessEntities.Moneda()
{
idMoneda = moneda.idMoneda,
Nombre = moneda.Nombre,
cveMoneda = moneda.cveMoneda
};
lstMonedas.Add(monedaObj);
}
}
return(lstMonedas);
}
public List <BusinessEntities.TipoCambio> ObtieneTipoCambio(int BusinessUnit, int Anio, int Mes, int Tipo, String Moneda)
{
List <BusinessEntities.TipoCambio> lstTipoCambio = new List <BusinessEntities.TipoCambio>();
BusinessEntities.TipoCambio tcObj = null;
using (SIACModeloDataContext dbContext = new SIACModeloDataContext())
{
var tiposcambio = dbContext.spSelTipoCambio(BusinessUnit, Anio, Mes, Tipo, Moneda);
foreach (var tc in tiposcambio)
{
tcObj = new BusinessEntities.TipoCambio()
{
BusinessUnit = Convert.ToInt32(tc.BusinessUnit),
Fecha = tc.ExchangeRateDate,
TipoCambioValor = tc.ExchangeRate.GetValueOrDefault(0),
FechaModificacion = tc.LastModified.GetValueOrDefault(DateTime.MinValue)
};
lstTipoCambio.Add(tcObj);
}
}
return(lstTipoCambio);
}
public List <BusinessEntities.BusinessUnitObj> GetBusinessUnits()
{
List <BusinessEntities.BusinessUnitObj> lstBU = new List <BusinessEntities.BusinessUnitObj>();
BusinessEntities.BusinessUnitObj buObj = null;
using (SIACModeloDataContext dbContext = new SIACModeloDataContext())
{
var bus = dbContext.spSelBusinessUnits();
foreach (var bu in bus)
{
buObj = new BusinessUnitObj()
{
BusinessUnit = bu.BusinessUnit,
Name = bu.Name,
Currency = bu.Currency,
BusinessUnitPS = bu.BusinessUnitPS
};
lstBU.Add(buObj);
}
}
return(lstBU);
}
public List <ConfiguracionSistemaObj> ObtieneConfiguracionSistema(int BusinessUnit, int SistemaId)
{
List <ConfiguracionSistemaObj> lstConfiguraciones = new List <ConfiguracionSistemaObj>();
ConfiguracionSistemaObj configuracionObj = null;
using (SIACModeloDataContext dbContext = new SIACModeloDataContext())
{
var configuracionDB = dbContext.spSelConfiguracionSistema(BusinessUnit, SistemaId);
foreach (var conf in configuracionDB)
{
configuracionObj = new ConfiguracionSistemaObj()
{
BusinessUnit = conf.BusinessUnit.GetValueOrDefault(0),
SistemaId = conf.SistemaId.GetValueOrDefault(0),
Configuracion = conf.Configuracion.Trim(),
Valor = conf.Valor.Trim(),
Descripcion = conf.Descripcion.Trim()
};
lstConfiguraciones.Add(configuracionObj);
}
}
return(lstConfiguraciones);
}
public List <BusinessEntities.Periodo> ObtienePeriodos(int BusinessUnit, int Anio)
{
List <BusinessEntities.Periodo> lstPeriodo = new List <BusinessEntities.Periodo>();
BusinessEntities.Periodo perObj = null;
using (SIACModeloDataContext dbContext = new SIACModeloDataContext())
{
var periodos = dbContext.spSelPeriodos(BusinessUnit, Anio);
foreach (var per in periodos)
{
perObj = new BusinessEntities.Periodo()
{
BusinessUnit = per.BusinessUnit,
PeriodoId = per.idPeriodo,
EstadoId = per.idEstado.GetValueOrDefault(),
FechaModificacion = per.FechaModificacion,
UsuarioModificacion = per.UsuarioModificacion
};
lstPeriodo.Add(perObj);
}
}
return(lstPeriodo);
}
