public void UpdateTimeStampTest()
{
string sql = "select * from TEST where int_field = @int_field";
FbTransaction transaction = this.Connection.BeginTransaction();
FbCommand command = new FbCommand(sql, Connection, transaction);
FbDataAdapter adapter = new FbDataAdapter(command);
adapter.MissingSchemaAction = MissingSchemaAction.AddWithKey;
adapter.SelectCommand.Parameters.Add("@int_field", FbDbType.Integer).Value = 1;
FbCommandBuilder builder = new FbCommandBuilder(adapter);
DataSet ds = new DataSet();
adapter.Fill(ds, "TEST");
Assert.AreEqual(1, ds.Tables["TEST"].Rows.Count, "Incorrect row count");
DateTime dtValue = DateTime.Now;
ds.Tables["TEST"].Rows[0]["TIMESTAMP_FIELD"] = dtValue;
adapter.Update(ds, "TEST");
adapter.Dispose();
builder.Dispose();
command.Dispose();
transaction.Commit();
transaction = Connection.BeginTransaction();
sql = "SELECT timestamp_field FROM TEST WHERE int_field = @int_field";
command = new FbCommand(sql, Connection, transaction);
command.Parameters.Add("@int_field", FbDbType.Integer).Value = 1;
DateTime val = (DateTime)command.ExecuteScalar();
transaction.Commit();
Assert.AreEqual(dtValue.Day, val.Day, "timestamp_field has not correct day");
Assert.AreEqual(dtValue.Month, val.Month, "timestamp_field has not correct month");
Assert.AreEqual(dtValue.Year, val.Year, "timestamp_field has not correct year");
Assert.AreEqual(dtValue.Hour, val.Hour, "timestamp_field has not correct hour");
Assert.AreEqual(dtValue.Minute, val.Minute, "timestamp_field has not correct minute");
Assert.AreEqual(dtValue.Second, val.Second, "timestamp_field has not correct second");
}
public object ExecuteScalar(string sql)
{
FbCommand cmd = new FbCommand(sql, con);
cmd.Connection.Open();
object ret = null;
try{
ret = cmd.ExecuteScalar();
}catch (Exception ex) {
throw ex;
}finally{
cmd.Connection.Close();
}
return(ret);
}
public void ParametrizedInsertTest(int id, bool?value)
{
using (var cmd = Connection.CreateCommand())
{
cmd.CommandText = "INSERT INTO withboolean (id, bool) VALUES (@id, @bool)";
cmd.Parameters.Add("id", id);
cmd.Parameters.Add("bool", value);
Assert.DoesNotThrow(() => cmd.ExecuteNonQuery());
}
using (FbCommand cmd = Connection.CreateCommand())
{
cmd.CommandText = $"SELECT bool FROM withboolean WHERE id = @id";
cmd.Parameters.Add("id", id);
Assert.AreEqual(value ?? (object)DBNull.Value, cmd.ExecuteScalar());
}
}
public object CleanTable()
{
connectionString = GlobalSetting.CreateConectionString(
@"C:\Users\user\Documents\visual studio 2013\Projects\WpfRandomValue\WPFDatabase.fdb",
"SYSDBA", "masterkey", "WIN1250");
using (var conn = new FbConnection(connectionString))
{
conn.Open();
var command = new FbCommand();
command.Connection = conn;
command.CommandText = "DELETE FROM NUMBERTABLE";
//command.Parameters.Add();
return(command.ExecuteScalar());
}
}
public int executeScalar(string sql)
{
FbCommand cmd = new FbCommand(sql, con);
cmd.Transaction = trans;
object o = cmd.ExecuteScalar();
if (o != DBNull.Value)
{
return(Convert.ToInt32(o));
}
else
{
return(0);
}
}
public int getIdentity()
{
FbCommand cmd = new FbCommand("SELECT @@IDENTITY", con);
cmd.Transaction = trans;
object o = cmd.ExecuteScalar();
if (o != null)
{
return(Convert.ToInt32(o));
}
else
{
return(0);
}
}
public T GetValueFromSelect <T>(string sql, FbTransaction trans, object parameters = null)
{
object result;
using (var command = new FbCommand(sql, trans.Connection, trans))
{
if (parameters != null)
{
command.Parameters.AddParams(DatabaseEngine.Firebird, parameters);
}
result = command.ExecuteScalar();
}
return(typeof(T) == typeof(object) ? (T)result : result.NGetValue <T, object>());
}
/// <summary>
/// Создает таблицу для задач с проверкой дубликации файлов
/// </summary>
/// <param name="taskName">Имя таблицы</param>
public static void CreateTableFingerprint(string taskName)
{
if (!StartFirebirdService())
{
throw new Exception("Не удалось запустить службу Firebird");
}
string connStr = @"SELECT 1 FROM RDB$RELATIONS
WHERE RDB$RELATION_NAME = '" + taskName + "'";
object result;
using (FbConnection connection = new FbConnection(ConnectionString)) {
connection.Open();
using (FbCommand command = new FbCommand(connStr, connection)) {
using (FbTransaction transaction = connection.BeginTransaction()) {
command.Transaction = transaction;
result = command.ExecuteScalar();
transaction.Rollback();
}
}
}
if (result != null)
{
return;
}
connStr = "CREATE TABLE " + taskName + @"
(FILENAME CHAR(255) NOT NULL,
HASH CHAR(255) NOT NULL,
OPERATIONDATE TIMESTAMP NOT NULL,
MODIFYDATE TIMESTAMP NOT NULL
);";
using (FbConnection connection = new FbConnection(ConnectionString)) {
connection.Open();
using (FbCommand command = new FbCommand(connStr, connection)) {
using (FbTransaction transaction = connection.BeginTransaction()) {
command.Transaction = transaction;
command.ExecuteNonQuery();
transaction.Commit();
}
}
}
}
private void KayitliMi1_CheckedChanged(object sender, EventArgs e)
{
try
{
if (KayitliMi1.Checked)
{
groupBox3.Enabled = true;
}
else
{
groupBox3.Enabled = false;
musara.Text = "";
SatisMusteri.SelectedIndex = -1;
checkBox1.Checked = false;
}
SatisMusteri.Items.Clear();
FbConnection baglan = new FbConnection(fk.Baglanti_Kodu());
baglan.Open();
FbCommand MustList = new FbCommand("SELECT * FROM Musteriler", baglan);
object sonuc = MustList.ExecuteScalar();
if (sonuc != null)
{
FbDataReader oku = MustList.ExecuteReader();
while (oku.Read())
{
SatisMusteri.Items.Add(oku["Musteri_adi"].ToString() + " " + oku["Musteri_soyadi"].ToString());
}
SatisMusteri.SelectedIndex = -1;
}
else
{
SatisMusteri.Enabled = false;
checkBox1.Enabled = false;
groupBox3.Enabled = false;
MessageBox.Show("Kayıtlı müşteri bulunmamaktadır, müşteri ekleyiniz.", "Bilgilendirme", MessageBoxButtons.OK, MessageBoxIcon.Information);
this.Close();
MusteriEkle me = new MusteriEkle();
me.ShowDialog();
}
baglan.Close();
}
catch (Exception h1)
{
MessageBox.Show(h1.Message, "Hata", MessageBoxButtons.OK, MessageBoxIcon.Error);
}
}
public Object ExecuteScalar(String sql)
{
FbCommand cmd = new FbCommand(sql, co);
Object o = null;
try
{
o = cmd.ExecuteScalar();
_lastError = "";
}
catch (Exception e)
{
_lastError = e.Message;
}
return(o);
}
/// <summary>
/// Executa (ExecuteScalar) e retorna o comando. T é o tipo de objeto de retorno.
/// </summary>
/// <param name="command"></param>
/// <returns></returns>
public static T Executar <T>(this FbCommand command)
{
var temp = command.ExecuteScalar();
if (temp is DBNull)
{
return(default(T));
}
else if (temp != null)
{
return((T)temp);
}
else
{
return(Activator.CreateInstance <T>());
}
}
private decimal GetArticlePrice(int articleId)
{
using (FbConnection fbConnection = new FbConnection(GlobalConstants.FireBirdConnectionString))
{
fbConnection.Open();
StringBuilder fbQuery = new StringBuilder();
fbQuery.AppendLine("SELECT a.Price FROM Article as a");
fbQuery.AppendLine($"WHERE a.Id = {articleId}");
using (FbCommand fbCommand = new FbCommand(fbQuery.ToString(), fbConnection))
{
decimal price = (decimal)fbCommand.ExecuteScalar();
return(price);
}
}
}
private void KayitliMi2_CheckedChanged(object sender, EventArgs e)
{
try
{
SatisMusteriCb.Items.Clear();
FbConnection baglan = new FbConnection(fk.Baglanti_Kodu());
baglan.Open();
FbCommand MustList = new FbCommand("SELECT * FROM Musteriler", baglan);
object sonuc = MustList.ExecuteScalar();
if (sonuc != null)
{
FbDataReader oku = MustList.ExecuteReader();
SatisMusteri.Enabled = true;
checkBox3.Enabled = true;
while (oku.Read())
{
SatisMusteriCb.Items.Add(oku["Musteri_adi"].ToString() + " " + oku["Musteri_soyadi"].ToString());
}
SatisMusteriCb.SelectedIndex = 0;
}
else
{
SatisMusteri.Enabled = false;
checkBox3.Enabled = false;
MessageBox.Show("Kayıtlı müşteri bulunmamaktadır.", "Bilgilendirme", MessageBoxButtons.OK, MessageBoxIcon.Information);
SatisMusteriB.Enabled = false;
}
baglan.Close();
textBox1.Text = "";
checkBox3.Checked = false;
if (KayitliMi2.Checked)
{
SatisMusteriB.Enabled = true;
}
else
{
SatisMusteriB.Enabled = false;
SatisMusteriCb.SelectedIndex = -1;
}
}
catch (Exception e6)
{
MessageBox.Show(e6.Message, "Hata", MessageBoxButtons.OK, MessageBoxIcon.Error);
}
}
public bool IniciarSesion(string pUsuario, string pPass)
{
if (_objContextoAD.Conexion.State == ConnectionState.Closed)
{
_objContextoAD.Conexion.Open();
}
string sql = "SELECT COUNT(USUARIO) FROM USUARIOS WHERE USUARIO = @USUARIO AND PASS = @PASS";
FbCommand cmd = new FbCommand(sql, _objContextoAD.Conexion);
cmd.Parameters.AddWithValue("@USUARIO", pUsuario.ToLower());
cmd.Parameters.AddWithValue("@PASS", pPass);
if (_objContextoAD.EsTransaccion)
{
cmd.Transaction = _objContextoAD.Transaccion;
}
return(Convert.ToInt32(cmd.ExecuteScalar()) > 0);
}
public User insert(User user)
{
FbConnection connection = null;
FbCommand statement = null;
FbTransaction transaction = null;
string sql = "execute procedure insert_user(@first_name, @second_name, @third_name, @app, @id_dept, @type, @login, @pass, @e_mail, @hash_pass)";
try
{
connection = daoFactory.getConnection();
connection.Open();
transaction = connection.BeginTransaction();
statement = new FbCommand(sql, connection);
statement.Parameters.Add("@first_name", user.FirstName);
statement.Parameters.Add("@second_name", user.SecondName);
statement.Parameters.Add("@third_name", user.ThirdName);
statement.Parameters.Add("@app", user.Appointment);
statement.Parameters.Add("@id_dept", user.Department.idDepartment);
statement.Parameters.Add("@type", user.TypeUser);
statement.Parameters.Add("@login", user.Login);
statement.Parameters.Add("@pass", user.Password);
statement.Parameters.Add("@e_mail", user.Email);
statement.Parameters.Add("@hash_pass", user.HashPass);
int id = Convert.ToInt32(statement.ExecuteScalar());
transaction.Commit();
if (id != 0)
{
user.Id = (int)id;
}
}
catch (Exception e)
{
transaction.Rollback();
throw new DAOException("Insert User error ", e);
}
finally
{
if (connection != null)
{
connection.Close();
}
}
return(user);
}
/**
* @Kyle van Raaij
* Gets a query out of the database table with as name _gridName.
* All the parameters connected to the database table _gridName will be acquired as well.
*
* @_gridName the name of the grid that is stored in the database
* @return the query used to get all gridvalues
**/
public QueryValues GetGridQuery(string _gridName)
{
FbConnection conn = dbconn.GetFbConnection();
try
{
FbCommand cmd = new FbCommand("CCDA_GRIDQUERY", conn);
//FbCommand cmd2 = new FbCommand("SELECT P.CCDA_P_NAME, p.CCDA_P_ID FROM CCDA_GRID G LEFT JOIN CCDA_PARAMETER P ON G.CCDA_G_NAME = P.CCDA_P_PARENTNAME", conn);
FbCommand cmd2 = new FbCommand("SELECT CCDA_P_NAME, CCDA_P_ID FROM CCDA_PARAMETER WHERE CCDA_P_PARENTNAME = @GRID_NAME", conn);
cmd2.CommandType = CommandType.Text;
cmd.CommandType = CommandType.StoredProcedure;
cmd.Parameters.Add("@GRID_NAME", _gridName);
cmd2.Parameters.Add("@GRID_NAME", _gridName);
conn.Open();
string query = (string)cmd.ExecuteScalar();
FbDataReader reader = cmd2.ExecuteReader();
QueryValues qValues = new QueryValues();
qValues.Query = query;
List <string> values = new List <string>();
if (reader.HasRows)
{
while (reader.Read())
{
values.Add(reader.GetString(0));
}
}
conn.Close();
qValues.Parameteres = values;
return(qValues);
}
catch (FbException ex)
{
Console.WriteLine(ex);
conn.Close();
return(null);
}
catch (NullReferenceException ex)
{
Console.WriteLine(ex);
conn.Close();
return(null);
}
}
public void BinaryBlobTest()
{
int id_value = GetId();
string selectText = "SELECT blob_field FROM TEST WHERE int_field = " + id_value.ToString();
string insertText = "INSERT INTO TEST (int_field, blob_field) values(@int_field, @blob_field)";
Console.WriteLine("\r\n\r\nBinary Blob Test");
Console.WriteLine("Generating an array of temp data");
// Generate an array of temp data
byte[] insert_values = new byte[100000 * 4];
RNGCryptoServiceProvider rng = new RNGCryptoServiceProvider();
rng.GetBytes(insert_values);
Console.WriteLine("Executing insert command");
// Execute insert command
FbTransaction transaction = Connection.BeginTransaction();
FbCommand insert = new FbCommand(insertText, Connection, transaction);
insert.Parameters.Add("@int_field", FbDbType.Integer).Value = id_value;
insert.Parameters.Add("@blob_field", FbDbType.Binary).Value = insert_values;
insert.ExecuteNonQuery();
transaction.Commit();
Console.WriteLine("Checking inserted values");
// Check that inserted values are correct
FbCommand select = new FbCommand(selectText, Connection);
byte[] select_values = (byte[])select.ExecuteScalar();
for (int i = 0; i < insert_values.Length; i++)
{
if (insert_values[i] != select_values[i])
{
throw new Exception("differences at index " + i.ToString());
}
}
Console.WriteLine("Finishing test");
}
private void MusteriEkle_Load(object sender, EventArgs e)
{
try
{
ToolTip Aciklama = new ToolTip();
Aciklama.SetToolTip(katekle, "Müşteri Kategorisi Ekle");
FbConnection komut_baglan = new FbConnection(fk.Baglanti_Kodu());
FbDataReader oku;
FbCommand cmd = new FbCommand();
object sonuc;
komut_baglan.Open();
cmd.Connection = komut_baglan;
cmd.CommandText = "SELECT * FROM Musteri_kategori";
sonuc = cmd.ExecuteScalar();
if (sonuc != null)
{
oku = cmd.ExecuteReader();
while (oku.Read())
{
Musteri_kategori.Items.Add(oku[1].ToString());
}
Musteri_kategori.SelectedIndex = 0;
oku.Close();
Musteri_kategori.Enabled = true;
ButonEkle.Enabled = true;
}
else
{
Musteri_kategori.Enabled = false;
ButonEkle.Enabled = false;
MessageBox.Show("Müşteri kategorisi bulunamadı, müşteri kategorisi ekleyiniz", "Bilgilendirme", MessageBoxButtons.OK, MessageBoxIcon.Information);
this.Close();
MusteriKategoriEkle mke = new MusteriKategoriEkle();
mke.ShowDialog();
}
komut_baglan.Close();
}
catch (Exception me1)
{
MessageBox.Show(me1.Message, "Hata", MessageBoxButtons.OK, MessageBoxIcon.Error);
}
}
public void UpdateTimeTest()
{
var sql = "select * from TEST where int_field = @int_field";
var transaction = Connection.BeginTransaction();
var command = new FbCommand(sql, Connection, transaction);
var adapter = new FbDataAdapter(command);
adapter.MissingSchemaAction = MissingSchemaAction.AddWithKey;
adapter.SelectCommand.Parameters.Add("@int_field", FbDbType.Integer).Value = 1;
var builder = new FbCommandBuilder(adapter);
var ds = new DataSet();
adapter.Fill(ds, "TEST");
Assert.AreEqual(1, ds.Tables["TEST"].Rows.Count, "Incorrect row count");
var dtValue = new TimeSpan(5, 6, 7);
ds.Tables["TEST"].Rows[0]["TIME_FIELD"] = dtValue;
adapter.Update(ds, "TEST");
adapter.Dispose();
builder.Dispose();
command.Dispose();
transaction.Commit();
transaction = Connection.BeginTransaction();
sql = "SELECT time_field FROM TEST WHERE int_field = @int_field";
command = new FbCommand(sql, Connection, transaction);
command.Parameters.Add("@int_field", FbDbType.Integer).Value = 1;
var val = (TimeSpan)command.ExecuteScalar();
transaction.Commit();
Assert.AreEqual(dtValue.Hours, val.Hours, "time_field has not correct hour");
Assert.AreEqual(dtValue.Minutes, val.Minutes, "time_field has not correct minute");
Assert.AreEqual(dtValue.Seconds, val.Seconds, "time_field has not correct second");
}
public void UpdateDateTest()
{
var sql = "select * from TEST where int_field = @int_field";
var transaction = Connection.BeginTransaction();
var command = new FbCommand(sql, Connection, transaction);
var adapter = new FbDataAdapter(command);
adapter.MissingSchemaAction = MissingSchemaAction.AddWithKey;
adapter.SelectCommand.Parameters.Add("@int_field", FbDbType.Integer).Value = 1;
var builder = new FbCommandBuilder(adapter);
var ds = new DataSet();
adapter.Fill(ds, "TEST");
Assert.AreEqual(1, ds.Tables["TEST"].Rows.Count, "Incorrect row count");
var dtValue = DateTime.Now;
ds.Tables["TEST"].Rows[0]["DATE_FIELD"] = dtValue;
adapter.Update(ds, "TEST");
adapter.Dispose();
builder.Dispose();
command.Dispose();
transaction.Commit();
transaction = Connection.BeginTransaction();
sql = "SELECT date_field FROM TEST WHERE int_field = @int_field";
command = new FbCommand(sql, Connection, transaction);
command.Parameters.Add("@int_field", FbDbType.Integer).Value = 1;
var val = (DateTime)command.ExecuteScalar();
transaction.Commit();
Assert.AreEqual(dtValue.Day, val.Day, "date_field has not correct day");
Assert.AreEqual(dtValue.Month, val.Month, "date_field has not correct month");
Assert.AreEqual(dtValue.Year, val.Year, "date_field has not correct year");
}
public static void Novi(string korisnickoIme, string sifra)
{
using (FbConnection con = new FbConnection(Baza.connectionString))
{
con.Open();
using (FbCommand cmd = new FbCommand("INSERT INTO KORISNICI (KORISNIKID, KORISNIK, SIFRA) VALUES (((SELECT MAX(KORISNIKID) FROM KORISNICI) + 1), @Korisnik, @Sifra) RETURNING KORISNIKID", con))
{
cmd.Parameters.AddWithValue("@Korisnik", korisnickoIme);
cmd.Parameters.AddWithValue("@Sifra", sifra);
cmd.Parameters.Add("KORISNIKID", FbDbType.Integer).Direction = ParameterDirection.Output;
var id = (int)cmd.ExecuteScalar();
Prava.Dodaj(id, 0, 1);
}
con.Close();
}
}
public int GetArticleIdByName(string name)
{
using (FbConnection fbConnection = new FbConnection(GlobalConstants.FireBirdConnectionString))
{
fbConnection.Open();
StringBuilder fbQuery = new StringBuilder();
fbQuery.AppendLine("SELECT Id FROM Article");
fbQuery.AppendLine($"WHERE Name = '{name}'");
using (FbCommand fbCommand = new FbCommand(fbQuery.ToString(), fbConnection))
{
int articleId = (int)fbCommand.ExecuteScalar();
return(articleId);
}
}
}
public static string GetParamParentName(string connectionString, int parentId)
{
string connStr = "SELECT NAME FROM PARAM WHERE PARAMID=" + parentId.ToString() + ";";
using (FbConnection connection = new FbConnection(connectionString)) {
connection.Open();
object result;
using (FbCommand command = new FbCommand(connStr, connection)) {
FbTransaction transaction = connection.BeginTransaction();
command.Transaction = transaction;
result = command.ExecuteScalar();
transaction.Rollback();
}
return((result == null) ? "" : result.ToString());
}
}
public void SimplifiedChineseTest()
{
string createTable = "CREATE TABLE TABLE1 (FIELD1 varchar(20))";
FbCommand create = new FbCommand(createTable, this.Connection);
create.ExecuteNonQuery();
create.Dispose();
// insert using parametrized SQL
string sql = "INSERT INTO Table1 VALUES (@value)";
FbCommand command = new FbCommand(sql, this.Connection);
command.Parameters.Add("@value", FbDbType.VarChar).Value = "中文";
command.ExecuteNonQuery();
command.Dispose();
sql = "SELECT * FROM TABLE1";
FbCommand select = new FbCommand(sql, this.Connection);
string result = select.ExecuteScalar().ToString();
select.Dispose();
Assert.AreEqual("中文", result, "Incorrect results in parametrized insert");
sql = "DELETE FROM TABLE1";
FbCommand delete = new FbCommand(sql, this.Connection);
delete.ExecuteNonQuery();
delete.Dispose();
// insert using plain SQL
sql = "INSERT INTO Table1 VALUES ('中文')";
FbCommand plainCommand = new FbCommand(sql, this.Connection);
plainCommand.ExecuteNonQuery();
plainCommand.Dispose();
sql = "SELECT * FROM TABLE1";
select = new FbCommand(sql, this.Connection);
result = select.ExecuteScalar().ToString();
select.Dispose();
Assert.AreEqual("中文", result, "Incorrect results in plain insert");
}
private void Signin(object sender, RoutedEventArgs e)
{
string name = signinName.Text;
string pass1 = signinPass.Text;
string pass2 = signinPass2.Text;
if (string.IsNullOrEmpty(name) || string.IsNullOrEmpty(pass1) || string.IsNullOrEmpty(pass2))
{
MessageBox.Show("Something is Empty!");
return;
}
if (pass1 != pass2)
{
MessageBox.Show("The re-password does not match!");
return;
}
using (FbConnection conn = new FbConnection(@"Server=localhost;User=SYSDBA;Password=admin;Database=C:\Users\Norbert\Documents\Visual Studio 2015\Projects\NCarRental\NCarRental\_Resources\DB.FDB"))
using (FbCommand cmd = conn.CreateCommand())
{
conn.Open();
cmd.CommandText = "select name from users where name=@name";
cmd.Parameters.Add("name", name);
var result = cmd.ExecuteScalar();
if (result != null)
{
MessageBox.Show("The username is already taken!");
return;
}
cmd.CommandText = "insert into users(name, pass, balance) values (@name, @pass, @balance)";
cmd.Parameters.Add("pass", pass1);
cmd.Parameters.Add("balance", 20000);
cmd.ExecuteNonQuery();
MessageBox.Show("Done!");
signinName.Text = "";
signinPass.Text = "";
signinPass2.Text = "";
}
}
private void btnAccept_Click(object sender, RoutedEventArgs e)
{
if (nameTB.Text == "")
{
MessageBox.Show("Podaj imię autora!", "Błąd", MessageBoxButton.OK, MessageBoxImage.Error);
return;
}
if (surnameTB.Text == "")
{
MessageBox.Show("Podaj nazwisko autora!", "Błąd", MessageBoxButton.OK, MessageBoxImage.Error);
return;
}
FbCommand command = new FbCommand("select count(*) from AUTORZY where IMIE = '" + nameTB.Text + "' and NAZWISKO = '" + surnameTB.Text + "' " +
"and ID_AUTOR <> " + id, connection);
Int32 result = (Int32)command.ExecuteScalar();
if (result > 0)
{
MessageBox.Show("Podany autor już istnieje!", "Błąd", MessageBoxButton.OK, MessageBoxImage.Error);
return;
}
else
{
if (isEdit)
{
command = new FbCommand("update AUTORZY set IMIE = '" + nameTB.Text + "' and NAZWISKO = '" + surnameTB.Text + "' where ID_AUTOR = " + id, connection);
result = command.ExecuteNonQuery();
}
else
{
command = new FbCommand("insert into AUTORZY (IMIE, NAZWISKO) values ('" + nameTB.Text + "', '" + surnameTB.Text + "')", connection);
result = command.ExecuteNonQuery();
}
}
if (result != 0)
{
MessageBox.Show("Operacja powiodła się!", "Sukces", MessageBoxButton.OK, MessageBoxImage.Information);
}
else
{
MessageBox.Show("Operacja nie powiodła się!", "Błąd", MessageBoxButton.OK, MessageBoxImage.Error);
}
this.Close();
}
public void CreateTableIfNotExists(string tableName, string tableStruct)
{
using (var conn = new FbConnection(_connectionString))
{
conn.Open();
using (var command = new FbCommand("select 1 from rdb$relations where rdb$relation_name = '" + tableName.ToUpper() + "';", conn))
{
var res = command.ExecuteScalar();
if (res == null)
{
using (var cmd = new FbCommand("create table " + tableName + tableStruct + ";", conn))
{
cmd.ExecuteNonQuery();
}
}
}
}
}
private void uyeMi_CheckedChanged(object sender, EventArgs e)
{
try
{
if (uyeMi.Checked)
{
FbConnection baglan = new FbConnection(fk.Baglanti_Kodu());
baglan.Open();
FbCommand MusSql = new FbCommand("SELECT Musteri_adi,Musteri_soyadi FROM Musteriler", baglan);
object Mvarmi = MusSql.ExecuteScalar();
if (Mvarmi != null)
{
FbDataReader MusOku = MusSql.ExecuteReader();
while (MusOku.Read())
{
musteri.Items.Add(MusOku["Musteri_adi"].ToString() + " " + MusOku["Musteri_soyadi"].ToString());
}
uyeyse.Enabled = true;
uyedegilse.Enabled = false;
musteri.SelectedIndex = 0;
}
else
{
DialogResult MusEkle = MessageBox.Show("Sistemde müşteri bulunmamaktadır, yeni müşteri eklemek ister misiniz?", "Bilgilendirme", MessageBoxButtons.YesNo, MessageBoxIcon.Information);
if (MusEkle == DialogResult.Yes)
{
MusteriEkle me = new MusteriEkle();
me.ShowDialog();
}
}
baglan.Close();
}
else
{
uyeyse.Enabled = false;
uyedegilse.Enabled = true;
}
}
catch (Exception e1)
{
MessageBox.Show(e1.Message, "Hata", MessageBoxButtons.OK, MessageBoxIcon.Error);
}
}
public void RunInstance()
{
int i = 0;
int errors = 0;
// restrict number of errors here to avoid endless output
int maxErrors = 5;
while (i < maxCycles)
{
FbCommand singleUsedCommand = new FbCommand(commandText, connection);
try
{
connection.Open();
object result1 = multipleUsedCommand.ExecuteScalar();
object result2 = singleUsedCommand.ExecuteScalar();
// following line prevents errors
//singleUsedCommand.Dispose();
}
catch (Exception ex)
{
Console.WriteLine("{0} instance {1}, cycle {2}, {3}", DateTime.Now, id, i + 1, ex.Message);
if (errors < maxErrors)
{
errors++;
}
else
{
break;
}
}
finally
{
connection.Close();
i++;
}
// inner connection can be used by another instance
Thread.Sleep(50);
}
}
private void UrunEkle_Load(object sender, EventArgs e)
{
try
{
ToolTip Aciklama = new ToolTip();
Aciklama.SetToolTip(katekle, "Ürün Kategorisi Ekle");
FbConnection komut_baglan = new FbConnection(fk.Baglanti_Kodu());
FbDataReader oku;
FbCommand cmd = new FbCommand();
object sonuc;
komut_baglan.Open();
cmd.Connection = komut_baglan;
cmd.CommandText = "SELECT * FROM Urun_kategori";
sonuc = cmd.ExecuteScalar();
if (sonuc != null)
{
oku = cmd.ExecuteReader();
while (oku.Read())
{
UrunKategori.Items.Add(oku[1].ToString());
}
UrunKategori.SelectedIndex = 0;
oku.Close();
}
else
{
MessageBox.Show("Ürün ekleyebilmek için önce ürün kategorisi ekleyin", "Bilgilendirme", MessageBoxButtons.OK, MessageBoxIcon.Information);
this.Close();
UrunKategoriEkle uke = new UrunKategoriEkle();
uke.ShowDialog();
}
komut_baglan.Close();
}
catch (Exception e1)
{
MessageBox.Show(e1.Message, "Hata", MessageBoxButtons.OK, MessageBoxIcon.Error);
}
}
