/// <summary>
/// Get Message By Date
/// </summary>
/// <param name="date">The Date The Message Got Sent</param>
/// <param name="compare">Search By Minute/Day</param>
/// <returns></returns>
public DataTable GetMessages(DateTime date, DateBy compare)
{
return(ExecuteStoreProcedure(GetTable, "MessageByDate",
new SqlParameter("@date", SqlDbType.DateTime)
{
Value = date
},
NvarChar("compareBy", compare.ToString())));
}
//Get Message Button Click Will Get Message By Date Or By Text
private void GetMessagesBtn_Click(object sender, EventArgs e)
{
if (GetMessageCheckBox.Checked)
{
DataBaseMessages.DataSource = data.GetMessages(MessageByText.Text);
}
else
{
DateBy dateBy = GetByDatePart.Checked ? DateBy.Day : DateBy.Minute;
DataBaseMessages.DataSource = data.GetMessages(MessageByDate.Value, dateBy);
}
}
