protected override void Seed(HomeCinemaContext context) { // create genres context.GenreSet.AddOrUpdate(g => g.Name, GenerateGenres()); // create movies context.MovieSet.AddOrUpdate(m => m.Title, GenerateMovies()); // create stocks context.StockSet.AddOrUpdate(GenerateStocks()); // create customers context.CustomerSet.AddOrUpdate(GenerateCustomers()); // create roles context.RoleSet.AddOrUpdate(r => r.Name, GenerateRoles()); // username: erick, password: erick context.UserSet.AddOrUpdate(u => u.Email, new User[] { new User() { Email = "*****@*****.**", Username = "******", HashedPassword = "******", Salt = "mNKLRbEFCH8y1xIyTXP4qA==", IsLocked = false, DateCreated = DateTime.Now } }); // Create user-admin context.UserRoleSet.AddOrUpdate(new UserRole[] { new UserRole() { RoleId = 1, UserId = 1 } }); }
protected override void DisposeCore() { if (m_dbContext != null) { m_dbContext.Dispose(); m_dbContext = null; } }
// class using Dispose for db after done the job . public void Dispose() { if (db != null) { db.Dispose(); db = null; } }
public MembershipService (HomeCinemaContext dbContext, IEncryptionService encryptionService, IUserRepository userRepository, IUserRoleRepository userRoleRepository, IRoleRepository roleRepository) { _dbContext = dbContext; _userRepository = userRepository; _encryptionService = encryptionService; _userRoleRepository = userRoleRepository; _roleRepository = roleRepository; }
//ctor. public TimeScreeningData() { db = new HomeCinemaContext(); ShowsTime = db.MovieShowTimes.ToList(); HomeCinemas = db.HomeCinemas.ToList(); Theatres = db.Theaters.ToList(); Movies = db.Movies.ToList(); TimeScreening = db.TimeScreening.ToList(); }
public StockWarning(HomeCinemaContext dbContext) { _dbContext = dbContext; googleSmtpClient.Host = "smtp.gmail.com"; //Or Your SMTP Server Address googleSmtpClient.Credentials = new System.Net.NetworkCredential ("*****@*****.**", "stockwarning"); // ***use valid credentials*** googleSmtpClient.Port = 587; //Or your Smtp Email ID and Password googleSmtpClient.EnableSsl = true; sendList(outOfStock()); }
public static List<string> GetChairNumbers(int[] chirsOrderdID,ICollection<ChairsOrderd> ChairsOrder ) { HomeCinemaContext db = new HomeCinemaContext(); List<string> ChairsNumber = new List<string>(); for (int i = 0; i < chirsOrderdID.Length; i++) { var row = db.Rows.Find(ChairsOrder.Where(x => chirsOrderdID[i] == x.ChairsOrderdiD).First().HallChairs.RowID); ChairsNumber.Add(string.Format(row.RowNumber.ToString() +":"+ChairsOrder.Where(x => chirsOrderdID[i] == x.ChairsOrderdiD).First().HallChairs.ChairNumber.ToString())); } return ChairsNumber; }
static void Main(string[] args) { HomeCinemaContext context = new HomeCinemaContext(); //var movies = _moviesRepository.GetAll().ToList(); StockWarning s = new StockWarning(context); s.outOfStock(); //googleSmtpClient.Host = "smtp.gmail.com"; //Or Your SMTP Server Address //googleSmtpClient.Credentials = new System.Net.NetworkCredential // ("*****@*****.**", "stockwarning"); // ***use valid credentials*** //googleSmtpClient.Port = 587; ////Or your Smtp Email ID and Password //googleSmtpClient.EnableSsl = true; }
public static bool CheckIfTheContractExist(int TheatresID,int MovieShowTimeID) { HomeCinemaContext db = new HomeCinemaContext(); //false == contact Not Exist. bool Checked = false; var Contracts = db.TimeScreening.Where(contract => contract.MovieTheatersID == TheatresID).ToList(); var time = db.MovieShowTimes.Find(MovieShowTimeID).ShowTime; foreach (var contract in Contracts) { Checked = (contract.MovieShowTime.ShowTime == time && contract.MovieTheatersID == TheatresID) ? true : false; if (Checked == true) //true == contact Exist and he need to pick another time OR theatres. break; } return Checked; }
public TheatersChairs(int? _showTimeID, int? _theatresID, int? timescreenID) { db= new HomeCinemaContext(); movieID = (from movid in db.Movies where movid.MovieID == (from mst in db.MovieShowTimes where mst.MovieShowTimeID == _showTimeID select mst).FirstOrDefault().MovieID select movid).SingleOrDefault().MovieID; theaters = (from mt in db.Theaters where mt.MovieTheatersID == _theatresID select mt).SingleOrDefault(); theaters.HomeCinema = db.HomeCinemas.Find(theaters.HomeCinemaID); timeScreening = db.TimeScreening.Find(timescreenID); rows = (from rws in db.Rows where rws.TheatersID == theaters.MovieTheatersID select rws).ToList(); hallChairs = new List<HallChairs>(); //adding hallChairs item's foreach (var rowItem in rows) { List<HallChairs> hallChairCollection = new List<Models.HallChairs>(); hallChairCollection = (from hc in db.HallChairs where hc.RowID == rowItem.RowsID select hc).ToList(); foreach (var hallchairItem in hallChairCollection) { hallChairs.Add(hallchairItem); } } }
public BaseApiController(HomeCinemaContext dbContext, IErrorRepository errorRepository) { this._dbContext = dbContext; this._errorRepository = errorRepository; }
public HomeCinemaContext Init() { return(dbContext ?? (dbContext = new HomeCinemaContext())); }
public RoleRepository(HomeCinemaContext dbContext) : base(dbContext) { }
public GenreController(HomeCinemaContext dbContext, IErrorRepository errorRepository, IGenreRepository genreRepository) : base(dbContext, errorRepository) { _genreRepository = genreRepository; }
public void RemoveItem(string removeCartId, int removeProdId) { try { using (var db = new HomeCinemaContext()) { // i need here to select the item and the movieId then i can remove cart var myItem = (from c in db.Orders where c.CartId == removeCartId select c).FirstOrDefault(); if (myItem != null) { // remove from DB db.Orders.Remove(myItem); db.SaveChanges(); } } } catch (Exception ex) { throw new Exception("Error: unable to Remove item " + ex.Message); } }
public ErrorRepository(HomeCinemaContext dbContext) : base(dbContext) { }
public HomeCinemaContext Init() { return dbContext ?? (dbContext = new HomeCinemaContext()); }
//ctor(terms) public TimeScreeningData(int? TimeScreenID,string termMovie = null , string termHomeCinema = null) { db = new HomeCinemaContext(); ShowsTime = new List<MovieShowTime>(); Theatres = new List<MovieTheaters>(); HomeCinemas = new List<HomeCinema>(); Movies = new List<Movie>(); TimeScreening = new List<TimeScreening>(); if (!string.IsNullOrEmpty(termMovie)&&!string.IsNullOrEmpty(termHomeCinema)) { Movies = db.Movies.Where(m => m.MovieName.Contains(termMovie)).GroupBy(n => n.MovieName).SelectMany(na => na).ToList(); HomeCinemas = db.HomeCinemas.Where(x => x.CinemaName.Contains(termHomeCinema)).GroupBy(na => na.CinemaName).SelectMany(na => na).ToList(); foreach (var movie in Movies) { ShowsTime.AddRange(db.MovieShowTimes.Where(t => t.MovieID == movie.MovieID).ToList()); } foreach (var homeCinema in HomeCinemas) { Theatres.AddRange(db.Theaters.Where(x => x.HomeCinemaID == homeCinema.HomeCinemaID).GroupBy(x => x.TheatersName).SelectMany(n => n).ToList()); } foreach (var showtime in ShowsTime) { foreach (var theater in Theatres) { TimeScreening.AddRange(db.TimeScreening.Where(x => x.MovieTheatersID == theater.MovieTheatersID && x.MovieShowTimeID == showtime.MovieShowTimeID).GroupBy(x => x.TimeScreeningID).SelectMany(x => x).ToList()); } } } else if (!string.IsNullOrEmpty(termMovie)) { Movies = db.Movies.Where(m => m.MovieName.Contains(termMovie)).GroupBy(n => n.MovieName).SelectMany(na => na).ToList(); foreach (var movie in Movies) { ShowsTime.AddRange(db.MovieShowTimes.Where(t => t.MovieID == movie.MovieID).ToList()); } foreach (var ShowTime in ShowsTime) { TimeScreening.AddRange(db.TimeScreening.Where(x=>x.MovieShowTimeID==ShowTime.MovieShowTimeID).GroupBy(n=>n.MovieShowTimeID).SelectMany(na=>na).ToList()); } foreach (var timeScreen in TimeScreening) { Theatres.AddRange(db.Theaters.Where(t => t.MovieTheatersID == timeScreen.MovieTheatersID).GroupBy(x=>x.MovieTheatersID).SelectMany(n=>n).ToList()); } foreach (var theatres in Theatres) { HomeCinemas.AddRange(db.HomeCinemas.Where(h => h.HomeCinemaID == theatres.HomeCinemaID).GroupBy(x => x.CinemaName).SelectMany(na => na).ToList()); } } else if (!string.IsNullOrEmpty(termHomeCinema)) { HomeCinemas = db.HomeCinemas.Where(x => x.CinemaName.Contains(termHomeCinema)).GroupBy(na=>na.CinemaName).SelectMany(na=>na).ToList(); foreach (var homeCinema in HomeCinemas) { Theatres.AddRange(db.Theaters.Where(x => x.HomeCinemaID == homeCinema.HomeCinemaID).GroupBy(x=>x.TheatersName).SelectMany(n=>n).ToList()); } foreach (var thea in Theatres) { TimeScreening.AddRange(db.TimeScreening.Where(x => x.MovieTheatersID == thea.MovieTheatersID).GroupBy(x=>x.Price).SelectMany(x=>x).ToList()); } foreach (var timescreen in TimeScreening) { ShowsTime.AddRange(db.MovieShowTimes.Where(x => x.MovieShowTimeID == timescreen.MovieShowTimeID).GroupBy(x=>x.ShowTime).SelectMany(x=>x).ToList()); } foreach (var showtime in ShowsTime) { Movies.AddRange(db.Movies.Where(m => m.MovieID == showtime.MovieID).GroupBy(x=>x.MovieName).SelectMany(x=>x).ToList()); } } else if (TimeScreenID.HasValue) { TimeScreening.Add(db.TimeScreening.Find((int)TimeScreenID)); foreach (var tmeScreening in TimeScreening) { ShowsTime.Add(tmeScreening.MovieShowTime); Theatres.Add(tmeScreening.MovieTheaters); HomeCinemas.Add(tmeScreening.MovieTheaters.HomeCinema); Movies.Add(tmeScreening.MovieShowTime.Movie); } } else { ShowsTime = db.MovieShowTimes.ToList(); HomeCinemas = db.HomeCinemas.ToList(); Theatres = db.Theaters.ToList(); Movies = db.Movies.ToList(); TimeScreening = db.TimeScreening.ToList(); } }
public BaseRepository(HomeCinemaContext dbContext) { this.dbContext = dbContext; }
public MoviesController(HomeCinemaContext dbContext, IErrorRepository errorRepository, IMovieRepository movieRepository) : base(dbContext, errorRepository) { _movieRepository = movieRepository; }
//ctor. public TheatersChairs() { db = new HomeCinemaContext(); }
public HomeCinemaContext Init() { return (this.dbContext ?? (this.dbContext = new HomeCinemaContext())); }