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);
}
}
