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

namespace ReportWeb.Models
{
    public class Broadcast
    {
        public Broadcast()
        {
        }

        public int id { get; set; }
        public String broadcast_name { get; set; }
        public String import_file { get; set; }
        public int count_sub { get; set; }
        public int status { get; set; }
        public String schedule_time { get; set; }
        public String finish_time { get; set; }
        public int sv_adv_id { get; set; }

        public String sv_code { get; set; }
        public String msg_adv { get; set; }
        public String channel_adv { get; set; }
        public string message_type { get; set; }
        public int count_sub_real { get; set; }
        public int progress_sub { get; set; }

        public static List<Broadcast> Parse(OracleDataReader reader)
        {
            List<Broadcast> result = new List<Broadcast>();
            try
            {
                while (reader.Read())
                {
                    Broadcast sv = new Broadcast();
                    for (int i = 0; i < reader.FieldCount; i++)
                    {
                        if (reader.GetName(i).ToUpper() == "ID")
                            try
                            {
                                sv.id = int.Parse(reader.GetValue(i).ToString());
                            }
                            catch { }
                        else if (reader.GetName(i).ToUpper() == "BROADCAST_NAME")
                            try
                            {
                                sv.broadcast_name = reader.GetValue(i).ToString();
                            }
                            catch { }
                        else if (reader.GetName(i).ToUpper() == "IMPORT_FILE")
                            try
                            {
                                sv.import_file = reader.GetValue(i).ToString();
                            }
                            catch { }
                        else if (reader.GetName(i).ToUpper() == "COUNT_SUB")
                            try
                            {
                                sv.count_sub = int.Parse(reader.GetValue(i).ToString());
                            }
                            catch { }
                        else if (reader.GetName(i).ToUpper() == "SCHEDULE_TIME")
                            try
                            {
                                sv.schedule_time = reader.GetDateTime(i).ToString("dd/MM/yyyy HH:mm:ss");
                            }
                            catch { }
                        else if (reader.GetName(i).ToUpper() == "FINISH_TIME")
                            try
                            {
                                sv.finish_time = reader.GetDateTime(i).ToString("dd/MM/yyyy HH:mm:ss");
                            }
                            catch { }
                        else if (reader.GetName(i).ToUpper() == "SV_ADV_ID")
                            try
                            {
                                sv.sv_adv_id = int.Parse(reader.GetValue(i).ToString());
                            }
                            catch { }
                        else if (reader.GetName(i).ToUpper() == "SV_CODE")
                            try
                            {
                                sv.sv_code = reader.GetValue(i).ToString();
                            }
                            catch { }
                        else if (reader.GetName(i).ToUpper() == "MSG_ADV")
                            try
                            {
                                sv.msg_adv = reader.GetValue(i).ToString();
                            }
                            catch { }
                        else if (reader.GetName(i).ToUpper() == "CHANNEL_ADV")
                            try
                            {
                                sv.channel_adv = reader.GetValue(i).ToString();
                            }
                            catch { }
                        else if (reader.GetName(i).ToUpper() == "MESSAGE_TYPE")
                            try
                            {
                                sv.message_type = reader.GetValue(i).ToString();
                            }
                            catch { }
                        else if (reader.GetName(i).ToUpper() == "COUNT_SUB_REAL")
                            try
                            {
                                sv.count_sub_real = int.Parse(reader.GetValue(i).ToString());
                            }
                            catch { }
                        else if (reader.GetName(i).ToUpper() == "PROGRESS_SUB")
                            try
                            {
                                sv.progress_sub = int.Parse(reader.GetValue(i).ToString());
                            }
                            catch { }
                        else if (reader.GetName(i).ToUpper() == "STATUS")
                            try
                            {
                                sv.status = int.Parse(reader.GetValue(i).ToString());
                            }
                            catch { }
                    }
                    result.Add(sv);
                }
                reader.Close();
            }
            catch
            {
            }
            finally
            {
                try
                {
                    reader.Close();
                }
                catch { }
            }
            return result;
        }
    }
}