예제 #1
0
        public static cinema_dbEntities cinema_DbEntities()
        {
            cinema_dbEntities output = null;

            var data = new ObjectData();

            GetSimpleContacts().ForEach(x => data.Table <contact_info>().Add(x));
            GetSimpleUserStatuses().ForEach(x => data.Table <user_status>().Add(x));
            GetSimpleUsers().ForEach(x => data.Table <user>().Add(x));
            GetSimpleUserTypes().ForEach(x => data.Table <user_type>().Add(x));
            GetSimpleType().ForEach(x => data.Table <type_film>().Add(x));
            GetSimpleFilms().ForEach(x => data.Table <film>().Add(x));
            GetSimpleCinemas().ForEach(x => data.Table <cinema>().Add(x));
            GetSimpleSalleStatus().ForEach(x => data.Table <salle_status>().Add(x));
            GetSimpleSalles().ForEach(x => data.Table <salle>().Add(x));
            GetSimpleSeances().ForEach(x => data.Table <seance>().Add(x));

            try
            {
                var connection = EntityConnectionFactory.CreateTransient("name=cinema_dbEntities", new ObjectDataLoader(data));
                output = new cinema_dbEntities(connection, false);
                return(output);
            }
            catch (Exception e)
            {
                Console.WriteLine(e.Message);
                return(output);
            }
        }
예제 #2
0
 public ManagerSeance(cinema_dbEntities cinema_DbEntities)
 {
     try
     {
         db = cinema_DbEntities;
     }
     catch (Exception e)
     {
         throw e;
     }
 }
예제 #3
0
 public ManagerSeance()
 {
     try
     {
         db = new cinema_dbEntities();
     }
     catch (Exception e)
     {
         throw e;
     }
 }
예제 #4
0
        private Dictionary <seance, List <seance> > PostManySeance(List <seance> seances, List <programmation> progs, ref List <int> ids)
        {
            //cinema_dbEntities localdb = new cinema_dbEntities();
            Dictionary <seance, List <seance> > conflict = new Dictionary <seance, List <seance> >();

            using (cinema_dbEntities localdb = new cinema_dbEntities())
            {
                foreach (var item in seances)
                {
                    try
                    {
                        List <seance> ConflictingSeances = ValidatorSeance.IsSeanceConflict(item, this.GetAllSeanceFromSalle(item.salle_id, null));
                        if (ValidatorSeance.IsValide(item) && ConflictingSeances.Count == 0 && !ValidatorSeance.IsSeanceExiste(item, this.GetAllSeanceFromSalle(item.salle_id, null)))
                        {
                            localdb.seances.Add(item);
                        }
                        else if (ConflictingSeances.Count != 0)
                        {
                            throw new ConflictiongSeanceException(ConflictingSeances);
                        }
                        else if (ValidatorSeance.IsSeanceExiste(item, this.GetAllSeanceFromSalle(item.salle_id, null)))
                        {
                            throw new ExistingItemException("seance");
                        }
                        else
                        {
                            throw new InvalidItemException("seance");
                        }
                    }
                    catch (ConflictiongSeanceException e)
                    {
                        conflict[item] = (List <seance>)e.Data[0];
                    }
                }
                localdb.SaveChanges();
            }

            foreach (var item in seances)
            {
                ids.Add(db.seances.Where(s => s.date_debut == item.date_debut && s.date_fin == item.date_fin && s.salle_id == item.salle_id).ToList()[0].id);
            }
            return(conflict);
        }
예제 #5
0
 public ManagerSalle(cinema_dbEntities cinema_Db)
 {
     db = cinema_Db;
 }
예제 #6
0
 public ManagerSalle()
 {
     db = new cinema_dbEntities();
 }
 public void Initialize()
 {
     _context = MockDB.cinema_DbEntities();
 }
예제 #8
0
 public ManagerProgrammation(cinema_dbEntities cinema_DbEntities)
 {
     db = cinema_DbEntities;
 }
예제 #9
0
 public ManagerProgrammation()
 {
     db = new cinema_dbEntities();
 }
예제 #10
0
 public ManagerCinema(cinema_dbEntities cinema_DbEntities)
 {
     db = cinema_DbEntities;
 }
예제 #11
0
 public ManagerCinema()
 {
     db = new cinema_dbEntities();
 }
 public ManagerTypeFilm(cinema_dbEntities dbEntities)
 {
     db = dbEntities;
 }
 public ManagerTypeFilm()
 {
     db = new cinema_dbEntities();
 }