using System;
using System.Collections.Generic;
using System.ComponentModel;
using System.Data;
using System.Drawing;
using System.Linq;
using System.Text;
using System.Windows.Forms;
using System.Data.OleDb;
using System.IO;

namespace Descartes
{
    public partial class frmTop : Form
    {
        public frmTop()
        {
            InitializeComponent();
        }

        int Sum = 0;
        OleDbConnection con;
        DataSet ds;
        OleDbDataAdapter da;

        int TempBalance;
        int MaxRows = 0;
        string User = "";


        private void mainMenuToolStripMenuItem3_Click(object sender, EventArgs e)
        {
            // Goes to the Main Menu Page

            frmMainMenu frm = new frmMainMenu();
            frm.Show();
            this.Hide();
        }

        private void catalogueToolStripMenuItem3_Click(object sender, EventArgs e)
        {
            // Goes to the Catalogue Page

            frmCatalogue frm = new frmCatalogue();
            frm.Show();
            this.Hide();
        }

        private void exitToolStripMenuItem_Click(object sender, EventArgs e)
        {
            Application.Exit();
        }

        private void tmrFadeIn_Tick(object sender, EventArgs e)
        {
            //Fades the page in

            this.Opacity += 0.02;
        }

        private void tmrWait_Tick(object sender, EventArgs e)
        {
            //Stops the fade in function

            tmrFadeIn.Enabled = false;
        }

        private void button1_Click(object sender, EventArgs e)
        {
            // Goes to the Main Menu Page

            frmMainMenu frm = new frmMainMenu();
            frm.Show();
            this.Hide();
        }

        private void accountInformationToolStripMenuItem3_Click(object sender, EventArgs e)
        {
            // Goes to the Account Information Page

            frmAccount frm = new frmAccount();
            frm.Show();
            this.Hide();
        }

        private void logoutToolStripMenuItem3_Click(object sender, EventArgs e)
        {
            // Goes to the Login Page

            frmLogin frm = new frmLogin();
            frm.Show();
            this.Hide();
        }

        private void frmTop_Load(object sender, EventArgs e)
        {
            string file_name = "user.ini";

            System.IO.StreamReader objReader;
            objReader = new System.IO.StreamReader(file_name);    //Reads the text file and saves it as a variable
            User = objReader.ReadLine().ToString();

            objReader.Close();



            con = new OleDbConnection();

            con.ConnectionString = "Provider=Microsoft.Jet.OLEDB.4.0; Data Source = " + Application.StartupPath + "\\..\\..\\banking.mdb"; //connection to database
            con.Open();

            ds = new DataSet();

            string sql = "SELECT * From account";
            da = new OleDbDataAdapter(sql, con);
            da.Fill(ds, "UserList");
            MaxRows = ds.Tables["UserList"].Rows.Count;

            string Balance;
            int User_int;
            int user;
            User_int = Convert.ToInt32(User);
            user = User_int - 2;      //user is just the row which the logged in user is situated on
            DataRow dRow = ds.Tables["UserList"].Rows[user];
            Balance = dRow.ItemArray.GetValue(3).ToString();

            label3.Text = Balance + ".00";

            con.Close();
            con.Dispose();
        }

