private void btnInsertSeat_Click(object sender, EventArgs e)
{
string theaterValue = cbTheater.Text;
string screenValue = cbScreen.Text;
ScreenAndSeat seat = lvBill.Tag as ScreenAndSeat;
if (ticketId == null || seat == null)
{
MessageBox.Show("Chưa chọn ghế", "Lỗi");
return;
}
else
{
ticketId = TicketDAL.Instance.GetTicketIdByShowtimeIdAndSeatId(getShowtimeId(), seat.MaGhe);
if (ticketId != 0)
{
MessageBox.Show("Ghế đã có người đặt", "Lỗi");
}
else
{
ScreenDAL.Instance.InsertSeat(getShowtimeId(), seat.MaGhe);
}
LoadSeat(screenValue, theaterValue);
showBill(ticketId);
}
}
private void showBill(int ticketId)
{
lvBill.Items.Clear();
Decimal priceTotal = 55000;
int showtimeId = getShowtimeId();
ScreenAndSeat seat = lvBill.Tag as ScreenAndSeat;
switch (ScreenDAL.Instance.seatExist(showtimeId, seat.MaGhe))
{
case 1:
priceTotal = 55000;
break;
default:
priceTotal = 0;
break;
}
List <Ticket> getTicketAt = TicketDAL.Instance.GetTicketByTicketId(ticketId);
foreach (Ticket item in getTicketAt)
{
/*
* ListViewItem lsvItem = new ListViewItem(item.TenPhim.ToString());
* lsvItem.SubItems.Add(item.GioChieu.ToString());
* switch(item.SoCot)
* {
* case 1:
* lsvItem.SubItems.Add("A" + item.SoHang.ToString());
* break;
* case 2:
* lsvItem.SubItems.Add("B" + item.SoHang.ToString());
* break;
* case 3:
* lsvItem.SubItems.Add("C" + item.SoHang.ToString());
* break;
* case 4:
* lsvItem.SubItems.Add("D" + item.SoHang.ToString());
* break;
*
* }
*/
ListViewItem lsvItem = new ListViewItem(item.TenDv.ToString());
lsvItem.SubItems.Add(item.SoLuong.ToString());
lsvItem.SubItems.Add(item.GiaDv.ToString("#,### đồng", CultureInfo.GetCultureInfo("vi-VN").NumberFormat));
priceTotal += item.GiaDv * item.SoLuong;
lvBill.Items.Add(lsvItem);
}
totalMoney = priceTotal;
tbPriceTotal.Text = priceTotal.ToString("#,### đồng", CultureInfo.GetCultureInfo("vi-VN").NumberFormat);
}
public List <ScreenAndSeat> getListSeat(String ScreenName, String theaterName)
{
List <ScreenAndSeat> screenList = new List <ScreenAndSeat>();
string query = string.Format("EXEC GetListSeat N'{0}' , N'{1}'", ScreenName, theaterName);
DataTable data = DataProvider.Instance.ExecuteQuery(query);
foreach (DataRow item in data.Rows)
{
ScreenAndSeat screen = new ScreenAndSeat(item);
screenList.Add(screen);
}
return(screenList);
}
private void btnServiceAdd_Click(object sender, EventArgs e)
{
int showtimeId = getShowtimeId();
string theaterValue = cbTheater.Text;
string screenValue = cbScreen.Text;
ScreenAndSeat seat = lvBill.Tag as ScreenAndSeat;
List <Ticket> getTicketAt = TicketDAL.Instance.GetTicketByTicketId(ticketId);
if (seat == null || ticketId == null)
{
MessageBox.Show("Chưa chọn ghế", "Lỗi");
return;
}
ticketId = TicketDAL.Instance.GetTicketIdByShowtimeIdAndSeatId(showtimeId, seat.MaGhe);
if (ticketId == 0)
{
MessageBox.Show("Ghế chưa được đặt", "Lỗi");
return;
}
Decimal getMoney = TicketDAL.Instance.GetMoneyByTicketId(ticketId);
if (getMoney > 0)
{
MessageBox.Show("Vé đã đặt không thể thêm", "Lỗi");
return;
}
if (ServicesDAL.Instance.ServiceExist(ticketId, (cbServices.SelectedItem as Services).MaDV) == 0)
{
TicketDAL.Instance.InsertService(ticketId, (cbServices.SelectedItem as Services).MaDV, 1);
}
else
{
int quantity = ServicesDAL.Instance.GetQuantityByTicketIdAndServiceId(ticketId, (cbServices.SelectedItem as Services).MaDV);
TicketDAL.Instance.UpdateService(ticketId, (cbServices.SelectedItem as Services).MaDV, quantity + 1);
}
LoadSeat(screenValue, theaterValue);
showBill(ticketId);
}
private void btnDeleteService_Click(object sender, EventArgs e)
{
try
{
int showtimeId = getShowtimeId();
string theaterValue = cbTheater.Text;
string screenValue = cbScreen.Text;
ScreenAndSeat seat = lvBill.Tag as ScreenAndSeat;
List <Ticket> getTicketAt = TicketDAL.Instance.GetTicketByTicketId(ticketId);
if (seat == null || ticketId == null)
{
MessageBox.Show("Chưa chọn ghế", "Lỗi");
return;
}
ticketId = TicketDAL.Instance.GetTicketIdByShowtimeIdAndSeatId(showtimeId, seat.MaGhe);
if (ticketId == 0)
{
MessageBox.Show("Ghế chưa được đặt", "Lỗi");
return;
}
if (ServicesDAL.Instance.ServiceCount(ticketId, (cbServices.SelectedItem as Services).MaDV) == 1)
{
ServicesDAL.Instance.DeleteDetailServiceByTicketdServiceId(ticketId, (cbServices.SelectedItem as Services).MaDV);
}
else
{
int quantity = ServicesDAL.Instance.GetQuantityByTicketIdAndServiceId(ticketId, (cbServices.SelectedItem as Services).MaDV);
TicketDAL.Instance.UpdateService(ticketId, (cbServices.SelectedItem as Services).MaDV, quantity - 1);
}
LoadSeat(screenValue, theaterValue);
showBill(ticketId);
}
catch { }
}
