public void mSQL_FakturaIzmeni(int ID, string Dbroj, DateTimePicker picker)
{
Connect();
MySqlCommand check_ID = new MySqlCommand();
check_ID.CommandText = "SELECT COUNT(*) FROM fakture WHERE xID=@ID";
check_ID.Parameters.AddWithValue("@ID", ID);
check_ID.Connection = connection;
var checkNumberID = check_ID.ExecuteScalar();
int valueID = Convert.ToInt32(checkNumberID);
if (valueID > 0)
{
ListaFaktura faktPage = new ListaFaktura();
MySqlCommand cmd = new MySqlCommand();
cmd.CommandText = "UPDATE fakture SET xBroj = @Dbroj, xDatum = @datum WHERE xID = @ID";
cmd.Parameters.AddWithValue("@ID", ID);
cmd.Parameters.AddWithValue("@Dbroj", Dbroj);
cmd.Parameters.AddWithValue("@datum", picker.Text);
cmd.Connection = connection;
var check = cmd.ExecuteScalar();
int value = Convert.ToInt32(check);
MessageBox.Show("Uspesno ste izmenili fakturu");
faktPage.RefreshGrid();
}
else
{
MessageBox.Show("Taj ID Fakture ne postoji");
}
}
private void btnLisFaktura_Click(object sender, EventArgs e)
{
ListaFaktura listaPage = new ListaFaktura();
listaPage.ShowDialog();
}