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 FuncInsertDataTable()
{
try
{
dataReportTable = LoadClass.FuncTable(dateFrom.Value.ToString("yyyy-MM-dd"), dateTo.Value.ToString("yyyy-MM-dd"));
for (int i = 0; i < dataReportTable.Rows.Count; i++)
{
if (dataReportTable.Rows[i][0].ToString() == "В период беременности")
{
lblPeriodBerem.Text = dataReportTable.Rows[i][2].ToString();
lblPeriodBeremCountryWomen.Text = dataReportTable.Rows[i][1].ToString();
}
else
{
lblPeriodRodov.Text = dataReportTable.Rows[i][2].ToString();
lblPeriodRodovCountryWomen.Text = dataReportTable.Rows[i][1].ToString();
}
}
}
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 EditRodBTN()
{
try
{
using (AddPatient apForm = new AddPatient(int.Parse(dataCertifRod.CurrentRow.Cells[13].Value.ToString()), false))
{
apForm.ShowDialog();
}
dataCertifRod.DataSource = LoadClass.FuncLoadFromTable(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 DataCertifRod_CellMouseDoubleClick(object sender, DataGridViewCellMouseEventArgs e)
{
try
{
using (AddPatient apForm = new AddPatient(int.Parse(dataCertifRod.CurrentRow.Cells[13].Value.ToString()), false))
{
apForm.ShowDialog();
}
dataCertifRod.AutoGenerateColumns = false;
dataCertifRod.DataSource = LoadClass.FuncLoadFromTable(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");
}
}
private void BtnApply_Click(object sender, EventArgs e)
{
try
{
Cursor.Current = Cursors.WaitCursor;
dataRodOtdel.DataSource = LoadClass.FuncLoad(dateFrom.Value.ToString("yyyy-MM-dd"), dateTo.Value.ToString("yyyy-MM-dd"));
dataCertifRod.DataSource = LoadClass.FuncLoadFromTable(dateFrom.Value.ToString("yyyy-MM-dd"), dateTo.Value.ToString("yyyy-MM-dd"));
Cursor.Current = Cursors.Default;
}
catch (Exception ex)
{
Cursor.Current = Cursors.Default;
MessageBox.Show(ex.Message, "Ошибка", MessageBoxButtons.OK, MessageBoxIcon.Error);
logger.Debug("\n/--------------------------------------------------------------------/\n" + ex.StackTrace + "\n//----------------------------//\n" + ex.Message + "\n\n");
}
}
private void DataCertifRod_KeyDown(object sender, KeyEventArgs e)
{
try
{
if (e.KeyCode == Keys.Delete)
{
if (MessageBox.Show("Вы действительно хотите удалить данную запись?", "Удаление выделенной записи", MessageBoxButtons.YesNo, MessageBoxIcon.Question) == DialogResult.Yes)
{
DeleteClass.deleteRod(int.Parse(dataCertifRod.CurrentRow.Cells[13].Value.ToString()), int.Parse(dataCertifRod.CurrentRow.Cells[14].Value.ToString()), dataCertifRod.CurrentRow.Cells[0].Value.ToString());
dataCertifRod.DataSource = LoadClass.FuncLoadFromTable(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 AddBerem_Load(object sender, EventArgs e)
{
try
{
cbTypeDoc.DataSource = docName;
if (insert == true)
{
woman = LoadClass.FuncINSRT(client_id);
tbLNAME.Text = woman.Rows[0][0].ToString();
tbFNAME.Text = woman.Rows[0][1].ToString();
tbMNAME.Text = woman.Rows[0][2].ToString();
dateBDATE.Value = DateTime.Parse(woman.Rows[0][3].ToString());
tbADDRESS.Text = woman.Rows[0][4].ToString();
tbSNILS.Text = woman.Rows[0][5].ToString();
tbSPOLICY.Text = woman.Rows[0][6].ToString();
tbNPOLICY.Text = woman.Rows[0][7].ToString();
cbTypeDoc.SelectedIndex = int.Parse(woman.Rows[0][8].ToString());
tbSDOC.Text = woman.Rows[0][9].ToString();
tbNDOC.Text = woman.Rows[0][10].ToString();
dateDDOC.Value = DateTime.Parse(woman.Rows[0][11].ToString());
tbODOC.Text = woman.Rows[0][12].ToString();
tbSCERTIF.Text = woman.Rows[0][13].ToString();
tbNCERTIF.Text = woman.Rows[0][14].ToString();
dateDCERTIF.Value = DateTime.Parse(woman.Rows[0][15].ToString());
tbSLEAF.Text = woman.Rows[0][16].ToString();
tbNLEAF.Text = woman.Rows[0][17].ToString();
dateDLEAF.Value = DateTime.Parse(woman.Rows[0][18].ToString());
}
else
{
forUpdate = InsertUpdateClass.LoadMotherUPDT_BTAL1(client_id);
tbLNAME.Text = forUpdate.Rows[0][1].ToString();
tbFNAME.Text = forUpdate.Rows[0][2].ToString();
tbMNAME.Text = forUpdate.Rows[0][3].ToString();
dateBDATE.Value = DateTime.Parse(forUpdate.Rows[0][4].ToString());
tbADDRESS.Text = forUpdate.Rows[0][5].ToString();
tbSNILS.Text = forUpdate.Rows[0][6].ToString();
tbSPOLICY.Text = forUpdate.Rows[0][7].ToString();
tbNPOLICY.Text = forUpdate.Rows[0][8].ToString();
cbTypeDoc.SelectedIndex = int.Parse(forUpdate.Rows[0][9].ToString());
tbSDOC.Text = forUpdate.Rows[0][10].ToString();
tbNDOC.Text = forUpdate.Rows[0][11].ToString();
dateDDOC.Value = DateTime.Parse(forUpdate.Rows[0][12].ToString());
tbODOC.Text = forUpdate.Rows[0][13].ToString();
tbSCERTIF.Text = forUpdate.Rows[0][14].ToString();
tbNCERTIF.Text = forUpdate.Rows[0][15].ToString();
dateDCERTIF.Value = DateTime.Parse(forUpdate.Rows[0][16].ToString());
tbSLEAF.Text = forUpdate.Rows[0][17].ToString();
tbNLEAF.Text = forUpdate.Rows[0][18].ToString();
dateDLEAF.Value = DateTime.Parse(forUpdate.Rows[0][19].ToString());
dateDREG.Value = DateTime.Parse(forUpdate.Rows[0][21].ToString());
tbQTW.Text = forUpdate.Rows[0][22].ToString();
cBMULP.Checked = (forUpdate.Rows[0][23].ToString() == "1" ? true : false);
cBPREM.Checked = (forUpdate.Rows[0][24].ToString() == "1" ? true : false);
PHELP_CB.Checked = (forUpdate.Rows[0][25].ToString() == "1" ? true : false);
if (forUpdate.Rows[0][20].ToString() == "1")
{
if (forUpdate.Rows[0][25].ToString() == "1")
{
lbCHK.ForeColor = Color.Black;
lbCHK.Text = "4000,00";
}
else
{
lbCHK.ForeColor = Color.Black;
lbCHK.Text = "3000,00";
}
}
this.Text = "Редактирование записи";
}
}
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 AddPatient_Load(object sender, EventArgs e)
{
try
{
cbTypeDoc.DataSource = docName;
dgvCHILD.AutoGenerateColumns = false;
dgvCHILD.DataSource = Child;
if (insert == true)
{
woman = LoadClass.FuncINSRT(client_id);
tbLNAME.Text = woman.Rows[0][0].ToString();
tbFNAME.Text = woman.Rows[0][1].ToString();
tbMNAME.Text = woman.Rows[0][2].ToString();
dateBDATE.Value = DateTime.Parse(woman.Rows[0][3].ToString());
tbADDRESS.Text = woman.Rows[0][4].ToString();
tbSNILS.Text = woman.Rows[0][5].ToString();
tbSPOLICY.Text = woman.Rows[0][6].ToString();
tbNPOLICY.Text = woman.Rows[0][7].ToString();
cbTypeDoc.SelectedIndex = int.Parse(woman.Rows[0][8].ToString());
tbSDOC.Text = woman.Rows[0][9].ToString();
tbNDOC.Text = woman.Rows[0][10].ToString();
dateDDOC.Value = DateTime.Parse(woman.Rows[0][11].ToString());
tbODOC.Text = woman.Rows[0][12].ToString();
tbSCERTIF.Text = woman.Rows[0][13].ToString();
tbNCERTIF.Text = woman.Rows[0][14].ToString();
dateDCERTIF.Value = DateTime.Parse(woman.Rows[0][15].ToString());
tbSLEAF.Text = woman.Rows[0][16].ToString();
tbNLEAF.Text = woman.Rows[0][17].ToString();
dateDLEAF.Value = DateTime.Parse(woman.Rows[0][18].ToString());
}
else
{
forTableUPD = InsertUpdateClass.FuncMotherUPD(client_id);
dateDREG.Value = DateTime.Parse(forTableUPD.Rows[0][0].ToString());
tbDIAG.Text = forTableUPD.Rows[0][1].ToString();
tbBQNT.Text = forTableUPD.Rows[0][2].ToString();
tbLNAME.Text = forTableUPD.Rows[0][3].ToString();
tbFNAME.Text = forTableUPD.Rows[0][4].ToString();
tbMNAME.Text = forTableUPD.Rows[0][5].ToString();
dateBDATE.Value = DateTime.Parse(forTableUPD.Rows[0][6].ToString());
tbADDRESS.Text = forTableUPD.Rows[0][7].ToString();
tbSNILS.Text = forTableUPD.Rows[0][8].ToString();
tbSPOLICY.Text = forTableUPD.Rows[0][9].ToString();
tbNPOLICY.Text = forTableUPD.Rows[0][10].ToString();
cbTypeDoc.SelectedIndex = int.Parse(forTableUPD.Rows[0][11].ToString());
tbSDOC.Text = forTableUPD.Rows[0][12].ToString();
tbNDOC.Text = forTableUPD.Rows[0][13].ToString();
dateDDOC.Value = DateTime.Parse(forTableUPD.Rows[0][14].ToString());
tbODOC.Text = forTableUPD.Rows[0][15].ToString();
tbSCERTIF.Text = forTableUPD.Rows[0][16].ToString();
tbNCERTIF.Text = forTableUPD.Rows[0][17].ToString();
dateDCERTIF.Value = DateTime.Parse(forTableUPD.Rows[0][18].ToString());
tbSLEAF.Text = forTableUPD.Rows[0][19].ToString();
tbNLEAF.Text = forTableUPD.Rows[0][20].ToString();
dateDLEAF.Value = DateTime.Parse(forTableUPD.Rows[0][21].ToString());
tbNCARD.Text = forTableUPD.Rows[0][22].ToString();
dateDCARD.Value = DateTime.Parse(forTableUPD.Rows[0][23].ToString());
BQNT = int.Parse(tbBQNT.Text);
Child = InsertUpdateClass.FuncChildUPD(client_id, tbSCERTIF.Text + " " + tbNCERTIF.Text);
dgvCHILD.DataSource = Child;
AddCNTChild = dgvCHILD.Rows.Count;
oldCertif = $"{tbSCERTIF.Text + " " + tbNCERTIF.Text}";
this.Text = "Редактирование записи";
}
}
catch (Exception ex)
{
MessageBox.Show(ex.Message, "Ошибка", MessageBoxButtons.OK, MessageBoxIcon.Error);
logger.Debug("\n/--------------------------------------------------------------------/\n" + ex.StackTrace + "\n//----------------------------//\n" + ex.Message + "\n\n");
}
}