Ejemplo n.º 1
0
        public List<DataObject.Log> List()
        {
            List<DataObject.Log> list = new List<DataObject.Log>();

            using (SqlConnection connection = new SqlConnection(ConnectionString))
            {
                connection.Open();

                string query = "SELECT Id, Originator, Fault, DateTimeAdded FROM [Logging].[Log] WHERE Id_LogType = 1 ORDER By Id DESC";

                using (SqlCommand command = new SqlCommand(query, connection))
                {
                    SqlDataReader reader = command.ExecuteReader();

                    if (reader.HasRows)
                    {
                        while (reader.Read())
                        {
                            DataObject.Log dataObject = new DataObject.Log();
                            dataObject.Id = int.Parse(reader.GetValue(0).ToString());
                            dataObject.Originator = reader.GetValue(1).ToString();
                            dataObject.Fault = reader.GetValue(2).ToString();
                            dataObject.DateAdded = Convert.ToDateTime(reader.GetValue(3).ToString());

                            list.Add(dataObject);
                        }
                    }
                }
            }

            return list;
        }
Ejemplo n.º 2
0
        public List <DataObject.Log> List()
        {
            List <DataObject.Log> list = new List <DataObject.Log>();

            using (SqlConnection connection = new SqlConnection(ConnectionString))
            {
                connection.Open();

                string query = "SELECT Id, Originator, Fault, DateTimeAdded FROM [Logging].[Log] WHERE Id_LogType = 1 ORDER By Id DESC";

                using (SqlCommand command = new SqlCommand(query, connection))
                {
                    SqlDataReader reader = command.ExecuteReader();

                    if (reader.HasRows)
                    {
                        while (reader.Read())
                        {
                            DataObject.Log dataObject = new DataObject.Log();
                            dataObject.Id         = int.Parse(reader.GetValue(0).ToString());
                            dataObject.Originator = reader.GetValue(1).ToString();
                            dataObject.Fault      = reader.GetValue(2).ToString();
                            dataObject.DateAdded  = Convert.ToDateTime(reader.GetValue(3).ToString());

                            list.Add(dataObject);
                        }
                    }
                }
            }

            return(list);
        }