private void taoGiaGhe()
{
foreach (Ghe ghe in GheList.ListAllGhe())
{
if (ghe.LoaiGhe.ToLower() == "phothong")
{
DAOGiaVeCuaGhe.InsertGiaVeCuaGhe(taoKeHoach(), ghe, Convert.ToInt32(txtPhoThong.Text));
}
if (ghe.LoaiGhe.ToLower() == "vip")
{
DAOGiaVeCuaGhe.InsertGiaVeCuaGhe(taoKeHoach(), ghe, Convert.ToInt32(txtVIP.Text));
}
if (ghe.LoaiGhe.ToLower() == "deluxe")
{
DAOGiaVeCuaGhe.InsertGiaVeCuaGhe(taoKeHoach(), ghe, Convert.ToInt32(txtDeluxe.Text));
}
if (ghe.LoaiGhe.ToLower() == "switchbox")
{
DAOGiaVeCuaGhe.InsertGiaVeCuaGhe(taoKeHoach(), ghe, Convert.ToInt32(txtSwitchbox.Text));
}
}
}
public static List <GiaVeCuaGhe> GetAll(string rap, string khandai, DateTime ngay, string suatchieu)
{
List <GiaVeCuaGhe> lstGia = new List <GiaVeCuaGhe>();
DataTable dt = DAOGiaVeCuaGhe.LoadGiaVe(rap, khandai, ngay, suatchieu);
foreach (DataRow dr in dt.Rows)
{
GiaVeCuaGhe acc = new GiaVeCuaGhe();
acc.GheID = dr["gheid"].ToString();
acc.GiaVe = Convert.ToInt32(dr["giavecuaghe"].ToString());
acc.TrangThai = dr["trangthai"].ToString();
lstGia.Add(acc);
}
return(lstGia);
}
void InsertOrder()
{
AccountModel acc = Session["accSession"] as AccountModel;
GiaVeCuaGhe giaGhe = Session["giaVe"] as GiaVeCuaGhe;
DAOdonHangVe.Insert(acc.Ten, acc.Email, giaGhe.TongTien, giaGhe.Rap);
Dictionary <string, int> lstGheDangChon = Session["lstGheDangChon"] as Dictionary <string, int>;
DateTime ngay = Convert.ToDateTime(Session["ngay"]);
foreach (KeyValuePair <string, int> item in lstGheDangChon)
{
DAOGiaVeCuaGhe.ChuyenTrangThaiDa(item.Key, giaGhe.Rap, giaGhe.KhanDai, giaGhe.Suat, ngay);
}
InsertVe();
}
private void lbSuatChieu_SelectedIndexChanged(object sender, EventArgs e)
{
lbKhanDai.DisplayMember = "khandaiid";
lbKhanDai.ValueMember = "khandaiid";
lbKhanDai.DataSource = DAOGiaVeCuaGhe.GetKhanDai(rap, lbTenPhim.SelectedValue.ToString(), lbSuatChieu.SelectedValue.ToString());
}
private void lbTenPhim_SelectedIndexChanged(object sender, EventArgs e)
{
lbSuatChieu.DisplayMember = "suatChieu";
lbSuatChieu.ValueMember = "suatChieu";
lbSuatChieu.DataSource = DAOGiaVeCuaGhe.GetSuatChieu(rap, lbTenPhim.SelectedValue.ToString());
}
private void ChonGhe_Load(object sender, EventArgs e)
{
lbTenPhim.DataSource = DAOGiaVeCuaGhe.GetTenPhim(rap);
lbTenPhim.DisplayMember = "tenPhim";
lbTenPhim.ValueMember = "tenPhim";
}
private void btnThanhToan_Click(object sender, EventArgs e)
{
if (ValidateOfMe.ValidateOfMe.isHaveEmptyTextBox(ref pnInfor))
{
return;
}
#region InsertDonHangVe
GiaVeCuaGhe giaVe = new GiaVeCuaGhe();
giaVe.Rap = rap;
giaVe.Suat = lbSuatChieu.SelectedValue.ToString();
giaVe.KhanDai = lbKhanDai.SelectedValue.ToString();
DAODonHangVe.Insert(txtTenKhach.Text,
txtTamTinh.Text,
lbDiscount.Text,
txtSoTienThanhToan.Text,
rap);
#endregion
#region update Trạng thái của ghế
foreach (KeyValuePair <string, int> item in lstGheDangChon)
{
DAOGiaVeCuaGhe.ChuyenTrangThaiDa(item.Key, giaVe);
}
#endregion
string dsGhe = "";
foreach (KeyValuePair <string, int> item in lstGheDangChon)
{
dsGhe += item.Key + " ";
}
#region In Hóa Đơn
string HoaDon = "Anh / Chi : " + txtTenKhach.Text + "\r\n" +
"dia chi : " + txtDiaChi.Text + "\r\n" +
"Phim : " + lbTenPhim.Text + "\r\n" +
"suat chieu : " + lbSuatChieu.Text + "\r\n" +
"khan dai : " + txtDiaChi.Text + "\r\n" +
"tam tinh : " + txtTamTinh.Text + "\r\n" +
"Disocunt : " + lbDiscount.Text + "\r\n" +
"giam : " + txtGiam.Text + "\r\n" +
"tong tien : " + txtSoTienThanhToan.Text + "\r\n" +
"ghe da chon : " + dsGhe;
using (SaveFileDialog sfd = new SaveFileDialog()
{
Filter = "DPF file|*.pdf", ValidateNames = true
})
{
if (sfd.ShowDialog() == DialogResult.OK)
{
iTextSharp.text.Document doc = new iTextSharp.text.Document(PageSize.A6.Rotate());
try
{
PdfWriter.GetInstance(doc, new FileStream(sfd.FileName, FileMode.Create));
doc.Open();
Paragraph a = new Paragraph(HoaDon);
doc.Add(new iTextSharp.text.Paragraph(a));
}
catch (Exception ex) {
MessageBox.Show(ex.Message);
}
finally { doc.Close(); }
}
}
#endregion
InsertVe();
MessageBox.Show("Đã Đặt xong ghế");
Reset();//set default cho form
}
