using System;
using System.Configuration;
using System.Data;
using System.Linq;
using System.Web;
using System.Web.Security;
using System.Web.UI;
using System.Web.UI.HtmlControls;
using System.Web.UI.WebControls;
using System.Web.UI.WebControls.WebParts;
using System.Xml.Linq;
using System.Data.SqlClient;

public partial class _Default : System.Web.UI.Page
{
    private SqlCommand sqlCmd;
    private SqlConnection hookUp;
    private string strInsert;
    private const decimal WRKHRS = 37.5M;
    private decimal HrsWorked;
    private decimal Overtime;
   /* protected void Page_Load(object sender, EventArgs e)
    {

    }*/
    protected void submitData(object sender, EventArgs e) {
        hookUp = new SqlConnection("Server=localhost\\SqlExpress;Database=test1;" + "Integrated Security=True");
        strInsert = "INSERT INTO Overtime(Week,HrsWorked,Overtime,Comment) VALUES (@week,@hrsWrk,@ovt,@cmmt)";
        HrsWorked = Convert.ToDecimal(hrs.Value);
        Overtime = HrsWorked - WRKHRS;
        sqlCmd = new SqlCommand(strInsert, hookUp);
        sqlCmd.Parameters.Add("@week", week.Value);
        sqlCmd.Parameters.Add("hrsWrk", HrsWorked);
        sqlCmd.Parameters.Add("@ovt", Overtime);
        sqlCmd.Parameters.Add("@cmmt", TextArea1.Value);
        hookUp.Open();
        sqlCmd.ExecuteNonQuery();
        hookUp.Close();
        week.Value = "";
        hrs.Value = "";
        TextArea1.Value = "";
    }
    protected void clearData(object sender, EventArgs e) {
        week.Value = "";
        hrs.Value = "";
        TextArea1.Value = "";
    }
    protected void clearTable(object sender, EventArgs e) {
        hookUp = new SqlConnection("Server=localhost\\SqlExpress;Database=test1;" + "Integrated Security=True");
        strInsert = "DELETE FROM Overtime";
        sqlCmd = new SqlCommand(strInsert, hookUp);
        hookUp.Open();
        sqlCmd.ExecuteNonQuery();
        hookUp.Close();
    }
    /*private decimal convertToDecimal(string toConvert) {
        public de
    }*/
}