using System;
using System.Collections.Generic;
using System.Linq;
using System.Text;
using Common;
using Common.institutelibraryDataSetTableAdapters;
using MySql.Data.MySqlClient;
using MySql.Data;
using System.Data;
//using System.Data.SqlClient;

namespace Provider
{
    public class Provider
    {
        institutelibraryDataSet libruryDataSet = new institutelibraryDataSet();

        MySqlDataAdapter[] libruryDataAdapters;

        DataTable[] libruryTables;
        string[] TablesName;

        SourceType dataType;
        string targetFile;

        public Provider() { }
        public institutelibraryDataSet GetAllData(SourceType dataType, string targetFile)
        {
            this.dataType = dataType;
            this.targetFile = targetFile;

            if(this.dataType==SourceType.XML)
            {
                this.libruryDataSet.ReadXml(targetFile);
                return this.libruryDataSet;
            }
            this.libruryTables = new DataTable[]
            {
              this.libruryDataSet.items,
              this.libruryDataSet.authors,
              this.libruryDataSet.books,
              this.libruryDataSet.borrows,
              this.libruryDataSet.copies,
              this.libruryDataSet.magazines,
              this.libruryDataSet.articles,
              this.libruryDataSet.articlesinmagazines,
              this.libruryDataSet.users
            };

            this.TablesName = new string[]
            {
              "Items","Authors","Books",
              "Borrows","Copies","Magazines",
              "Articles","ArticlesInMagazines","Users"
            };

            this.libruryDataAdapters = new MySqlDataAdapter[this.TablesName.Length];
            MySqlConnection con = new MySqlConnection(this.targetFile);

            for (int i = 0; i < this.TablesName.Length;i++)
            {
                this.libruryDataAdapters[i] =
                    new MySqlDataAdapter("SELECT * FROM "+ this.TablesName[i].ToString(),con);
                //MySqlCommandBuilder combld = new MySqlCommandBuilder(this.libruryDataAdapters[i]);
            }
            try
            {
                for (int i = 0; i < this.libruryDataAdapters.Length; i++)
                {
                    this.libruryDataAdapters[i].Fill(this.libruryTables[i]);
                }
            }
            catch 
            {
                this.libruryDataSet = null;
            }
            //this.libruryDataSet.WriteXml("BookLibrury.xml");
            //this.libruryDataSet.WriteXmlSchema("BookLibrury.xsd");
            return this.libruryDataSet;
        }

        public void UpdateAllData()
        { 
          if(this.dataType==SourceType.XML)
          {
              this.libruryDataSet.WriteXml(this.targetFile);
              return;
          }

          for (int i = 0; i < this.libruryDataAdapters.Length;i++)
          {
              this.libruryDataAdapters[i].Update(this.libruryTables[i]);
          }
        }
    }
}