void LoadGrid() { try { if (rbTarihAralikli.Checked) { sd = dtpStart.Value; fd = dtpFinish.Value; } _source = _mngCariHar.GenelBorcAlacakDokumu(UserInfo.Sube.Id, txtCariKodu.Text, sd, fd); dataGridView1.DataSource = _source; if (_source != null && _source.Rows.Count > 0) { double borc = double.Parse(_source.Compute("sum(Borc)", "").ToString()); double alacak = double.Parse(_source.Compute("sum(Alacak)", "").ToString()); tslabCariToplamBorc.Text = borc.ToString("F2"); tslabCariToplamAlacak.Text = alacak.ToString("F2"); tslabCariBakiyesi.Text = (borc - alacak).ToString("F2"); dataGridView1.Columns["Borc"].DefaultCellStyle.Format = "F2"; dataGridView1.Columns["Alacak"].DefaultCellStyle.Format = "F2"; dataGridView1.Columns["BorcBakiyesi"].DefaultCellStyle.Format = "F2"; dataGridView1.Columns["AlacakBakiyesi"].DefaultCellStyle.Format = "F2"; } } catch (Exception exc) { MessageBox.Show(exc.Message); LogWrite.Write(exc); } }
private void btnTest_Click(object sender, EventArgs e) { try { StringBuilder conStr = new StringBuilder(); conStr.AppendFormat("Server={0};", txtServer.Text); conStr.AppendFormat("Initial Catalog={0};", txtDatabase.Text); conStr.AppendFormat("Password={0};", txtPassword.Text); conStr.AppendFormat("User ID={0}", txtUserID.Text); Settings set = new Settings { ConnectionString = conStr.ToString() }; //set.Paket = (IndeksPaket)Enum.Parse(typeof(IndeksPaket), cmbPaket.Text); set.Paket = IndeksPaket.Pro; set.DataBase = "MsSql"; set.Kurulum = "0"; //Engine.SaveConnectinString(conStr.ToString()); Engine.SaveSettings(set); ProcessDataBase prc = new ProcessDataBase(); bool test = prc.TestConnection(); if (test) { MessageBox.Show("Bağlandı"); } else { MessageBox.Show("Bağlanamadı"); } } catch (Exception exc) { MessageBox.Show(exc.Message); LogWrite.Write(exc); } }
//double toplamIskonto() { // if (_source != null && _source.Rows.Count > 0) // return double.Parse(_source.Compute("sum(Iskanto)", "").ToString()); // else // return 0; //} void LoadGrid() { try { DateTime?tarBas = null, tarBit = null, tesBas = null, tesBit = null; if ((dtTarBasTar.Value != dtTarBitTar.Value && dtTarBasTar.Value < dtTarBitTar.Value)) { tarBas = dtTarBasTar.Value; tarBit = dtTarBitTar.Value; } if ((dtTesBasTar.Value != dtTesBitTar.Value && dtTesBasTar.Value < dtTesBitTar.Value)) { tesBas = dtTesBasTar.Value; tesBit = dtTesBitTar.Value; } _source = _mngSipUst.SiparisRapor(UserInfo.Sube.Id, SecilenSiparisDurumlari(), txtCariKodu.Text, tarBas, tarBit, tesBas, tesBit); _source.Replace("SiprasTip", "5", "MüşteriSiparişi"); _source.Replace("SiprasTip", "6", "SatıcıSiparişi"); dataGridView1.DataSource = _source; if (_source != null && _source.Rows.Count > 0) { tslabToplamKdvTutar.Text = toplamKdvTutar().ToString("F2"); tslabToplamBrutTutar.Text = toplamBrutTutar().ToString("F2"); tslabToplamTutar.Text = toplamTutar().ToString("F2"); tslabToplamIskonto.Text = toplamIskanto().ToString("F2"); } } catch (Exception exc) { MessageBox.Show(exc.Message); LogWrite.Write(exc); } }
void SetKasaGenelGider() { try { _selectedKasaKodu = cmboxKasalar.Text; if (!string.IsNullOrEmpty(_selectedKasaKodu)) { double gelir = mngKasaHar.GetKasaGelirGiderBySubeKoduAndKasaKodu(UserInfo.Sube.Id, _selectedKasaKodu, KasaGelirGider.Gelir); double gider = mngKasaHar.GetKasaGelirGiderBySubeKoduAndKasaKodu(UserInfo.Sube.Id, _selectedKasaKodu, KasaGelirGider.Gider); Kasa kasa = mngKasa.GetById(_selectedKasaKodu, false); double devir = kasa.SonDevirTutar.GetValueOrDefault(0); double bakiye = (gelir + devir) - gider; txtDevir.Text = devir.ToString("F2"); txtToplamGelir.Text = gelir.ToString("F2"); txtToplamGider.Text = gider.ToString("F2"); txtDevreden.Text = bakiye.ToString("F2"); tslabTopGelir.Text = gelir.ToString("F2"); tslabTopGider.Text = gider.ToString("F2"); tsLabBakiye.Text = bakiye.ToString("F2"); this.Text = string.Format("KasaKodu:{0};Tarih:{1}", cmboxKasalar.Text, dateIslemTarih.Value.ToString("d")); } } catch (Exception exc) { MessageBox.Show(exc.Message); LogWrite.Write(exc); } }
void Kaydet() { Sube sube = new Sube(); //AssignSubeValue(sube); try { sube = managerSube.GetById(txtSubeKodu.Text, false); if (sube == null) { sube = new Sube(); } AssignSubeValue(sube); sube.Id = txtSubeKodu.Text; BeginTransaction(); managerSube.SaveOrUpdate(sube); LoadAllSube(); YeniKayit(); } catch (Exception) { } finally { try { CommitTransaction(); } catch (Exception exc) { LogWrite.Write(exc); MessageBox.Show(exc.Message); } } }
public frmCekDurum(int cekId, CekTip cekTip, CekDurum cekDurum) : base() { InitializeComponent(); g_mngCek = _mngFac.GetCekManager(); g_cekId = cekId; g_cekTip = cekTip; g_cekDurum = cekDurum; SetData(); txtBankaHesap.DataSource = () => { try { return(_mngBanka.GetBankaHesapNoBySubeKodu(UserInfo.Sube.Id, txtBankaHesap.Text)); } catch (Exception exc) { LogWrite.Write(exc); MessageBox.Show(exc.Message); } return(null); }; txtCari.DataSource = () => { try { return(_mngCari.GetCariKodsBySubeKodu(UserInfo.Sube.Id, txtCari.Text).ToStringList(15, txtCari.Ayirac)); } catch (Exception exc) { MessageBox.Show(exc.Message); LogWrite.Write(exc); } return(null); }; LoadKasa(cmbKasa); InitializeScreenValues(); SetControlLocation(); }
void OzelKalemSil() { DialogResult re = MessageBox.Show("Kayıt Silinsin mi?", "Dikkat", MessageBoxButtons.YesNoCancel, MessageBoxIcon.Question); if (re == DialogResult.Yes) { try { if (_selectedOzelKasaHar != null) { KasaHareket kasahar = mngKasaHar.GetById(_selectedOzelKasaHar.Value, true); mngKasaHar.BeginTransaction(); mngKasaHar.Delete(kasahar); DataGridViewRow dr = dataGridViewOzel.SelectedRows[0]; dataGridViewOzel.Rows.Remove(dr);; OzelYeniKayit(); SetKasaGenelGider(); } } catch (Exception) { } finally { try { mngKasaHar.CommitTransaction(); } catch (Exception exc) { MessageBox.Show(exc.Message); LogWrite.Write(exc); } } } }
void KalemSil() { try { DialogResult re = MessageBox.Show("Kayıt Silinsin mi?", "Dikkat", MessageBoxButtons.YesNoCancel, MessageBoxIcon.Question); if (re == DialogResult.Yes) { if (_selectedSipKalId != null) { SiparisKalem sh = mngSipKal.GetById(_selectedSipKalId.Value, false); BeginTransaction(); mngSipKal.Delete(sh); HesaplaToplamlari(); _selectedSipKalId = null; LoadSiparisToGrid(); YeniKalem(); } } } catch (Exception exc) { MessageBox.Show(exc.Message); LogWrite.Write(exc); } finally { try { CommitTransaction(); } catch (Exception exc) { LogWrite.Write(exc); MessageBox.Show(exc.Message); } } }
void HesaplaToplamlari() { try { if (_currentStok == null) { _currentStok = mngStk.GetById(txtStokKodu.Text, false); } //HesaplaToplam hes = new HesaplaToplam(_ftirsip) //{ // Fiyat = txtFyt.Text.ParseNullable<double>(x => double.Parse(x)), // KdvDahil = chkKdvDahilmi.Checked, // Miktar = txtMiktar.Text.ParseStruct<double>(x => double.Parse(x)), // Stok = _currentStok //}; //hes.IskontoOranlari.Add(txtIsk1.Text.ParseNullable<double>(x => double.Parse(x))); //hes.IskontoOranlari.Add(txtIsk2.Text.ParseNullable<double>(x => double.Parse(x))); //hes.IskontoOranlari.Add(txtIsk3.Text.ParseNullable<double>(x => double.Parse(x))); //hes.IskontoOranlari.Add(txtIsk4.Text.ParseNullable<double>(x => double.Parse(x))); //hes.IskontoOranlari.Add(txtIsk5.Text.ParseNullable<double>(x => double.Parse(x))); //txtBrutToplam.Text = (hes.BrutHesapla()).ToString("F2"); //txtIskToplam.Text = (hes.SatirIskantosuToplam()).ToString("F2"); //txtAraToplam.Text = (hes.AraToplam()).ToString("F2"); //txtKdvToplam.Text = (hes.KdvHesapla()).ToString("F2"); //txtGenelToplam.Text = (hes.GenelToplam()).ToString("F2"); } catch (Exception exc) { LogWrite.Write(exc); MessageBox.Show(exc.Message); } }
void MiktarArtir() { try { if (string.IsNullOrEmpty(txtMiktar.Text)) { txtMiktar.Text = "1"; //txtBarkod.Focus(); HesaplaTutarFiyat(); } else { double d = txtMiktar.Text.ParseStruct <double>(x => double.Parse(x)); d += 1; txtMiktar.Text = d.ToString(); HesaplaTutarFiyat(); //txtBarkod.Focus(); } } catch (Exception exc) { LogWrite.Write(exc); MessageBox.Show(exc.Message); } }
private void txtSatisFiyat_KeyDown(object sender, KeyEventArgs e) { if (!string.IsNullOrEmpty(txtSatisFiyat.Text) && (e.KeyCode == Keys.Tab || e.KeyCode == Keys.Enter)) { try { if (_currentStok == null) { _currentStok = mngStk.GetBySubeAndBarkod1(UserInfo.Sube.Id, txtBarkod.Text); } if (_currentStok == null) { _currentStok = mngStk.GetById(txtBarkod.Text, false); } if (_currentStok != null) { //txtStokKodu.Text = _currentStok.Id; //txtSatisFiyat.Text = _currentStok.SatisFiyat1.GetValueOrDefault().ToString(); KalemKaydet(); //YeniKalem(); } } catch (Exception exc) { MessageBox.Show(exc.Message); LogWrite.Write(exc); } } }
private void txtBarkod_KeyDown(object sender, KeyEventArgs e) { if (!string.IsNullOrEmpty(txtBarkod.Text) && (e.KeyCode == Keys.Tab || e.KeyCode == Keys.Enter)) { try { //if (_currentStok == null) _currentStok = mngStk.GetBySubeAndBarkod1(UserInfo.Sube.Id, txtBarkod.Text); if (_currentStok == null) { _currentStok = mngStk.GetById(txtBarkod.Text, false); } if (_currentStok != null) { //txtStokKodu.Text = _currentStok.Id; if (string.IsNullOrEmpty(txtSatisFiyat.Text.Trim()) || txtSatisFiyat.Text.Trim() == "0") { txtSatisFiyat.Text = _currentStok.SatisFiyat1.GetValueOrDefault().ToString(); } txtSatisFiyat.Focus(); labSecilenUrun.Text = string.Format("{0} {1}", _currentStok.Id, _currentStok.StokAdi); // KalemKaydet(); //YeniKalem(); } } catch (Exception exc) { MessageBox.Show(exc.Message); LogWrite.Write(exc); } } }
private void dataGridView1_CellClick(object sender, DataGridViewCellEventArgs e) { try { if (dataGridView1.CurrentRow != null) { //txtStokKodu.Text = _selectedStokKodu = dataGridView1.CurrentRow.Cells["clStokKodu"].Value.ToStringOrEmpty(); _currentStok = null; txtMiktar.Text = dataGridView1.CurrentRow.Cells["clMiktar"].Value.ToStringOrEmpty(); txtSatisFiyat.Text = dataGridView1.CurrentRow.Cells["clFiyat"].Value.ToStringOrEmpty(); txtBarkod.Text = dataGridView1.CurrentRow.Cells["clBarkod"].Value.ToStringOrEmpty(); _selectedStokHarId = dataGridView1.CurrentRow.Cells["clId"].Value.ToString().ParseNullable <int>(x => int.Parse(x)); txtTutar.Text = double.Parse(dataGridView1.CurrentRow.Cells["clTutar"].Value.ToStringOrEmpty()).ToString("F2"); //txtMiktar.Focus() ; //txtStokMiktar.Text = mngSth.GetStokMiktar(txtStokKodu.Text).ToString(); if (string.IsNullOrEmpty(txtBarkod.Text)) { txtBarkod.Text = dataGridView1.CurrentRow.Cells[clStokKodu.Name].Value.ToStringOrEmpty(); } txtBarkod.Focus(); } } catch (Exception exc) { MessageBox.Show(exc.Message); LogWrite.Write(exc); } }
private void btnPrint_Click(object sender, EventArgs e) { frmRaporDialog frm = new frmRaporDialog(true, true, true, false); frm.ShowDialog(); try { ReportTo?dest = frm.GetReportDestination(); if (dest.HasValue) { if (dest.Value != ReportTo.CrytalReport) { // Create the report and turn our query into a ReportSource var report = new Report(_data.ToReportSource()); // Customize the Text Fields report.TextFields.Title = "Gün gün Kasa Raporu"; report.TextFields.Header = string.Format(@" Kasa :{0} Rapor Tarihi: {1} Tarih Aralığı:{2} ", cmboxKasalar.Text, DateTime.Now, GetTarihAraligi()); // Render hints allow you to pass additional hints to the reports as they are being rendered report.DataFields["Gelir"].ShowTotals = true; report.DataFields["Gider"].ShowTotals = true; report.DataFields["Bakiye"].ShowTotals = true; // Customize the data fields report.RenderHints["HtmlStyle"] = "th { font-size: 14px !important;font-weight:bold !important}"; report.DataFields["Gelir"].DataFormatString = "{0:F2}"; report.DataFields["Gider"].DataFormatString = "{0:F2}"; report.DataFields["Bakiye"].DataFormatString = "{0:F2}"; report.DataFields["Tarih"].DataFormatString = "{0:d}"; string fileName = "gunGunKasaRaporu.xls"; IReportWriter writer = new ExcelReportWriter(); if (dest.Value == ReportTo.Html) { writer = new HtmlReportWriter(); fileName = "gunGunKasaRaporu.html"; } else if (dest.Value == ReportTo.Csv) { writer = new DelimitedTextReportWriter(); fileName = "gunGunKasaRaporu.txt"; } string file = Path.Combine(Engine.DokumanPath(), fileName); FileStream fs = new FileStream(file, FileMode.Create); writer.WriteReport(report, fs); fs.Close(); Process prc = new Process(); prc.StartInfo.FileName = file; prc.Start(); } } } catch (Exception exc) { MessageBox.Show(exc.Message); LogWrite.Write(exc); } }
void ConstructDataBase() { try { string pathScript = Path.Combine(Application.StartupPath, @"script/scripts.txt"); StreamReader sr = new StreamReader(pathScript); string sqlScripts = sr.ReadToEnd(); sr.Close(); string database = _database; sqlScripts = sqlScripts.Replace("#DataBaseName#", database); string pathMdf = dataBasePath; string pathLdf = pathMdf; pathMdf = Path.Combine(dataBasePath, database + ".mdf"); pathLdf = Path.Combine(dataBasePath, database + "_log.ldf"); sqlScripts = sqlScripts.Replace("#PathMdf#", pathMdf); sqlScripts = sqlScripts.Replace("#PathLdf#", pathLdf); sqlScripts = sqlScripts.Replace("HAN_log", database + "_log"); ProcessDataBase pData = new ProcessDataBase(); pData.ExecuteNonQueries(sqlScripts, textBox1); btnKapat.Enabled = true; Settings set = Engine.FindSettings(); set.Kurulum = "1"; Engine.SaveSettings(set); } catch (Exception exc) { LogWrite.Write(exc); MessageBox.Show(exc.Message); } }
private void txtStokKodu_KeyUp(object sender, KeyEventArgs e) { if (!string.IsNullOrEmpty(txtStokKodu.Text) && e.KeyCode == Keys.Tab) { try { //if(_currentStok==null) _currentStok = mngStk.GetById(txtStokKodu.Text, false); if (_currentStok != null) { txtStokIsmi.Text = _currentStok.StokAdi; txtBarkod.Text = _currentStok.Barkod1; txtKdv.Text = _currentStok.KdvOrani.FromNullableToString(); if (_selectedSipKalId == null || _selectedStokKodu != txtStokKodu.Text) { SetFiyat(); } cmbBirim.Focus(); } else { frmStok frm = new frmStok(this, _ftirsip); txtStokKodu.CloseAutoComplete(); frm.txtStokIsmi.Focus(); frm.WindowState = FormWindowState.Maximized; frm.ShowDialog(); } } catch (Exception exc) { MessageBox.Show(exc.Message); LogWrite.Write(exc); } } }
void LoadCategory() { try { if (StokCariCategory.Stok == _stokCari) { List <StokCategory> liste = _mngStkCat.GetListRootCategories(); foreach (var item in liste) { TreeNode tn = new TreeNode(); tn.Text = string.Format("{0}-{1}", item.Id, item.CategoryName); RecursiveAddNode(item.ChildCategories, tn); treeView1.Nodes.Add(tn); } } else { List <CariCategory> liste = _mngCariCat.GetListRootCategories(); foreach (var item in liste) { TreeNode tn = new TreeNode(); tn.Text = string.Format("{0}-{1}", item.Id, item.CategoryName); RecursiveAddNode(item.ChildCategories, tn); treeView1.Nodes.Add(tn); } } } catch (Exception exc) { LogWrite.Write(exc); MessageBox.Show(exc.Message); } }
void SiparisSil() { bool isBegin = false; try { if (_currentSipUst != null) { DialogResult re = MessageBox.Show("Kayıt Silinsin mi?", "Dikkat", MessageBoxButtons.YesNoCancel, MessageBoxIcon.Question); if (re == DialogResult.Yes) { isBegin = true; mngSipKal.TopluKalemSil(_currentSipUst.FatirsNo, _ftirsip); BeginTransaction(); mngSipUst.Delete(_currentSipUst); //mngSipUst.CommitTransaction(); } } } catch (Exception) { } finally { try { if (isBegin) { mngSipUst.Delete(_currentSipUst); CommitTransaction(); InitializeForm(); GetLastArtiSipNo(); } } catch (Exception exc) { LogWrite.Write(exc); MessageBox.Show(exc.Message); } } }
public frmKasaKayitlari() { InitializeComponent(); mng = new ManagerFactory(Engine.GetConString(), Engine.GetSqlServerType()); mngKasa = mng.GetKasaManager(); mngKasaHar = mng.GetKasaHarManager(); mngCari = mng.GetCariManager(); mngCariHar = mng.GetCariHareketManager(); LoadKasa(); TapGelirGider(); txtCariKod.DataSource = () => { try { return(mngCari.GetCariKodsBySubeKodu(UserInfo.Sube.Id, txtCariKod.Text).ToStringList(15, txtCariKod.Ayirac)); } catch (Exception exc) { MessageBox.Show(exc.Message); LogWrite.Write(exc); } return(null); }; txtCariKod.DataSource = () => { try { return(mngCari.GetCariKodsBySubeKodu(UserInfo.Sube.Id, txtCariKod.Text).ToStringList(15, txtCariKod.Ayirac)); } catch (Exception exc) { MessageBox.Show(exc.Message); LogWrite.Write(exc); } return(null); }; }
void grd_CellClick(object sender, DataGridViewCellEventArgs e) { try { if (filterDataGridView1.grd.CurrentRow != null) { DataGridViewRow currentRow = filterDataGridView1.grd.CurrentRow; txtStokKodu.Text = _selectedStokKodu = currentRow.Cells["clStokKodu"].Value.ToStringOrEmpty(); _currentStok = mngStk.GetById(_selectedStokKodu, false); DoldurStokBirimleri(_currentStok, cmbBirim); txtStokIsmi.Text = currentRow.Cells["clStokAdi"].Value.ToStringOrEmpty(); txtMiktar.Text = currentRow.Cells["clMiktar"].Value.ToStringOrEmpty(); cmbBirim.Text = currentRow.Cells[clHareketBirim.Name].Value.ToStringOrEmpty(); txtFyt.Text = currentRow.Cells["clFiyat"].Value.ToStringOrEmpty(); txtIsk1.Text = currentRow.Cells["clIsk1"].Value.ToStringOrEmpty(); txtIsk2.Text = currentRow.Cells["clIsk2"].Value.ToStringOrEmpty(); txtIsk3.Text = currentRow.Cells["clIsk3"].Value.ToStringOrEmpty(); txtIsk4.Text = currentRow.Cells["clIsk4"].Value.ToStringOrEmpty(); txtIsk5.Text = currentRow.Cells["clIsk5"].Value.ToStringOrEmpty(); txtBarkod.Text = currentRow.Cells["clBarkod"].Value.ToStringOrEmpty(); _selectedSipKalId = currentRow.Cells["clId"].Value.ToString().ParseNullable <int>(x => int.Parse(x)); txtTutar.Text = currentRow.Cells["clTutar"].Value.ToStringOrEmpty(); txtBarkod.Focus(); txtStokMiktar.Text = mngSth.GetStokMiktar(txtStokKodu.Text).ToString(); txtKdv.Text = currentRow.Cells[clKdvOrani.Name].Value.ToStringOrEmpty(); } } catch (Exception exc) { MessageBox.Show(exc.Message); LogWrite.Write(exc); } }
private void dataGridViewCari_CellClick(object sender, DataGridViewCellEventArgs e) { try { DataGridViewRow dr = dataGridViewCari.CurrentRow; if (dr != null) { txtCariKod.Text = dr.Cells["clCariKod"].Value.ToStringOrEmpty(); txtCariIsim.Text = dr.Cells["clCariIsim"].Value.ToStringOrEmpty(); txtHesapBakiyesi.Text = dr.Cells["clHesapBakiyesi"].Value.ToStringOrEmpty(); txtCariTel.Text = dr.Cells["clTel"].Value.ToStringOrEmpty(); txtCariAdres.Text = dr.Cells["clAdres"].Value.ToStringOrEmpty(); txtCariVergiNumarasi.Text = dr.Cells["clVergiNumarasi"].Value.ToStringOrEmpty(); txtCariVergiDairesi.Text = dr.Cells["clVergiDairesi"].Value.ToStringOrEmpty(); txtCariGrup1.Text = dr.Cells["clGrup1"].Value.ToStringOrEmpty(); txtCariGrup2.Text = dr.Cells["clGrup2"].Value.ToStringOrEmpty(); txtCariFisNo.Text = dr.Cells["clFisNo"].Value.ToStringOrEmpty(); txtCariTutar.Text = dr.Cells["clTutar"].Value.ToStringOrEmpty(); txtCariKasaAciklama.Text = dr.Cells["clKasaAciklama"].Value.ToStringOrEmpty(); _selectedCahar = dr.Cells["clCariHarId"].Value.ToString().ParseNullable <int>(x => int.Parse(x)); _selectedKasaHar = dr.Cells["clKasaHarId"].Value.ToString().ParseNullable <int>(x => int.Parse(x)); txtCariKod.Focus(); } } catch (Exception exc) { MessageBox.Show(exc.Message); LogWrite.Write(exc); } }
public frmIrsFatura(string IrsNo, FTIRSIP ftirsip) { _irsNo = IrsNo; _ftirsip = ftirsip; mng = new ManagerFactory(Engine.GetConString(), Engine.GetSqlServerType()); mngFatUst = mng.GetFatirsUstManager(); mngCari = mng.GetCariManager(); mngSth = mng.GetStokHareketManager(); mngKasa = mng.GetKasaManager(); mngKasaHar = mng.GetKasaHarManager(); mngCariHrk = mng.GetCariHareketManager(); InitializeComponent(); try { _fatIrsUst = mngFatUst.GetByBelgeNoBelgeTipAndSubeKodu(_irsNo, _ftirsip, UserInfo.Sube.Id); if (_fatIrsUst.FatTipi == FatTipi.KapaliFat || _fatIrsUst.FatTipi == FatTipi.MuhtelifFat) { LoadKasa(); cmboxKasalar.Enabled = true; } txtFatNo.Text = mngFatUst.GetLastArtiOneFatIrsNoBySubeKoduAndFtirsip(UserInfo.Sube.Id, DetermineFtirsip(ftirsip)); } catch (Exception exc) { MessageBox.Show(exc.Message); LogWrite.Write(exc); } }
void KayitSil() { DialogResult re = MessageBox.Show("Kayıt Silinsin mi?", "Dikkat", MessageBoxButtons.YesNoCancel, MessageBoxIcon.Question); if (re == DialogResult.Yes) { try { Sube sube = managerSube.GetById(txtSubeKodu.Text, true); if (!UserInfo.Kullanici.Adminmi.Value) { MessageBox.Show("Sadece admin kullanıcı şube silebilir"); return; } if (sube != null && UserInfo.Sube.Id == sube.Id) { MessageBox.Show("Bulunduğunuz şubeyi silemezsiniz"); return; } managerSube.BeginTransaction(); managerSube.Delete(sube); LoadAllSube(); btnYeni_Click(this, EventArgs.Empty); } catch (Exception exc) { MessageBox.Show(exc.Message); LogWrite.Write(exc); } finally { try { managerSube.CommitChanges(); } catch (Exception exc) { LogWrite.Write(exc); MessageBox.Show(exc.Message); } } } }
void LoadGrid() { try { KasaHareketDurumlari helper = GetKasaHareketDurumlari(checkedListBoxHareketTipleri); int yil = int.Parse(maskedTextBoxYil.Text); _source = _mngKasaHar.AyAyGelirGiderRaporu(helper, cmboxKasalar.Text, UserInfo.Sube.Id, yil); _source.Replace("Ay", "1", "Ocak"); _source.Replace("Ay", "2", "Şubat"); _source.Replace("Ay", "3", "Mart"); _source.Replace("Ay", "4", "Nisan"); _source.Replace("Ay", "5", "Mayıs"); _source.Replace("Ay", "6", "Haziran"); _source.Replace("Ay", "7", "Temmuz"); _source.Replace("Ay", "8", "Ağustos"); _source.Replace("Ay", "9", "Eylül"); _source.Replace("Ay", "01", "Ocak"); _source.Replace("Ay", "02", "Şubat"); _source.Replace("Ay", "03", "Mart"); _source.Replace("Ay", "04", "Nisan"); _source.Replace("Ay", "05", "Mayıs"); _source.Replace("Ay", "06", "Haziran"); _source.Replace("Ay", "07", "Temmuz"); _source.Replace("Ay", "08", "Ağustos"); _source.Replace("Ay", "09", "Eylül"); _source.Replace("Ay", "10", "Ekim"); _source.Replace("Ay", "11", "Kasım"); _source.Replace("Ay", "12", "Aralık"); dataGridView1.DataSource = _source; if (_source != null && _source.Rows.Count > 0) { tslabToplamGelir.Text = ToplamGelir().ToString("F2"); tslabToplamGider.Text = ToplamGider().ToString("F2"); tslabToplamBakiye.Text = ToplamBakiye().ToString("F2"); dataGridView1.Columns["Bakiye"].DefaultCellStyle.Format = "F2"; } } catch (Exception exc) { LogWrite.Write(exc); MessageBox.Show(exc.Message); } }
private void btnKaydet_Click(object sender, EventArgs e) { try { //Server=FATIH;Initial Catalog=HAN2009;Password=sapass;User ID=sa StringBuilder conStr = new StringBuilder(); conStr.AppendFormat("Server={0};", txtServer.Text); conStr.AppendFormat("Initial Catalog={0};", txtDatabase.Text); conStr.AppendFormat("Password={0};", txtPassword.Text); conStr.AppendFormat("User ID={0}", txtUserID.Text); Settings set = new Settings { ConnectionString = conStr.ToString() }; //Engine.SaveConnectinString(conStr.ToString()); //set.Paket = (IndeksPaket)Enum.Parse(typeof(IndeksPaket), cmbPaket.Text); set.Paket = IndeksPaket.Pro; set.Kurulum = "0"; set.DataBase = "MsSql"; Engine.SaveSettings(set); frmKurStp2 frm = new frmKurStp2(_frmLogin, this, txtDatabase.Text); this.Hide(); frm.ShowDialog(); } catch (Exception exc) { MessageBox.Show(exc.Message); LogWrite.Write(exc); } }
void Sil() { DialogResult re = MessageBox.Show("Kayıt Silinsin mi?", "Dikkat", MessageBoxButtons.YesNoCancel, MessageBoxIcon.Question); if (re == DialogResult.Yes) { try { if (_selectedDizayn != null) { Dizayn d = mngDizayn.GetById(_selectedDizayn.Value, false); mngDizayn.BeginTransaction(); mngDizayn.Delete(d); YeniKalem(); } } catch (Exception exc) { MessageBox.Show(exc.Message); LogWrite.Write(exc); } finally { try { mngDizayn.CommitTransaction(); } catch (Exception exc) { MessageBox.Show(exc.Message); LogWrite.Write(exc); } } } }
private void btnRaporla_Click(object sender, EventArgs e) { try { HesapHareketTuru?turu = null; turu = HareketTipiniBelirle(turu); hareketList = mngHesap.GetHesapNoWithDate(UserInfo.Sube.Id, txtHesapNo.Text, dateTimeStart.Value.JustDate(), dateTimeFinish.Value.JustDate(), turu); dataGridView1.Columns[clTutar.Name].DefaultCellStyle.Format = "F2"; dataGridView1.AutoGenerateColumns = false; hareketList.Replace("HareketTuru", "1", "ParaYatirma(+)"); hareketList.Replace("HareketTuru", "2", "ParaCekme(-)"); hareketList.Replace("HareketTuru", "3", "GelenHavale(+)"); hareketList.Replace("HareketTuru", "4", "GidenHavale(-)"); hareketList.Replace("HareketTuru", "5", "KrediKarti"); hareketList.Replace("HareketTuru", "6", "ÇekÖdeme"); hareketList.Replace("HareketTuru", "7", "ÇekTahsil"); hareketList.Replace("HareketTuru", "8", "SenetTahsil"); if (hareketList.Count > 0) { btnPrint.Visible = true; tslabToplamTutar.Text = hareketList.Sum(x => x.Tutar).ToString("F2"); } else { btnPrint.Visible = false; } dataGridView1.DataSource = hareketList; } catch (Exception exc) { MessageBox.Show(exc.Message); LogWrite.Write(exc); } }
void Kaydet() { try { Dizayn dizayn = null; if (_selectedDizayn != null) { dizayn = mngDizayn.GetById(_selectedDizayn.Value, false); } else { dizayn = new Dizayn(); } dizayn.DizaynAdi = txtDizaynAdi.Text; dizayn.DizaynTipi = cmboxDizaynTipi.SelectedIndex == 0 ? DizaynTipi.SatisFatura : DizaynTipi.SatisIrsaliye; dizayn.Sube = UserInfo.Sube; mngDizayn.BeginTransaction(); mngDizayn.SaveOrUpdate(dizayn); LoadGrid(); YeniKalem(); } catch (Exception) { } finally { try { mngDizayn.CommitTransaction(); } catch (Exception exc) { MessageBox.Show(exc.Message); LogWrite.Write(exc); } } }
void LoadGrid() { try { if (rbTarihAralikli.Checked) { sd = dtpStart.Value; fd = dtpFinish.Value; } //_source = mngStokHar.StokMaliyetRaporu(UserInfo.Sube.Id,_alisGirisKod, txtStokKodu.Text,sd, //fd); _source = mngStokHar.StokMalMaliyetRaporu(UserInfo.Sube.Id, txtStokKodu.Text, txtStokGrup.Text, sd, fd); dataGridView1.DataSource = _source; if (_source != null && _source.Rows.Count > 0) { tslabEldekiMalMiktar.Text = eldekiMalMiktar().ToString("F2"); tslabToplamAlisMiktar.Text = toplamAlisMiktar().ToString("F2"); tslabToplamAlisTutar.Text = toplamAlisTutar().ToString("F2"); tslabToplamSatisMiktar.Text = toplamSatisMiktar().ToString("F2"); tslabToplamSatisTutar.Text = toplamSatisTutar().ToString("F2"); tslabTopKalanMalinMaliyeti.Text = toplamKalanMalinMaliyeti().ToString("F2"); } } catch (Exception exc) { MessageBox.Show(exc.Message); LogWrite.Write(exc); } }
void KayitSil() { DialogResult re = MessageBox.Show("Kayıt Silinsin mi?", "Dikkat", MessageBoxButtons.YesNoCancel, MessageBoxIcon.Question); if (re == DialogResult.Yes) { try { ListViewItem item = listView1.SelectedItems[0]; string cariKodu = item.SubItems[0].Text; if (string.IsNullOrEmpty(cariKodu)) { MessageBox.Show("cari seçiniz"); return; } Cari cari = mngCari.GetById(cariKodu, true); mngCari.BeginTransaction(); mngCari.Delete(cari); } catch (Exception) { } finally { try { mngCari.CommitTransaction(); LoadCari(); } catch (Exception exc) { MessageBox.Show(exc.Message); LogWrite.Write(exc); } } } }