public MainLayoutViewModel()
        {
            using (GastroEntities db = new GastroEntities()){
                AdminKontakte k = (from AdminKontakte ak in db.AdminKontakte where ak.id == 1 select ak).FirstOrDefault();

                AdresseName    = k.AdresseName;
                AdresseStrasse = k.AdresseStrasse;
                AdresseZusatz  = k.AdresseZusatz;
                AdressePlz     = k.AdressePlz;
                AdresseOrt     = k.AdresseOrt;
                AdresseEmail   = k.Email;
                AdresseInhaber = k.AdresseInhaber;

                Telefon     = k.Telefon;
                TelefonCall = "tel:" + k.Telefon.Replace("-", "").Replace("/", "").Replace(" ", "");
                Pinterest   = k.Pinterest;
                Instagramm  = k.Instagramm;
                Youtube     = k.Youtube;
                Snapchat    = k.Snapchat;
                Facebook    = k.Facebook;
                GooglePlus  = k.GooglePlus;

                News     = (from News news in db.News orderby news.Datum descending select news).ToList();
                Umfragen = (from Umfragen u in db.Umfragen where u.DatumStart <DateTime.Now && u.DatumEnde> DateTime.Now select u).ToList();
            }
        }
Exemple #2
0
        public HomeKontakteModel()
        {
            using (GastroEntities db = new GastroEntities())
            {
                Kontakt = (from AdminKontakte a in db.AdminKontakte where a.id == 1 select a).FirstOrDefault();
                int sprachId = CultureHelper.GetCurrentCultureId();


                if (sprachId != 1)
                {
                    var element = (from I18n i18n in db.I18n where i18n.Typ == 9 && i18n.AllergenId == 1 && i18n.SprachId == sprachId select i18n).FirstOrDefault();
                    if (element != null)
                    {
                        Kontakt.Einleitungstext   = element.Ergänzung1;
                        Kontakt.TextFuerNachricht = element.Ergänzung2;
                    }
                    else
                    {
                        Kontakt.Einleitungstext   = "";
                        Kontakt.TextFuerNachricht = "";
                    }
                }
            }
        }