//Show Date and Frequency if you search someone.
private void ShowDateFreq()
{
nameTextBox.ResetText();
frequency.ResetText();
MostRecentVisitText.ResetText();
nameTextBox.AppendText(textSearch.Text);
string query = "SELECT a.MostRecentVisit , a.Frequency FROM Person a " +
"WHERE a.Name = @Name";
connection = new SqlConnection(connectionString);
SqlCommand command = new SqlCommand(query, connection);
command.Parameters.AddWithValue("@Name", textSearch.Text);
connection.Open();
using (SqlDataReader reader = command.ExecuteReader())
{
if (reader.Read())
{
MostRecentVisitText.AppendText(reader.GetDateTime(0).ToString());
frequency.AppendText(reader.GetInt32(1).ToString() + " times");
}
else
{
AddPerson();
}
}
}
//Add if not existed
private void AddPerson()
{
string query = "INSERT INTO Person VALUES (@Name, @Date, 0)";
using (connection = new SqlConnection(connectionString))
using (SqlCommand command = new SqlCommand(query, connection))
{
connection.Open();
command.Parameters.AddWithValue("@Name", textSearch.Text);
command.Parameters.AddWithValue("@Date", DateTime.Now);
MostRecentVisitText.AppendText(DateTime.Now.ToString("yyyy-MM-dd HH:mm:ss tt"));
frequency.AppendText("0");
command.ExecuteReader();
}
}
