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