public void GetAll()
{
NetSatisContext context = new NetSatisContext();
StokDal stokDal = new StokDal();
gridControl1.DataSource = stokDal.StokListele(context);
}
public frmGenelIade(DateTime baslangic, DateTime bitis)
{
InitializeComponent();
context = new NetSatisContext();
gridContStokHareket.DataSource = stokHareketDal.GenelIadeListele(context, "Perakende İade Faturası", "Perakende İade İrsaliyesi", baslangic, bitis);
}
private void btnGiris_Click(object sender, EventArgs e)
{
using (var context = new NetSatisContext()) {
context.Database.CreateIfNotExists();
if (!context.Cariler.Any(c => c.CariKodu == "VRS001"))
{
context.Cariler.Add(new Cari {
CariAdi = "Peşin Satış",
CariKodu = "VRS001",
FaturaUnvani = "Peşin Satış",
CariTuru = "Müşteri",
});
context.SaveChanges();
}
}
if (context.Kullanicilar.Any(c => c.KullaniciAdi == txtKullanici.Text && c.Parola == txtParola.Text))
{
girisBasarili = true;
RoleTool.KullaniciEntity =
context.Kullanicilar.SingleOrDefault(c => c.KullaniciAdi == txtKullanici.Text);
this.DialogResult = DialogResult.OK;
this.Close();
}
else
{
MessageBox.Show("Girdiğiniz kullanıcı adı veya parola hatalı.");
txtKullanici.Text = null;
txtParola.Text = null;
}
}
public rptStokDurumu()
{
InitializeComponent();
NetSatisContext context = new NetSatisContext();
StokDAL stokDal = new StokDAL();
ObjectDataSource stokDataSource = new ObjectDataSource {
DataSource = stokDal.StokListele(context)
};
this.DataSource = stokDataSource;
colStokKodu.DataBindings.Add("Text", this.DataSource, "StokKodu");
colStokAdi.DataBindings.Add("Text", this.DataSource, "StokAdi");
colBirim.DataBindings.Add("Text", this.DataSource, "Birim");
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, "MevcutStok");
XRSummary sumStokToplam = new XRSummary();
sumStokToplam.Func = SummaryFunc.Sum;
sumStokToplam.Running = SummaryRunning.Group;
sumStokToplam.FormatString = "{0:N2}";
lblToplamStok.DataBindings.Add("Text", null, "MevcutStok");
lblToplamStok.Summary = sumStokToplam;
}
public rptCariExtresi(int CariID, DateTime baslangic, DateTime bitis)
{
InitializeComponent();
NetSatisContext context = new NetSatisContext();
CariDAL cariDal = new CariDAL();
var cariEntity = cariDal.GetByFilter(context, c => c.Id == CariID);
ObjectDataSource cariEkstreDataSource = new ObjectDataSource {
DataSource = cariDal.CariFisAyrinti(context, CariID, baslangic, bitis)
};
List <GenelToplam> cariBakiyeDataSource = (List <GenelToplam>)cariDal.CariGenelToplam(context, CariID);
this.DataSource = cariEkstreDataSource;
lblCariKodu.DataBindings.Add("Text", cariEntity, "CariKodu");
lblCariAdı.DataBindings.Add("Text", cariEntity, "CariAdi");
colSeri.DataBindings.Add("Text", this.DataSource, "Seri");
colFisTuru.DataBindings.Add("Text", this.DataSource, "FisTuru");
colBelgeNo.DataBindings.Add("Text", this.DataSource, "BelgeNo");
colSira.DataBindings.Add("Text", this.DataSource, "Sira");
colTarih.DataBindings.Add("Text", this.DataSource, "Tarih", "{0:dd.MM.yyyy}");
colVadeTarihi.DataBindings.Add("Text", this.DataSource, "VadeTarihi", "{0:dd.MM.yyyy}");
colToplamTutar.DataBindings.Add("Text", this.DataSource, "ToplamTutar", "{0:C2}");
colOdenen.DataBindings.Add("Text", this.DataSource, "Odenen", "{0:C2}");
colAktif.DataBindings.Add("Text", this.DataSource, "AktifTutar", "{0:C2}");
lblBaslangic.Text = baslangic.ToShortDateString();
lblBitis.Text = bitis.ToShortDateString();
colAlacak.DataBindings.Add("Text", cariBakiyeDataSource[0], "Bilgi");
colAlacakTutar.DataBindings.Add("Text", cariBakiyeDataSource[0], "Tutar", "{0:C2}");
colBorc.DataBindings.Add("Text", cariBakiyeDataSource[1], "Bilgi");
colBorcTutar.DataBindings.Add("Text", cariBakiyeDataSource[1], "Tutar", "{0:C2}");
colBakiye.DataBindings.Add("Text", cariBakiyeDataSource[2], "Bilgi");
colBakiyeTutar.DataBindings.Add("Text", cariBakiyeDataSource[2], "Tutar", "{0:C2}");
}
public frmKullaniciGiris()
{
InitializeComponent();
SqlConnectionStringBuilder conneticiConnectionStringBuilder = new SqlConnectionStringBuilder();
conneticiConnectionStringBuilder.ConnectionString =
SettingsTool.AyarOku(SettingsTool.Ayarlar.DatabaseAyarlar_BaglantiCumlesi);
if (!ConnectionTool.CheckConnetion(conneticiConnectionStringBuilder.ConnectionString))
{
frmBaglantiAyarlari form = new frmBaglantiAyarlari();
form.ShowDialog();
}
context = new NetSatisContext();
KlasoreIzinVer();
checkAnimsa.CheckStateChanged += (s, e) => {
if (checkAnimsa.CheckState == CheckState.Checked)
{
Properties.Settings.Default.Animsa = true;
Properties.Settings.Default.KullaniciAdi = txtKullanici.Text;
Properties.Settings.Default.Parola = txtParola.Text;
Properties.Settings.Default.Save();
}
else
{
Properties.Settings.Default.Animsa = false;
Properties.Settings.Default.KullaniciAdi = null;
Properties.Settings.Default.Parola = null;
Properties.Settings.Default.Save();
}
};
}
public frmGenelSatisRapor(DateTime baslangic, DateTime bitis)
{
InitializeComponent();
context = new NetSatisContext();
gridContStokHareket.DataSource = stokHareketDal.StokSatisListeletTarih(context, "Stok Çıkış", baslangic, bitis);
}
public Form1()
{
using (var context = new NetSatisContext())
{
context.Database.CreateIfNotExists();
}
InitializeComponent();
}
public void KodArttirma(string fis)
{
_context = new NetSatisContext();
var x = _context.Kodlar.SingleOrDefault(c => c.Tablo == fis);
x.SonDeger++;
_context.SaveChanges();
}
public Form1()
{
InitializeComponent();
using (var context = new NetSatisContext())
{
// Veri tabanında database varsa, kurulmaz. Yoksa kurulur.
context.Database.CreateIfNotExists();
}
}
public rptStokHareketleri()
{
InitializeComponent();
NetSatisContext context = new NetSatisContext();
StokHareketDAL stokHareketDal = new StokHareketDAL();
ObjectDataSource datasource = new ObjectDataSource {
DataSource = stokHareketDal.GetAll(context)
};
this.DataSource = datasource;
colFisKodu.DataBindings.Add("Text", this.DataSource, "FisKodu");
//colHareket.DataBindings.Add("Text", this.DataSource, "Hareket");
//colStokKodu.DataBindings.Add("Text", this.DataSource, "StokKodu");
//colStokAdi.DataBindings.Add("Text", this.DataSource, "StokAdi");
colSatisKdv.DataBindings.Add("Text", this.DataSource, "Kdv");
colBirimi.DataBindings.Add("Text", this.DataSource, "Birimi");
colMiktar.DataBindings.Add("Text", this.DataSource, "Miktar");
colBirimFiyat.DataBindings.Add("Text", this.DataSource, "BirimFiyati", "{0:C2}");
colIndirimOrani.DataBindings.Add("Text", this.DataSource, "IndirimOrani");
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]";
colIndirimTutar.DataBindings.Add("Text", null, "IndirimTutar", "{0:C2}");
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.DataBindings.Add("Text", null, "IndirimTutar");
lblToplamTutar.DataBindings.Add("Text", null, "Tutar");
lblIndirimTutar.Summary = sumIndirimTutari;
lblToplamTutar.Summary = sumToplamTutar;
}
public frmGunlukHareketler(NetSatisContext context, System.DateTime dtBaslangic, System.DateTime dtBitis)
{
context = _context;
InitializeComponent();
gridContKasaHareket.DataSource =
kasaDal.OdemeTuruToplamKasaTariheGoreListele(context,
x => x.Tarih >= dtBaslangic && x.Tarih <= dtBitis);
}
public frmStokSec(ref NetSatisContext _context, bool cokluSecim = false)
{
InitializeComponent();
this.context = _context;
if (cokluSecim)
{
lblUyari.Visible = true;
gridStoklar.OptionsSelection.MultiSelect = true;
}
}
protected override bool IsValid(PropertyValidatorContext context)
{
var dataId = context.Instance.GetType().GetProperty("Id").GetValue(context.Instance);
using (var netSatisContext = new NetSatisContext())
{
var result = netSatisContext.Set <TEntity>().Where($"{context.PropertyName}==@0 And Id!=@1", context.PropertyValue, dataId).Any();
return(!result);
}
}
private void btnKaydet_Click(object sender, EventArgs e)
{
NetSatisContext context = new NetSatisContext();
StokDal stokDal = new StokDal();
if (stokDal.AddorUpdate(context, _entity))
{
stokDal.Save(context);
saved = true;
this.Close();
}
}
public static void RolleriYukle(XtraForm form)
{
NetSatisContext context = new NetSatisContext();
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 void btnSil_Click(object sender, EventArgs e)
{
NetSatisContext context = new NetSatisContext();
StokDal stokDal = new StokDal();
if (MessageBox.Show("Seçili olan veriyi silmek istediğinize emin misiniz?", "UYARI", MessageBoxButtons.YesNo) == DialogResult.Yes)
{
secilen = gridView1.GetFocusedRowCellValue(colStokKodu).ToString();
stokDal.Delete(context, c => c.StokKodu == secilen);
stokDal.Save(context);
GetAll();
}
}
public frmStokSec(ref NetSatisContext _context, string aramaMetni, bool useRef = true)
{
InitializeComponent();
if (useRef)
{
this.context = _context;
}
else
{
this.context = new NetSatisContext();
}
txtAramaMetni.Text = aramaMetni;
}
private void btnDuzenle_Click(object sender, EventArgs e)
{
NetSatisContext context = new NetSatisContext();
StokDal stokDal = new StokDal();
secilen = gridView1.GetFocusedRowCellValue(colStokKodu).ToString();
FrmStokIslem form = new FrmStokIslem(stokDal.GetByFilter(context, c => c.StokKodu == secilen));
form.ShowDialog();
if (form.saved)
{
GetAll();
}
}
public static void RolleriYukle(RibbonControl form)
{
try
{
NetSatisContext context = new NetSatisContext();
foreach (var item in context.KullaniciRolleri.Where(c => c.KullaniciAdi == KullaniciEntity.KullaniciAdi && c.FormAdi == "fmrAnaMenu" || c.FormAdi == "frmFrontOffice" && c.Yetki == false).ToList())
{
form.Items.SingleOrDefault(c => c.Name == item.KontrolAdi).Enabled = false;
}
}
catch (Exception)
{
}
}
private void Form1_Load(object sender, EventArgs e)
{
var context = new NetSatisContext();
var cariDal = new CariDAL();
var entity = new Entities.Tables.Cari
{
CariKodu = "123456789",
CariAdi = "Can Özaytekin",
YetkiliKisi = "Can",
FaturaUnvani = "Özaytekin"
};
cariDal.AddOrUpdate(context, entity);
cariDal.Save(context);
}
public void TestMethod1()
{
var context = new NetSatisContext();
var stokDal = new StokDAL();
var stok = stokDal.GetAll(context, x => x.StokHareket.Count > 5 && x.StokHareket.Any(c => c.SatisFiyati > 0 && (c.Hareket == "Stok Çıkış" && c.FisTuru != "Perakende Fatura") ||
(c.FisTuru == "Satış İrsaliyesi" && c.StokIrsaliye == "1"))).FirstOrDefault();
var res = stok.StokHareket.ToList();
var sonuc = res.Count() / res.Sum(c => c.SatisFiyati);
Console.WriteLine(stok.StokAdi + " için Stok çıkış ortalama fiyat hesaplama");
Console.WriteLine("Adet=>" + stok.StokHareket.Count);
Console.WriteLine("Satış fiyatı=>" + res.Sum(c => c.SatisFiyati));
Console.WriteLine("Sonuç=>" + sonuc);
Assert.IsTrue(res.Count() > 0);
Assert.IsTrue(res.Sum(c => c.SatisFiyati) > 0);
}
public rptCariBakiye()
{
InitializeComponent();
NetSatisContext context = new NetSatisContext();
CariDAL cariDal = new CariDAL();
ObjectDataSource cariBakiyeDataSource = new ObjectDataSource {
DataSource = cariDal.GetCariler(context)
};
this.DataSource = cariBakiyeDataSource;
colCariKodu.DataBindings.Add("Text", this.DataSource, "CariKodu");
colCariAdi.DataBindings.Add("Text", this.DataSource, "CariAdi");
colIl.DataBindings.Add("Text", this.DataSource, "Il");
colIlce.DataBindings.Add("Text", this.DataSource, "Ilce");
colAlacak.DataBindings.Add("Text", this.DataSource, "Alacak");
colBorc.DataBindings.Add("Text", this.DataSource, "Borc");
colDurum.DataBindings.Add("Text", this.DataSource, "HesapBakiye");
CalculatedField calcBakiye = new CalculatedField();
this.CalculatedFields.Add(calcBakiye);
calcBakiye.Name = "Bakiye";
calcBakiye.Expression = "[Alacak]-[Borc]";
colBakiye.DataBindings.Add("Text", null, "Bakiye", "{0:C2}");
XRSummary sumToplamTutar = new XRSummary();
sumToplamTutar.Func = SummaryFunc.Sum;
sumToplamTutar.Running = SummaryRunning.Group;
sumToplamTutar.FormatString = "{0:C2}";
#region Güncellenen Alan
CalculatedField calcBorcAlacak = new CalculatedField();
this.CalculatedFields.Add(calcBorcAlacak);
calcBorcAlacak.Name = "SonDurum";
//calcBorcAlacak.Expression = "Iif([lblGenelToplam] >= 0, 'Alacak Var', 'Borç Var')";
calcBorcAlacak.Expression = "Iif([lblGenelToplam] > 0, 'Alacak Var', 'Borç Var')";
#endregion
lblGenelToplam.DataBindings.Add("Text", null, "Bakiye");
lblGenelToplam.Summary = sumToplamTutar;
lblDurum.DataBindings.Add("Text", null, "SonDurum");
}
public void EnvanterHazirla()
{
NetSatisContext context = new NetSatisContext();
StokHareketDAL stokHareketDal = new StokHareketDAL();
DataSet gelen = stokHareketDal.StokEnvanterListele(context);
using (OpenFileDialog OFD = new OpenFileDialog())
{
if (OFD.ShowDialog() == DialogResult.OK)
{
rptStokEnvanter rpt = new rptStokEnvanter();
rpt.LoadLayout(OFD.FileName);
rpt.DataSource = gelen;
rpt.DataMember = "EnvanterBilgileri";
rpt.ShowPreview();
}
}
}
public rptKasa(int KasaID, DateTime baslangic, DateTime bitis)
{
InitializeComponent();
NetSatisContext context = new NetSatisContext();
KasaHareketDAL kasatDal = new KasaHareketDAL();
var kasaEntity = kasatDal.GetByFilter(context, c => c.Id == KasaID);
ObjectDataSource kasaHareketDataSource = new ObjectDataSource {
DataSource = kasatDal.kasaHareket(context, KasaID, baslangic, bitis)
};
this.DataSource = kasaHareketDataSource;
colOdemeTuru.DataBindings.Add("Text", this.DataSource, "OdemeTuru.OdemeTuruAdi");
colKasaAdi.DataBindings.Add("Text", this.DataSource, "Kasa.KasaAdi");
colTipi.DataBindings.Add("Text", this.DataSource, "Hareket");
colTarih.DataBindings.Add("Text", this.DataSource, "Tarih", "{0:dd.MM.yyyy}");
colTutar.DataBindings.Add("Text", this.DataSource, "Tutar");
colAciklama.DataBindings.Add("Text", this.DataSource, "Aciklama");
}
private static StokHareket StokToStokHareket(NetSatisContext context, Entities.Tables.Stok entity, decimal miktar)
{
StokHareket stokHareket = new StokHareket();
IndirimDal indirimDal = new IndirimDal();
stokHareket.StokId = entity.Id;
stokHareket.IndirimOrani = indirimDal.StokIndirimi(context, entity.StokKodu);
//stokHareket.BirimFiyati = txtFisTuru.Text == "Alış Faturası" ? entity.AlisFiyati1 : entity.SatisFiyati1;
stokHareket.Miktar = miktar;
stokHareket.Tarih = DateTime.Now;
stokHareket.Kdv = entity.SatisKdv;
return(stokHareket);
}
private void btnKopyala_Click(object sender, EventArgs e)
{
NetSatisContext context = new NetSatisContext();
StokDal stokDal = new StokDal();
secilen = gridView1.GetFocusedRowCellValue(colStokKodu).ToString();
Entities.Tables.Stok stokEntity = new Entities.Tables.Stok();
stokEntity = stokDal.GetByFilter(context, c => c.StokKodu == secilen);
stokEntity.Id = -1;
stokEntity.StokKodu = null;
FrmStokIslem form = new FrmStokIslem(stokEntity);
form.ShowDialog();
if (form.saved)
{
GetAll();
}
}
public rptStokDurumu()
{
InitializeComponent();
NetSatisContext context = new NetSatisContext();
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, "StokGrubu");
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, "MevcutStok");
}
private void Listele()
{
context = new NetSatisContext();
gridContFisler.DataSource = fisDal.Listelemeler(context, "Satış İrsaliyesi");
}
private void Listele()
{
context = new NetSatisContext();
gridContFisler.DataSource = fisDal.Listelemeler(context, "Verilen Sipariş Fişi");
}
