public string Insert(MovieSchedule movieSchedule)
{
SqlParameter[] parms = new SqlParameter[]
{
new SqlParameter("@id", SqlDbType.NVarChar, 36)
{
Value = movieSchedule.Id
}
, new SqlParameter("@movieId", SqlDbType.NVarChar, 36)
{
Value = movieSchedule.MovieId
}
, new SqlParameter("@scheduleId", SqlDbType.Int)
{
Value = movieSchedule.MovieTypeId
}
};
object id = SqlHelper.ExecuteScalar(
SqlHelper.ConnString
, CommandType.Text
, "INSERT INTO MovieSchedule VALUES(@id)"
, parms);
return(Convert.ToString(id));
}
protected void updatebtn_Click(object sender, EventArgs e)
{
MovieSchedule ms = new MovieSchedule();
ms.Id = Convert.ToInt32(iddropdown.SelectedValue);
Movie m = new Movie();
m = movieschedule_controller.GetMovieId(Moviedropdown.SelectedValue);
ms.MovieId = m.Id;
Theatre t = new Theatre();
t = movieschedule_controller.GetTheatreId(theatredropdown.SelectedValue);
ms.TheatreId = t.Id;
Timing timing = new Timing();
timing = movieschedule_controller.GetTimingId(timingdropdown.SelectedValue);
ms.TimingId = timing.Id;
ms.ScheduleDate = Convert.ToDateTime(scheddatetxt.Text);
movieschedule_controller.UpdateSchedule(ms);
status.Text = " Schedule updated successfully";
}
protected override void Seed(sp18Team7Final.DAL.AppDbContext context)
{
GenreData AddGenres = new GenreData();
AddGenres.SeedGenres(context);
MovieData AddMovies = new MovieData();
AddMovies.SeedMovies(context);
Customers AddCustomers = new Customers();
AddCustomers.SeedCustomers(context);
Employees AddEmployees = new Employees();
AddEmployees.SeedEmployees(context);
MovieSchedule SeedShowtimes = new MovieSchedule();
SeedShowtimes.SeedShowtimes(context);
PricingData SeedPrices = new PricingData();
SeedPrices.SeedPrices(context);
}
protected void createbtn_Click(object sender, EventArgs e)
{
MovieSchedule addschedule = new MovieSchedule();
Movie m = new Movie();
m = movieschedule_controller.GetMovieId(Moviedropdown.SelectedValue);
addschedule.MovieId = m.Id;
Theatre t = new Theatre();
t = movieschedule_controller.GetTheatreId(theatredropdown.SelectedValue);
addschedule.TheatreId = t.Id;
Timing timing = new Timing();
timing = movieschedule_controller.GetTimingId(timingdropdown.SelectedValue);
addschedule.TimingId = timing.Id;
addschedule.ScheduleDate = Convert.ToDateTime(scheddatetxt.Text);
movieschedule_controller.CreateSchedule(addschedule);
MovieSchedule scheduleId = movieschedule_controller.RetrieveLastSchedule();
if (scheduleId != null)
{
bookingController.InseartSeatsForNewSchedule(scheduleId.Id);
}
status.Text = "New Schedule created successfully";
}
public MovieSchedule RetrieveLastSchedule()
{
var q = from x in db.MovieSchedules
select x;
MovieSchedule m = q.ToList().LastOrDefault();
return(m);
}
protected void deletebtn_Click(object sender, EventArgs e)
{
MovieSchedule ms = new MovieSchedule();
ms.Id = Convert.ToInt32(iddropdown.SelectedValue);
movieschedule_controller.DeleteSchedule(ms);
status.Text = "Schedule deleted";
}
public MovieSchedule RetrieveMovieSchedule(int scheduleid)
{
var q = from x in db.MovieSchedules
where x.Id == scheduleid
select x;
MovieSchedule m = q.First();
return(m);
}
public ActionResult ChooseTicket(string filmId, string timeId, string cinemaId, string selectDate)
{
int filmIdData = Convert.ToInt32(filmId);
int timeIdData = Convert.ToInt32(timeId);
int cinemaIdData = Convert.ToInt32(cinemaId);
DateTime scheduleDate = DateTime.Parse(selectDate);
MovieScheduleService msService = new MovieScheduleService();
MovieSchedule schedule = msService.FindMovieSchedule(filmIdData, timeIdData, cinemaIdData, scheduleDate).First();
ViewBag.scheduleId = schedule.scheduleId;
return(View());
}
protected void iddropdown_SelectedIndexChanged(object sender, EventArgs e)
{
int scheduleid = Convert.ToInt32(iddropdown.SelectedValue);
MovieSchedule moviescheduleobj = new MovieSchedule();
moviescheduleobj = movieschedule_controller.RetrieveMovieSchedule(scheduleid);
//movieidtxt.Text = moviescheduleobj.MovieId.ToString();
//theatreidtxt.Text = moviescheduleobj.TheatreId.ToString();
//timingidtxt.Text = moviescheduleobj.TimingId.ToString();
//scheduledatetxt.Text = moviescheduleobj.ScheduleDate.ToString();
}
public void UpdateSchedule(MovieSchedule ms)
{
var q = db.MovieSchedules.FirstOrDefault(x => x.Id == ms.Id);
q.Id = ms.Id;
q.MovieId = ms.MovieId;
q.TheatreId = ms.TheatreId;
q.TimingId = ms.TimingId;
q.ScheduleDate = ms.ScheduleDate;
db.SaveChanges();
}
public void DeleteSchedule(MovieSchedule ms)
{
var query = from x in db.MovieSchedules
where x.Id == ms.Id
select x;
foreach (MovieSchedule movschd in query)
{
db.DeleteObject(movschd);
}
db.SaveChanges();
}
public ActionResult ChooseTicket1(string filmId, string timeId, string cinemaId)
{
int filmIdData = Convert.ToInt32(filmId);
int timeIdData = Convert.ToInt32(timeId);
int cinemaIdData = Convert.ToInt32(cinemaId);
DateTime scheduleDate = DateTime.Parse("2018-06-08");
//DateTime scheduleDate = DateTime.Today;
MovieScheduleService msService = new MovieScheduleService();
MovieSchedule schedule = msService.FindMovieSchedule(filmIdData, timeIdData, cinemaIdData, scheduleDate).First();
ViewBag.scheduleId = schedule.scheduleId;
return(View("~/Views/Home/ChooseTicket.cshtml"));
}
public ActionResult ChooseTicketAndSeatToday(string filmId, string timeId, string cinemaId)
{
int filmIdData = Convert.ToInt32(filmId);
int timeIdData = Convert.ToInt32(timeId);
int cinemaIdData = Convert.ToInt32(cinemaId);
string startTime = new ShowTimeService().FindByID(timeIdData).startTime;
DateTime today = DateTime.Today;
string dateInput = today.Year + "-" + today.Month + "-" + today.Day + " " + startTime;//21:30
DateTime scheduleDate = DateTime.Parse(dateInput);
MovieScheduleService msService = new MovieScheduleService();
MovieSchedule schedule = msService.FindMovieSchedule(filmIdData, timeIdData, cinemaIdData, scheduleDate).First();
ViewBag.scheduleId = schedule.scheduleId;
return(View("~/Views/Home/ChooseTicketAndSeat.cshtml"));
}
public MovieSchedule FromSqlDataReader(SqlDataReader reader)
{
MovieSchedule obj = new MovieSchedule();
if (reader["id"] is DBNull == false)
{
obj.Id = Convert.ToString(reader["id"]);
}
if (reader["movieId"] is DBNull == false)
{
obj.MovieId = Convert.ToString(reader["movieId"]);
}
if (reader["scheduleId"] is DBNull == false)
{
obj.ScheduleId = Convert.ToInt32(reader["scheduleId"]);
}
if (reader["movieName"] is DBNull == false)
{
obj.MovieName = Convert.ToString(reader["movieName"]);
}
if (reader["movieDuration"] is DBNull == false)
{
obj.MovieDuration = Convert.ToByte(reader["movieDuration"]);
}
if (reader["movieTypeId"] is DBNull == false)
{
obj.MovieTypeId = Convert.ToByte(reader["movieTypeId"]);
}
if (reader["movieTypeName"] is DBNull == false)
{
obj.MovieTypeName = Convert.ToString(reader["movieTypeName"]);
}
if (reader["scheduleName"] is DBNull == false)
{
obj.ScheduleName = Convert.ToString(reader["scheduleName"]);
}
if (reader["scheduleBeginDate"] is DBNull == false)
{
obj.ScheduleBeginDate = Convert.ToDateTime(reader["scheduleBeginDate"]);
}
if (reader["scheduleDuration"] is DBNull == false)
{
obj.ScheduleDuration = Convert.ToInt16(reader["scheduleDuration"]);
}
return(obj);
}
public ActionResult ChooseTicketAndSeat(string filmId, string timeId, string cinemaId, string selectDate)
{
int filmIdData = Convert.ToInt32(filmId);
int timeIdData = Convert.ToInt32(timeId);
int cinemaIdData = Convert.ToInt32(cinemaId);
string startTime = new ShowTimeService().FindByID(timeIdData).startTime;
//DateTime scheduleDate = DateTime.Parse(selectDate);
DateTime dateSelect = DateTime.Parse(selectDate);
string dateInput = dateSelect.Year + "-" + dateSelect.Month + "-" + dateSelect.Day + " " + startTime;//21:30
DateTime scheduleDate = DateTime.Parse(dateInput);
MovieScheduleService msService = new MovieScheduleService();
MovieSchedule schedule = msService.FindMovieSchedule(filmIdData, timeIdData, cinemaIdData, scheduleDate).First();
ViewBag.scheduleId = schedule.scheduleId;
return(View());
}
public void Update(MovieSchedule movieSchedule)
{
SqlParameter[] parms = new SqlParameter[]
{
new SqlParameter("@id", SqlDbType.NVarChar, 36)
{
Value = movieSchedule.Id
}
, new SqlParameter("@movieId", SqlDbType.NVarChar, 36)
{
Value = movieSchedule.MovieId
}
, new SqlParameter("@scheduleId", SqlDbType.Int)
{
Value = movieSchedule.ScheduleId
}
};
SqlHelper.ExecuteNonQuery(
SqlHelper.ConnString
, CommandType.Text
, "UPDATE movieSchedule SET id=@id WHERE movieId=@movieId WHERE scheduleId=@scheduleId"
, parms);
}
private void Add()
{
try
{
using (var unitOfWork = new UnitOfWork(new MovieBookingContext()))
{
var movieschedule = new MovieSchedule
{
MovieId = _movie.Id,
CinemaId = (int)cboCinema.SelectedValue,
DateFrom = dtpDateFrom.Value,
DateTo = dtpDateTo.Value,
TimeFrom = dtpTimeFrom.Value,
TimeTo = dtpTimeTo.Value,
Price = (float)Convert.ToDecimal(txtPrice.Text),
RowLetter = txtRowLetter.Text,
SeatPerRow = Convert.ToInt32(txtSeatPerRow.Text)
};
unitOfWork.MovieSchedules.Add(movieschedule);
if (unitOfWork.Complete() > 0)
{
MovieSchedule(_movie.Id);
cboCinema.SelectedIndex = 0;
txtPrice.Text = "";
txtRowLetter.Text = "";
txtSeatPerRow.Text = "";
}
}
}
catch (Exception e)
{
MessageBox.Show(e.Message);
}
}
public void CreateSchedule(MovieSchedule ms)
{
db.AddToMovieSchedules(ms);
db.SaveChanges();
}
public void DeleteSchedule(MovieSchedule ms)
{
movieschedule_broker.DeleteSchedule(ms);
}
public void CreateSchedule(MovieSchedule ms)
{
movieschedule_broker.CreateSchedule(ms);
}
public void Update(MovieSchedule entity)
{
movieScheduleRepository.Update(entity);
}
public void Create(MovieSchedule entity)
{
movieScheduleRepository.Create(entity);
}
public string AddMovieSchedule(MovieSchedule movieSchedule)
{
throw new NotImplementedException();
}
public double?GetMoviePrice(int scheduleId)
{
MovieSchedule movieSchedule = controller.GetScheduleDetails(scheduleId);
return(movieSchedule.Movie.Price);
}
public void UpdateSchedule(MovieSchedule ms)
{
movieschedule_broker.UpdateSchedule(ms);
}
/// <inheritdoc />
public void Add(MovieSchedule entity)
{
_context.MovieSchedules.Add(entity);
}
public MovieSchedule GetScheduleDetails(int scheduleId)
{
MovieSchedule schedule = context.MovieSchedules.FirstOrDefault(t => t.Id == scheduleId);
return(schedule);
}
/// <inheritdoc />
public void Delete(MovieSchedule entity)
{
_context.MovieSchedules.Remove(entity);
}
public void ResetMovieSchedule(MovieSchedule movieSchedule)
{
throw new NotImplementedException();
}
public void DisplayTitle()
{
MovieSchedule movieSchedule = controller.GetScheduleDetails(scheduleId);
lblSeatAvailability.Text = "Seat availability for " + movieSchedule.Movie.Name + " " + movieSchedule.ScheduleDate.ToString().Substring(0, 9) + " At " + movieSchedule.Timing.StartTime.ToString().Substring(9);
}
