public void ThemRapChieu(RapChieu rapchieu) { string query = ""; query = "Insert into RapChieu (TenRap, SoPhong, DiaChi, DienThoai) " + "values ('"+ rapchieu.TenRap + "'," + rapchieu.SoPhong +",'" + rapchieu.DiaChi + "','" + rapchieu.DienThoai + "')" ; try { this.addRow(query); } catch (OracleException ex) { throw ex; } }
public void CapNhatRapChieu(RapChieu rapchieu) { string query = ""; query = "Update [RapChieu] " + "Set [RapChieu].TenRap = '" + rapchieu.TenRap + "'," + "[RapChieu].SoPhong = " + rapchieu.SoPhong + "," + "[RapChieu].DiaChi = '" + rapchieu.DiaChi + "'," + "[RapChieu].DienThoai = '" + rapchieu.DienThoai + "'" + " Where [RapChieu].MaRap = " + rapchieu.MaRap ; try { this.editRow(query); } catch (OracleException ex) { throw ex; } }
//thong tin public RapChieu ThongTinRapChieu(int maRap) { RapChieu rapchieu = new RapChieu(); DataTable data = new DataTable(); string query = ""; if (maRap >= 0) { query = @"select [RapChieu].* from [RapChieu] where [RapChieu].MaRap = " + maRap; try { data = this.getRows(query); if (data.Rows.Count>0) { DataRow row = data.Rows[0]; rapchieu.MaRap = (int)row[0]; rapchieu.TenRap = row[1].ToString(); rapchieu.SoPhong = (int)row[2]; rapchieu.DiaChi = row[3].ToString(); rapchieu.DienThoai = row[4].ToString(); return rapchieu; } else { return rapchieu; } } catch (OracleException ex) { throw ex; } } else { return rapchieu; } }
private void btnLuu_Click(object sender, EventArgs e) { if (themmoi) { rapchieu = new RapChieu(); try { PutRapChieuData(rapchieu); rcDB.ThemRapChieu(rapchieu); } catch (Exception ex) { MessageBox.Show(ex.Message); } } else { RapChieu newRapChieu = new RapChieu(); newRapChieu.MaRap = rapchieu.MaRap; try { this.PutRapChieuData(newRapChieu); rcDB.CapNhatRapChieu(newRapChieu); } catch (Exception ex) { MessageBox.Show(ex.Message); } } DanhSachRapChieu(); this.EnabledControlNhap(false); this.EnabledControl(true); EmptyControl(); }
///xoa public void XoaRapChieu(RapChieu rapchieu) { string query = ""; if (rapchieu.MaRap > 0) { query = "Delete [RapChieu] "+ " where [RapChieu].MaRap = " + rapchieu.MaRap; try { this.deleteRow(query); } catch (OracleException ex) { throw ex; } } }
private void PutRapChieuData(RapChieu rapchieu) { rapchieu.TenRap = txtTenRap.Text; rapchieu.SoPhong =Convert.ToInt16(txtSoPhong.Text); rapchieu.DiaChi = txtDiaChi.Text; rapchieu.DienThoai = txtDienThoai.Text; }
private void HienThiRapChieu(RapChieu rapchieu) { if (rapchieu!=null) { txtTenRap.Text = rapchieu.TenRap; txtSoPhong.Text = rapchieu.SoPhong.ToString(); txtDiaChi.Text = rapchieu.DiaChi; txtDienThoai.Text = rapchieu.DienThoai; } else { MessageBox.Show("KO co Rap Chieu Phim!"); } }
private void grvRapChieu_RowHeaderMouseClick(object sender, DataGridViewCellMouseEventArgs e) { //int i = e.RowIndex; DataGridViewSelectedRowCollection rows = grvRapChieu.SelectedRows; foreach (DataGridViewRow row in rows) { DataRow myRow = (row.DataBoundItem as DataRowView).Row; int maRap = myRow.Field<int>("MaRap"); rapchieu = rcDB.ThongTinRapChieu(maRap); HienThiRapChieu(rapchieu); } }