private void listViewZhitie_SelectedIndexChanged(object sender, EventArgs e)
{
buttonApply.Enabled = true;
buttonDelete.Enabled = true;
textBoxName.Enabled = true;
textBoxCena.Enabled = true;
bNew = false;
if (listViewZhitie.FocusedItem == null)
{
return;
}
int k = queueZhitie.Count;
for (int i = 0; i < k; i++)
{
m_zhitie = (_Zhitie)queueZhitie.Dequeue();
if (m_zhitie.id.ToString() == (string)listViewZhitie.Items[listViewZhitie.FocusedItem.Index].Tag)
{
textBoxName.Text = m_zhitie.nazvanie;
textBoxCena.Text = m_zhitie.cena;
queueZhitie.Enqueue(m_zhitie);
break;
}
;
queueZhitie.Enqueue(m_zhitie);
}
}
private void comboBoxZhitie_SelectedIndexChanged(object sender, EventArgs e)
{
if (comboBoxZhitie.SelectedIndex == -1)
{
return;
}
m_zhitie = (_Zhitie)comboBoxZhitie.SelectedItem;
}
public void refreshZhitie()
{
string Zhitie = "";
if (comboBoxZhitie.SelectedIndex != -1)
{
Zhitie = m_zhitie.nazvanie.ToString();
}
comboBoxZhitie.Items.Clear();
queueZhitie.Clear();
try
{
mainWin.m_dbConnector.Lock();
MySqlConnection conn = mainWin.m_dbConnector.getMySqlConnection();
string sql = "SELECT `id`, `nazvanie` FROM `zhitie` ORDER BY `id`";
MySqlDataAdapter myAdapter = new MySqlDataAdapter();
myAdapter.SelectCommand = new MySqlCommand(sql, conn);
DataSet dataSet = new DataSet();
myAdapter.Fill(dataSet);
DataTable dataTable = dataSet.Tables[0];
_Zhitie c = new _Zhitie();
foreach (DataRow dataRow in dataTable.Rows)
{
c.id = dataRow["id"].ToString();
c.nazvanie = dataRow["nazvanie"].ToString().Trim();
comboBoxZhitie.Items.Add(c);
if (Zhitie != "" && Zhitie == c.nazvanie.ToString())
{
comboBoxZhitie.SelectedItem = c;
}
queueZhitie.Enqueue(c);
}
}
catch (Exception ex)
{
MessageBox.Show(ex.ToString());
}
finally
{
mainWin.m_dbConnector.Unlock();
}
}
public void refreshZhitie()
{
listViewZhitie.Items.Clear();
queueZhitie.Clear();
try
{
mainWin.m_dbConnector.Lock();
MySqlConnection conn = mainWin.m_dbConnector.getMySqlConnection();
string sql = "SELECT `id`, `nazvanie`, `cena` FROM `zhitie` ORDER BY `id`";
MySqlDataAdapter myAdapter = new MySqlDataAdapter();
myAdapter.SelectCommand = new MySqlCommand(sql, conn);
DataSet dataSet = new DataSet();
myAdapter.Fill(dataSet);
DataTable dataTable = dataSet.Tables[0];
listViewZhitie.Items.Clear();
queueZhitie.Clear();
_Zhitie t = new _Zhitie();
foreach (DataRow dataRow in dataTable.Rows)
{
ListViewItem item1 = new ListViewItem(dataRow["id"].ToString().Trim(), 0);
t.id = dataRow["id"].ToString();
item1.SubItems.Add(dataRow["nazvanie"].ToString().Trim());
t.nazvanie = dataRow["nazvanie"].ToString().Trim();
item1.SubItems.Add(dataRow["cena"].ToString().Trim());
t.cena = dataRow["cena"].ToString().Trim();
listViewZhitie.Items.Add(item1);
listViewZhitie.Items[listViewZhitie.Items.Count - 1].Tag = dataRow["id"].ToString();
queueZhitie.Enqueue(t);
}
}
catch (Exception ex)
{
MessageBox.Show(ex.ToString());
}
finally
{
mainWin.m_dbConnector.Unlock();
}
}
private void listViewZhitie_SelectedIndexChanged(object sender, EventArgs e)
{
buttonApply.Enabled = true;
buttonDelete.Enabled = true;
textBoxName.Enabled = true;
textBoxCena.Enabled = true;
bNew = false;
if (listViewZhitie.FocusedItem == null)
return;
int k = queueZhitie.Count;
for (int i = 0; i < k; i++)
{
m_zhitie = (_Zhitie)queueZhitie.Dequeue();
if (m_zhitie.id.ToString() == (string)listViewZhitie.Items[listViewZhitie.FocusedItem.Index].Tag)
{
textBoxName.Text = m_zhitie.nazvanie;
textBoxCena.Text = m_zhitie.cena;
queueZhitie.Enqueue(m_zhitie);
break;
};
queueZhitie.Enqueue(m_zhitie);
}
}
public void refreshZhitie()
{
listViewZhitie.Items.Clear();
queueZhitie.Clear();
try
{
mainWin.m_dbConnector.Lock();
MySqlConnection conn = mainWin.m_dbConnector.getMySqlConnection();
string sql = "SELECT `id`, `nazvanie`, `cena` FROM `zhitie` ORDER BY `id`";
MySqlDataAdapter myAdapter = new MySqlDataAdapter();
myAdapter.SelectCommand = new MySqlCommand(sql, conn);
DataSet dataSet = new DataSet();
myAdapter.Fill(dataSet);
DataTable dataTable = dataSet.Tables[0];
listViewZhitie.Items.Clear();
queueZhitie.Clear();
_Zhitie t = new _Zhitie();
foreach (DataRow dataRow in dataTable.Rows)
{
ListViewItem item1 = new ListViewItem(dataRow["id"].ToString().Trim(), 0);
t.id = dataRow["id"].ToString();
item1.SubItems.Add(dataRow["nazvanie"].ToString().Trim());
t.nazvanie = dataRow["nazvanie"].ToString().Trim();
item1.SubItems.Add(dataRow["cena"].ToString().Trim());
t.cena = dataRow["cena"].ToString().Trim();
listViewZhitie.Items.Add(item1);
listViewZhitie.Items[listViewZhitie.Items.Count - 1].Tag = dataRow["id"].ToString();
queueZhitie.Enqueue(t);
}
}
catch (Exception ex)
{
MessageBox.Show(ex.ToString());
}
finally
{
mainWin.m_dbConnector.Unlock();
}
}
private void listViewRasselenie_SelectedIndexChanged(object sender, EventArgs e)
{
buttonApply.Enabled = true;
buttonDelete.Enabled = true;
textBoxName.Enabled = true;
comboBoxZhitie.SelectedIndex = -1;
dateTimePicker1.Enabled = true;
comboBoxZhitie.Enabled = true;
textBoxKolDays.Enabled = true;
textBoxKolCzel.Enabled = true;
textBoxPark.Enabled = true;
textBoxNkvit.Enabled = true;
comboBoxCity.Enabled = true;
comboBoxZakazczik.Enabled = true;
textBoxBron.Enabled = true;
textBoxBez.Enabled = true;
bNew = false;
if (listViewRasselenie.FocusedItem == null)
{
return;
}
int k = queueRasselenie.Count;
for (int i = 0; i < k; i++)
{
m_rasselenie = (_Rasselenie)queueRasselenie.Dequeue();
if (m_rasselenie.id.ToString() == (string)listViewRasselenie.Items[listViewRasselenie.FocusedItem.Index].Tag)
{
textBoxName.Text = m_rasselenie.FiO;
textBoxKolDays.Text = m_rasselenie.Kol_dney;
textBoxKolCzel.Text = m_rasselenie.Kol_czel;
textBoxPark.Text = m_rasselenie.parkovka;
textBoxNkvit.Text = m_rasselenie.N_kvit;
comboBoxCity.Text = m_rasselenie.City;
comboBoxZakazczik.Text = m_rasselenie.zakazczik;
//if (m_rasselenie.zhitie_bez == "")
comboBoxZhitie.Text = m_rasselenie.zhitie;
//else comboBoxZhitie.Text = m_rasselenie.zhitie_bez;
//if (m_rasselenie.bron_bez == "")
textBoxBron.Text = m_rasselenie.bron;
//else textBoxBron.Text = m_rasselenie.bron_bez;
textBoxBez.Text = m_rasselenie.bron_bez;
dateTimePicker1.Value = DateTime.Parse(m_rasselenie.date);
_Zhitie c;
int k2 = queueZhitie.Count;
for (int i2 = 0; i2 < k2; i2++)
{
c = (_Zhitie)queueZhitie.Dequeue();
if (c.nazvanie.ToString() == m_rasselenie.zhitie.ToString())
{
for (int iii = 0; iii < comboBoxZhitie.Items.Count; iii++)
{
if (((_Zhitie)comboBoxZhitie.Items[iii]).nazvanie == c.nazvanie)
{
comboBoxZhitie.SelectedIndex = iii;
m_zhitie = c;
break;
}
}
}
;
queueZhitie.Enqueue(c);
}
queueRasselenie.Enqueue(m_rasselenie);
break;
}
;
queueRasselenie.Enqueue(m_rasselenie);
}
}
private void listViewRasselenie_SelectedIndexChanged(object sender, EventArgs e)
{
buttonApply.Enabled = true;
buttonDelete.Enabled = true;
textBoxName.Enabled = true;
comboBoxZhitie.SelectedIndex = -1;
dateTimePicker1.Enabled = true;
comboBoxZhitie.Enabled = true;
textBoxKolDays.Enabled = true;
textBoxKolCzel.Enabled = true;
textBoxPark.Enabled = true;
textBoxNkvit.Enabled = true;
comboBoxCity.Enabled = true;
comboBoxZakazczik.Enabled = true;
textBoxBron.Enabled = true;
textBoxBez.Enabled = true;
bNew = false;
if (listViewRasselenie.FocusedItem == null)
return;
int k = queueRasselenie.Count;
for (int i = 0; i < k; i++)
{
m_rasselenie = (_Rasselenie)queueRasselenie.Dequeue();
if (m_rasselenie.id.ToString() == (string)listViewRasselenie.Items[listViewRasselenie.FocusedItem.Index].Tag)
{
textBoxName.Text = m_rasselenie.FiO;
textBoxKolDays.Text = m_rasselenie.Kol_dney;
textBoxKolCzel.Text = m_rasselenie.Kol_czel;
textBoxPark.Text = m_rasselenie.parkovka;
textBoxNkvit.Text = m_rasselenie.N_kvit;
comboBoxCity.Text = m_rasselenie.City;
comboBoxZakazczik.Text = m_rasselenie.zakazczik;
//if (m_rasselenie.zhitie_bez == "")
comboBoxZhitie.Text = m_rasselenie.zhitie;
//else comboBoxZhitie.Text = m_rasselenie.zhitie_bez;
//if (m_rasselenie.bron_bez == "")
textBoxBron.Text = m_rasselenie.bron;
//else textBoxBron.Text = m_rasselenie.bron_bez;
textBoxBez.Text = m_rasselenie.bron_bez;
dateTimePicker1.Value = DateTime.Parse(m_rasselenie.date);
_Zhitie c;
int k2 = queueZhitie.Count;
for (int i2 = 0; i2 < k2; i2++)
{
c = (_Zhitie)queueZhitie.Dequeue();
if (c.nazvanie.ToString() == m_rasselenie.zhitie.ToString())
{
for (int iii = 0; iii < comboBoxZhitie.Items.Count; iii++)
{
if (((_Zhitie)comboBoxZhitie.Items[iii]).nazvanie == c.nazvanie)
{
comboBoxZhitie.SelectedIndex = iii;
m_zhitie = c;
break;
}
}
};
queueZhitie.Enqueue(c);
}
queueRasselenie.Enqueue(m_rasselenie);
break;
};
queueRasselenie.Enqueue(m_rasselenie);
}
}
private void comboBoxZhitie_SelectedIndexChanged(object sender, EventArgs e)
{
if (comboBoxZhitie.SelectedIndex == -1)
return;
m_zhitie = (_Zhitie)comboBoxZhitie.SelectedItem;
}
public void refreshZhitie()
{
string Zhitie = "";
if (comboBoxZhitie.SelectedIndex != -1)
{
Zhitie = m_zhitie.nazvanie.ToString();
}
comboBoxZhitie.Items.Clear();
queueZhitie.Clear();
try
{
mainWin.m_dbConnector.Lock();
MySqlConnection conn = mainWin.m_dbConnector.getMySqlConnection();
string sql = "SELECT `id`, `nazvanie` FROM `zhitie` ORDER BY `id`";
MySqlDataAdapter myAdapter = new MySqlDataAdapter();
myAdapter.SelectCommand = new MySqlCommand(sql, conn);
DataSet dataSet = new DataSet();
myAdapter.Fill(dataSet);
DataTable dataTable = dataSet.Tables[0];
_Zhitie c = new _Zhitie();
foreach (DataRow dataRow in dataTable.Rows)
{
c.id = dataRow["id"].ToString();
c.nazvanie = dataRow["nazvanie"].ToString().Trim();
comboBoxZhitie.Items.Add(c);
if (Zhitie != "" && Zhitie == c.nazvanie.ToString())
{
comboBoxZhitie.SelectedItem = c;
}
queueZhitie.Enqueue(c);
}
}
catch (Exception ex)
{
MessageBox.Show(ex.ToString());
}
finally
{
mainWin.m_dbConnector.Unlock();
}
}
private void listViewReportsRasselenie_SelectedIndexChanged(object sender, EventArgs e)
{
if (listViewReportsRasselenie.FocusedItem == null)
return;
int k = queueReportsRasselenie.Count;
for (int i = 0; i < k; i++)
{
m_reportsrasselenie = (_ReportsRasselenie)queueReportsRasselenie.Dequeue();
if (m_reportsrasselenie.date.ToString() == (string)listViewReportsRasselenie.Items[listViewReportsRasselenie.FocusedItem.Index].Tag)
{
// textBoxName.Text = m_reportsrasselenie.date;
// textBoxCity.Text = m_reportsrasselenie.city;
_Zhitie c;
int k2 = queueZhitie.Count;
for (int i2 = 0; i2 < k2; i2++)
{
c = (_Zhitie)queueZhitie.Dequeue();
if (c.nazvanie.ToString() == m_reportsrasselenie.zhitie.ToString())
{
for (int iii = 0; iii < comboBoxZhitie.Items.Count; iii++)
{
if (((_Zhitie)comboBoxZhitie.Items[iii]).nazvanie == c.nazvanie)
{
comboBoxZhitie.SelectedIndex = iii;
m_zhitie = c;
break;
}
}
};
queueZhitie.Enqueue(c);
}
queueReportsRasselenie.Enqueue(m_reportsrasselenie);
break;
};
queueReportsRasselenie.Enqueue(m_reportsrasselenie);
}
}