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 btnAdd_Click(object sender, EventArgs e) { try { addMuzekkere(); } catch (Exception ex) { MessageBoxs.ErrorMessage(ex); } }
private void dgv_cevaplar_CellClick(object sender, DataGridViewCellEventArgs e) { try { getEkler(); btnAddEk.Enabled = true; } catch (Exception ex) { MessageBoxs.ErrorMessage(ex); } }
public frmViewKesinti(int kisiNo) { try { InitializeComponent(); this.kisiNo = kisiNo; loadKesintiler(); } catch (Exception ex) { MessageBoxs.ErrorMessage(ex); } }
public frmCevapYaziları(int IcraKayıtNumarası) { try { InitializeComponent(); this.IcraKayıtNumarası = IcraKayıtNumarası; getCevaplar(); } catch (Exception ex) { MessageBoxs.ErrorMessage(ex); } }
private void btnaddKesinti_Click(object sender, EventArgs e) { try { if (tBoxBakiye.Text != "" && cBoxAlacak.SelectedIndex != 0) { addKesinti(); } } catch (Exception ex) { MessageBoxs.ErrorMessage(ex); } }
private void fillCBoxKurumlar() { try { DataTable dt = this.getKurumListesi(); cBoxKurumlar.DataSource = dt; cBoxKurumlar.DisplayMember = "Kurum Adı"; cBoxKurumlar.ValueMember = "Kurum Numarası"; } catch (Exception ex) { MessageBoxs.ErrorMessage(ex); } }
private void btnAdd_Click(object sender, EventArgs e) { try { if (cevapDosyaYolu != "" && tBox_evrak_sayısı.Text != "") { addCevap(); getCevaplar(); } } catch (Exception ex) { MessageBoxs.ErrorMessage(ex); } }
private void frmIcralar_Load(object sender, EventArgs e) { try { if (kisiNo != 0) { loadPersonel(); getIcralar(); } } catch (Exception ex) { MessageBoxs.ErrorMessage(ex); } }
private void frmCevapYaziları_FormClosing(object sender, FormClosingEventArgs e) { try { string FILEPATH = Environment.ExpandEnvironmentVariables("%APPDATA%\\PersonelIcraTakipProgrami\\tmp"); if (Directory.Exists(FILEPATH)) { Directory.Delete(FILEPATH, true); } } catch (Exception ex) { MessageBoxs.ErrorMessage(ex); } }
private void frm_addPersonel_Load(object sender, EventArgs e) { try { if (tboxKisiNo.Text != "") { fillCBoxKurumlar(); loadPersonel(Convert.ToInt32(tboxKisiNo.Text)); } } catch (Exception ex) { MessageBoxs.ErrorMessage(ex); } }
private void btnOpenEk_Click(object sender, EventArgs e) { try { OpenFileDialog openFile = new OpenFileDialog(); openFile.Filter = "PDF Dosyası |*.pdf|UDF Dosyası |*.udf|JPEG Dosyası |*.jpg"; openFile.RestoreDirectory = true; if (openFile.ShowDialog() == DialogResult.OK) { ekDosyaYolu = openFile.FileName; } } catch (Exception ex) { MessageBoxs.ErrorMessage(ex); } }
public addIcra() { try { InitializeComponent(); LoadIcraDairesi(); LoadAlacak(); LoadIcraTuru(); dgvBorclular.DataSource = prepareBorcluDGV(); dgvAlacak.DataSource = prepareAlacakDGV(); dgvAlacak.Columns[0].Visible = false; } catch (Exception ex) { MessageBoxs.ErrorMessage(ex); } }
private void btnOpenFile_Click(object sender, EventArgs e) { try { OpenFileDialog openFile = new OpenFileDialog(); openFile.Filter = "PDF Dosyası | *.pdf"; openFile.RestoreDirectory = true; if (openFile.ShowDialog() == DialogResult.OK) { pdfViewer.LoadFromFile(openFile.FileName); } } catch (Exception ex) { MessageBoxs.ErrorMessage(ex); } }
private void btnSave_Click(object sender, EventArgs e) { try { if (checkAlreadySaved(Convert.ToInt32(tboxKisiNo.Text))) { updatePersonel(); } else { addPersonel(); } } catch (Exception ex) { MessageBoxs.ErrorMessage(ex); } }
private void dgv_muzekkereler_CellClick(object sender, DataGridViewCellEventArgs e) { try { int kayitNo = Convert.ToInt32(dgv_muzekkereler.Rows[e.RowIndex].Cells[0].Value); NpgsqlCommand command = new NpgsqlCommand(); command.CommandText = "select \"goruntu\", \"dosya_uzantantisi\" from tb_muzekkereler where kayitno = @kayitno_"; command.Parameters.AddWithValue("@kayitno_", NpgsqlTypes.NpgsqlDbType.Integer, kayitNo); DataTable dt = dbConnection.getData(command); if (dt.Rows.Count > 0) { byte[] byteArray = (byte[])dt.Rows[0][0]; MemoryStream stream = new MemoryStream(byteArray); pdfViewer.LoadFromStream(stream); } } catch (Exception ex) { MessageBoxs.ErrorMessage(ex); } }
private DataTable getKurumListesi() { DataTable dt = new DataTable(); try { NpgsqlCommand command = new NpgsqlCommand(); string sql = "SELECT kk5 as \"Kurum Numarası\", adi as \"Kurum Adı\" FROM public.tb_kurumlar"; command.CommandText = sql; dt = dbConnection.getData(command); DataRow dr = dt.NewRow(); dr[0] = -1; dr[1] = ""; dt.Rows.InsertAt(dr, 0); } catch (Exception ex) { MessageBoxs.ErrorMessage(ex); } return(dt); }
private void btn_save_Click(object sender, EventArgs e) { try { if (dgvAlacak.Rows.Count == 0 || dgvBorclular.Rows.Count == 0) { MessageBoxs.WarningMessage("Dikkat borçlu veya kesinti yapılabilecek alacak şeçilmemiş."); return; } if (this.IcraKayitNo != 0) { UpdateIcra2DB(); } else { addIcra2DB(); } } catch (Exception ex) { MessageBoxs.ErrorMessage(ex); } }
private void toolStripMenuItem1_Click(object sender, EventArgs e) { try { int kayitNo = Convert.ToInt32(dgv_ekler.SelectedRows[0].Cells[0].Value); NpgsqlCommand command = new NpgsqlCommand(); command.CommandText = "select \"goruntu\", \"dosya_uzantisi\", \"aciklama\" from tb_cevaplar_ekler where kayitno = @kayitno_"; command.Parameters.AddWithValue("@kayitno_", NpgsqlTypes.NpgsqlDbType.Integer, kayitNo); DataTable dt = dbConnection.getData(command); if (dt.Rows.Count > 0) { string FILEPATH = Environment.ExpandEnvironmentVariables("%APPDATA%\\PersonelIcraTakipProgrami\\tmp"); Directory.CreateDirectory(FILEPATH); FILEPATH += "\\" + kayitNo + "_" + dt.Rows[0][2].ToString() + "_" + DateTime.Now.Year + "_" + DateTime.Now.Month + "_" + DateTime.Now.Day + "_" + DateTime.Now.Millisecond + "." + dt.Rows[0][1].ToString(); byte[] byteArray = (byte[])dt.Rows[0][0]; saveFile(byteArray, FILEPATH); Process.Start(FILEPATH); } } catch (Exception ex) { MessageBoxs.ErrorMessage(ex); } }