private void btnBanVe_Click(object sender, EventArgs e) { int i = 0; string dayghe = ""; //chinh sua lai VePhim theo SuatChieu va SoGhe DataGridViewSelectedRowCollection rows = grvVePhim.SelectedRows; foreach (DataGridViewRow row in rows) { DataRow myRow = (row.DataBoundItem as DataRowView).Row; int pMaVe = Convert.ToInt32(myRow.Field<string>("MaVe")); int pMaSuatChieu = Convert.ToInt32(myRow.Field<string>("MaSuatChieu")); string pSoGhe = myRow.Field<string>("SoGhe"); vephim = vephimDB.TimVePhim(pMaVe); VePhim newVephim = new VePhim(); newVephim.MaVe = vephim.MaVe; newVephim.MaSuatChieu = vephim.MaSuatChieu; newVephim.SoGhe = vephim.SoGhe; PutVePhimData(newVephim); vephimDB.CapNhatVePhim(vephim, newVephim); i++; dayghe += pSoGhe + " "; } MessageBox.Show("Da ban " + i + " ve phim!"); //hien thi Danh sach VePhim cua DatCho DanhSachVePhim(dayghe); //cap nhat trang thai Dat Cho cboTrangThaiDatCho.SelectedIndex = 2; //hien thi button Luu Dat cho btnLuu.Enabled = true; //btnKhong.Visible = false; }
//dem tong so VePhim theo SuatChieu public int SoVePhim(int maSuatChieu) { VePhim vephim = new VePhim(); DataTable data = new DataTable(); int soLuongVe = 0; string query = ""; if (maSuatChieu > 0 ) { query = "select count([VePhim].MaVe) " + "from [VePhim] " + " where [VePhim].MaSuatChieu = " + maSuatChieu; try { if (getValue(query)!=null) { soLuongVe = (int)this.getValue(query); } else { soLuongVe = 0; } } catch (OracleException ex) { throw ex; } } else { soLuongVe = 0; } return soLuongVe; }
public void CapNhatVePhim(VePhim oldVephim, VePhim newVephim) { int oldtrangthaimua; int newtrangthaimua; if (oldVephim.TrangThaiMua == true) { oldtrangthaimua = 1; } else { oldtrangthaimua = 0; } if (newVephim.TrangThaiMua == true) { newtrangthaimua = 1; } else { newtrangthaimua = 0; } string query = ""; query = "Update [VePhim] " + "Set [VePhim].NgayInVe = '" + newVephim.NgayInVe.ToShortDateString() + "', " + "[VePhim].MaSuatChieu = " + newVephim.MaSuatChieu + ", " + "[VePhim].SoGhe = '" + newVephim.SoGhe + "', " + "[VePhim].GiaVe = " + newVephim.GiaVe + ", " + "[VePhim].MaKhuyenMai = " + newVephim.MaKhuyenMai + ", " + "[VePhim].GiaVeUuDai = " + newVephim.GiaVeUuDai + ", " + "[VePhim].TrangThaiMua = " + newtrangthaimua + " where [VePhim].MaVe = " + oldVephim.MaVe + " and [VePhim].NgayInVe = '" + oldVephim.NgayInVe.ToShortDateString() + "'" + " and [VePhim].MaSuatChieu = " + oldVephim.MaSuatChieu + " and [VePhim].SoGhe = '" + oldVephim.SoGhe + "'" + " and [VePhim].GiaVe = " + oldVephim.GiaVe + " and [VePhim].MaKhuyenMai = " + oldVephim.MaKhuyenMai + " and [VePhim].GiaVeUuDai = " + oldVephim.GiaVeUuDai + " and [VePhim].TrangThaiMua = " + oldtrangthaimua; try { this.editRow(query); } catch ( OracleException ex) { throw ex; } }
//tim VePhim theo SuatChieu va SoGhe public VePhim TimVePhim(int maSuatChieu, string soGhe) { VePhim vephim = new VePhim(); DataTable data = new DataTable(); string query = ""; if (maSuatChieu > 0 && soGhe!="") { query = "select [VePhim].* " + "from [VePhim] " + " where [VePhim].MaSuatChieu = " + maSuatChieu + " and [VePhim].SoGhe = '" + soGhe + "'"; try { data = this.getRows(query); if (data.Rows.Count > 0) { DataRow row = data.Rows[0]; vephim.MaVe = (int)row[0]; vephim.NgayInVe = (DateTime)row[1]; vephim.MaSuatChieu = (int)row[2]; vephim.SoGhe = row[3].ToString(); vephim.GiaVe = (decimal)row[4]; vephim.GiaVeUuDai = (decimal)row[5]; vephim.MaKhuyenMai = (int)row[6]; vephim.TrangThaiMua = (bool)row[7]; return vephim; } else { vephim=null; } } catch (OracleException ex) { throw ex; } } else { vephim=null; } return vephim; }
//tim VePhim theo MaVe public VePhim TimVePhim(int maVe) { VePhim vephim = new VePhim(); DataTable data = new DataTable(); string query = ""; if (maVe > 0) { query = @"select [VePhim].* from [VePhim] where [VePhim].MaVe = " + maVe; try { data = this.getRows(query); if (data.Rows.Count > 0) { DataRow row = data.Rows[0]; vephim.MaVe = (int)row[0]; if (row[1] != null) { vephim.NgayInVe = (DateTime)row[1]; } else { vephim.NgayInVe = DateTime.MinValue; } vephim.MaSuatChieu = (int)row[2]; vephim.SoGhe = row[3].ToString(); if (row[4]!=null) { vephim.GiaVe = (decimal)row[4]; } else { vephim.GiaVe = 0; } if (row[5]!=null) { vephim.GiaVeUuDai = (decimal)row[5]; } else { vephim.GiaVeUuDai = 0; } if (row[6]!=null) { vephim.MaKhuyenMai = (int)row[6]; } else { vephim.MaKhuyenMai = 0; } vephim.TrangThaiMua = (bool)row[7]; return vephim; } else { return vephim; } } catch (OracleException ex) { throw ex; } } else { return vephim; } }
public void ThemVePhim(VePhim vephim) { int trangthaimua; if (vephim.TrangThaiMua == true) { trangthaimua = 1; } else { trangthaimua = 0; } string query = ""; query = "Insert into [VePhim] (NgayInVe, MaSuatChieu, SoGhe, GiaVe, GiaVeUuDai, MaKhuyenMai, TrangThaiMua) " + "values ('" + vephim.NgayInVe.ToShortDateString() + "'," + vephim.MaSuatChieu + ",'" + vephim.SoGhe + "'," + vephim.GiaVe + "," + vephim.GiaVeUuDai + "," + vephim.MaKhuyenMai + "," + trangthaimua + ")"; //query = "Insert into [VePhim] (MaSuatChieu, SoGhe) " + // "values (" + vephim.MaSuatChieu + ",'" + vephim.SoGhe + "')"; try { this.addRow(query); } catch ( OracleException ex) { throw ex; } }
private void TaoVePhimTuDong(int pmaSuatChieu) { //tao Ve Phim theo SuatChieu //tao danh sach ten ghe voi 10 hang, 11 cot bool trangthaimua = false; vephim = new VePhim(); List<string> listGhe = new List<string>(); listGhe = DanhSachTenGhe(10, 11); try { int j = 0; for (int i = 0; i < listGhe.Count; i++) { vephim.NgayInVe = DateTime.Today; vephim.MaSuatChieu = pmaSuatChieu; vephim.SoGhe = listGhe[i]; vephim.GiaVe = giaVe; vephim.GiaVeUuDai = 0; vephim.MaKhuyenMai = 1; vephim.TrangThaiMua = trangthaimua; vephimDB.ThemVePhim(vephim); j++; } MessageBox.Show("Da tao " + j + " ve phim cua suat chieu " + pmaSuatChieu); } catch (Exception ex) { MessageBox.Show(ex.Message); } }
private void PutVePhimData(VePhim newVephim) { newVephim.NgayInVe = dtpNgayInVe.Value; newVephim.GiaVe = Convert.ToDecimal(txtGiaVe.Text); KhuyenMai khuyenmai = new KhuyenMai(); khuyenmai = khuyenmaiDB.ThongTinKhuyenMai(dtpNgayInVe.Value); newVephim.MaKhuyenMai = khuyenmai.MaKhuyenMai; newVephim.GiaVeUuDai = Convert.ToDecimal(txtGiaVeUuDai.Text); newVephim.TrangThaiMua = true; }
private void DanhSachVePhim(string cacsoghe) { DataTable dtVePhim = new DataTable(); dtVePhim.Columns.Add("MaVe"); dtVePhim.Columns.Add("MaSuatChieu"); dtVePhim.Columns.Add("SoGhe"); dtVePhim.Columns.Add("TrangThaiMua"); //tim VePhim theo SuatChieu va SoGhe vephim = new VePhim(); string[] dayGhe = Chuyen(cacsoghe); if (maSuatChieu > 0) { if (dayGhe != null) { for (int i = 0; i < dayGhe.Length; i++) { string ghe = dayGhe[i]; vephim = vephimDB.TimVePhim(maSuatChieu, ghe); if (vephim != null) { dtVePhim.Rows.Add(vephim.MaVe, vephim.MaSuatChieu, vephim.SoGhe, vephim.TrangThaiMua); grvVePhim.DataSource = dtVePhim; } else { MessageBox.Show("SuatChieu chua tao VePhim tu dong!"); } } } else { MessageBox.Show("Chua nhap so ghe"); } } else { MessageBox.Show("Chua chon SuatChieu!"); } }