protected void btnSearch_Click(object sender, EventArgs e)
    {
        RequestsDAL.SearchLeaveRequest(ref dt, DateTime.Parse(txtStartDate.Text),
                                       DateTime.Parse(txtEndDate.Text), ddlLeaveType.SelectedItem.Value, txtName.Text);

        GridView1.DataSource = dt;
        GridView1.DataBind();


//      LeaveRequest request = new LeaveRequest();
//      request.EmployeeId = Int32.Parse(Session["employeeid"].ToString());
//
//      request.StartDate = Convert.ToDateTime(txtStartDate.Text);
//      request.StartDate = DateTime.Parse(txtStartDate.Text);
//      request.EndDate = DateTime.Parse(txtEndDate.Text);
//      request.LeaveType = ddlLeaveType.SelectedItem.Value;
//      request.Reason = txtReason.Text;
//      request.RequestedOn = DateTime.Now;
//      request.Status = "n"; // new
//
//      bool done = RequestsDAL.AddLeaveRequest(request);
//      if (done)
//          lblMsg.Text = "Your request for leave has been stored";
//      else
//          lblMsg.Text = "Sorry! Could not store your request. Try again!";
    }