public void SaveFirm(FirmaBilgileri firma)
{
using (AlacaYazilimWebSiteEntities entities = new AlacaYazilimWebSiteEntities())
{
FirmaBilgileri dbFirma = entities.FirmaBilgileri.Add(firma);
dbFirma.Aktif = true;
entities.SaveChanges();
}
}
public void SavePopup(Popup popup)
{
using (AlacaYazilimWebSiteEntities entities = new AlacaYazilimWebSiteEntities())
{
popup.CreateDate = DateTime.Now;
popup.Aktif = true;
entities.Popup.Add(popup);
entities.SaveChanges();
}
}
public void DeletePopup(int popupId)
{
using (AlacaYazilimWebSiteEntities entities = new AlacaYazilimWebSiteEntities())
{
Popup dbPopup = entities.Popup.FirstOrDefault(f => f.PopupId == popupId);
entities.Popup.Remove(dbPopup);
entities.SaveChanges();
}
}
public void DeleteReference(int referenceId)
{
using (AlacaYazilimWebSiteEntities entities = new AlacaYazilimWebSiteEntities())
{
Referans dbReference = entities.Referans.FirstOrDefault(f => f.ReferansId == referenceId);
entities.Referans.Remove(dbReference);
entities.SaveChanges();
}
}
public void SaveProduct(Urun urun)
{
using (AlacaYazilimWebSiteEntities entities = new AlacaYazilimWebSiteEntities())
{
urun.CreateDate = DateTime.Now;
urun.Aktif = true;
entities.Urun.Add(urun);
entities.SaveChanges();
}
}
public void SaveUser(Kullanicilar user)
{
using (AlacaYazilimWebSiteEntities entities = new AlacaYazilimWebSiteEntities())
{
user.CreateDate = DateTime.Now;
user.Aktif = true;
entities.Kullanicilar.Add(user);
entities.SaveChanges();
}
}
public void DeleteCustomerWriting(int customerWritingId)
{
using (AlacaYazilimWebSiteEntities entities = new AlacaYazilimWebSiteEntities())
{
MusteriYazi dbCustomerWriting = entities.MusteriYazi.FirstOrDefault(f => f.MusteriYaziId == customerWritingId);
entities.MusteriYazi.Remove(dbCustomerWriting);
entities.SaveChanges();
}
}
public void DeleteFirm(int firmaId)
{
using (AlacaYazilimWebSiteEntities entities = new AlacaYazilimWebSiteEntities())
{
FirmaBilgileri dbFirma = entities.FirmaBilgileri.FirstOrDefault(f => f.Id == firmaId);
entities.FirmaBilgileri.Remove(dbFirma);
entities.SaveChanges();
}
}
public void SaveNews(DuyuruHaber news)
{
using (AlacaYazilimWebSiteEntities entities = new AlacaYazilimWebSiteEntities())
{
news.CreateDate = DateTime.Now;
news.Aktif = true;
entities.DuyuruHaber.Add(news);
entities.SaveChanges();
}
}
public void SaveReference(Referans reference)
{
using (AlacaYazilimWebSiteEntities entities = new AlacaYazilimWebSiteEntities())
{
reference.CreateDate = DateTime.Now;
reference.Aktif = true;
entities.Referans.Add(reference);
entities.SaveChanges();
}
}
public void DeleteProduct(int urunId)
{
using (AlacaYazilimWebSiteEntities entities = new AlacaYazilimWebSiteEntities())
{
Urun dbUrun = entities.Urun.FirstOrDefault(f => f.UrunId == urunId);
entities.Urun.Remove(dbUrun);
entities.SaveChanges();
}
}
public void DeleteDownloadLink(int downloadLinkId)
{
using (AlacaYazilimWebSiteEntities entities = new AlacaYazilimWebSiteEntities())
{
DownloadLink dbKullanici = entities.DownloadLink.FirstOrDefault(f => f.DownloadId == downloadLinkId);
entities.DownloadLink.Remove(dbKullanici);
entities.SaveChanges();
}
}
public void SaveProductGroup(UrunGrup urunGrup)
{
using (AlacaYazilimWebSiteEntities entities = new AlacaYazilimWebSiteEntities())
{
urunGrup.Createdate = DateTime.Now;
urunGrup.Aktif = true;
entities.UrunGrup.Add(urunGrup);
entities.SaveChanges();
}
}
public void SaveDownloadLink(DownloadLink downloadLink)
{
using (AlacaYazilimWebSiteEntities entities = new AlacaYazilimWebSiteEntities())
{
downloadLink.CreateDate = DateTime.Now;
downloadLink.Aktif = 1;
entities.DownloadLink.Add(downloadLink);
entities.SaveChanges();
}
}
public void DeleteProductGroup(int urunGrupId)
{
using (AlacaYazilimWebSiteEntities entities = new AlacaYazilimWebSiteEntities())
{
UrunGrup dburunGrup = entities.UrunGrup.FirstOrDefault(f => f.UrunGrupId == urunGrupId);
entities.UrunGrup.Remove(dburunGrup);
entities.SaveChanges();
}
}
public void DeleteUser(int userId)
{
using (AlacaYazilimWebSiteEntities entities = new AlacaYazilimWebSiteEntities())
{
Kullanicilar dbKullanici = entities.Kullanicilar.FirstOrDefault(f => f.KullaniciId == userId);
entities.Kullanicilar.Remove(dbKullanici);
entities.SaveChanges();
}
}
public void SaveCustomerWriting(MusteriYazi customerWriting)
{
using (AlacaYazilimWebSiteEntities entities = new AlacaYazilimWebSiteEntities())
{
customerWriting.CreateDate = DateTime.Now;
customerWriting.Aktif = true;
entities.MusteriYazi.Add(customerWriting);
entities.SaveChanges();
}
}
public void DeleteNews(int NewsId)
{
using (AlacaYazilimWebSiteEntities entities = new AlacaYazilimWebSiteEntities())
{
DuyuruHaber dbNew = entities.DuyuruHaber.FirstOrDefault(f => f.DuyuruId == NewsId);
entities.DuyuruHaber.Remove(dbNew);
entities.SaveChanges();
}
}
public void UpdateProductGroup(UrunGrup urunGrup)
{
using (AlacaYazilimWebSiteEntities entities = new AlacaYazilimWebSiteEntities())
{
UrunGrup dburunGrup = entities.UrunGrup.FirstOrDefault(f => f.UrunGrupId == urunGrup.UrunGrupId);
dburunGrup.AnaGrupId = urunGrup.AnaGrupId;
dburunGrup.UrunGrupAdi = urunGrup.UrunGrupAdi;
dburunGrup.Aktif = urunGrup.Aktif;
entities.SaveChanges();
}
}
public void UpdatePopup(Popup popup)
{
using (AlacaYazilimWebSiteEntities entities = new AlacaYazilimWebSiteEntities())
{
Popup dbPopup = entities.Popup.FirstOrDefault(f => f.PopupId == popup.PopupId);
dbPopup.Popup1 = popup.Popup1;
dbPopup.Sira = popup.Sira;
dbPopup.Aktif = popup.Aktif;
entities.SaveChanges();
}
}
public void UpdateDownloadLink(DownloadLink downloadLink)
{
using (AlacaYazilimWebSiteEntities entities = new AlacaYazilimWebSiteEntities())
{
DownloadLink dbKullanici = entities.DownloadLink.FirstOrDefault(f => f.DownloadId == downloadLink.DownloadId);
dbKullanici.DownloadAdi = downloadLink.DownloadAdi;
dbKullanici.DownloadUrl = downloadLink.DownloadUrl;
dbKullanici.Aciklama = downloadLink.Aciklama;
dbKullanici.Aktif = downloadLink.Aktif;
entities.SaveChanges();
}
}
public void UpdateUser(Kullanicilar user)
{
using (AlacaYazilimWebSiteEntities entities = new AlacaYazilimWebSiteEntities())
{
Kullanicilar dbKullanici = entities.Kullanicilar.FirstOrDefault(f => f.KullaniciId == user.KullaniciId);
dbKullanici.KullaniciAdi = user.KullaniciAdi;
dbKullanici.Email = user.Email;
dbKullanici.Aciklama = user.Aciklama;
dbKullanici.Sifre = user.Sifre;
dbKullanici.Aktif = user.Aktif;
entities.SaveChanges();
}
}
public void UpdateProduct(Urun urun)
{
using (AlacaYazilimWebSiteEntities entities = new AlacaYazilimWebSiteEntities())
{
Urun dbUrun = entities.Urun.FirstOrDefault(f => f.UrunId == urun.UrunId);
dbUrun.Aciklama = urun.Aciklama;
dbUrun.FKUrunGrupId = urun.FKUrunGrupId;
dbUrun.ListeFiyat = urun.ListeFiyat;
dbUrun.ListeIskontoOran = urun.ListeIskontoOran;
dbUrun.UrunAdi = urun.UrunAdi;
dbUrun.Aktif = urun.Aktif;
entities.SaveChanges();
}
}
public void UpdateFirm(FirmaBilgileri firma)
{
using (AlacaYazilimWebSiteEntities entities = new AlacaYazilimWebSiteEntities())
{
FirmaBilgileri dbFirma = entities.FirmaBilgileri.FirstOrDefault(f => f.Id == firma.Id);
dbFirma.Adres = firma.Adres;
dbFirma.CepTelefon = firma.CepTelefon;
dbFirma.DestekMail = firma.DestekMail;
dbFirma.Fax = firma.Fax;
dbFirma.FirmaAdi = firma.FirmaAdi;
dbFirma.FirmaAdiUzun = firma.FirmaAdiUzun;
dbFirma.IletisimMail = firma.IletisimMail;
dbFirma.SatisMail = firma.SatisMail;
dbFirma.Telefon1 = firma.Telefon1;
dbFirma.Telefon2 = firma.Telefon2;
dbFirma.Aktif = firma.Aktif;
entities.SaveChanges();
}
}
public void UpdateReference(Referans reference)
{
using (AlacaYazilimWebSiteEntities entities = new AlacaYazilimWebSiteEntities())
{
Referans dbReference = entities.Referans.FirstOrDefault(f => f.ReferansId == reference.ReferansId);
dbReference.ReferansFirmaAdi = reference.ReferansFirmaAdi;
if (!string.IsNullOrEmpty(reference.ResimUrl))
{
dbReference.ResimUrl = reference.ResimUrl;
}
dbReference.FirmaUrl = reference.FirmaUrl;
dbReference.Sira = reference.Sira;
dbReference.Aktif = reference.Aktif;
dbReference.ShowInSlider = reference.ShowInSlider;
entities.SaveChanges();
}
}
public void UpdateNews(DuyuruHaber news)
{
using (AlacaYazilimWebSiteEntities entities = new AlacaYazilimWebSiteEntities())
{
DuyuruHaber dbNew = entities.DuyuruHaber.FirstOrDefault(f => f.DuyuruId == news.DuyuruId);
dbNew.DuyuruBaslik = news.DuyuruBaslik;
dbNew.Duyuru = news.Duyuru;
dbNew.DuyuruKisa = news.DuyuruKisa;
if (!string.IsNullOrEmpty(news.ImageUrl))
{
dbNew.ImageUrl = news.ImageUrl;
}
dbNew.Sira = news.Sira;
dbNew.Aktif = news.Aktif;
entities.SaveChanges();
}
}
public void UpdateCustomerWriting(MusteriYazi customerWriting)
{
using (AlacaYazilimWebSiteEntities entities = new AlacaYazilimWebSiteEntities())
{
MusteriYazi dbCustomerWriting = entities.MusteriYazi.FirstOrDefault(f => f.MusteriYaziId == customerWriting.MusteriYaziId);
dbCustomerWriting.Isim = customerWriting.Isim;
dbCustomerWriting.Unvan = customerWriting.Unvan;
dbCustomerWriting.MusteriYazi1 = customerWriting.MusteriYazi1;
if (!string.IsNullOrEmpty(customerWriting.ResimUrl))
{
dbCustomerWriting.ResimUrl = customerWriting.ResimUrl;
}
dbCustomerWriting.Sira = customerWriting.Sira;
dbCustomerWriting.FirmaUrl = customerWriting.FirmaUrl;
dbCustomerWriting.Aktif = customerWriting.Aktif;
entities.SaveChanges();
}
}