private void RefreshDataGrid(string findtext = "")
{
try {
dtgMasters.DataSource = (from Masters in General.context.Masters
where
Masters.Name.Contains(findtext) ||
Masters.SurName.Contains(findtext) ||
Masters.Patronymic.Contains(findtext) ||
Masters.Phone.Contains(findtext)
select new
{
Masters.ID,
Masters.SurName,
Masters.Name,
Masters.Patronymic,
Masters.Birthday,
Masters.Phone,
Masters.imagename
}).ToList();
if (dtgMasters.RowCount > 0)
{
dtgMasters.Rows[0].Selected = true;
}
images = SettingsMasters.GetPicture(dtgMasters, out nameimages);
}catch (Exception exp)
{
MessageBox.Show(exp.Message.ToString());
}
}
private void btnFindDate_Click(object sender, EventArgs e)
{
var result = General.context.Masters.Select
(x => new
{
x.ID,
x.SurName,
x.Name,
x.Patronymic,
x.Birthday,
x.Phone,
x.imagename
});
DateTime Birthday = new DateTime(dtpClient.Value.Year, dtpClient.Value.Month, dtpClient.Value.Day);
foreach (RadioButton rdb in this.Controls.OfType <RadioButton>())
{
if (rdb.Checked)
{
switch (rdb.Text.ToString().Trim())
{
case "≥":
{
dtgMasters.DataSource = result.Where(x => x.Birthday >= Birthday).Select
(x => new
{
x.ID,
x.SurName,
x.Name,
x.Patronymic,
x.Birthday,
x.Phone,
x.imagename
}).ToList(); break;
}
case "≤":
{
dtgMasters.DataSource = result.Where(x => x.Birthday <= Birthday).Select
(x => new
{
x.ID,
x.SurName,
x.Name,
x.Patronymic,
x.Birthday,
x.Phone,
x.imagename
}).ToList(); break;
}
case "=":
{
dtgMasters.DataSource = result.Where(x => x.Birthday == Birthday).Select
(x => new
{
x.ID,
x.SurName,
x.Name,
x.Patronymic,
x.Birthday,
x.Phone,
x.imagename
}).ToList(); break;
}
case "∀": RefreshDataGrid(); break;
}
}
}
images = SettingsMasters.GetPicture(dtgMasters, out nameimages);
if (dtgMasters.RowCount != 0)
{
picBox.Image = SettingsMasters.CrutchImage(dtgMasters.Rows[0].Cells[6].FormattedValue.ToString().Trim());
}
GetInfoCount();
}
