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); } }
public ManagerSeance(cinema_dbEntities cinema_DbEntities) { try { db = cinema_DbEntities; } catch (Exception e) { throw e; } }
public ManagerSeance() { try { db = new cinema_dbEntities(); } catch (Exception e) { throw e; } }
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); }
public ManagerSalle(cinema_dbEntities cinema_Db) { db = cinema_Db; }
public ManagerSalle() { db = new cinema_dbEntities(); }
public void Initialize() { _context = MockDB.cinema_DbEntities(); }
public ManagerProgrammation(cinema_dbEntities cinema_DbEntities) { db = cinema_DbEntities; }
public ManagerProgrammation() { db = new cinema_dbEntities(); }
public ManagerCinema(cinema_dbEntities cinema_DbEntities) { db = cinema_DbEntities; }
public ManagerCinema() { db = new cinema_dbEntities(); }
public ManagerTypeFilm(cinema_dbEntities dbEntities) { db = dbEntities; }
public ManagerTypeFilm() { db = new cinema_dbEntities(); }