using System;
using System.Collections.Generic;
using System.Linq;
using System.Web;
using System.Web.UI;
using System.Web.UI.WebControls;
using System.Data.SqlClient;


public partial class Home : System.Web.UI.Page
{
    private int expenseID;//expense string can be rent, car, bills, food as integer so as 1,2,3,4
    private SqlCommand sqlCmd;
    private SqlConnection hookUp;
    private string strInsert;
    private string radioButtonId;
    private SqlDataReader reader;
    //private int storedInt;



    protected void Page_Load(object sender, EventArgs e)
    {
        if (!IsPostBack) {//returns false the first time the page is displayed true when redisplayed
            initForm();
        }

    }
    private void initForm() {
        amount.Visible = false;//hide amount info on page load
        rent.Checked = false;//unselect all radio buttons
        car.Checked = false;
        bills.Checked = false;
        food.Checked = false;
        radioButtonID.Value = "";//empty hidden field
        //System.Diagnostics.Debug.WriteLine("oh oh oh");

    }
    protected void CheckedChanged(object sender, EventArgs e)
    {
        amount.Visible = true;//showamount info on page load
        /*find out the id of the selected button*/
        RadioButton buttonId = sender as RadioButton;//cast sender as button
       // radioButtonID.Text = buttonId.ID;//select the ID
       radioButtonId = radioButtonID.Value = buttonId.ID;//select the ID
       switch (radioButtonId) {
           case "rent":
               expenseID = 1;
               break;
           case "car":
               expenseID = 2;
               break;
           case "bills":
               expenseID = 3;
               break;
           case "food":
               expenseID = 4;
               break;
       }
        //TO REMOVE
      //outputTxt.Text =  DateTime.Now.ToString("dd/MM/yyyy");
     //  outputTxt.Text = Convert.ToString(expenseID);

    }
    protected void submitForm(object sender, EventArgs e){
        hookUp = new SqlConnection("Server=localhost\\SqlExpress;Database=Applications;" + "Integrated Security=True");
        strInsert = "INSERT INTO expenses(Date,ExpenseId,Cost,Comment) VALUES (@date,@expenseid,@cost,@comment)";
        sqlCmd = new SqlCommand(strInsert, hookUp);
        //  sqlCmd.Parameters.Add("@date", DateTime.Now.ToString("dd/MM/yyyy"));
        sqlCmd.Parameters.Add("@date", DateTime.Now);
        sqlCmd.Parameters.Add("@expenseid", expenseID);
        sqlCmd.Parameters.Add("@cost", Convert.ToDecimal(billValue.Text));
        sqlCmd.Parameters.Add("@comment", expenseComment.Value);
        hookUp.Open();
        sqlCmd.ExecuteNonQuery();
        hookUp.Close();




        initForm();//re Initialize form after submission
    }

    //to check what's in the other sql table
    //protected void getValues(object sender, EventArgs e) {

    //    hookUp = new SqlConnection("Server=localhost\\SqlExpress;Database=Applications;" + "Integrated Security=True");
    //    strInsert = "SELECT Id FROM expenseCode";
    //    sqlCmd = new SqlCommand(strInsert, hookUp);
    //    hookUp.Open();
    //    reader = sqlCmd.ExecuteReader();
    //    while (reader.Read())
    //    {
    //        outputTxt.Text += Convert.ToString(reader["Id"]);
    //    }
    //    reader.Close();
    //    hookUp.Close();
    //}


}