COBOL TO SQL

using System;
using System.Collections.Generic;
using System.Linq;
using System.Text;
using System.IO;

namespace SIC_SQL
{
    public class table
    {
        public List<string> fileLines;
        public List<Ligne> lignes;
        public int NumChamp = 0;
        public int GRang = 0;
        public List<Champ> champs;
        public List<Field> field; 
        public string view_Name;
        private string base_view_Name;
        private string load_view_Name;
        private string table_name;

        private void getNumChamp()
        {

            foreach (var e in fileLines)
            {
                Ligne line = new Ligne(e);
                if (line.Niveau == 0 || line.Niveau == 1) { continue; }
                else
                {
                    NumChamp = line.Niveau;
                    break;
                }
            }

        }


        public table(string file)
        {
            fileLines = File.ReadAllLines(file).ToList();
            getNumChamp();
            lignes = new List<Ligne>();
            champs = new List<Champ>();
            int rang = 0;

            foreach (var l in fileLines)
            {
                Ligne ll = new Ligne(l);
                if (ll.Niveau != 0)
                {
                    ll.Rang = rang++;
                    lignes.Add(ll);
                }
            }

            var uneLigne = lignes.Where(l => l.Niveau == 1).Single();
            view_Name = "[vw_" + uneLigne.Nom + "]";
            base_view_Name = "[vw_base_" + uneLigne.Nom + "]";
            load_view_Name = "[vw_load_" + uneLigne.Nom + "]";
            table_name = "[" + uneLigne.Nom.Remove(uneLigne.Nom.Length - 1, 1) + "]";

           Initialisation();

            //lignes.Where(l => l.Niveau == NumChamp).Select(l => l).ToList<ILigne>().ForEach(l => champs.Add(new Champ( l)));
            //champs.ForEach(ch => ch.childline = getChild(ch.parentline));

            //field = new List<Field>();
            //foreach (var ll in lignes.Where(l => l.Niveau == NumChamp))
            //{
            //    Field f = new Field();
            //    f.parentline = ll;
            //    int i = ll.Rang;
            //    if (i < lignes.Count-1)
            //    {
            //        ILigne tmpLine = lignes[++i];
            //        //ret.Add(tmpLine);
            //        while (tmpLine.Niveau > NumChamp)
            //        {

            //            f.childline.Add(new Child { line = tmpLine });
            //            tmpLine = lignes[++i];
            //        }
            //    }
            //    field.Add(f);
                
        //}
        }

        public void Initialisation()
        {
            var ligneNiveau = lignes.Where(l => l.Niveau == NumChamp).Select(l => l).ToList<ILigne>();
            int filer = 0;
            foreach (var l in ligneNiveau)
            {

                if (l.isOccurs)
                {
                    Champ unchamp = new Champ(l, getChild(l));
                    this.AddChamps(unchamp.Duppliquer());
                }
                else
                {
                    if (l.Nom== "FILLER")
                    {
                        ILigne ll = new OccursLigne(l, filer++);
                        champs.Add(new Champ(ll, getChild(ll)));
                    }
                    else
                    {
                        champs.Add(new Champ(l, getChild(l)));
                    }
                }

            }
        }

        public void AddChamps(List<Champ> lst)
        {
            foreach (var item in lst)
            {
                champs.Add(item);
            }
        }

        public ILigne Prev(ILigne l)
        {
            return lignes.Where(li => li.Rang == l.Rang + 1).Single();
        }

        public ILigne Suiv(ILigne l)
        {
            return lignes.Where(li => li.Rang == l.Rang - 1).Single();
        }

      public   List<Champ> getChild(ILigne line)
        {
            List<Champ> ret = new List<Champ>();
            
                int i = line.Rang;
          if (i < lignes.Count-1){
                ILigne tmpLine = lignes[++i];
                //ret.Add(tmpLine);
                while ( tmpLine.Niveau > NumChamp)
                {
                    ret.Add(new Champ(tmpLine));
                    tmpLine = lignes[++i];
                }
            }
            return ret;
        }

        public List<string> ToSQL()
        {
            List<string> list = new List<string>();
            list.Add(string.Format (" CREATE TABLE {0} (",this.table_name ));
            foreach (var e in champs)
            {

                
                    list.Add(e.SQLType());
                
            }
            list.Add(")");
            return list;
        }

        

        public List<string> CreateBaseView()
        {
            List<string> list = new List<string>();

            list.Add(string.Format("CREATE VIEW {0} (", this.base_view_Name ));
            list.Add("SELECT  ");
            int tailleTotale = 1;
            foreach (var e in champs)
            {
                if (e.parentline.Niveau == NumChamp)
                {

                    e.TailleTotal = tailleTotale;
                    list.Add(e.SQLBaseView());
                    tailleTotale += e.Valeur;
                }
            }
            //foreach (var e in field)
            //{
                

            //        e.TailleTotal = tailleTotale;
            //        list.Add(e.SQLBaseView());
            //        tailleTotale += e.Valeur;
               
            //}
            list.Add(string.Format("FROM {0} ", this.table_name));

            list.Add("");
            list.Add("");
            list.Add(string.Format("CREATE TABLE {0} (", this.table_name));
            list.Add(string.Format("DATA varchar({0}) ",tailleTotale+1));
            list.Add(")");
            return list;
        }

        public List<string> CreateViewLoad()
        {
            List<string> list = new List<string>();
            list.Add(string.Format("CREATE VIEW {0} (", this.load_view_Name));
            list.Add("SELECT  ");
            foreach (var e in champs)
            {
                if (e.parentline.Niveau == NumChamp)
                {

                    if (!e.parentline.isOccurs)
                    {
                        list.Add(e.parentline.SQLLoadView());
                    }
                    else
                    {
                        e.Duppliquer().ForEach(ch => list.Add(ch.parentline.SQLLoadView()));
                    }

                   
                    
                }
            }
            list.Add(string.Format("FROM {0} ", this.base_view_Name));
            return list;
        }

        public List<string> CreateView()
        {
            List<string> list = new List<string>();
            list.Add(string.Format("CREATE VIEW {0} (", this.view_Name));
            list.Add("SELECT  ");
            foreach (var e in champs)
            {
                if (e.parentline.Niveau == NumChamp)
                {

                    if (!e.parentline.isOccurs)
                    {
                        //list.Add(e.parentline.SQLLoadView());
                        e.SQLView().ForEach(l => list.Add(l));
                    }
                    else
                    {
                       // list.Add(e.parentline.SQLLoadView());
                        e.Duppliquer().ForEach(ch => ch.SQLView().ForEach(l => list.Add(l)));
                    }



                }
            }
            list.Add(string.Format("FROM {0} ", this.table_name));
            return list;

        }



    }
}