Esempio n. 1
0
        // Eventuellt korta ner koderna
        internal static bool AddCountry(StaffyloContext context, Country country)
        {
            bool countryAdded = false;
            var  countryToAdd = context.Countries.Where(c => c.Code == country.Code).Select(c => c);

            if (countryToAdd == null)
            {
                context.Countries.Add(country);
                context.SaveChanges();
                countryAdded = true;
            }

            return(countryAdded);
        }
Esempio n. 2
0
        internal static bool DeleteCountry(StaffyloContext context, string code)
        {
            bool    countryDeleted  = false;
            Country countryToDelete = context.Countries.Where(c => c.Code == code).FirstOrDefault();

            if (countryToDelete != null)
            {
                context.Remove(countryToDelete);
                context.SaveChanges();
                countryDeleted = true;
            }

            return(countryDeleted);
        }
Esempio n. 3
0
        internal static bool UpdateCountry(StaffyloContext context, Country country)
        {
            bool    countryUpdated  = false;
            Country countryToUpdate = context.Countries.Where(c => c.Code == country.Code).FirstOrDefault();

            if (countryToUpdate != null)
            {
                countryToUpdate.Name = country.Name;
                context.Update(countryToUpdate);
                context.SaveChanges();
                countryUpdated = true;
            }

            return(countryUpdated);
        }
Esempio n. 4
0
 internal static Country ReadDB(StaffyloContext context, string countryCode)
 {
     return(context.Countries.Where(c => c.Code == countryCode).FirstOrDefault());
 }