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 }