public frmTheatre(ShowTimes showTimes, Movie movie)
{
InitializeComponent();
Times = showTimes;
Movie = movie;
}
public frmTau(ShowTimes showTimes, Taudidto thienboat)
{
InitializeComponent();
Times = showTimes;
thienboat = thienboat;
}
void AutoCreateTicketsByShowTimes(ShowTimes showTimes)
{
int result = 0;
Cinema cinema = CinemaDAO.GetCinemaByName(showTimes.CinemaName);
int Row = cinema.Row;
int Column = cinema.SeatInRow;
for (int i = 0; i < Row; i++)
{
int temp = i + 65;
char nameRow = (char)(temp);
for (int j = 1; j <= Column; j++)
{
string seatName = nameRow.ToString() + j;
result += TicketDAO.InsertTicketByShowTimes(showTimes.ID, seatName);
}
}
if (result == Row * Column)
{
int ret = ShowTimesDAO.UpdateStatusShowTimes(showTimes.ID, 1);
if (ret > 0)
{
MessageBox.Show("TẠO VÉ TỰ ĐỘNG THÀNH CÔNG!", "THÔNG BÁO");
}
}
else
{
MessageBox.Show("TẠO VÉ TỰ ĐỘNG THẤT BẠI!", "THÔNG BÁO");
}
}
private void lsvAllListShowTimes_Click(object sender, EventArgs e)
{
if (lsvAllListShowTimes.SelectedItems.Count > 0)
{
ShowTimes showTimes = lsvAllListShowTimes.SelectedItems[0].Tag as ShowTimes;
LoadTicketsByShowTimes(showTimes.ID);
}
}
public void Set(IEnumerable <Cinema> cinemas)
{
var showTimes = new ShowTimes
{
Cinemas = cinemas,
Created = DateTime.Now
};
var serialized = JsonConvert.SerializeObject(showTimes);
_cache.SetString(CacheKey, serialized);
}
public static List <ShowTimes> GetListShowTimesNotCreateTickets()
{
List <ShowTimes> listShowTimes = new List <ShowTimes>();
DataTable data = DataProvider.ExecuteQuery("USP_GetListShowTimesNotCreateTickets");
foreach (DataRow row in data.Rows)
{
ShowTimes showTimes = new ShowTimes(row);
listShowTimes.Add(showTimes);
}
return(listShowTimes);
}
private void btnShowAllTicketsByShowTime_Click(object sender, EventArgs e)
{
if (lsvAllListShowTimes.SelectedItems.Count > 0)
{
ShowTimes showTimes = lsvAllListShowTimes.SelectedItems[0].Tag as ShowTimes;
LoadTicketsByShowTimes(showTimes.ID);
}
else
{
MessageBox.Show("BẠN CHƯA CHỌN LỊCH CHIẾU ĐỂ XEM!!!", "THÔNG BÁO");
}
}
private void lvLichDi_Click(object sender, EventArgs e)
{
if (lvLichDi.SelectedItems.Count > 0)
{
timer1.Stop();
ShowTimes showTimes = lvLichDi.SelectedItems[0].Tag as ShowTimes;
Taudidto thienboat = cboFilmName.SelectedItem as Taudidto;
frmTau frm = new frmTau(showTimes, thienboat);
this.Hide();
frm.ShowDialog();
this.OnLoad(null);
this.Show();
}
}
private void lvLichChieu_Click(object sender, EventArgs e)
{
if (lvLichChieu.SelectedItems.Count > 0)
{
timer1.Stop();
ShowTimes showTimes = lvLichChieu.SelectedItems[0].Tag as ShowTimes;
Movie movie = cboFilmName.SelectedItem as Movie;
frmTheatre frm = new frmTheatre(showTimes, movie);
this.Hide();
frm.ShowDialog();
this.OnLoad(null);
this.Show();
}
}
private void btnAddTicketsByShowTime_Click(object sender, EventArgs e)
{
if (lsvAllListShowTimes.SelectedItems.Count > 0)
{
ShowTimes showTimes = lsvAllListShowTimes.SelectedItems[0].Tag as ShowTimes;
if (showTimes.Status == 1)
{
MessageBox.Show("LỊCH CHIẾU NÀY ĐÃ ĐƯỢC TẠO VÉ!!!", "THÔNG BÁO");
return;
}
AutoCreateTicketsByShowTimes(showTimes);
LoadAllListShowTimes();
LoadTicketsByShowTimes(showTimes.ID);
}
else
{
MessageBox.Show("BẠN CHƯA CHỌN LỊCH CHIẾU ĐỂ TẠO!!!", "THÔNG BÁO");
}
}
public async Task <IActionResult> OnGetAsync(string id, string marketFilter)
{
MarketFilter = marketFilter;
if (id == null)
{
return(NotFound());
}
Movie = await _context.Movies
.Include(m => m.ShowTimes)
.ThenInclude(st => st.Theater)
.ThenInclude(t => t.Market)
.AsNoTracking()
.FirstOrDefaultAsync(m => m.Title == id);
if (Movie == null)
{
return(NotFound());
}
Markets = await _context.Markets
.AsNoTracking()
.ToListAsync();
ShowTimes = Movie.ShowTimes
.Where(st =>
st.Date >= DateTime.Now &&
st.SeatsLeft > 0)
.ToList();
if (marketFilter.Equals("all-movies"))
{
FilteredShowTimes = ShowTimes;
}
else
{
FilteredShowTimes = ShowTimes
.Where(st => st.Theater.Market.Name == marketFilter)
.ToList();
}
return(Page());
}
private void DeleteTicketsByShowTimes(ShowTimes showTimes)
{
Cinema cinema = CinemaDAO.GetCinemaByName(showTimes.CinemaName);
int Row = cinema.Row;
int Column = cinema.SeatInRow;
int result = TicketDAO.DeleteTicketsByShowTimes(showTimes.ID);
if (result == Row * Column)
{
int ret = ShowTimesDAO.UpdateStatusShowTimes(showTimes.ID, 0);
if (ret > 0)
{
MessageBox.Show("XÓA TẤT CẢ CÁC VÉ CỦA LỊCH CHIẾU ID=" + showTimes.ID + " THÀNH CÔNG!", "THÔNG BÁO");
}
}
else
{
MessageBox.Show("XÓA TẤT CẢ CÁC VÉ CỦA LỊCH CHIẾU ID=" + showTimes.ID + " THẤT BẠI!", "THÔNG BÁO");
}
}
public ActionResult chairStatus(int filmID, int timeslotID)
{
var chairDAO = new ChairDAO();
var filmDAO = new FilmDAO();
var showtimeDAO = new ShowTimeDAO();
var userDAO = new UserDAO();
List <Chair> chair = db.Chairs.ToList();
List <Chair> chairSelected = chairDAO.getChairSelected2(filmID, timeslotID).ToList();
Film f = filmDAO.getFilmByID(filmID);
ViewBag.film = f;
ShowTimes s = showtimeDAO.getShowtime(filmID, timeslotID);
ViewBag.showtime = s;
TimeSlot t = showtimeDAO.getTimebyID(timeslotID);
ViewBag.timeslot = t.Time;
var userLogin = (UserLogin)Session[CommonConstants.USER_SESSION];
ViewBag.userLogged = userDAO.getUserById(userLogin.UserID);
foreach (var c in chair)
{
foreach (var cs in chairSelected)
{
if (c.ChairID == cs.ChairID)
{
c.Status = true;
}
}
}
ViewBag.chair = chair;
return(View());
}
private void LoadListShowTimeByFilm(string formatthienboatID)
{
DataTable data = ShowTimesDAO.GetListShowTimeByFormatthienboat(formatthienboatID, dtpThoiGian.Value);
//if (data == null) return;
foreach (DataRow row in data.Rows)
{
ShowTimes showTimes = new ShowTimes(row);
ListViewItem lvi = new ListViewItem("");
lvi.SubItems.Add(showTimes.CinemaName);
lvi.SubItems.Add(showTimes.thienboatName);
lvi.SubItems.Add(showTimes.Time.ToShortTimeString());
lvi.Tag = showTimes;
string statusShowTimes = TicketDAO.CountTheNumberOfTicketsSoldByShowTime(showTimes.ID)
+ "/" + TicketDAO.CountToltalTicketByShowTime(showTimes.ID);
lvi.SubItems.Add(statusShowTimes);
float status = (float)TicketDAO.CountTheNumberOfTicketsSoldByShowTime(showTimes.ID)
/ TicketDAO.CountToltalTicketByShowTime(showTimes.ID);
//thêm ảnh status
if (status == 1)
{
lvi.ImageIndex = 2;
}
else if (status > 0.5f)
{
lvi.ImageIndex = 1;
}
else
{
lvi.ImageIndex = 0;
}
lvLichDi.Items.Add(lvi);
}
}
