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