Пример #1
0
        public void AddDeveloper(string Developer_Name, string Official_Site, bool Indie)
        {
            var        _context  = new db_MinligareevMAContext();
            Developers developer = new Developers();

            developer.Developer_Name = Developer_Name;
            developer.Official_Site  = Official_Site;
            developer.Indie          = Indie;
            try
            {
                _context.Developers.Add(developer);
                _context.SaveChanges();
            }
            catch (Exception ex)
            {
                MessageBox.Show(ex.ToString(), "Warning");
                Logging(ex.Message, ex.StackTrace);
            }
        }
Пример #2
0
        public List <Developers> GetDevelopersEF()
        {
            List <Developers> Developer = new List <Developers>();

            foreach (var el in _context.Developers)
            {
                Developers d = new Developers();
                d.ID_Developer   = el.ID_Developer;
                d.Developer_Name = el.Developer_Name;
                d.Official_Site  = el.Official_Site;
                d.Indie          = el.Indie;
                Developer.Add(d);
            }
            Developers All = new Developers();

            All.ID_Developer   = -1;
            All.Developer_Name = "All Developers";
            Developer.Insert(0, All);
            return(Developer.ToList());
        }
Пример #3
0
        public List <Developers> GetDevelopersEF_WithoutAll(bool?Active)
        {
            List <Developers> resDeveloper = new List <Developers>();
            var dev = _context.Developers.Where(o => o.ID_Developer >= 0);

            if (Active.HasValue)
            {
                dev = dev.Where(o => o.Indie == Active);
            }
            //if (idGame.HasValue) dev = dev.Where(o => o.Games.Where(q => q.ID_Game == idGame).Count() > 0);
            foreach (var el in dev)
            {
                Developers d = new Developers();
                d.ID_Developer   = el.ID_Developer;
                d.Developer_Name = el.Developer_Name;
                d.Official_Site  = el.Official_Site;
                d.Indie          = el.Indie;
                resDeveloper.Add(d);
            }
            return(resDeveloper.ToList());
        }
Пример #4
0
 public void DeleteDeveloper(int ID)
 {
     try
     {
         foreach (var el in _context.Games)
         {
             if (el.ID_Developer == ID)
             {
                 _context.Games.Remove(el);
             }
         }
         Developers developer = (from d in _context.Developers where d.ID_Developer == ID select d).SingleOrDefault();
         _context.Developers.Remove(developer);
         _context.SaveChanges();
     }
     catch (Exception ex)
     {
         MessageBox.Show(ex.ToString(), "Warning");
         Logging(ex.Message, ex.StackTrace);
     }
 }