private void addIcra2DB()
{
try
{
decimal bakiye = parayaCevir(tBoxBakiye.Text);
if (bakiye > 0)
{
NpgsqlCommand command = new NpgsqlCommand();
command.CommandText = "select addIcra(@esasno , @tarih , @icra_dairesi, @tutar_ , @icraturu, @borclu , @alacak, @oncelik, @sabit_kesinti);";
command.Parameters.AddWithValue("@esasno", NpgsqlTypes.NpgsqlDbType.Text, tBoxEsasNo.Text);
command.Parameters.AddWithValue("@tarih", NpgsqlTypes.NpgsqlDbType.Date, Date_date.Value);
command.Parameters.AddWithValue("@icra_dairesi", NpgsqlTypes.NpgsqlDbType.Integer, Convert.ToInt32(cBox_İcraDairesi.SelectedValue));
command.Parameters.AddWithValue("@tutar_", NpgsqlTypes.NpgsqlDbType.Money, bakiye);
command.Parameters.AddWithValue("@sabit_kesinti", NpgsqlTypes.NpgsqlDbType.Money, parayaCevir(tBox_sabit_kesinti.Text));
command.Parameters.AddWithValue("@icraturu", NpgsqlTypes.NpgsqlDbType.Integer, Convert.ToInt32(cBox_IcraTuru.SelectedValue));
command.Parameters.AddWithValue("@oncelik", NpgsqlTypes.NpgsqlDbType.Boolean, cBox_Oncelik.Checked);
command.Parameters.AddWithValue("@borclu", NpgsqlTypes.NpgsqlDbType.Array | NpgsqlTypes.NpgsqlDbType.Integer, getBorclu());
command.Parameters.AddWithValue("@alacak", NpgsqlTypes.NpgsqlDbType.Array | NpgsqlTypes.NpgsqlDbType.Integer, getAlacak());
// command.CommandType = CommandType.StoredProcedure;
dbConnection.sendQuery(command);
MessageBoxs.SuccessMessage("İcra Dosyası Oluşturma Başarılı");
clear();
}
}
catch (Exception)
{
throw;
}
}
private void btnSave_Click(object sender, EventArgs e)
{
try
{
SaveFileDialog save = new SaveFileDialog();
save.Filter = "PDF Dosyası | *.pdf";
if (save.ShowDialog() == DialogResult.OK)
{
MemoryStream stream = new MemoryStream();
pdfViewer.SaveToFile(stream);
byte[] bytesInStream = new byte[stream.Length];
bytesInStream = stream.ToArray();
FileStream fileStream = new FileStream(save.FileName, FileMode.Create, FileAccess.Write);
stream.CopyTo(fileStream);
fileStream.Write(bytesInStream, 0, bytesInStream.Length);
fileStream.Close();
}
MessageBoxs.SuccessMessage("Dosya Kaydedildi");
}
catch (Exception ex)
{
MessageBoxs.ErrorMessage(ex);
}
}
private void addMuzekkere()
{
try
{
NpgsqlCommand command = new NpgsqlCommand();
command.CommandText = "INSERT INTO tb_muzekkereler (\"gelistarihi\", \"icra\", \"goruntu\", \"dosya_uzantantisi\") VALUES (@tarih, @kayitno , @goruntu , @uzantı);";
command.Parameters.AddWithValue("@kayitno", NpgsqlTypes.NpgsqlDbType.Integer, this.IcraKayitNo);
command.Parameters.AddWithValue("@tarih", NpgsqlTypes.NpgsqlDbType.Date, Date_date.Value);
command.Parameters.AddWithValue("@goruntu", NpgsqlTypes.NpgsqlDbType.Bytea, File.ReadAllBytes(pdfViewer.FileName));
command.Parameters.AddWithValue("@uzantı", NpgsqlTypes.NpgsqlDbType.Varchar, "pdf");
dbConnection.sendQuery(command);
MessageBoxs.SuccessMessage("Müzekkere eklendi");
loadMuzekkere();
}
catch (Exception)
{
throw;
}
}
private void addCevap()
{
try
{
NpgsqlCommand command = new NpgsqlCommand();
command.CommandText = "INSERT INTO tb_cevaplar VALUES (default, @kayitno, @tarih, @evraksayisi, @goruntu, @uzantı); ";
command.Parameters.AddWithValue("@kayitno", NpgsqlTypes.NpgsqlDbType.Integer, IcraKayıtNumarası);
command.Parameters.AddWithValue("@tarih", NpgsqlTypes.NpgsqlDbType.Date, Date_date.Value);
command.Parameters.AddWithValue("@evraksayisi", NpgsqlTypes.NpgsqlDbType.Integer, Convert.ToInt32(tBox_evrak_sayısı.Text));
command.Parameters.AddWithValue("@goruntu", NpgsqlTypes.NpgsqlDbType.Bytea, File.ReadAllBytes(cevapDosyaYolu));
command.Parameters.AddWithValue("@uzantı", NpgsqlTypes.NpgsqlDbType.Varchar, getFileExtension(cevapDosyaYolu));
dbConnection.sendQuery(command);
cevapDosyaYolu = "";
MessageBoxs.SuccessMessage("Evrak Sisteme Başarıyla Eklendi");
}
catch (Exception)
{
throw;
}
}
private void addPersonel()
{
try
{
NpgsqlCommand command = new NpgsqlCommand();
command.CommandText = "INSERT INTO public.tb_personel (kisi_no, tc_no, adı, soyadı, ckurum) VALUES (@kisino, @tcno, @adı, @soyadı, @ckurum)";
command.Parameters.AddWithValue("@kisino", NpgsqlTypes.NpgsqlDbType.Integer, Convert.ToInt32(tboxKisiNo.Text));
command.Parameters.AddWithValue("@tcno", NpgsqlTypes.NpgsqlDbType.Bigint, Convert.ToDecimal(tBoxTCNo.Text));
command.Parameters.AddWithValue("@adı", NpgsqlTypes.NpgsqlDbType.Text, tBoxAdi.Text);
command.Parameters.AddWithValue("@soyadı", NpgsqlTypes.NpgsqlDbType.Text, tBoxSoyadi.Text);
command.Parameters.AddWithValue("@ckurum", NpgsqlTypes.NpgsqlDbType.Integer, Convert.ToInt32(cBoxKurumlar.SelectedValue));
dbConnection.sendQuery(command);
tboxKisiNo.Enabled = false;
tBoxTCNo.Enabled = false;
MessageBoxs.SuccessMessage("Kişi Oluşturma Başarılı");
}
catch (Exception)
{
throw;
}
}
private void updatePersonel()
{
try
{
NpgsqlCommand command = new NpgsqlCommand();
command.CommandText = "UPDATE public.tb_personel SET adı=@adı, soyadı=@soyadı, ckurum=@ckurum WHERE kisi_no=@kisino";
command.Parameters.AddWithValue("@kisino", NpgsqlTypes.NpgsqlDbType.Integer, Convert.ToInt32(tboxKisiNo.Text));
command.Parameters.AddWithValue("@adı", NpgsqlTypes.NpgsqlDbType.Text, tBoxAdi.Text);
command.Parameters.AddWithValue("@soyadı", NpgsqlTypes.NpgsqlDbType.Text, tBoxSoyadi.Text);
command.Parameters.AddWithValue("@ckurum", NpgsqlTypes.NpgsqlDbType.Integer, Convert.ToInt32(cBoxKurumlar.SelectedValue));
dbConnection.sendQuery(command);
tboxKisiNo.Enabled = false;
tBoxTCNo.Enabled = false;
MessageBoxs.SuccessMessage("Kişi Güncelleme Başarılı");
}
catch (Exception)
{
throw;
}
}
private void addEk()
{
try
{
NpgsqlCommand command = new NpgsqlCommand();
command.CommandText = "INSERT INTO tb_cevaplar_ekler (kayitno, yazıno, goruntu, dosya_uzantisi, aciklama) VALUES (default, @yazino, @goruntu, @uzantı, @aciklama); ";
command.Parameters.AddWithValue("@yazino", NpgsqlTypes.NpgsqlDbType.Integer, Convert.ToInt32(dgv_cevaplar.SelectedRows[0].Cells[0].Value));
command.Parameters.AddWithValue("@goruntu", NpgsqlTypes.NpgsqlDbType.Bytea, File.ReadAllBytes(ekDosyaYolu));
command.Parameters.AddWithValue("@uzantı", NpgsqlTypes.NpgsqlDbType.Varchar, getFileExtension(ekDosyaYolu));
command.Parameters.AddWithValue("@aciklama", NpgsqlTypes.NpgsqlDbType.Text, richTox_ek_aciklama.Text);
dbConnection.sendQuery(command);
ekDosyaYolu = "";
richTox_ek_aciklama.Text = "";
MessageBoxs.SuccessMessage("Evrak Eki Sisteme Başarıyla Eklendi");
getEkler();
}
catch (Exception)
{
throw;
}
}
private void addKesinti()
{
try
{
decimal bakiye = parayaCevir(tBoxBakiye.Text);
if (bakiye > 0)
{
NpgsqlCommand command = new NpgsqlCommand();
command.CommandText = "INSERT INTO tb_kesintiler VALUES (default, @kisi, @icra, @tur, @tarih, @tutar);";
command.Parameters.AddWithValue("@tutar", NpgsqlTypes.NpgsqlDbType.Money, bakiye);
command.Parameters.AddWithValue("@tarih", NpgsqlTypes.NpgsqlDbType.Date, Date_date.Value);
command.Parameters.AddWithValue("@tur", NpgsqlTypes.NpgsqlDbType.Integer, Convert.ToInt32(cBoxAlacak.SelectedValue));
command.Parameters.AddWithValue("@kisi", NpgsqlTypes.NpgsqlDbType.Integer, KisiNo);
command.Parameters.AddWithValue("@icra", NpgsqlTypes.NpgsqlDbType.Integer, IcraNo);
dbConnection.sendQuery(command);
MessageBoxs.SuccessMessage("Kesinti Sisteme Eklendi");
this.Close();
}
}
catch (Exception)
{
throw;
}
}