private void NapolniListView()
{
var connectionString = ConfigurationManager.ConnectionStrings["myDatabaseConnection"].ConnectionString;
using (MySqlConnection connection = new MySqlConnection(connectionString))
{
var query = "select b.opis, b.kolicina from blago b " +
"join dobavnice dn on dn.blago_id = b.st_dokumenta " +
"where dn.id = " + id_dobavnice + ";";
connection.Open();
using (MySqlCommand command = new MySqlCommand(query, connection))
using (MySqlDataReader reader = command.ExecuteReader())
{
while (reader.Read())
{
LVI list_items = new LVI();
if (reader["opis"] != DBNull.Value)
{
list_items.Opis = (Convert.ToString(reader["opis"]));
}
if (reader["kolicina"] != DBNull.Value)
{
list_items.Kol = (Convert.ToInt32(reader["kolicina"]));
}
lvi_list_dobavnice.Add(list_items);
}
connection.Close();
}
}
}
private void NapolniListView()
{
var connectionString = ConfigurationManager.ConnectionStrings["myDatabaseConnection"].ConnectionString;
using (MySqlConnection connection = new MySqlConnection(connectionString))
{
var query = "select b.opis, b.cena_brez_ddv, b.cena_z_ddv, b.kolicina, b.vrednost, b.ddv from blago b " +
"join racuni dn on dn.blago_id = b.st_dokumenta " +
"where dn.id = " + id_racuna + ";";
connection.Open();
using (MySqlCommand command = new MySqlCommand(query, connection))
using (MySqlDataReader reader = command.ExecuteReader())
{
while (reader.Read())
{
LVI list_items = new LVI();
if (reader["opis"] != DBNull.Value)
{
list_items.Opis = (Convert.ToString(reader["opis"]));
}
if (reader["cena_brez_ddv"] != DBNull.Value)
{
list_items.Cena_brez_ddv = (Convert.ToDecimal(reader["cena_brez_ddv"])).ToString("#,###.00");
list_items._Cena_brez_ddv = (Convert.ToDecimal(reader["cena_brez_ddv"]));
}
if (reader["cena_z_ddv"] != DBNull.Value)
{
list_items.Cena_z_ddv = (Convert.ToDecimal(reader["cena_z_ddv"])).ToString("#,###.00");
list_items._Cena_z_ddv = (Convert.ToDecimal(reader["cena_z_ddv"]));
}
if (reader["kolicina"] != DBNull.Value)
{
list_items.Kol = (Convert.ToInt32(reader["kolicina"]));
}
if (reader["vrednost"] != DBNull.Value)
{
list_items.Vrednost = (Convert.ToDecimal(reader["vrednost"])).ToString("#,###.00");
list_items._Vrednost = (Convert.ToDecimal(reader["vrednost"]));
}
if (reader["ddv"] != DBNull.Value)
{
list_items.Ddv = (Convert.ToDecimal(reader["ddv"])).ToString("#,###.00");
list_items._Ddv = (Convert.ToDecimal(reader["ddv"]));
}
lvi_list.Add(list_items);
}
connection.Close();
}
}
}
private void buttonDelete_Click(object sender, EventArgs e)
{
if (listViewMain.SelectedItems.Count == 1)
{
if (MessageBox.Show("정말로 삭제하시겠습니까?", "질문", MessageBoxButtons.YesNo, MessageBoxIcon.Question) == DialogResult.Yes)
{
ManageItems manageItems = new ManageItems(this);
foreach (ListViewItem LVI in listViewMain.SelectedItems)
{
manageItems.Delete(LVI.Index);
LVI.Remove();
}
manageItems.SaveFile();
}
}
else
{
MessageBox.Show("삭제하실 항목을 선택해 주세요.", "오류", MessageBoxButtons.OK, MessageBoxIcon.Exclamation);
}
}
