using Oracle.ManagedDataAccess.Client;
using System;
using System.Collections.Generic;
using System.Linq;
using System.Web;

namespace ReportWeb.Models
{
    public class ToolConfig
    { 
        public int id { get; set; }
        public int service_id { get; set; }
        public string name { get; set; }
        public string value { get; set; }
        public string note { get; set; }
        public string description { get; set; }

        public static List<ToolConfig> Parse(OracleDataReader reader)
        {
            List<ToolConfig> result = new List<ToolConfig>();
            try
            {
                while (reader.Read())
                {
                    ToolConfig sv = new ToolConfig();
                    for (int i = 0; i < reader.FieldCount; i++)
                    {
                        if (reader.GetName(i).ToLower() == "id")
                            try { sv.id = int.Parse(reader.GetValue(i).ToString()); }
                            catch { }
                        else if (reader.GetName(i).ToLower() == "service_id")
                            try { sv.service_id = int.Parse(reader.GetValue(i).ToString()); }
                            catch { }
                        else if (reader.GetName(i).ToLower() == "name")
                            try { sv.name = reader.GetValue(i).ToString(); }
                            catch { }
                        else if (reader.GetName(i).ToLower() == "value")
                            try { sv.value = reader.GetValue(i).ToString(); }
                            catch { }
                        else if (reader.GetName(i).ToLower() == "note")
                            try { sv.note = reader.GetValue(i).ToString(); }
                            catch { }
                        else if (reader.GetName(i).ToLower() == "description")
                            try { sv.description = reader.GetValue(i).ToString(); }
                            catch { }
                    }
                    result.Add(sv);
                }
                reader.Close();
            }
            catch (Exception ex)
            {

            }
            finally
            {
                try
                {
                    reader.Close();
                }
                catch { }
            }
            return result;
        }
    }
}