private void DataBerem_KeyDown(object sender, KeyEventArgs e)
{
try
{
if (e.KeyCode == Keys.Delete)
{
if (MessageBox.Show("Вы действительно хотите удалить данную запись?", "Удаление выделенной записи", MessageBoxButtons.YesNo, MessageBoxIcon.Question) == DialogResult.Yes)
{
DeleteClass.deleteBerem(int.Parse(dataBerem.CurrentRow.Cells[11].Value.ToString()), int.Parse(dataBerem.CurrentRow.Cells[12].Value.ToString()));
dataBerem.AutoGenerateColumns = false;
dataBerem.DataSource = LoadClass.LoadBeremCertif(dateFrom.Value.ToString("yyyy-MM-dd"), dateTo.Value.ToString("yyyy-MM-dd"));
}
}
else
{
return;
}
}
catch (Exception ex)
{
MessageBox.Show(ex.Message, "Ошибка", MessageBoxButtons.OK, MessageBoxIcon.Error);
logger.Debug("\n/--------------------------------------------------------------------/\n" + ex.StackTrace + "\n//----------------------------//\n" + ex.Message + "\n\n");
}
}
private void MainForm_Load(object sender, EventArgs e)
{
try
{
txtNameOrg.Text = Properties.Settings.Default.Name_LPU;
DateTime checkDate = DateTime.Today.AddMonths(-1);
dateFrom.Value = new DateTime(checkDate.Year, checkDate.Month, 25);
dateTo.Value = new DateTime(DateTime.Today.Year, DateTime.Today.Month, 25);
dataCertifRod.AutoGenerateColumns = false;
dataCertifRod.DataSource = LoadClass.FuncLoadFromTable(dateFrom.Value.ToString("yyyy-MM-dd"), dateTo.Value.ToString("yyyy-MM-dd"));
dataBerem.AutoGenerateColumns = false;
dataBerem.DataSource = LoadClass.LoadBeremCertif(dateFrom.Value.ToString("yyyy-MM-dd"), dateTo.Value.ToString("yyyy-MM-dd"));
FuncInsertDataTable();
}
catch (Exception ex)
{
MessageBox.Show(ex.Message, "Ошибка", MessageBoxButtons.OK, MessageBoxIcon.Error);
logger.Debug("\n/--------------------------------------------------------------------/\n" + ex.StackTrace + "\n//----------------------------//\n" + ex.Message + "\n\n");
}
}
private void DataBerem_CellMouseDoubleClick(object sender, DataGridViewCellMouseEventArgs e)
{
try
{
using (AddBerem abForm = new AddBerem(int.Parse(dataBerem.CurrentRow.Cells[12].Value.ToString()), false))
{
abForm.ShowDialog();
}
dataBerem.AutoGenerateColumns = false;
dataBerem.DataSource = LoadClass.LoadBeremCertif(dateFrom.Value.ToString("yyyy-MM-dd"), dateTo.Value.ToString("yyyy-MM-dd"));
}
catch (Exception ex)
{
MessageBox.Show(ex.Message, "Ошибка", MessageBoxButtons.OK, MessageBoxIcon.Error);
logger.Debug("\n/--------------------------------------------------------------------/\n" + ex.StackTrace + "\n//----------------------------//\n" + ex.Message + "\n\n");
}
}
private void DateTo_CloseUp(object sender, EventArgs e)
{
try
{
dataCertifRod.AutoGenerateColumns = false;
dataCertifRod.DataSource = LoadClass.FuncLoadFromTable(dateFrom.Value.ToString("yyyy-MM-dd"), dateTo.Value.ToString("yyyy-MM-dd"));
dataBerem.AutoGenerateColumns = false;
dataBerem.DataSource = LoadClass.LoadBeremCertif(dateFrom.Value.ToString("yyyy-MM-dd"), dateTo.Value.ToString("yyyy-MM-dd"));
FuncInsertDataTable();
}
catch (Exception ex)
{
MessageBox.Show(ex.Message, "Ошибка", MessageBoxButtons.OK, MessageBoxIcon.Error);
logger.Debug("\n/--------------------------------------------------------------------/\n" + ex.StackTrace + "\n//----------------------------//\n" + ex.Message + "\n\n");
}
}