public int InsertTicketNonCusID(dtoTicket ticket)
{
int count = 0;
try
{
string sql = "INSERT [dbo].[Ticket] ([TimeCreated], [TicketPrice], [SeatName], [FilmID], [SetID], [EmployeeID]) VALUES (@TimeCreate, @Price, @SeatName, @FilmID, @SetID, @EmployeeID)";
SqlParameter parameterTimeCreate = new SqlParameter("@TimeCreate", SqlDbType.DateTime);
parameterTimeCreate.Value = ticket.TimeCreate;
SqlParameter parameterPrice = new SqlParameter("@Price", SqlDbType.Decimal);
parameterPrice.Value = ticket.TicketPrice;
SqlParameter parameterSeatName = new SqlParameter("@SeatName", SqlDbType.NVarChar);
parameterSeatName.Value = ticket.SeatName;
SqlParameter parameterFilmID = new SqlParameter("@FilmID", SqlDbType.Int);
parameterFilmID.Value = ticket.FilmID;
SqlParameter parameterSetID = new SqlParameter("@SetID", SqlDbType.Int);
parameterSetID.Value = ticket.SetID;
SqlParameter parameterEmployeeID = new SqlParameter("@EmployeeID", SqlDbType.Int);
parameterEmployeeID.Value = ticket.EmployeeID;
count = InsertUpdateDeleteData(sql, new[] { parameterTimeCreate, parameterPrice, parameterSeatName, parameterFilmID, parameterSetID, parameterEmployeeID });
}
finally
{
CloseConnection();
}
return(count);
}
public List <dtoTicket> GetTickets()
{
dalTicket dalTicket = new dalTicket();
List <dtoTicket> listEmp = new List <dtoTicket>();
DataTable Tickets = dalTicket.GetTickets();
for (int i = 0; i < Tickets.Rows.Count; i++)
{
dtoTicket Ticket = new dtoTicket();
DataRow row = Tickets.Rows[i];
if (row[6] is DBNull)
{
Ticket.TicketID = Convert.ToInt32(row[0]);
Ticket.TimeCreate = Convert.ToDateTime(row[1]);
Ticket.TicketPrice = Convert.ToInt32(row[2]);
Ticket.SeatName = row[3].ToString();
Ticket.FilmID = Convert.ToInt32(row[4]);
Ticket.SetID = Convert.ToInt32(row[5]);
Ticket.EmployeeID = Convert.ToInt32(row[7]);
listEmp.Add(Ticket);
}
else
{
Ticket.TicketID = Convert.ToInt32(row[0]);
Ticket.TimeCreate = Convert.ToDateTime(row[1]);
Ticket.TicketPrice = Convert.ToInt32(row[2]);
Ticket.SeatName = row[3].ToString();
Ticket.FilmID = Convert.ToInt32(row[4]);
Ticket.SetID = Convert.ToInt32(row[5]);
Ticket.CustomerID = Convert.ToInt32(row[6]);
Ticket.EmployeeID = Convert.ToInt32(row[7]);
listEmp.Add(Ticket);
}
}
return(listEmp);
}
public int InsertTicket(dtoTicket ticket)
{
dalTicket dal = new dalTicket();
return(dal.InsertTicket(ticket));
}
private void btnConfirm_Click(object sender, EventArgs e)
{
int count = 0;
List <dtoViewTicket> tickets = new List <dtoViewTicket>();
string employeeName = employee.GetEmployeeName(frmLogin.UserLogin.EmployeeID);
try
{
if (DanhSachChon.Count == 0)
{
throw new Exception("Mời chọn ghế!");
}
else if (txtCusID.Text == "")
{
foreach (var i in DanhSachChon)
{
dtoTicket dtoTicket = new dtoTicket();
dtoViewTicket viewTicket = new dtoViewTicket();
viewTicket.TicketID = ticket.GetCountTicket() + 1;
viewTicket.CustomerFullName = "Guest";
viewTicket.EmployeeFullName = employeeName;
viewTicket.FilmName = TicketInfo.FilmName;
viewTicket.RoomID = setDetail.GetRoomID(TicketInfo.FilmID, TicketInfo.SetID);
viewTicket.StartTime = TicketInfo.StartTime;
viewTicket.TicketPrice = 75000;
viewTicket.SeatName = i.Text;
viewTicket.CreateDate = DateTime.Now;
viewTicket.CustomerBirthDay = Convert.ToDateTime("01/01/1900");
tickets.Add(viewTicket);
//Thêm dữ liệu để lưu trữ lên DB
dtoTicket.EmployeeID = frmLogin.UserLogin.EmployeeID;
dtoTicket.SetID = TicketInfo.SetID;
dtoTicket.TicketPrice = 75000;
dtoTicket.TimeCreate = DateTime.Now;
dtoTicket.SeatName = i.Text;
dtoTicket.FilmID = TicketInfo.FilmID;
count += ticket.InsertTicketNonCusID(dtoTicket);
}
}
else if (!balCustomer.CheckCustomer(Convert.ToInt32(txtCusID.Text)))
{
throw new Exception("Mã khách hàng không tồn tại!");
}
else
{
foreach (var i in DanhSachChon)
{
dtoTicket dtoTicket = new dtoTicket();
dtoViewTicket viewTicket = new dtoViewTicket();
viewTicket.TicketID = ticket.GetCountTicket() + 1;
viewTicket.CustomerFullName = customer.GetCustomerName(Convert.ToInt32(txtCusID.Text));
viewTicket.EmployeeFullName = employeeName;
viewTicket.FilmName = TicketInfo.FilmName;
viewTicket.RoomID = setDetail.GetRoomID(TicketInfo.FilmID, TicketInfo.SetID);
viewTicket.StartTime = TicketInfo.StartTime;
viewTicket.TicketPrice = Convert.ToDecimal(ticket.GetPrice(Convert.ToInt32(txtCusID.Text)));
viewTicket.SeatName = i.Text;
viewTicket.CreateDate = DateTime.Now;
viewTicket.CustomerBirthDay = customer.GetCustomerBirthDay(Convert.ToInt32(txtCusID.Text));
tickets.Add(viewTicket);
//Thêm dữ liệu để lưu trữ lên DB
dtoTicket.CustomerID = Convert.ToInt32(txtCusID.Text);
dtoTicket.EmployeeID = frmLogin.UserLogin.EmployeeID;
dtoTicket.SetID = TicketInfo.SetID;
dtoTicket.TicketPrice = ticket.GetPrice(Convert.ToInt32(txtCusID.Text));
dtoTicket.TimeCreate = DateTime.Now;
dtoTicket.SeatName = i.Text;
dtoTicket.FilmID = TicketInfo.FilmID;
count += ticket.InsertTicket(dtoTicket);
}
}
string tb = count.ToString() + " Vé đã được mua thành công";
XtraMessageBox.Show(tb, "Successful", MessageBoxButtons.OK, MessageBoxIcon.Information);
foreach (var i in ticket.GetTickets())
{
foreach (SimpleButton j in simpleButtons)
{
if (i.SeatName == j.Text && i.SetID == TicketInfo.SetID && i.FilmID == TicketInfo.FilmID)
{
MakeUp(j);
}
}
}
while (DanhSachChon.Count > 0)
{
DanhSachChon.RemoveAt(0);
}
foreach (var i in tickets)
{
using (frmPrintTicket frm = new frmPrintTicket())
{
frm.PrintTicket(i);
frm.ShowDialog();
}
}
}
catch (Exception ex)
{
XtraMessageBox.Show(ex.Message, "Error", MessageBoxButtons.OK, MessageBoxIcon.Information);
}
}
