private void btnView_Click(object sender, RoutedEventArgs e)
        {
            try
            {
                db    = new LetranIntegratedSystemEntities();
                TList = new List <TransactionList>();


                var query = db.GetHRiSLeaveTransactionReport().ToList();

                foreach (var x in query)
                {
                    TransactionList tl = new TransactionList();
                    tl.Days         = x.Days.Value;
                    tl.Designation  = x.Designation;
                    tl.EmployeeName = x.EmployeeName;
                    tl.EmployeeNo   = x.EmployeeNo;
                    tl.EndDate      = x.EndDate.Value;
                    tl.FiledDate    = x.FiledDate.Value;
                    tl.RangeDate    = x.RangeDate;
                    tl.Reason       = x.Reason;
                    tl.StartDate    = x.StartDate.Value;
                    tl.Type         = x.Type;
                    TList.Add(tl);
                }

                if (rbSpecific.IsChecked == true)
                {
                    if (!String.IsNullOrEmpty(dpEnd.Text) && !String.IsNullOrEmpty(dpStart.Text))
                    {
                        DateTime StartDate = Convert.ToDateTime(dpStart.SelectedDate);
                        DateTime EndDate   = Convert.ToDateTime(dpEnd.SelectedDate);

                        TList = TList.Where(m => m.StartDate >= StartDate && m.StartDate <= EndDate).ToList();
                    }
                    else
                    {
                        MessageBox.Show("Date/s cannot be empty", "System Warning!", MessageBoxButton.OK, MessageBoxImage.Warning);
                        return;
                    }
                }
                if (rbToday.IsChecked == true)
                {
                    TList = TList.Where(m => m.StartDate == DateTime.Now.Date).ToList();
                }
                if (rbMonth.IsChecked == true)
                {
                    TList = TList.Where(m => m.StartDate.Month == DateTime.Now.Month && m.StartDate.Year == DateTime.Now.Year).ToList();
                }
                if (rbYear.IsChecked == true)
                {
                    TList = TList.Where(m => m.StartDate.Year == DateTime.Now.Year).ToList();
                }

                dgLeaveTransaction.ItemsSource = TList;
            }
            catch (Exception)
            {
                MessageBox.Show("Something went wrong.", "System Error!", MessageBoxButton.OK, MessageBoxImage.Error);
            }
        }