예제 #1
0
        // INDRA : FJQP CHANGE REQUEST ConfigMultiple y Capt. Contratos
        public IList <configMultipleRegModel> ConsultarConfigMultiples(ConfigRequestModel configRequestModel)
        {
            List <configMultipleRegModel> listDatos = new List <configMultipleRegModel>();

            try
            {
                SqlCommand command = new SqlCommand
                {
                    CommandText = ConstStoredProcedures.SpObtieneDatosConfigMultiple
                };
                command.Parameters.Add("@IdAseguradora", SqlDbType.BigInt).Value = configRequestModel.Aseguradora;
                command.Parameters.Add("@IdProducto", SqlDbType.BigInt).Value    = configRequestModel.Producto;
                command.Parameters.Add("@IdPerfil", SqlDbType.VarChar).Value     = configRequestModel.Perfil;
                command.Parameters.Add("@IdUsuario", SqlDbType.Int).Value        = configRequestModel.Usuario;

                SqlDataReader datosStored = iGenericDataAccess.StoredProcedure(command);
                if (datosStored.HasRows)
                {
                    while (datosStored.Read())
                    {
                        listDatos.Add(new configMultipleRegModel
                        {
                            idAseguradora           = Convert.ToInt32(datosStored["idAseguradora"]),
                            Aseguradora             = Convert.ToString(datosStored["Aseguradora"]),
                            idProducto              = Convert.ToInt32(datosStored["idProducto"]),
                            Producto                = Convert.ToString(datosStored["Producto"]),
                            idPerfil                = Convert.ToInt32(datosStored["idPerfil"]),
                            Perfil                  = Convert.ToString(datosStored["Perfil"]),
                            idUsuario               = Convert.ToInt32(datosStored["idUsuario"]),
                            Usuario                 = Convert.ToString(datosStored["Usuario"]),
                            iPermiteEmisionMultiple = Convert.ToInt32(datosStored["iPermiteEmisionMultiple"]),
                            iPermiteContrato        = Convert.ToInt32(datosStored["iPermiteContrato"])
                        });
                    }
                    iGenericDataAccess.CloseConnection();
                }
            }
            catch (Exception e)
            {
                iGenericDataAccess.CloseConnection();
                throw new DalException(Codes.ERR_00_01, e);
            }

            return(listDatos);
        }
예제 #2
0
 public SingleResponse <IList <configMultipleRegModel> > PermiteConfigMultiples(ConfigRequestModel configRequestModel)
 {
     return(iEmitirBusiness.PermiteConfigMultiple(configRequestModel));
 }