        private void btnTopUp_Click(object sender, EventArgs e)
        {
            if (radioButton1.Checked == true)
            {
                Sum = 5;
                radioButton1.Checked = false;
                radioButton2.Checked = false;
                radioButton3.Checked = false;
                radioButton4.Checked = false;
                radioButton5.Checked = false;
                radioButton6.Checked = false;
                radioButton7.Checked = false;
                radioButton8.Checked = false;
                radioButton9.Checked = false;
                radioButton11.Checked = false;
                radioButton12.Checked = false;
            }

            if (radioButton2.Checked == true)
            {
                Sum = 10;
                radioButton1.Checked = false;
                radioButton2.Checked = false;
                radioButton3.Checked = false;
                radioButton4.Checked = false;
                radioButton5.Checked = false;
                radioButton6.Checked = false;
                radioButton7.Checked = false;
                radioButton8.Checked = false;
                radioButton9.Checked = false;
                radioButton11.Checked = false;
                radioButton12.Checked = false;
            }

            if (radioButton3.Checked == true)
            {
                Sum = 20;
                radioButton1.Checked = false;
                radioButton2.Checked = false;
                radioButton3.Checked = false;
                radioButton4.Checked = false;
                radioButton5.Checked = false;
                radioButton6.Checked = false;
                radioButton7.Checked = false;
                radioButton8.Checked = false;
                radioButton9.Checked = false;
                radioButton11.Checked = false;
                radioButton12.Checked = false;
            }

            if (radioButton4.Checked == true)
            {
                Sum = 250;
                radioButton1.Checked = false;
                radioButton2.Checked = false;
                radioButton3.Checked = false;
                radioButton4.Checked = false;
                radioButton5.Checked = false;
                radioButton6.Checked = false;
                radioButton7.Checked = false;
                radioButton8.Checked = false;
                radioButton9.Checked = false;
                radioButton11.Checked = false;
                radioButton12.Checked = false;
            }

            if (radioButton5.Checked == true)
            {
                Sum = 100;
                radioButton1.Checked = false;
                radioButton2.Checked = false;
                radioButton3.Checked = false;
                radioButton4.Checked = false;
                radioButton5.Checked = false;
                radioButton6.Checked = false;
                radioButton7.Checked = false;
                radioButton8.Checked = false;
                radioButton9.Checked = false;
                radioButton11.Checked = false;
                radioButton12.Checked = false;
            }

            if (radioButton6.Checked == true)
            {
                Sum = 50;
                radioButton1.Checked = false;
                radioButton2.Checked = false;
                radioButton3.Checked = false;
                radioButton4.Checked = false;
                radioButton5.Checked = false;
                radioButton6.Checked = false;
                radioButton7.Checked = false;
                radioButton8.Checked = false;
                radioButton9.Checked = false;
                radioButton11.Checked = false;
                radioButton12.Checked = false;
            }

            if (radioButton7.Checked == true)
            {
                Sum = 2500;
                radioButton1.Checked = false;
                radioButton2.Checked = false;
                radioButton3.Checked = false;
                radioButton4.Checked = false;
                radioButton5.Checked = false;
                radioButton6.Checked = false;
                radioButton7.Checked = false;
                radioButton8.Checked = false;
                radioButton9.Checked = false;
                radioButton11.Checked = false;
                radioButton12.Checked = false;
            }

            if (radioButton8.Checked == true)
            {
                Sum = 1000;
                radioButton1.Checked = false;
                radioButton2.Checked = false;
                radioButton3.Checked = false;
                radioButton4.Checked = false;
                radioButton5.Checked = false;
                radioButton6.Checked = false;
                radioButton7.Checked = false;
                radioButton8.Checked = false;
                radioButton9.Checked = false;
                radioButton11.Checked = false;
                radioButton12.Checked = false;
            }

            if (radioButton9.Checked == true)
            {
                Sum = 500;
                radioButton1.Checked = false;
                radioButton2.Checked = false;
                radioButton3.Checked = false;
                radioButton4.Checked = false;
                radioButton5.Checked = false;
                radioButton6.Checked = false;
                radioButton7.Checked = false;
                radioButton8.Checked = false;
                radioButton9.Checked = false;
                radioButton11.Checked = false;
                radioButton12.Checked = false;
            }

            if (radioButton12.Checked == true)
            {
                Sum = 5000;
                radioButton1.Checked = false;
                radioButton2.Checked = false;
                radioButton3.Checked = false;
                radioButton4.Checked = false;
                radioButton5.Checked = false;
                radioButton6.Checked = false;
                radioButton7.Checked = false;
                radioButton8.Checked = false;
                radioButton9.Checked = false;
                radioButton11.Checked = false;
                radioButton12.Checked = false;
            }

            if (radioButton11.Checked == true)
            {
                Sum = 10000;
                radioButton1.Checked = false;
                radioButton2.Checked = false;
                radioButton3.Checked = false;
                radioButton4.Checked = false;
                radioButton5.Checked = false;
                radioButton6.Checked = false;
                radioButton7.Checked = false;
                radioButton8.Checked = false;
                radioButton9.Checked = false;
                radioButton11.Checked = false;
                radioButton12.Checked = false;
            }

            con = new OleDbConnection();

            con.ConnectionString = "Provider=Microsoft.Jet.OLEDB.4.0; Data Source = " + Application.StartupPath + "\\..\\..\\banking.mdb"; //connection to database
            con.Open();

            ds = new DataSet();

            string sql = "SELECT * From account";
            da = new OleDbDataAdapter(sql, con);
            da.Fill(ds, "UserList");
            MaxRows = ds.Tables["UserList"].Rows.Count;

            string Balance;
            int User_int;
            int user;
            User_int = Convert.ToInt32(User);
            user = User_int - 2;      //user is just the row which the logged in user is situated on
            DataRow dRow = ds.Tables["UserList"].Rows[user];
            Balance = dRow.ItemArray.GetValue(3).ToString();     //Balance has been found
            TempBalance = Convert.ToInt32(Balance);

            TempBalance = TempBalance + Sum;

            decimal finalBalance = TempBalance;

            System.Data.OleDb.OleDbCommandBuilder cb;
            cb = new System.Data.OleDb.OleDbCommandBuilder(da);
            System.Data.DataRow dRow2 = ds.Tables["UserList"].Rows[user];

            dRow[3] = finalBalance;

            da.Update(ds, "UserList");

            label3.Text = TempBalance + ".00";

            MessageBox.Show("Your balance has been successfully updated! Your new balance is shown on the right.", "Top-up Successful", MessageBoxButtons.OK, MessageBoxIcon.Asterisk);

            con.Close();
            con.Dispose();
        }
    }
}