public void ThemSuatChieu(SuatChieu suatchieu)
{
string query = "";
query = "Insert into SuatChieu (NgayChieu, GioChieu, PhongChieu, MaRap, MaPhim) " +
"values ('"+ suatchieu.NgayChieu + "','" + suatchieu.GioChieu + "'," +
suatchieu.PhongChieu + "," + suatchieu.MaRap + "," + suatchieu.MaPhim + ")" ;
try
{
this.addRow(query);
}
catch (OracleException ex)
{
throw ex;
}
}
//thong tin
public SuatChieu ThongTinSuatChieu(int maSuatChieu)
{
SuatChieu suatchieu = new SuatChieu();
DataTable data = new DataTable();
string query = "";
if (maSuatChieu >= 0)
{
query = @"select [SuatChieu].*
from [SuatChieu]
where [SuatChieu].MaSuatChieu = " + maSuatChieu;
try
{
data = this.getRows(query);
if (data.Rows.Count>0)
{
DataRow row = data.Rows[0];
suatchieu.MaSuatChieu = (int)row[0];
suatchieu.NgayChieu = (DateTime)row[1];
suatchieu.GioChieu = (int)row[2];
suatchieu.PhongChieu = (int)row[3];
suatchieu.MaRap = (int)row[4];
suatchieu.MaPhim = (int)row[5];
return suatchieu;
}
else
{
return suatchieu;
}
}
catch (OracleException ex)
{
throw ex;
}
}
else
{
return suatchieu;
}
}
private void btnLuu_Click(object sender, EventArgs e)
{
if (themmoi)
{
suatchieu = new SuatChieu();
try
{
PutSuatChieuData(suatchieu);
suatchieuDB.ThemSuatChieu(suatchieu);
}
catch (Exception ex)
{
MessageBox.Show(ex.Message);
}
}
else
{
//SuatChieu newSuatChieu = new SuatChieu();
//newSuatChieu.MaSuatChieu = suatchieu.MaSuatChieu;
//try
//{
// this.PutSuatChieuData(newSuatChieu);
// suatchieuDB.CapNhatSuatChieu(newSuatChieu);
//}
//catch (Exception ex)
//{
// MessageBox.Show(ex.Message);
//}
}
DanhSachSuatChieu();
//this.EnabledControl(false);
this.EnabledButton(true);
}
private void PutSuatChieuData(SuatChieu suatchieu)
{
int phongChieu=0;
int gioChieu=0;
int maPhim=0;
this.thongtinLichChieu(ref phongChieu, ref gioChieu, ref maPhim);
suatchieu.NgayChieu = dtpNgayChieu.Value;
suatchieu.MaRap = (int)cboRapChieu.SelectedValue;
suatchieu.PhongChieu = phongChieu;
suatchieu.GioChieu = gioChieu;
suatchieu.MaPhim = maPhim;
}
private void btnXoa_Click(object sender, EventArgs e)
{
MessageBox.Show(maSuatChieu.ToString());
suatchieu = suatchieuDB.ThongTinSuatChieu(maSuatChieu);
string thongbao = "Bạn có chắc muốn xóa Suất chiếu vào " + tinSuatChieu;
DialogResult button = MessageBox.Show(thongbao, "Xac nhan xoa", MessageBoxButtons.YesNo);
if (button == DialogResult.Yes)
{
suatchieuDB.XoaSuatChieu(suatchieu);
DanhSachSuatChieu();
}
//this.EnabledControl(false);
}
//public void CapNhatSuatChieu(SuatChieu suatchieu)
//{
// string query = "";
// query = "Update [SuatChieu] " +
// "Set [SuatChieu].NgayChieu = '" + suatchieu.NgayChieu + "'," +
// "[SuatChieu].GioChieu = '" + suatchieu.GioChieu + "'," +
// "[SuatChieu].PhongChieu = " + suatchieu.PhongChieu + "," +
// "[SuatChieu].MaRap = " + suatchieu.MaRap + "," +
// "[SuatChieu].MaPhim = " + suatchieu.MaPhim + "" +
// " Where [SuatChieu].MaSuatChieu = " + suatchieu.MaSuatChieu ;
// try
// {
// this.editRow(query);
// }
// catch (OracleException ex)
// {
// throw ex;
// }
//}
///xoa
public void XoaSuatChieu(SuatChieu suatchieu)
{
string query = "";
if (suatchieu.MaSuatChieu > 0)
{
query = "Delete [SuatChieu] "+
" where [SuatChieu].MaSuatChieu = " + suatchieu.MaSuatChieu;
try
{
this.deleteRow(query);
}
catch (OracleException ex)
{
throw ex;
}
}
}
public string TinSuatChieu(int maSuatChieu)
{
SuatChieu suatchieu = new SuatChieu();
DataTable data = new DataTable();
string tinSuatChieu = "";
string query = "";
if (maSuatChieu >= 0)
{
query = "select [SuatChieu].MaSuatChieu, [SuatChieu].NgayChieu, [SuatChieu].GioChieu, " +
"[SuatChieu].PhongChieu, [SuatChieu].MaRap, [SuatChieu].MaPhim, " +
"[RapChieu].TenRap, [Phim].TuaDePhim " +
"from ([RapChieu] join [SuatChieu] on [RapChieu].MaRap = [SuatChieu].MaRap) " +
" join [Phim] on [SuatChieu].MaPhim = [Phim].MaPhim " +
"where [SuatChieu].MaSuatChieu = " + maSuatChieu;
try
{
data = this.getRows(query);
if (data.Rows.Count > 0)
{
DataRow row = data.Rows[0];
tinSuatChieu = "NgayChieu: " + (DateTime)row[1] +
"\n GioChieu: " + (int)row[2] +
"\n PhongChieu: " + (int)row[3] +
"\n TenRap: " + row[6].ToString() +
"\n TenPhim: " + row[7].ToString();
return tinSuatChieu;
}
else
{
return tinSuatChieu;
}
}
catch (OracleException ex)
{
throw ex;
}
}
else
{
return tinSuatChieu;
}
}
//ngay chieu phim cua Suat chieu
private DateTime NgayChieuPhim(int pMaSuatChieu)
{
DateTime ngay;
SuatChieu sc = new SuatChieu();
SuatChieuDB scDB = new SuatChieuDB();
sc = scDB.ThongTinSuatChieu(pMaSuatChieu);
ngay = sc.NgayChieu;
return ngay;
}