private void autoLoadReport(DateTime from, DateTime To, Boolean pro) { List <filmReport> totalTickets = new List <filmReport>(); cinemaTicketManagerDataContext dataContext = new cinemaTicketManagerDataContext(); List <filmReport> reports = new List <filmReport>(); var listFilms = dataContext.calendershows.Where(x => x.showDate >= from && x.showDate <= To).GroupBy(x => x.film, x => x.id, (key, g) => new { film = key, calendar = g.ToList() }); foreach (var item in listFilms) { var tickets = dataContext.tickets.Where(x => item.calendar.Contains(x.calenderShow) && x.createdDate >= from && x.createdDate <= To).GroupBy(x => x.calendershow1.film, x => x.totalPrice, (key, g) => new { film = key, total = g.ToList() }); foreach (var item1 in tickets) { filmReport film = new filmReport() { filmName = dataContext.films.FirstOrDefault(x => x.id == item.film).filmName, totalView = item1.total.Count, totalRevenue = item1.total.Sum() }; totalTickets.Add(film); } } rptTotalFilmReport report = new rptTotalFilmReport(); report.SetDataSource(totalTickets); crystalReport.ReportSource = report; crystalReport.Show(); }
private void button1_Click(object sender, EventArgs e) { if (txtUserName.Text != "") { if (txtPassword.Text != "") { cinemaTicketManagerDataContext dataContext = new cinemaTicketManagerDataContext(); account user = dataContext.accounts.FirstOrDefault(x => x.userName == txtUserName.Text && x.password == txtPassword.Text); if (user != null) { mainForm.userLogin = user; if (chkRemenber.Checked) { using (StreamWriter sw = new StreamWriter("textfile.txt")) { sw.Write(txtUserName.Text); } } else { using (StreamWriter sw = new StreamWriter("textfile.txt")) { sw.Write(""); } } this.Close(); } else { alertDanger alert = new alertDanger("Login Failt", "User account or password is incorrect!"); alert.ShowDialog(); txtPassword.Text = ""; } } else { alertDanger alert = new alertDanger("Login Failt", "Password is empty!"); alert.ShowDialog(); txtPassword.Text = ""; } } else { alertDanger alert = new alertDanger("Login Failt", "UserName is empty!"); alert.ShowDialog(); txtPassword.Text = ""; } }
private void loadTicket() { cinemaTicketManagerDataContext dataContext = new cinemaTicketManagerDataContext(); var ticketDetailt = dataContext.showTickets.FirstOrDefault(x => x.id == ticketId); if (ticketDetailt != null) { txtFilmName.Text = ticketDetailt.film; txtID.Text = ticketId.ToString(); txtBuyer.Text = ticketDetailt.buyer; txtCreatedBy.Text = ticketDetailt.createdName; txtCreatedDate.Text = ticketDetailt.createdDate.Month + "/" + ticketDetailt.createdDate.Day + "/" + ticketDetailt.createdDate.Year; txtPrice.Text = ticketDetailt.totalPrice + "$"; txtRoom.Text = ticketDetailt.room; txtSeat.Text = ticketDetailt.seatName; txtDate.Text = ticketDetailt.showDate.Month + "/" + ticketDetailt.showDate.Day + "/" + ticketDetailt.showDate.Year; txtShowTime.Text = ticketDetailt.timeName; } }
private void autoLoadReport(int ticketID) { cinemaTicketManagerDataContext dataContext = new cinemaTicketManagerDataContext(); var tickets = from t in dataContext.showTickets where t.id == ticketID select new ticketViewDetailtReport { id = t.id, buyer = t.buyer, createdBy = t.createdBy + t.createdName, createdDate = t.createdDate, film = t.film, room = t.room, seatName = t.seatName, showDate = t.showDate, showTime = t.timeName + " - " + t.timeBegin / 60 + "h" + t.timeBegin % 60, totalPrice = t.totalPrice }; rptTicketPrinter prints = new rptTicketPrinter(); prints.SetDataSource(tickets); crystalReport.ReportSource = prints; crystalReport.Show(); }
private void autoLoadReport(DateTime from, DateTime To) { List <totalTicketReport> totalTickets = new List <totalTicketReport>(); cinemaTicketManagerDataContext dataContext = new cinemaTicketManagerDataContext(); var listFilms = dataContext.calendershows.Where(x => x.showDate >= from && x.showDate <= To).GroupBy(x => x.film, x => x.id, (key, g) => new { film = key, calendar = g.ToList() }); foreach (var item in listFilms) { var tickets = dataContext.tickets.Where(x => item.calendar.Contains(x.calenderShow) && x.createdDate >= from && x.createdDate <= To).GroupBy(x => x.createdDate, x => x.totalPrice, (key, g) => new { createdDate = key, total = g.ToList() }); foreach (var item1 in tickets) { totalTicketReport totalTicket = new totalTicketReport() { dateFrom = from, date = item1.createdDate, filmName = dataContext.films.FirstOrDefault(x => x.id == item.film).filmName, totalTicket = item1.total.Count, totalRevenue = item1.total.Sum(), }; totalTickets.Add(totalTicket); } } if (DateTime.Compare(from, To) == 0) { rptTicketAllFilmReport report = new rptTicketAllFilmReport(); report.SetDataSource(totalTickets); crystalReport.ReportSource = report; crystalReport.Show(); } else { rptTicketAllFilmReport_SingleDay report = new rptTicketAllFilmReport_SingleDay(); report.SetDataSource(totalTickets); crystalReport.ReportSource = report; crystalReport.Show(); } }