public List <VisitorEmployeeView> searchVisitorByDate(string time1, string time2)
{
List <VisitorEmployeeView> visitorEmployeeViewList = new List <VisitorEmployeeView>();
DataAccessLayer.Instance.createDatabaseConnection();
string query = "SELECT visiting_time, visitor_id, visitor_name, employee_id, employee_name, relationship, purpose FROM visitoremployeeview WHERE visiting_time BETWEEN '" + time1 + "' AND '" + time2 + "';";
try
{
using (MySqlCommand mySqlCommand = new MySqlCommand(query, DataAccessLayer.Instance.Connection))
{
MySqlDataReader dataReader = mySqlCommand.ExecuteReader();
while (dataReader.Read())
{
VisitorEmployeeView visitorEmployeeView = new VisitorEmployeeView();
visitorEmployeeView.VisitingTime = dataReader.GetString(0);
visitorEmployeeView.VisitorID = dataReader.GetInt32(1);
visitorEmployeeView.VisitorName = dataReader.GetString(2);
visitorEmployeeView.EmployeeID = dataReader.GetInt32(3);
visitorEmployeeView.EmployeeName = dataReader.GetString(4);
visitorEmployeeView.Relationship = dataReader.GetString(5);
visitorEmployeeView.Purpose = dataReader.GetString(6);
visitorEmployeeViewList.Add(visitorEmployeeView);
}
return(visitorEmployeeViewList);
}
}
catch (Exception ex)
{
MessageBox.Show(ex.Message, this.ToString() + " SearchVisitorByDate Exception", MessageBoxButton.OK, MessageBoxImage.Error);
return(null);
}
}
private void Button_SearchByName(object sender, RoutedEventArgs ex)
{
List <VisitorEmployeeView> visitorEmployeeViewList = new List <VisitorEmployeeView>();
VisitorEmployeeView visitorEmployeeView = new VisitorEmployeeView();
visitorEmployeeView.VisitorName = TbxVisitorSearch.Text;
if (!visitorEmployeeView.VisitorName.Equals(""))
{
visitorEmployeeViewList = BLT.searchVisitorByName(visitorEmployeeView.VisitorName);
if (visitorEmployeeViewList != null)
{
if (visitorEmployeeViewList.Count != 0)
{
AlertVisitorSearch.Visibility = Visibility.Collapsed;
TbxVisitorSearch.Text = "";
ReceptionistVisitorDG.ItemsSource = visitorEmployeeViewList;
ReceptionistTablePanel.Visibility = Visibility.Visible;
ReceptionistVisitorDG.Visibility = Visibility.Visible;
}
else
{
AlertVisitorSearch.Text = "No Results Found";
AlertVisitorSearch.Visibility = Visibility.Visible;
ReceptionistTablePanel.Visibility = Visibility.Collapsed;
ReceptionistVisitorDG.Visibility = Visibility.Collapsed;
}
}
else
{
AlertVisitorSearch.Text = "Connection Error! Please Try Again Later";
AlertVisitorSearch.Visibility = Visibility.Visible;
ReceptionistTablePanel.Visibility = Visibility.Collapsed;
ReceptionistVisitorDG.Visibility = Visibility.Collapsed;
}
}
else
{
AlertVisitorSearch.Text = "The Search Field Is Empty";
AlertVisitorSearch.Visibility = Visibility.Visible;
ReceptionistTablePanel.Visibility = Visibility.Collapsed;
ReceptionistVisitorDG.Visibility = Visibility.Collapsed;
}
}
