private void ReportDailyTicketsLoad()
{
DataSet ds = new DataSet();
DataTable dt = new DataTable("DailyTickets");
dt.Columns.Add("person_name");
dt.Columns.Add("issuer_user_name");
dt.Columns.Add("price");
dt.Columns.Add("create_date");
ds.Tables.Add(dt);
List <DailyTicketDTO> dailyTickets = DailyTicketsDAO.getDailyTicketsInDateRange(dateFrom, dateTo);
foreach (var dailyTicket in dailyTickets)
{
DataRow dr = ds.Tables[0].NewRow();
dr["person_name"] = dailyTicket.person_name;
dr["issuer_user_name"] = dailyTicket.issuer_user_name;
dr["price"] = dailyTicket.price;
dr["create_date"] = dailyTicket.create_date.ToString("dd.MM.yyyy. hh:mm:ss");
ds.Tables[0].Rows.Add(dr);
}
rptDailyTickets1.SetDataSource(ds);
rptDailyTickets1.SetParameterValue("pDateFrom", dateFrom.ToString("dd.MM.yyyy."));
rptDailyTickets1.SetParameterValue("pDateTo", dateTo.ToString("dd.MM.yyyy."));
rptDailyTickets1.SetParameterValue("pDatum", DateTime.Now.ToString("dd.MM.yyyy."));
crystalReportViewer.ReportSource = rptDailyTickets1;
crystalReportViewer.Refresh();
}
public DailyTicketForm()
{
InitializeComponent();
var ticketTypes = DailyTicketsDAO.getAllTypes();
comboBoxTicketType.Items.AddRange(ticketTypes.ToArray());
comboBoxTicketType.SelectedIndex = 0;
}
private void btnConfirm_Click(object sender, EventArgs e)
{
var dt = (daily_ticket_type)comboBoxTicketType.SelectedItem;
var quantity = (int)numTicketQuantity.Value;
var ticket = new daily_ticket()
{
issuer_user_account_id = 1, //POPRAVITI ISSUER-a
daily_ticket_type_id = dt.daily_ticket_type_id,
price = dt.price,
create_date = DateTime.Now
};
while ((quantity--) > 0)
{
DailyTicketsDAO.insert(ticket);
}
//UBACITI MESSAGEBOX za stampanje karte
this.Close();
}
