public AppResponse MantenimientoHistorico(List <IndicadorDetalleHistoricoLogic> listaIndicadorDetalle, List <VariableFormulaHistoricoLogic> listaVariables, string accion)
{
try
{
DataTable dtIndicadorDetalle = new DataTable();
DataTable dtVariableFormula = new DataTable();
List <IndicadorDetalleHistorico> listaEntidadIndicadorDetalle = listaIndicadorDetalle.Cast <IndicadorDetalleHistorico>().ToList();
List <VariableFormulaHistorico> listaEntidadVariableFormula = listaVariables.Cast <VariableFormulaHistorico>().ToList();
dtIndicadorDetalle = Util.ConvertListToDatatable(listaEntidadIndicadorDetalle);
dtVariableFormula = Util.ConvertListToDatatable(listaEntidadVariableFormula);
SQLServer.OpenConection();
SQLServer.CreateCommand("MOV.USP_MANT_INDICADOR_DETALLE_HISTORICO", CommandType.StoredProcedure,
SQLServer.CreateParameter("ACCION", SqlDbType.VarChar, accion),
SQLServer.CreateParameter("VARIABLE_FORMULA_HISTORICO_TYPE", SqlDbType.Structured, dtVariableFormula),
SQLServer.CreateParameter("INDICADOR_DETALLE_HISTORICO_TYPE", SqlDbType.Structured, dtIndicadorDetalle));
using (IDataReader oReader = SQLServer.GetDataReader(CommandBehavior.CloseConnection))
{
oResponse = new GenericInstance <AppResponse>().readDataReader(oReader);
}
}
catch (Exception ex)
{
oResponse.SetException(string.Format("{ 0}: { 1}.", System.AppDomain.CurrentDomain.FriendlyName, ex.Message));
}
return(oResponse);
}
public AppResponse Mantenimiento(List <IndicadorDetalleLogic> lista, List <VariableFormulaLogic> listaFormula, string accion)
{
try
{
DataTable dt = new DataTable();
DataTable dtVariableFormula = new DataTable();
List <IndicadorDetalle> listEntidad = lista.Cast <IndicadorDetalle>().ToList();
List <VariableFormula> listaVariableFormula = listaFormula.Cast <VariableFormula>().ToList();
dt = Util.ConvertListToDatatable(listEntidad);
dtVariableFormula = Util.ConvertListToDatatable(listaVariableFormula);
SQLServer.OpenConection();
SQLServer.CreateCommand("MOV.USP_MANT_INDICADOR_DETALLE", CommandType.StoredProcedure,
SQLServer.CreateParameter("ACCION", SqlDbType.VarChar, accion),
SQLServer.CreateParameter("INDICADOR_DETALLE_TYPE", SqlDbType.Structured, dt),
SQLServer.CreateParameter("VARIABLE_FORMULA_TYPE", SqlDbType.Structured, dtVariableFormula));
using (IDataReader oReader = SQLServer.GetDataReader(CommandBehavior.CloseConnection))
{
oResponse = new GenericInstance <AppResponse>().readDataReader(oReader);
}
}
catch (Exception ex)
{
oResponse.SetException(string.Format("{ 0}: { 1}.", System.AppDomain.CurrentDomain.FriendlyName, ex.Message));
}
return(oResponse);
//return new AppResponse { Code = "S",Description= "Se registro exitosamente" };
}
public AppResponse Mantenimiento(List <PerfilLogic> lista, string accion)
{
try
{
DataTable dt = new DataTable();
List <Perfil> listEntidad = lista.Cast <Perfil>().ToList();
dt = Util.ConvertListToDatatable(listEntidad);
SQLServer.OpenConection();
SQLServer.CreateCommand("SEG.USP_MANT_PERFIL", CommandType.StoredProcedure,
SQLServer.CreateParameter("ACCION", SqlDbType.VarChar, accion),
SQLServer.CreateParameter("PERFIL_TYPE", SqlDbType.Structured, dt));
using (IDataReader oReader = SQLServer.GetDataReader(CommandBehavior.CloseConnection))
{
oResponse = new GenericInstance <AppResponse>().readDataReader(oReader);
}
}
catch (Exception ex)
{
oResponse.SetException(string.Format("{ 0}: { 1}.", System.AppDomain.CurrentDomain.FriendlyName, ex.Message));
}
return(oResponse);
}
