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()));
}
