void loadvars(int empId, DateTime dtf, DateTime dtt)
 {
     try
     {
         if (dtf.Date > dtt.Date)
         {
             label12.Visible = true;
             listView1.Items.Clear();
         }
         else
         {
             label12.Visible = false;
             var list = svc.EmployeeLeave_Select(empId, dtf, dtt);
             listView1.Items.Clear();
             if (list.Count >= 100)
             {
                 MessageBox.Show("Search result is limited to 100 records only. Narrow your search for specific results.", "Warning", MessageBoxButtons.OK, MessageBoxIcon.Exclamation);
             }
             foreach (var li in list)
             {
                 ListViewItem lv = new ListViewItem(li.Id.ToString());
                 lv.SubItems.Add(li.EmployeeId.ToString("0000"));
                 lv.SubItems.Add(li.EmployeeFullName);
                 lv.SubItems.Add(li.LeaveType);
                 lv.SubItems.Add(li.LeaveDateFrom.ToShortDateString());
                 lv.SubItems.Add(li.LeaveDateTo.ToShortDateString());
                 lv.SubItems.Add(li.NoDaysLeave.ToString());
                 lv.SubItems.Add(li.LeaveStatus);
                 lv.Font = new Font(lv.Font, FontStyle.Regular);
                 listView1.Items.AddRange(new ListViewItem[] { lv });
             }
         }
     }
     catch (Exception ex) { MessageBox.Show(ex.Message, "Error"); }
 }