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