public static void ChuyenTrangThaiDa(string gheID, GiaVeCuaGhe giaVeCuaGhe)
{
string sql = @"UPDATE [dbo].[giaVeCuaGhe]
SET
[trangThai] = 'da'
WHERE gheID=@gheID and
tenRap=@rap and
khanDaiID =@khandai and
ngayChieu=CONVERT(DATE, GETDATE()) and
suatChieu=@suat ";
SqlParameter pr1 = new SqlParameter("@gheID", SqlDbType.NVarChar);
pr1.Value = gheID;
SqlParameter pr2 = new SqlParameter("@rap", SqlDbType.NVarChar);
pr2.Value = giaVeCuaGhe.Rap;
SqlParameter pr3 = new SqlParameter("@khandai", SqlDbType.NVarChar);
pr3.Value = giaVeCuaGhe.KhanDai;
SqlParameter pr4 = new SqlParameter("@suat", SqlDbType.NVarChar);
pr4.Value = giaVeCuaGhe.Suat;
DAO.ExecuteSQLWithParameters(sql, pr1, pr2, pr3, pr4);
}
protected void Page_Load(object sender, EventArgs e)
{
if (!IsPostBack)
{
if (Session["accSession"] == null)
{
btnAccount.ImageUrl = "~/images/unknowPerson.PNG";
}
else
{
btnAccount.ImageUrl = "~/images/person.PNG";
}
AccountModel acc = Session["accSession"] as AccountModel;
ten.Text = acc.Ten;
GiaVeCuaGhe giaVe = Session["giaVe"] as GiaVeCuaGhe;
phim.Text = giaVe.Phim;
rap.Text = giaVe.Rap;
suatchieu.Text = giaVe.Suat;
khandai.Text = giaVe.KhanDai;
tien.Text = giaVe.TongTien;
string ghe = "";
Dictionary <string, int> lstGheDangChon = Session["lstGheDangChon"] as Dictionary <string, int>;
foreach (KeyValuePair <string, int> item in lstGheDangChon)
{
ghe += " " + item.Key;
}
dsGhe.Text = ghe;
series.Text = DAOdonHangVe.GetSeries().Rows[0][0].ToString();
}
}
void HienGhe(GiaVeCuaGhe giaVe)
{
tlpGhe.Controls.Clear();
int count = 0;
for (int i = 0; i < tlpGhe.RowCount; i++)
{
for (int j = 0; j < tlpGhe.ColumnCount; j++)
{
Label lbGhe = new Label();
lbGhe.AutoSize = false;
lbGhe.Dock = DockStyle.Fill;
lbGhe.TextAlign = ContentAlignment.MiddleCenter;
lbGhe.BorderStyle = BorderStyle.FixedSingle;
lbGhe.Text = GiaVeCuaGheList.GetAll(giaVe)[count].GheID;
#region Set Mau Ghe
if (GiaVeCuaGheList.GetAll(giaVe)[count].TrangThai == "chua")
{
lbGhe.BackColor = Color.White;
}
if (GiaVeCuaGheList.GetAll(giaVe)[count].TrangThai == "da")
{
lbGhe.BackColor = Color.Gray;
}
#endregion
lbGhe.Click += LbGhe_Click;
tlpGhe.Controls.Add(lbGhe, j, i);
count++;
}
}
}
public static DataTable GetGiaGhe(GiaVeCuaGhe giaVeCuaGhe)
{
string sql = @"SELECT gheid , giavecuaghe,trangthai
FROM giaVeCuaGhe
where ngayChieu = CONVERT(DATE, GETDATE())
and tenRap like @rap
and tenPhim like @phim
and suatChieu like @suat
and khanDaiID like @khandai" ;
SqlParameter pr1 = new SqlParameter("@rap", SqlDbType.NVarChar);
pr1.Value = giaVeCuaGhe.Rap;
SqlParameter pr2 = new SqlParameter("@phim", SqlDbType.NVarChar);
pr2.Value = giaVeCuaGhe.Phim;
SqlParameter pr3 = new SqlParameter("@suat", SqlDbType.NVarChar);
pr3.Value = giaVeCuaGhe.Suat;
SqlParameter pr4 = new SqlParameter("@khandai", SqlDbType.NVarChar);
pr4.Value = giaVeCuaGhe.KhanDai;
return(DAO.GetDataBySQLWithParameters(sql, pr1, pr2, pr3, pr4));
}
void GiaTungLoaiGhe(GiaVeCuaGhe giaVe)
{
txtPhoThong.Text = GiaVeCuaGheList.GetAll(giaVe)[0].GiaVe.ToString();
txtVIP.Text = GiaVeCuaGheList.GetAll(giaVe)[30].GiaVe.ToString();
txtDeluxe.Text = GiaVeCuaGheList.GetAll(giaVe)[60].GiaVe.ToString();
txtSwitchBox.Text = GiaVeCuaGheList.GetAll(giaVe)[88].GiaVe.ToString();
}
protected void Page_Load(object sender, EventArgs e)
{
if (!IsPostBack)
{
GiaVeCuaGhe giaGhe = Session["giaVe"] as GiaVeCuaGhe;
tongTien.Text = giaGhe.TongTien;
}
}
void InsertVe()
{
GiaVeCuaGhe giaGhe = Session["giaVe"] as GiaVeCuaGhe;
Dictionary <string, int> lstGheDangChon = Session["lstGheDangChon"] as Dictionary <string, int>;
foreach (KeyValuePair <string, int> item in lstGheDangChon)
{
DAOVe.Insert(giaGhe, item.Key, item.Value.ToString());
}
}
void InputToSession()
{
GiaVeCuaGhe giaVe = new GiaVeCuaGhe();
giaVe.Rap = rblRap.SelectedValue;
giaVe.Phim = Request.QueryString["phim"];
giaVe.Suat = rbSuat.SelectedValue;
giaVe.KhanDai = rbKhanDai.SelectedValue;
giaVe.TongTien = txtTamTinh.Text;
Session["giaVe"] = giaVe;
Session["ngay"] = cPickDate.SelectedDate.ToString();
}
void InsertVe()
{
GiaVeCuaGhe giaVe = new GiaVeCuaGhe();
giaVe.Rap = rblRap.SelectedValue;
giaVe.Phim = Request.QueryString["phim"];
giaVe.Suat = rbSuat.SelectedValue;
giaVe.KhanDai = rbKhanDai.SelectedValue;
foreach (KeyValuePair <string, int> item in lstGheDangChon)
{
DAOVe.Insert(giaVe, item.Key, item.Value.ToString());
}
}
void InsertVe()
{
GiaVeCuaGhe giaVe = new GiaVeCuaGhe();
giaVe.Rap = rap;
giaVe.Phim = lbTenPhim.SelectedValue.ToString();
giaVe.Suat = lbSuatChieu.SelectedValue.ToString();
giaVe.KhanDai = lbKhanDai.SelectedValue.ToString();
foreach (KeyValuePair <string, int> item in lstGheDangChon)
{
DAOVe.Insert(giaVe, item.Key, item.Value.ToString());
}
}
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 btnTim_Click(object sender, EventArgs e)
{
Reset();
try
{
GiaVeCuaGhe giaVe = new GiaVeCuaGhe();
giaVe.Rap = rap;
giaVe.Phim = lbTenPhim.SelectedValue.ToString();
giaVe.Suat = lbSuatChieu.SelectedValue.ToString();
giaVe.KhanDai = lbKhanDai.SelectedValue.ToString();
GiaTungLoaiGhe(giaVe);
HienGhe(giaVe);
}catch (Exception ex)
{
MessageBox.Show("Chưa chọn đủ các đề mục");
}
}
public static void Insert(GiaVeCuaGhe giaVeCuaGhe, string gheID, string giaVe)
{
string sql = @"declare @IDDonHang int
select top (1) @IDDonHang = donHangVeID from donHangVe order by donHangVeID desc
print @IDDonHang
INSERT INTO [dbo].[ve]
([tenPhim]
,[tenRap]
,[khanDaiID]
,[ngayChieu]
,[suatChieu]
,[gheID]
,[giaVe]
,[donHangID])
VALUES
(@tenPhim
,@tenRap
,@khanDaiID
,getdate()
,@suatChieu
,@gheID
,@giaVe
,@IDDonHang)";
SqlParameter pr1 = new SqlParameter("@tenPhim", SqlDbType.NVarChar);
pr1.Value = giaVeCuaGhe.Phim;
SqlParameter pr2 = new SqlParameter("@tenRap", SqlDbType.NVarChar);
pr2.Value = giaVeCuaGhe.Rap;
SqlParameter pr3 = new SqlParameter("@khanDaiID", SqlDbType.NVarChar);
pr3.Value = giaVeCuaGhe.KhanDai;
SqlParameter pr4 = new SqlParameter("@suatChieu", SqlDbType.NVarChar);
pr4.Value = giaVeCuaGhe.Suat;
SqlParameter pr5 = new SqlParameter("@gheID", SqlDbType.NVarChar);
pr5.Value = gheID;
SqlParameter pr6 = new SqlParameter("@giaVe", SqlDbType.Int);
pr6.Value = giaVe;
DAO.ExecuteSQLWithParameters(sql, pr1, pr2, pr3, pr4, pr5, pr6);
}
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
}
