public List <Models.Donusum.HareketTipi> HareketTipiListele()
{
using (VTContext db = new VTContext()) {
var list = db.HareketTipi.ToList();
return(list);
}
}
public void DetailsGuncelle(Models.Donusum.Details _details)
{
using (VTContext db = new VTContext()) {
var temp = db.Detail.FirstOrDefault(x => x.MasterId == _details.MasterId && x.TempId == _details.TempId);
if (temp == null)
{
temp = db.Detail.FirstOrDefault(x => x.MasterId == _details.MasterId && x.StokId == _details.StokId);
}
if (temp == null)
{
return;
}
temp.HareketTipi = _details.HareketTipi;
temp.HarTip = _details.HarTip;
temp.Isk1 = _details.Isk1;
temp.Isk2 = _details.Isk2;
temp.Isk3 = _details.Isk3;
temp.IskontoTutar = _details.IskontoTutar;
temp.Kdv = _details.Kdv;
temp.KdvOrani = _details.KdvOrani;
temp.KdvDahilFiyat = _details.KdvDahilFiyat;
temp.MasterId = _details.MasterId;
temp.Matrah = _details.Matrah;
temp.Miktar = _details.Miktar;
temp.MusteriKodu = _details.MusteriKodu;
temp.StokId = _details.StokId;
temp.Tutar = _details.Tutar;
temp.TempId = _details.TempId;
db.SaveChanges();
}
}
public List <Models.LicKeyGenerator> LisansOlustur(Models.LicKeyGenerator lisans)
{
//var request = (HttpWebRequest)WebRequest.Create(url);
//var response = (HttpWebResponse)request.GetResponse();
//var responseString = new StreamReader(response.GetResponseStream()).ReadToEnd();
List <Models.LicKeyGenerator> g = new List <Models.LicKeyGenerator>();
Models.LicKeyGenerator l = new Models.LicKeyGenerator
{
IsActive = lisans.IsActive,
FirmaAdi = lisans.FirmaAdi,
Email = lisans.Email,
Id = Guid.NewGuid(),
LicKey = Guid.NewGuid(),
Telefon = lisans.Telefon,
VDNo = lisans.VDNo,
VergiDairesi = lisans.VergiDairesi
};
g.Add(l);
using (VTContext db = new VTContext())
{
db.LicKeyGenerators.Add(l);
db.SaveChanges();
return(g.ToList());
}
}
public int HareketIdGetir(string Aciklama)
{
using (VTContext db = new VTContext()) {
var list = db.HareketTipi.Where(x => x.Aciklama == Aciklama).FirstOrDefault();
return(list.Id);
}
}
public void DetailsOlustur(Models.Donusum.Details _details)
{
using (VTContext db = new VTContext()) {
db.Detail.Add(_details);
db.SaveChanges();
}
}
public int MasterGuncelle(Models.Donusum.Master _master)
{
string f = _master.FisKodu;
using (VTContext db = new VTContext()) {
var temp = db.Master.FirstOrDefault(x => x.FisKodu == _master.FisKodu);
temp.Aciklama = _master.Aciklama;
temp.AlisVerisNo = _master.AlisVerisNo;
temp.DokumanKodu = _master.DokumanKodu;
temp.EditDate = _master.EditDate;
temp.EditUser = _master.EditUser;
temp.FisKodu = _master.FisKodu;
temp.FisTuru = _master.FisTuru;
temp.HareketTipi = _master.HareketTipi;
temp.HarTip = _master.HarTip;
temp.IslemTarihi = _master.IslemTarihi;
temp.Kdv = _master.Kdv;
temp.MusteriKodu = _master.MusteriKodu;
temp.Matrah = _master.Matrah;
temp.NetTutar = _master.NetTutar;
temp.SaveDate = _master.SaveDate;
temp.SaveUser = _master.SaveUser;
temp.SeriKodu = _master.SeriKodu;
temp.SiraKodu = _master.SiraKodu;
temp.Tutar = _master.Tutar;
temp.VadeTarihi = _master.VadeTarihi;
temp.DipIskonto = _master.DipIskonto;
db.SaveChanges();
}
return(_master.Id);
}
public List <Models.LicKeyGenerator> MusteriListesi()
{
using (VTContext db = new VTContext())
{
var list = db.LicKeyGenerators.ToList();
return(list);
}
}
public void DetailsSil(int id)
{
using (VTContext db = new VTContext()) {
var temp = db.Detail.FirstOrDefault(x => x.Id == id);
db.Detail.Remove(temp);
db.SaveChanges();
}
}
public void HareketTipiSil(int id)
{
using (VTContext db = new VTContext()) {
var list = db.HareketTipi.Where(x => x.Id == id).FirstOrDefault();
db.HareketTipi.Remove(list);
db.SaveChanges();
}
}
public void HareketTipiDuzenle(int id, string Kodu, string Aciklama)
{
using (VTContext db = new VTContext()) {
var list = db.HareketTipi.Where(x => x.Id == id).FirstOrDefault();
list.Kodu = Kodu;
list.Aciklama = Aciklama;
db.SaveChanges();
}
}
public void LisansDevreActive(string VdNo)
{
using (VTContext db = new VTContext())
{
var list = db.LicKeyGenerators.Where(x => x.FirmaAdi == VdNo).FirstOrDefault();
list.IsActive = true;
db.SaveChanges();
}
}
public void HareketTipiOlustur(string Kodu, string Aciklama)
{
using (VTContext db = new VTContext()) {
Models.Donusum.HareketTipi h = new Models.Donusum.HareketTipi {
Aciklama = Aciklama,
Kodu = Kodu
};
db.HareketTipi.Add(h);
db.SaveChanges();
}
}
public int MasterOlustur(Models.Donusum.Master _master)
{
string f = _master.FisKodu;
using (VTContext db = new VTContext()) {
db.Master.Add(_master);
db.SaveChanges();
}
using (VTContext dbs = new VTContext()) {
var list = dbs.Master.Where(x => x.FisKodu == f).FirstOrDefault();
return(list.Id);
}
}
public void MasterSil(int id)
{
using (VTContext db = new VTContext()) {
var temp = db.Master.Where(x => x.AlisVerisNo == id).FirstOrDefault();
if (temp != null)
{
db.Master.Remove(temp);
var detailTemp = db.Detail.Where(x => x.MasterId == temp.Id).ToList();
db.Detail.RemoveRange(detailTemp);
}
db.SaveChanges();
}
}
public bool LisansGenerator(string Key)
{
//FirmaOlustur();
Guid lickey = new Guid(Key);
using (VTContext db = new VTContext())
{
var list = db.LicKeyGenerators.Where(x => x.LicKey == lickey).Where(x => x.IsActive == true).FirstOrDefault();
if (list != null)
{
return(list.IsActive);
}
else
{
return(false);
}
}
}
private InvoiceLineType[] InvoiceLineDoldur(int Master)
{
List <InvoiceLineType> Liste = new List <InvoiceLineType>();
using (VTContext db = new VTContext())
{
var list = db.Detail.Where(x => x.MasterId == Master).ToList();
foreach (var item in list)
{
var veri = db.Database.SqlQuery <Stoklar>("SELECT Id,StokKodu,StokAdi FROM Stoklar where Id='" +
item.StokId + "'").FirstOrDefault();
string _IL_ID = Convert.ToString(item.StokId);
string _IL_StokCode = Convert.ToString(veri.StokKodu);
string _IL_InvoicedQuantity = Convert.ToString(item.Miktar);
string _IL_LineExtensionAmount = "0";
string _IL_TaxAmount = Convert.ToString(item.KdvOrani);
string _IL_TaxableAmount = Convert.ToString(item.Kdv);
string _IL_Percent = "";
string _IL_TaxCategory_Name = "";
string _IL_TaxCategory_TaxTypeCode = "";
string _IL_ItemName = veri.StokAdi;
string _IL_Price = Convert.ToString(item.Tutar);
string _IL_Birim = "C62";
string KdvIstisnasi = "";
string KdvIstisnasiCode = "";
_IL_ID = Convert.ToString(_IL_ID);
_IL_StokCode = Convert.ToString(_IL_StokCode);
_IL_InvoicedQuantity = Convert.ToString(_IL_InvoicedQuantity);
_IL_LineExtensionAmount = Convert.ToString(_IL_LineExtensionAmount);
_IL_TaxAmount = Convert.ToString(_IL_TaxAmount);
_IL_TaxableAmount = Convert.ToString(_IL_TaxableAmount);
_IL_Percent = Convert.ToString(_IL_Percent);
_IL_TaxCategory_Name = Convert.ToString(_IL_TaxCategory_Name);
_IL_TaxCategory_TaxTypeCode = Convert.ToString(_IL_TaxCategory_TaxTypeCode);
_IL_ItemName = Convert.ToString(_IL_ItemName);
_IL_Price = Convert.ToString(_IL_Price);
_IL_Birim = Convert.ToString(_IL_Birim);
KdvIstisnasi = Convert.ToString(KdvIstisnasi);
KdvIstisnasiCode = Convert.ToString(KdvIstisnasiCode);
InvoiceLineType lineItem = new InvoiceLineType()
{
ID = new IDType {
Value = _IL_ID
},
InvoicedQuantity = new InvoicedQuantityType
{
unitCode = _IL_Birim, Value = Math.Round(Convert.ToDecimal(_IL_InvoicedQuantity), 4)
},
LineExtensionAmount = new LineExtensionAmountType
{
currencyID = "TRY", Value = Math.Round(Convert.ToDecimal(_IL_LineExtensionAmount), 4)
},
AllowanceCharge = new AllowanceChargeType[]
{
new AllowanceChargeType()
{
ChargeIndicator = new ChargeIndicatorType {
Value = false
},
MultiplierFactorNumeric = new MultiplierFactorNumericType {
Value = 0.00M
},
Amount = new AmountType2 {
currencyID = "TRY", Value = 0.00M
},
BaseAmount = new BaseAmountType
{
currencyID = "TRY", Value = Math.Round(Convert.ToDecimal(_IL_TaxableAmount), 4)
}
}
},
TaxTotal = new TaxTotalType
{
TaxAmount = new TaxAmountType
{
currencyID = "TRY", Value = Math.Round(Convert.ToDecimal(_IL_TaxAmount), 4)
},
TaxSubtotal = new TaxSubtotalType[]
{
new TaxSubtotalType()
{
TaxableAmount = new TaxableAmountType
{
currencyID = "TRY", Value = Math.Round(Convert.ToDecimal(_IL_TaxableAmount), 4)
},
TaxAmount = new TaxAmountType
{
currencyID = "TRY", Value = Math.Round(Convert.ToDecimal(_IL_TaxAmount), 4)
},
Percent = new PercentType1 {
Value = Math.Round(Convert.ToDecimal(_IL_Percent), 4)
},
TaxCategory = new TaxCategoryType
{
TaxScheme = new TaxSchemeType
{
Name = new NameType1 {
Value = "KDV"
},
TaxTypeCode = new TaxTypeCodeType {
Value = "0015"
}
},
TaxExemptionReasonCode = new TaxExemptionReasonCodeType
{
Value = KdvIstisnasiCode
},
TaxExemptionReason = new TaxExemptionReasonType {
Value = KdvIstisnasi
}
}
}
},
},
Item = new ItemType
{
Name = new NameType1 {
Value = _IL_ItemName
},
SellersItemIdentification = new ItemIdentificationType
{
ID = new IDType {
Value = _IL_StokCode.Replace(" ", "")
}
}
},
Price = new PriceType
{
PriceAmount = new PriceAmountType
{
currencyID = "TRY", Value = Math.Round(Convert.ToDecimal(_IL_Price), 4)
}
}
};
Liste.Add(lineItem);
}
}
return(Liste.ToArray());
}
public Models.Donusum.HareketTipi HareketTipiGetir(int id)
{
using (VTContext db = new VTContext()) {
return(db.HareketTipi.Where(x => x.Id == id).FirstOrDefault());
}
}
private void btnKaydet_Click(object sender, EventArgs e)
{
BaglantiCumleOlustur();
connectionStringBuilder.InitialCatalog = "master";
if (ConnectionTool.CheckConnetion(connectionStringBuilder.ConnectionString))
{
connectionStringBuilder.InitialCatalog = txtDatabase.Text;
MessageBox.Show(
"Seçtiğiniz Server'da belirtilen Database yoksa bu mesajdan sonra oluşturulacak bu işlem biraz uzun sürebilir");
NetSatis.Entities.Tools.SettingsTool.AyarDegistir(NetSatis.Entities.Tools.SettingsTool.Ayarlar.DatabaseAyarlar_BaglantiCumlesi, connectionStringBuilder.ConnectionString);
NetSatis.Entities.Tools.SettingsTool.Save();
using (var context = new NetSatisContext())
{
context.Database.CreateIfNotExists();
if (!context.Kasalar.Any(c => c.KasaKodu == "001"))
{
context.Kasalar.Add(new Kasa
{
KasaAdi = "Kasa1",
KasaKodu = "001",
});
context.SaveChanges();
}
}
using (var context = new NetSatisContext())
{
context.Database.CreateIfNotExists();
if (!context.Depolar.Any(c => c.DepoKodu == "001"))
{
context.Depolar.Add(new Depo
{
DepoAdi = "Merkez Depo",
DepoKodu = "001",
});
context.SaveChanges();
}
}
using (var context = new NetSatisContext())
{
context.Database.CreateIfNotExists();
if (!context.Kullanicilar.Any(c => c.KullaniciAdi == "Yönetici"))
{
context.Kullanicilar.Add(new Kullanici
{
KullaniciAdi = "Yönetici",
Parola = "741852",
HatirlatmaSorusu = "Program Firması",
Cevap = "EMD",
DepoId = 1,
KasaId = 1,
});
context.SaveChanges();
}
}
using (var context = new NetSatisContext())
{
context.Database.CreateIfNotExists();
if (!context.OdemeTurleri.Any(c => c.OdemeTuruKodu == "001"))
{
context.OdemeTurleri.Add(new OdemeTuru
{
OdemeTuruAdi = "Nakit",
OdemeTuruKodu = "001",
});
context.SaveChanges();
}
}
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ış",
});
context.SaveChanges();
}
}
using (var context = new NetSatisContext())
{
context.Database.CreateIfNotExists();
if (!context.OdemeTurleri.Any(c => c.OdemeTuruKodu == "002"))
{
context.OdemeTurleri.Add(new OdemeTuru
{
OdemeTuruAdi = "Kredi Kartı",
OdemeTuruKodu = "002",
});
context.SaveChanges();
}
}
using (var context = new NetSatisContext())
{
context.Database.CreateIfNotExists();
if (!context.OdemeTurleri.Any(c => c.OdemeTuruKodu == "003"))
{
context.OdemeTurleri.Add(new OdemeTuru
{
OdemeTuruAdi = "Evrak",
OdemeTuruKodu = "003"
});
context.SaveChanges();
}
}
using (var donusum = new VTContext())
{
donusum.Database.CreateIfNotExists();
if (!donusum.HareketTipi.Any(c => c.Kodu == "A"))
{
donusum.HareketTipi.Add(new NetSatis.EDonusum.Models.Donusum.HareketTipi
{
Aciklama = "A",
Kodu = "A"
});
donusum.SaveChanges();
}
}
using (var donusum = new VTContext())
{
donusum.Database.CreateIfNotExists();
if (!donusum.HareketTipi.Any(c => c.Kodu == "B"))
{
donusum.HareketTipi.Add(new NetSatis.EDonusum.Models.Donusum.HareketTipi
{
Aciklama = "B",
Kodu = "B"
});
donusum.SaveChanges();
}
}
using (var donusum = new VTContext())
{
donusum.Database.CreateIfNotExists();
if (!donusum.HareketTipi.Any(c => c.Kodu == "-"))
{
donusum.HareketTipi.Add(new NetSatis.EDonusum.Models.Donusum.HareketTipi
{
Aciklama = "-",
Kodu = "-"
});
donusum.SaveChanges();
}
}
using (var context = new NetSatisContext())
{
context.Database.CreateIfNotExists();
if (!context.Kodlar.Any(c => c.Tablo == "Fis"))
{
context.Kodlar.Add(new Kod
{
OnEki = "TSF",
SonDeger = 1,
Tablo = "Fis"
});
context.SaveChanges();
}
}
kaydedildi = true;
this.Close();
}
else
{
MessageBox.Show("Bağlantı Başarısız !");
}
}
