private void operatorBilgileriToolStripMenuItem_Click(object sender, EventArgs e)
{
string countQuery = "SELECT COUNT(OPERATOR_TO_RAPOR.OP_RAPOR_INCKEY) TOTAL FROM OPERATOR_TO_RAPOR " +
"INNER JOIN OPERATOR ON OPERATOR_TO_RAPOR.OP_INCKEY = OPERATOR.OP_INCKEY " +
"WHERE OPERATOR_TO_RAPOR.RAPOR_INCKEY = " + Convert.ToInt32(selectedItem.Item2[0].Value.ToString());
sqlCmd = new SqlCommand(countQuery, Program.connection);
SqlDataReader reader = sqlCmd.ExecuteReader();
reader.Read();
if (((int)reader["TOTAL"]) > 0)
{
selectedItem = new Tuple <int, DataGridViewCellCollection>(raporListGridView.SelectedRows[0].Index, raporListGridView.SelectedRows[0].Cells);
OperatorListesi operatorListesi = new OperatorListesi(this);
operatorListesi.query = "SELECT OPERATOR.OP_INCKEY, OPERATOR.ADSOYAD ADI_SOYADI, CASE WHEN OPERATOR.OP_DURUMU = 1 THEN 'Aktif' ELSE 'Pasif' END AS OPERATOR_DURUMU, " +
"FORMAT(OPERATOR.ISE_BAS_TARIH, 'dd.MM.yyyy') ISE_BASLAMA_TARIHI FROM OPERATOR_TO_RAPOR " +
"INNER JOIN OPERATOR ON OPERATOR_TO_RAPOR.OP_INCKEY = OPERATOR.OP_INCKEY " +
"WHERE OPERATOR_TO_RAPOR.RAPOR_INCKEY = " + Convert.ToInt32(selectedItem.Item2[0].Value.ToString()) + " ORDER BY OPERATOR.OP_INCKEY DESC";
operatorListesi.Text = "SMOOTHSIS [ " + selectedItem.Item2[3].Value.ToString() + " VARDİYA RAPORU OPERATÖR LİSTESİ ]";
operatorListesi.ShowDialog();
}
else
{
Notification.messageBox("BU RAPORA AİT OPERATÖR BULUNMUYOR.");
}
}
private void operatörListesiToolStripMenuItem_Click(object sender, EventArgs e)
{
OperatorListesi operatorListesi = new OperatorListesi();
operatorListesi.Show();
}
public OperatorDuzenle(OperatorListesi operatorListesi)
{
InitializeComponent();
this.operatorListesi = operatorListesi;
}
