public Form1()
{
InitializeComponent();
//comboBox1.SelectedIndex = 0;
chatAdapter = new MyChatTableAdapters.ChatTableAdapter();
userAdapter = new MyChatTableAdapters.UsersTableAdapter();
sessionAdapter = new MyChatTableAdapters.SessionsLogTableAdapter();
userDB = userAdapter.GetData();
chatDB = chatAdapter.GetData();
sessionDB = sessionAdapter.GetData();
}
private void buttonOk_Click(object sender, EventArgs e)
{
var chatAdapter = new MyChatTableAdapters.ChatTableAdapter();
var userAdapter = new MyChatTableAdapters.UsersTableAdapter();
var userDB = userAdapter.GetData();
var chatDB = chatAdapter.GetData();
var dateStart = DateTime.Parse(dateTimePicker1.Text);
var dateEnd = DateTime.Parse(dateTimePicker2.Text);
if (checkBoxDate.Checked && checkBoxName.Checked)
{
var query = from u in userDB
where u.UserName == textBox1.Text
join m in chatDB on u.UserID equals m.UserID
where m.MessageDate >= dateStart && m.MessageDate <= dateEnd
select new { UserID = u.UserID, UserName = u.UserName, MessageText = m.MessageText, MessageDate = m.MessageDate };
dataGridViewChat.DataSource = query.ToList();
}
else if (checkBoxDate.Checked && !checkBoxName.Checked)
{
var query = from u in userDB
join m in chatDB on u.UserID equals m.UserID
where m.MessageDate >= dateStart && m.MessageDate <= dateEnd
select new { UserID = u.UserID, UserName = u.UserName, MessageText = m.MessageText, MessageDate = m.MessageDate };
dataGridViewChat.DataSource = query.ToList();
}
else if (!checkBoxDate.Checked && checkBoxName.Checked)
{
var query = from u in userDB
where u.UserName == textBox1.Text
join m in chatDB on u.UserID equals m.UserID
select new { UserID = u.UserID, UserName = u.UserName, MessageText = m.MessageText, MessageDate = m.MessageDate };
dataGridViewChat.DataSource = query.ToList();
}
this.Close();
}