public List <Referans> GetReferences()
{
using (AlacaYazilimWebSiteEntities entities = new AlacaYazilimWebSiteEntities())
{
List <Referans> referenceDbList = entities.Referans.Where(u => u.Aktif.HasValue && u.Aktif.Value).OrderBy(c => c.ReferansFirmaAdi).ToList();
return(referenceDbList);
}
}
public List <UrunGrup> GetProductGroups()
{
using (AlacaYazilimWebSiteEntities entities = new AlacaYazilimWebSiteEntities())
{
List <UrunGrup> ProductGroupsDbList = entities.UrunGrup.Where(u => u.Aktif.HasValue && u.Aktif.Value).OrderBy(c => c.UrunGrupAdi).ToList();
return(ProductGroupsDbList);
}
}
public List <Popup> GetPopups()
{
using (AlacaYazilimWebSiteEntities entities = new AlacaYazilimWebSiteEntities())
{
List <Popup> popupDbList = entities.Popup.Where(u => u.Aktif.HasValue && u.Aktif.Value).OrderBy(c => c.PopupAd).ToList();
return(popupDbList);
}
}
public List <Referans> GetTopReferences()
{
using (AlacaYazilimWebSiteEntities entities = new AlacaYazilimWebSiteEntities())
{
List <Referans> referenceDbList = entities.Referans.Where(u => u.Aktif.HasValue && u.Aktif.Value && u.ShowInSlider.HasValue).Take(20).ToList();
return(referenceDbList);
}
}
public FirmaBilgileri GetFirstActiveFirm()
{
using (AlacaYazilimWebSiteEntities entities = new AlacaYazilimWebSiteEntities())
{
FirmaBilgileri firm = entities.FirmaBilgileri.FirstOrDefault(u => u.Aktif.HasValue && u.Aktif.Value);
return(firm);
}
}
public List <Kullanicilar> GetUsers()
{
using (AlacaYazilimWebSiteEntities entities = new AlacaYazilimWebSiteEntities())
{
List <Kullanicilar> UserDbList = entities.Kullanicilar.Where(u => u.Aktif.HasValue && u.Aktif.Value).OrderByDescending(c => c.CreateDate).ToList();
return(UserDbList);
}
}
public List <FirmaBilgileri> GetFirms()
{
using (AlacaYazilimWebSiteEntities entities = new AlacaYazilimWebSiteEntities())
{
List <FirmaBilgileri> firmsDbList = entities.FirmaBilgileri.Where(u => u.Aktif.HasValue && u.Aktif.Value).OrderBy(c => c.FirmaAdi).ToList();
return(firmsDbList);
}
}
public List <Urun> GetSubAdditionalProducts(int mainGroupId, int productId)
{
using (AlacaYazilimWebSiteEntities entities = new AlacaYazilimWebSiteEntities())
{
List <Urun> productsDbList = entities.Urun.Where(u => u.Aktif.HasValue && u.Aktif.Value && u.FKUrunGrupId == mainGroupId && u.FKAnaUrunId == productId).OrderBy(c => c.UrunAdi).ToList();
return(productsDbList);
}
}
public List <DuyuruHaber> GetNews()
{
using (AlacaYazilimWebSiteEntities entities = new AlacaYazilimWebSiteEntities())
{
List <DuyuruHaber> newsDbList = entities.DuyuruHaber.Where(u => u.Aktif.HasValue && u.Aktif.Value).OrderByDescending(u => u.CreateDate).ToList();
return(newsDbList);
}
}
public List <MusteriYazi> GetCustomerWritings()
{
using (AlacaYazilimWebSiteEntities entities = new AlacaYazilimWebSiteEntities())
{
List <MusteriYazi> customerWritingDbList = entities.MusteriYazi.Where(u => u.Aktif.HasValue && u.Aktif.Value).OrderBy(c => c.FirmaUrl).ToList();
return(customerWritingDbList);
}
}
public List <Referans> GetSliderReferences()
{
using (AlacaYazilimWebSiteEntities entities = new AlacaYazilimWebSiteEntities())
{
List <Referans> referenceDbList = entities.Referans.Where(u => u.Aktif.HasValue && u.Aktif.Value && u.ShowInSlider.HasValue && u.ShowInSlider.Value && !string.IsNullOrEmpty(u.ResimUrl)).ToList();
return(referenceDbList);
}
}
public DuyuruHaber GetNew(int newsId)
{
using (AlacaYazilimWebSiteEntities entities = new AlacaYazilimWebSiteEntities())
{
DuyuruHaber news = entities.DuyuruHaber.FirstOrDefault(u => u.DuyuruId == newsId);
return(news);
}
}
public List <DownloadLink> GetDownloadLinks()
{
using (AlacaYazilimWebSiteEntities entities = new AlacaYazilimWebSiteEntities())
{
List <DownloadLink> downloadLinkDbList = entities.DownloadLink.Where(u => u.Aktif == 1).OrderBy(c => c.Aciklama).ToList();
return(downloadLinkDbList);
}
}
public void SaveFirm(FirmaBilgileri firma)
{
using (AlacaYazilimWebSiteEntities entities = new AlacaYazilimWebSiteEntities())
{
FirmaBilgileri dbFirma = entities.FirmaBilgileri.Add(firma);
dbFirma.Aktif = true;
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 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 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 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 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 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 SaveReference(Referans reference)
{
using (AlacaYazilimWebSiteEntities entities = new AlacaYazilimWebSiteEntities())
{
reference.CreateDate = DateTime.Now;
reference.Aktif = true;
entities.Referans.Add(reference);
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 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 SaveUser(Kullanicilar user)
{
using (AlacaYazilimWebSiteEntities entities = new AlacaYazilimWebSiteEntities())
{
user.CreateDate = DateTime.Now;
user.Aktif = true;
entities.Kullanicilar.Add(user);
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 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 SaveNews(DuyuruHaber news)
{
using (AlacaYazilimWebSiteEntities entities = new AlacaYazilimWebSiteEntities())
{
news.CreateDate = DateTime.Now;
news.Aktif = true;
entities.DuyuruHaber.Add(news);
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();
}
}
