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