private void simpleButton1_Click(object sender, EventArgs e) { BaglantiCumleOlustur(); connectionStringBuilder.InitialCatalog = "master"; if (ConnectionTool.CheckConnection(connectionStringBuilder.ConnectionString)) { connectionStringBuilder.InitialCatalog = txtDbAdi.Text; MessageBox.Show("Sectiğiniz Serverda Belittiğiniz Database Yoksa Bu Mesajdan Sonra Oluşturulacak.Bu İşlem Uzun Sürebilir. "); SettingsTool.AyarDegistir(SettingsTool.Ayarlar.DatabaseAyarlari_BaglantiCumlesi, connectionStringBuilder.ConnectionString); SettingsTool.save(); using (var context = new IsbaSatisContext()) { context.Database.CreateIfNotExists(); if (!context.Kullanicilar.Any(c => c.KullaniciAdi == "yönetici")) { context.Kullanicilar.Add(new Kullanici { KullaniciAdi = "yönetici", Adi = "isba", Soyadi = "Yazılım", Parola = "2515", KayitTarihi = DateTime.Now }); context.SaveChanges(); } } kaydedildi = true; this.Close(); } else { MessageBox.Show("Bağlantı Başarısız"); } }
public Form1() { InitializeComponent(); DevExpress.LookAndFeel.UserLookAndFeel.Default.SkinName = "Visual Studio 2013 Light"; using (var context = new IsbaSatisContext()) { context.Database.CreateIfNotExists(); if (!context.Kullanicilar.Any(c => c.KullaniciAdi == "yönetici")) { context.Kullanicilar.Add(new Kullanici { KullaniciAdi = "yönetici", Adi = "isba", Soyadi = "Yazılım", Parola = "2515", KayitTarihi = DateTime.Now }); context.SaveChanges(); } } frmKullaniciGiris form = new frmKullaniciGiris(); form.ShowDialog(); barKullaniciAdi.Caption = $"Giriş Yapan Kullanıcı : {RolTool.KullaniciEntity.KullaniciAdi}"; }
public CodeTool(XtraForm form, Table table, IsbaSatisContext context) { _form = form; _context = context; _table = table; manager.Form = _form; menu = new PopupMenu(manager); }
protected override bool IsValid(PropertyValidatorContext context) { using (var isbaSatisContext = new IsbaSatisContext()) { var dataId = context.Instance.GetType().GetProperty("Id").GetValue(context.Instance); var result = isbaSatisContext.Set <TEntity>().Where($"{context.PropertyName}==@0 And Id!=@1", context.PropertyValue, dataId).Any(); return(!result); } }
public frmKullaniciGiris() { InitializeComponent(); if (!ConnectionTool.CheckConnection(SettingsTool.AyarOku(SettingsTool.Ayarlar.DatabaseAyarlari_BaglantiCumlesi))) { frmBaglantiAyarlari frm = new frmBaglantiAyarlari(); frm.ShowDialog(); } context = new IsbaSatisContext(); }
public static void RolleriYukle(RibbonControl form) { IsbaSatisContext context = new IsbaSatisContext(); foreach (var item in context.KullaniciRolleri.Where(c => c.KullaniciAdi == KullaniciEntity.KullaniciAdi && c.FormAdi == "FrmAnaMenu" && c.Yetki == false).ToList()) { var bulan = form.Items.Where(c => c.Name == item.KontrolAdi).SingleOrDefault(); if (bulan != null) { bulan.Enabled = false; } } }
public rptSokBazliHareket(DateTime baslangic, DateTime bitis, string stok) { InitializeComponent(); IsbaSatisContext context = new IsbaSatisContext(); StokHareketDAL stokHareketDAL = new StokHareketDAL(); ObjectDataSource dataSource = new ObjectDataSource { DataSource = stokHareketDAL.StokHareketStokBazli(context, baslangic, bitis, stok) }; this.DataSource = dataSource; colHareketi.DataBindings.Add("Text", this.DataSource, "Hareket"); colTarih.DataBindings.Add("Text", this.DataSource, "Tarih"); colBarkod.DataBindings.Add("Text", this.DataSource, "Barkod"); colStokAdi.DataBindings.Add("Text", this.DataSource, "StokAdi"); colBirimi.DataBindings.Add("Text", this.DataSource, "Birimi"); colKdv.DataBindings.Add("Text", this.DataSource, "Kdv", "{0:'%'0}"); colMiktar.DataBindings.Add("Text", this.DataSource, "Miktar"); colBirimFiyat.DataBindings.Add("Text", this.DataSource, "BirimFiyati", "{0:C2}"); colIndirimOrani.DataBindings.Add("Text", this.DataSource, "IndirimOrani", "{0:'%'0}"); colIndirimTutar.DataBindings.Add("Text", null, "indirimTutar", "{0:C2}"); colTutar.DataBindings.Add("Text", this.DataSource, "ToplamTutar", "{0:C2}"); lblToplamTutar.DataBindings.Add("Text", this.DataSource, "genelTutar", "{0:C2}"); lblIndirimTutar.DataBindings.Add("Text", null, "stokIndToplam", "{0:C2}"); //CalculatedField calcIndirimTutari = new CalculatedField(); //this.CalculatedFields.Add(calcIndirimTutari); //calcIndirimTutari.Name = "IndirimTutar"; //calcIndirimTutari.Expression = "([BirimFiyati] * [Miktar]) / 100 * [IndirimOrani] "; //CalculatedField calcTutar = new CalculatedField(); //this.CalculatedFields.Add(calcTutar); //calcTutar.Name = "Tutar"; //calcTutar.Expression = "([BirimFiyati] * [Miktar]) - [IndirimTutar]"; //colTutar.DataBindings.Add("Text", null, "Tutar", "{0:C2}"); //XRSummary sumIndirimTutari = new XRSummary(); //sumIndirimTutari.Func = SummaryFunc.Sum; //sumIndirimTutari.Running = SummaryRunning.Group; //sumIndirimTutari.FormatString = "{0:C2}"; //XRSummary sumToplamTutar = new XRSummary(); //sumToplamTutar.Func = SummaryFunc.Sum; //sumToplamTutar.Running = SummaryRunning.Group; //sumToplamTutar.FormatString = "{0:C2}"; //lblIndirimTutar.Summary = sumIndirimTutari; //lblToplamTutar.Summary = sumToplamTutar; }
public static void RolleriYukle(XtraForm form) { IsbaSatisContext context = new IsbaSatisContext(); foreach (var item in context.KullaniciRolleri.Where(c => c.KullaniciAdi == KullaniciEntity.KullaniciAdi && c.FormAdi == form.Name && c.Yetki == false).ToList()) { var bulunan = form.Controls.Find(item.KontrolAdi, true).SingleOrDefault(); if (bulunan != null) { bulunan.Enabled = false; } } }
private static StokHareket StokToStokHareket(IsbaSatisContext context, Isbasatis.Entities.Tables.Stok entity, decimal miktar) { StokHareket stokHareket = new StokHareket(); IndirimDAL indirimDAL = new IndirimDAL(); stokHareket.StokId = entity.Id; stokHareket.DepoId = Convert.ToInt32(SettingsTool.AyarOku(SettingsTool.Ayarlar.SatisAyarlari_VarsayilanDepo)); // stokHareket.BirimFiyati = txtFisturu.Text == "Alış Faturası" ? entity.AlisFiyati1 : entity.SatisFiyati1; stokHareket.Miktar = miktar; stokHareket.Tarih = DateTime.Now; stokHareket.IndirimOrani = indirimDAL.StokIndirimi(context, entity.StokKodu); stokHareket.Kdv = entity.SatisKdv; return(stokHareket); }
public rptGunlukSatis(DateTime giris) { InitializeComponent(); IsbaSatisContext context = new IsbaSatisContext(); KasaHareketDAL kasaHareketDAL = new KasaHareketDAL(); ObjectDataSource kasaDatasource = new ObjectDataSource { DataSource = kasaHareketDAL.OdemeTuruSatisListele(context, giris) }; this.DataSource = kasaDatasource; colOdemeTuru.DataBindings.Add("Text", this.DataSource, "OdemeTuruAdi"); colKasaGiris.DataBindings.Add("Text", this.DataSource, "KasaGiris", "{0:C2}"); colKasaCikis.DataBindings.Add("Text", this.DataSource, "KasaCikis", "{0:C2}"); colBakiye.DataBindings.Add("Text", this.DataSource, "Bakiye", "{0:C2}"); }
public rptStokDurumu() { InitializeComponent(); IsbaSatisContext context = new IsbaSatisContext(); StokDAL stokDAL = new StokDAL(); ObjectDataSource stokDataSource = new ObjectDataSource { DataSource = stokDAL.StokListele(context) }; this.DataSource = stokDataSource; colStokKodu.DataBindings.Add("Text", this.DataSource, "StokKodu"); colBarkod.DataBindings.Add("Text", this.DataSource, "Barkod"); colStokAdi.DataBindings.Add("Text", this.DataSource, "StokAdi"); colBirimi.DataBindings.Add("Text", this.DataSource, "Birimi"); colStokGrubu.DataBindings.Add("Text", this.DataSource, "Barkod"); colStokAltGrubu.DataBindings.Add("Text", this.DataSource, "StokAltGrubu"); colSatisKdv.DataBindings.Add("Text", this.DataSource, "SatisKdv"); colStokGiris.DataBindings.Add("Text", this.DataSource, "StokGiris"); colStokCikis.DataBindings.Add("Text", this.DataSource, "StokCikis"); colMevcutStok.DataBindings.Add("Text", this.DataSource, "MevcutStokBakiye"); }
public void BarButonOlustur() { _context = new IsbaSatisContext(); foreach (var kod in _context.Kodlar.Where(c => c.Tablo == _table.ToString()).ToList()) { BarButtonItem item = new BarButtonItem { Name = "btnKod" + kod.SonDeger, Tag = kod.Id, Caption = KodOlustur(kod.OnEki, kod.SonDeger), ImageOptions = { Image = Isbasatis.Entities.Properties.Resources.code } }; item.ItemClick += Button_Click; menu.AddItem(item); } BarButtonItem yeniKodEkle = new BarButtonItem { Name = "btnYeniKodEkle", Caption = "Yeni Kod Oluştur", ImageOptions = { Image = Isbasatis.Entities.Properties.Resources.add } }; yeniKodEkle.ItemClick += YeniKodEkle_Click; menu.AddItem(yeniKodEkle).BeginGroup = true; BarButtonItem guncelle = new BarButtonItem { Name = "btnGüncelle", Caption = "Güncelle", ImageOptions = { Image = Isbasatis.Entities.Properties.Resources.refresh } }; guncelle.ItemClick += Guncelle_Click; menu.AddItem(guncelle); DropDownButton buton = (DropDownButton)_form.Controls.Find("btnKod", true).SingleOrDefault(); buton.MenuManager = manager; buton.DropDownControl = menu; }
public rptStokHareketleri(DateTime baslangic, DateTime bitis) { InitializeComponent(); IsbaSatisContext context = new IsbaSatisContext(); StokHareketDAL stokHareketDAL = new StokHareketDAL(); ObjectDataSource dataSource = new ObjectDataSource { DataSource = stokHareketDAL.StokHareketTarihAraligi(context, baslangic, bitis) }; this.DataSource = dataSource; colHareketi.DataBindings.Add("Text", this.DataSource, "Hareket"); colTarih.DataBindings.Add("Text", this.DataSource, "Tarih"); colBarkod.DataBindings.Add("Text", this.DataSource, "Barkod"); colStokAdi.DataBindings.Add("Text", this.DataSource, "StokAdi"); colBirimi.DataBindings.Add("Text", this.DataSource, "Birimi"); colKdv.DataBindings.Add("Text", this.DataSource, "Kdv", "{0:'%'0}"); colMiktar.DataBindings.Add("Text", this.DataSource, "Miktar"); colBirimFiyat.DataBindings.Add("Text", this.DataSource, "BirimFiyati", "{0:C2}"); colIndirimOrani.DataBindings.Add("Text", this.DataSource, "IndirimOrani", "{0:'%'0}"); colIndirimTutar.DataBindings.Add("Text", null, "indirimTutar", "{0:C2}"); colTutar.DataBindings.Add("Text", this.DataSource, "ToplamTutar", "{0:C2}"); lblToplamTutar.DataBindings.Add("Text", this.DataSource, "genelTutar", "{0:C2}"); lblIndirimTutar.DataBindings.Add("Text", null, "stokIndToplam", "{0:C2}"); }
public rptFatura(string fisKodu) { InitializeComponent(); IsbaSatisContext context = new IsbaSatisContext(); StokHareketDAL stokHareketDAL = new StokHareketDAL(); FisDAL fisDAL = new FisDAL(); Fis fisBilgi = fisDAL.GetByFilter(context, c => c.FisKodu == fisKodu); ObjectDataSource stokHareketDatasource = new ObjectDataSource { DataSource = stokHareketDAL.GetAll(context, c => c.FisKodu == fisKodu) }; this.DataSource = stokHareketDatasource; lblCariAdi.Text = fisBilgi.Cari.CariAdi; lblAdres.Text = fisBilgi.Adres; lblIkametgah.Text = fisBilgi.Semt + "\\" + fisBilgi.Ilce + "\\" + fisBilgi.Il; lblFaturaTarihi.Text = fisBilgi.Tarih.ToString(); colStokAdi.DataBindings.Add("Text", this.DataSource, "Stok.StokAdi"); colMiktar.DataBindings.Add("Text", this.DataSource, "Miktar"); colBirimFiyat.DataBindings.Add("Text", this.DataSource, "BirimFiyati"); CalculatedField calcIndirimTutari = new CalculatedField(); this.CalculatedFields.Add(calcIndirimTutari); calcIndirimTutari.Name = "IndirimTutari"; calcIndirimTutari.Expression = "([BirimFiyati] * [Miktar]) / 100 * [IndirimOrani] "; CalculatedField calcKdvToplam = new CalculatedField(); this.CalculatedFields.Add(calcKdvToplam); calcKdvToplam.Name = "KdvTutari"; calcKdvToplam.Expression = "([BirimFiyati] * [Miktar]-[IndirimTutari]) / 100 * [Kdv] "; CalculatedField calcTutar = new CalculatedField(); this.CalculatedFields.Add(calcTutar); calcTutar.Name = "Tutar"; calcTutar.Expression = "([BirimFiyati] * [Miktar]) - [KdvTutari] - [IndirimTutari] "; CalculatedField calcKdvliTutar = new CalculatedField(); this.CalculatedFields.Add(calcKdvliTutar); calcKdvliTutar.Name = "KdvDahil"; calcKdvliTutar.Expression = "([BirimFiyati] * [Miktar]) - [IndirimTutari]"; colToplamTutar.DataBindings.Add("Text", null, "Tutar"); XRSummary sumAraToplam = new XRSummary(); sumAraToplam.Func = SummaryFunc.Sum; sumAraToplam.Running = SummaryRunning.Page; sumAraToplam.FormatString = "{0:C2}"; XRSummary sumKdvToplam = new XRSummary(); sumKdvToplam.Func = SummaryFunc.Sum; sumKdvToplam.Running = SummaryRunning.Page; sumKdvToplam.FormatString = "{0:C2}"; XRSummary sumGenelToplam = new XRSummary(); sumGenelToplam.Func = SummaryFunc.Sum; sumGenelToplam.Running = SummaryRunning.Page; sumGenelToplam.FormatString = "{0:C2}"; lblAraToplam.DataBindings.Add("Text", null, "Tutar", "{0:C2}"); lblKdvToplam.DataBindings.Add("Text", null, "KdvTutari", "{0:C2}"); lblGenelToplam.DataBindings.Add("Text", null, "KdvDahil", "{0:C2}"); lblAraToplam.Summary = sumAraToplam; lblKdvToplam.Summary = sumKdvToplam; lblGenelToplam.Summary = sumGenelToplam; }
public rptBilgiFisi(string fisKodu) { InitializeComponent(); IsbaSatisContext context = new IsbaSatisContext(); StokHareketDAL stokHareketDAL = new StokHareketDAL(); FisDAL fisDAL = new FisDAL(); Fis fisBilgi = fisDAL.GetByFilter(context, c => c.FisKodu == fisKodu); lblFisKodu.Text = "Fiş Kodu : " + fisBilgi.FisKodu; lblTarih.Text = fisBilgi.Tarih.ToString(); ObjectDataSource stokHareketDatasource = new ObjectDataSource { DataSource = stokHareketDAL.GetAll(context, c => c.FisKodu == fisKodu) }; this.DataSource = stokHareketDatasource; CalculatedField calcTutar = new CalculatedField(); this.CalculatedFields.Add(calcTutar); calcTutar.Name = "Tutar"; calcTutar.Expression = "[BirimFiyati] * [Miktar]"; CalculatedField calcIndirimTutari = new CalculatedField(); this.CalculatedFields.Add(calcIndirimTutari); calcIndirimTutari.Name = "IndirimTutari"; calcIndirimTutari.Expression = "([BirimFiyati] * [Miktar]) / 100 * [IndirimOrani] "; CalculatedField calcKdvToplam = new CalculatedField(); this.CalculatedFields.Add(calcKdvToplam); calcKdvToplam.Name = "KdvTutari"; calcKdvToplam.Expression = "([BirimFiyati] * [Miktar]-[IndirimTutari]) / 100 * [Kdv] "; CalculatedField calcKdvsizToplam = new CalculatedField(); this.CalculatedFields.Add(calcKdvsizToplam); calcKdvsizToplam.Name = "AraToplam"; calcKdvsizToplam.Expression = "([BirimFiyati] * [Miktar]) - [KdvTutari] - [IndirimTutari] "; CalculatedField calcKdvliTutar = new CalculatedField(); this.CalculatedFields.Add(calcKdvliTutar); calcKdvliTutar.Name = "KdvDahil"; calcKdvliTutar.Expression = "([BirimFiyati] * [Miktar]) - [IndirimTutari]"; //colToplamTutar.DataBindings.Add("Text", null, "Tutar"); XRSummary sumAraToplam = new XRSummary(); sumAraToplam.Func = SummaryFunc.Sum; sumAraToplam.Running = SummaryRunning.Page; sumAraToplam.FormatString = "{0:C2}"; XRSummary sumIndirimToplam = new XRSummary(); sumIndirimToplam.Func = SummaryFunc.Sum; sumIndirimToplam.Running = SummaryRunning.Page; sumIndirimToplam.FormatString = "{0:C2}"; XRSummary sumKdvToplam = new XRSummary(); sumKdvToplam.Func = SummaryFunc.Sum; sumKdvToplam.Running = SummaryRunning.Page; sumKdvToplam.FormatString = "{0:C2}"; XRSummary sumGenelToplam = new XRSummary(); sumGenelToplam.Func = SummaryFunc.Sum; sumGenelToplam.Running = SummaryRunning.Page; sumGenelToplam.FormatString = "{0:C2}"; lblAraToplam.DataBindings.Add("Text", null, "AraToplam", "{0:C2}"); lblIndirimToplam.DataBindings.Add("Text", null, "IndirimTutari", "{0:C2}"); lblKdvToplam.DataBindings.Add("Text", null, "KdvTutari", "{0:C2}"); lblGenelToplam.DataBindings.Add("Text", null, "KdvDahil", "{0:C2}"); lblAraToplam.Summary = sumAraToplam; lblIndirimToplam.Summary = sumIndirimToplam; lblKdvToplam.Summary = sumKdvToplam; lblGenelToplam.Summary = sumGenelToplam; }