Ejemplo n.º 1
0
        /// <summary>
        /// Obtener una lista de pacientes key values
        /// </summary>
        /// <returns></returns>
        public static KeyValueUsuarioList Get()
        {
            KeyValueUsuarioList list = null;

            try
            {
                list = KeyValueUsuarioListDal.Get();
            }
            catch (SqlException ex)
            {
                Methods.GenerateLogsRelease("KeyValueUsuarioListBrl", "Get", string.Format("{0} {1} Error: {2}", DateTime.Now.ToShortDateString(), DateTime.Now.ToShortTimeString(), ex.Message));
                throw ex;
            }
            catch (Exception ex)
            {
                Methods.GenerateLogsRelease("KeyValueUsuarioListBrl", "Get", string.Format("{0} {1} Error: {2}", DateTime.Now.ToShortDateString(), DateTime.Now.ToShortTimeString(), ex.Message));
                throw ex;
            }

            return(list);
        }
        /// <summary>
        /// Obtener una lista de pacientes key values
        /// </summary>
        /// <returns></returns>
        public static KeyValueUsuarioList Get()
        {
            Methods.GenerateLogsDebug("KeyValuePacienteListDal", "Get", string.Format("{0} Info: {1}", DateTime.Now.ToLongDateString(), "Empezando a ejecutar el metodo paraobtener una lista de pacientes"));

            KeyValueUsuarioList res = new KeyValueUsuarioList();
            SqlCommand          cmd = null;
            SqlDataReader       dr  = null;
            string query            = "SELECT UsuarioId, Concat(Nombre, ' ', Apellido) as 'Nombre completo' FROM Usuario Where Eliminado=0";

            try
            {
                cmd = Methods.CreateBasicCommand(query);
                dr  = Methods.ExecuteDataReaderCommand(cmd);

                while (dr.Read())
                {
                    res.Add(new KeyValueUsuario()
                    {
                        UsuarioId      = dr.GetInt32(0),
                        NombreCompleto = dr.GetString(1)
                    });
                }
            }
            catch (SqlException ex)
            {
                Methods.GenerateLogsRelease("KeyValueUsuarioListDal", "Obtener", ex.Message + " " + ex.StackTrace);
                throw ex;
            }
            catch (Exception ex)
            {
                Methods.GenerateLogsRelease("KeyValueUsuarioListDal", "Obtener", ex.Message + " " + ex.StackTrace);
                throw ex;
            }
            finally
            {
                cmd.Connection.Close();
            }
            return(res);
        }