using System;
using System.Data;
using System.Data.SqlClient;
using System.Configuration;
using System.Collections;
using System.Web;
using System.Web.Security;
using System.Web.UI;
using System.Web.UI.WebControls;
using System.Web.UI.WebControls.WebParts;
using System.Web.UI.HtmlControls;
using LYB.VB;

public partial class group0_DocumentLists : System.Web.UI.Page
{
    DataUtils utils = new DataUtils();
    protected void Page_Load(object sender, EventArgs e)
    {
        lblListCount.Text = (utils.GetNumberOfListsForGroup(2)).ToString();
        lblActualDocumentsCount.Text = (utils.GetNumberOfActualDocumentsForGroup(2)).ToString();
        lblConcertsCount.Text = (utils.GetNumberOfConcertsDocumentsForGroup(2)).ToString();
        lblLibraryCount.Text = (utils.GetNumberOfLibraryDocumentsForGroup(2)).ToString();
    }
    protected void btnGenerateDocumentLibrary_Click(object sender, EventArgs e)
    {
        // delete list 'NL' rows
        DataSet dsList = utils.GetBySQL("SELECT ListID FROM List Where ListType = 'NL'", "list");
        string select = "SELECT *";
        string delete = "DELETE";
        string table = "Composition_DocumentPath_List";
        string fromTable = " FROM " + table + " WHERE ListID = " + ((int)dsList.Tables["list"].Rows[0].ItemArray[0]).ToString();
        string selectString = select + fromTable;
        string deleteString = delete + fromTable;
        int deleteResult = utils.DeleteCommand(table, selectString, deleteString);

        DataSet dsComposition = utils.GetBySQL("SELECT CompositionID, CompositionName FROM Composition WHERE ComposerID > 0 ORDER BY CompositionName", "compositions", true);
        DataSet dsDocumentPath = utils.GetBySQL("SELECT DocumentPathID, FileName FROM DocumentPath WHERE Type = 'pdf' ORDER BY FileName", "documentpaths", true);
        // get empty dataset for new composition_documentpath_list rows
        DataSet dsComposition_DocumentPath_List = utils.GetBySQL("SELECT * FROM Composition_DocumentPath_List WHERE 1 = 0", "composition_documentpath_list", true);
        int sortOrder = 0;
        foreach (DataRow compositionRow in dsComposition.Tables["compositions"].Rows)
        {
            bool matched = false;
            int compositionID = (int)compositionRow.ItemArray[0];
            foreach (DataRow documentPathRow in dsDocumentPath.Tables["documentpaths"].Rows)
            {
                string compositionNameEdited = compositionRow.ItemArray[1].ToString().ToLower();
                compositionNameEdited = compositionNameEdited.Replace(" ", "_");
                compositionNameEdited = compositionNameEdited.Replace("Å", "A");
                compositionNameEdited = compositionNameEdited.Replace("Ä", "A");
                compositionNameEdited = compositionNameEdited.Replace("Ö", "o");
                compositionNameEdited = compositionNameEdited.Replace("å", "a");
                compositionNameEdited = compositionNameEdited.Replace("ä", "a");
                compositionNameEdited = compositionNameEdited.Replace("ö", "o");
                compositionNameEdited = compositionNameEdited.Replace(",", "");
                compositionNameEdited = compositionNameEdited.Replace("ó", "o");
                compositionNameEdited = compositionNameEdited.Replace("é", "e");
                compositionNameEdited = compositionNameEdited.Replace("(", "");
                compositionNameEdited = compositionNameEdited.Replace(")", "");
                if (compositionNameEdited == documentPathRow.ItemArray[1].ToString())
                {
                    int documentPathID = (int)documentPathRow.ItemArray[0];
                    try
                    {
                        sortOrder++;
                        DataRow newRow = dsComposition_DocumentPath_List.Tables["composition_documentpath_list"].NewRow();
                        object[] rowArray = new object[5];
                        rowArray[0] = null;
                        rowArray[1] = compositionID;
                        rowArray[2] = documentPathID;
                        rowArray[3] = (int)dsList.Tables["list"].Rows[0].ItemArray[0];
                        rowArray[4] = sortOrder;
                        newRow.ItemArray = rowArray;
                        dsComposition_DocumentPath_List.Tables["composition_documentpath_list"].Rows.Add(newRow);
                        matched = true;
                    }
                    catch (System.Exception ex)
                    {
                        throw new System.Exception("Error in btnGenerateDocumentLibrary_Click(1): " + ex.Message.ToString());
                    }
                }
            }
            if (!matched)
            {
                int documentPathID = 223;
                try
                {
                    sortOrder++;
                    DataRow newRow = dsComposition_DocumentPath_List.Tables["composition_documentpath_list"].NewRow();
                    object[] rowArray = new object[5];
                    rowArray[0] = null;
                    rowArray[1] = compositionID;
                    rowArray[2] = documentPathID;
                    rowArray[3] = (int)dsList.Tables["list"].Rows[0].ItemArray[0];
                    rowArray[4] = sortOrder;
                    newRow.ItemArray = rowArray;
                    dsComposition_DocumentPath_List.Tables["composition_documentpath_list"].Rows.Add(newRow);
                    matched = true;
                }
                catch (System.Exception ex)
                {
                    throw new System.Exception("Error in btnGenerateDocumentLibrary_Click(2): " + ex.Message.ToString());
                }
            }
        }
        try
        {
            string result;
            if (sortOrder > 0)
                result = utils.UpdateBatch(dsComposition_DocumentPath_List, "composition_documentpath_list");
            lblLibraryCount.Text = (sortOrder).ToString();
        }
        catch (System.Exception ex2)
        {
            throw new System.Exception("Error in btnGenerateDocumentLibrary_Click(3): " + ex2.Message.ToString());
        }
    }
}