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;
}
