#include "Form1.h"
#include "Database.h"
#include "Form2.h"
#include "Login.h"
#include "Data_Main.h"

using namespace System;
using namespace System::ComponentModel;
using namespace System::Collections;
using namespace System::Collections::Generic;
using namespace System::Windows::Forms;
using namespace System::Data;
using namespace System::Drawing;
using namespace System::Threading;
using namespace System::Data;
using namespace System::Data::SQLite;

[STAThread]
void Main(array<String^>^ arg) {
    Application::EnableVisualStyles();
    Application::SetCompatibleTextRenderingDefault(false);

    trucking::Login form;
    Application::Run(%form);
}

System::Void trucking::Form1::button_load_Click(System::Object ^ sender, System::EventArgs ^ e)
{
    List<Data^> ^Data1;
    String^ Colums_Name = "order_id INTEGER PRIMARY KEY, destination STRING, initial_point STRING, type_of_cargo STRING, type_of_car STRING, cost STRING, weight STRING, date STRING, user_id INTEGER, client_id INTEGER, inactive BOOLEAN";
    String^ DB_name = "TRUCKING";
    String^ Colums_Name_2 = "users_id INTEGER PRIMARY KEY, password STRING, login STRING, is_admin BOOLEAN";
    String^ DB_name_2 = "USERS";
    String^ DB_name_3 = "CLIENTS";
    String^ Colums_Name_3 = "client_id INTEGER PRIMARY KEY, owner STRING, passport_series STRING, passport_number STRING";
    String^ Selected_Values = "*";
    int i = 0;
    Database ^DB = gcnew Database();
    DB->Open_DB();
    DB->Create_Table_DB(DB_name, Colums_Name);
    DB->Create_Table_DB(DB_name_2, Colums_Name_2);
    DB->Create_Table_DB(DB_name_3, Colums_Name_3);
    SQLiteDataReader ^reader = DB->Select_Table_DB(Selected_Values, DB_name);

    DataTable^ Table = gcnew DataTable();
    dataGridView1->DataSource = Table;

    for (int colCtr = 0; colCtr < reader->FieldCount; ++colCtr)
    {
        Table->Columns->Add(reader->GetName(colCtr));
    }
    array<String^>^ strarray = gcnew array<String^>(reader->FieldCount);
    while (reader->Read())
    {
        for (int colCtr = 0; colCtr < reader->FieldCount; ++colCtr)
        {
            strarray[colCtr] = reader->GetValue(colCtr)->ToString();


        }
        Table->Rows->Add(strarray);

        i++;
    }
    DB->Close();

}

System::Void trucking::Form1::button_add_Click(System::Object ^ sender, System::EventArgs ^ e)
{
    Form2^ Frm2 = gcnew Form2(user_id1);
    Frm2->ShowDialog();
    this->button_load->PerformClick();
}

System::Void trucking::Form1::bttn_edit_Click(System::Object ^ sender, System::EventArgs ^ e)
{
    try {
        Form2^ Frm_edit = gcnew Form2(true, this->dataGridView1->SelectedCells[0]->RowIndex+1,user_id1);

        Frm_edit->Show();



    }
    catch(Exception ^e)
    {

    }




}

System::Void trucking::Form1::Form1_Shown(System::Object ^ sender, System::EventArgs ^ e)
{

}

System::Void trucking::Form1::Form1_FormClosing(System::Object ^ sender, System::Windows::Forms::FormClosingEventArgs ^ e)
{
    Application::Exit();
}