private void btnCikis_Click(object sender, EventArgs e)
{
FrmGiris giris = new FrmGiris();
giris.Show();
this.Hide();
}
public FrmSatisRaporu()
{
InitializeComponent();
cmd = new OleDbCommand();
cmd.Connection = FrmGiris.conn;
FrmGiris.baglan();
}
public FrmKullaniciEkle()
{
cmd = new OleDbCommand();
InitializeComponent();
cmd.Connection = FrmGiris.conn;
FrmGiris.baglan();
}
public FrmYeniKupon()
{
InitializeComponent();
cmd = new OleDbCommand();
cmd.Connection = FrmGiris.conn;
FrmGiris.baglan();
}
public frmAnaForm()
{
InitializeComponent();
cmd = new OleDbCommand();
cmd.Connection = FrmGiris.conn;
FrmGiris.baglan();
}
public FrmSalonlariDuzenle()
{
InitializeComponent();
cmd = new OleDbCommand();
cmd.Connection = FrmGiris.conn;
FrmGiris.baglan();
}
private void frmFatura_Load(object sender, EventArgs e)
{
lblTam.Text = frmAnaForm.toplamtam.ToString() + " Tane Tam Bilet";
lblOgrenci.Text = frmAnaForm.toplamogrenci.ToString() + " Tane Öğrenci Bilet";
lblToplam.Text = "Toplam " + frmAnaForm.tutar + " TL";
cmd.Connection = FrmGiris.conn;
FrmGiris.baglan();
}
private void frmSinemaBilgi_Load(object sender, EventArgs e)
{
cmd = new OleDbCommand();
cmd.Connection = FrmGiris.conn;
FrmGiris.baglan();
cmd.CommandText = "select SinemaAd from SinemaBilgi";
textBox1.Text = cmd.ExecuteScalar().ToString();
}
private void FrmKuponlariDuzenle_Load(object sender, EventArgs e)
{
cmd = new OleDbCommand();
da = new OleDbDataAdapter();
da.SelectCommand = cmd;
cmd.Connection = FrmGiris.conn;
FrmGiris.baglan();
GridDoldur();
}
public FrmKullaniciDuzenle()
{
InitializeComponent();
cmd = new OleDbCommand();
da = new OleDbDataAdapter();
da.SelectCommand = cmd;
cmd.Connection = FrmGiris.conn;
FrmGiris.baglan();
}
private void FrmSeansEkle_Load(object sender, EventArgs e)
{
cmd = new OleDbCommand();
cmd.Connection = FrmGiris.conn;
FrmGiris.baglan();
da = new OleDbDataAdapter(cmd);
FimleriCek();
SalonlariCek();
}
private void FrmFisler_Load(object sender, EventArgs e)
{
cmd = new OleDbCommand();
da = new OleDbDataAdapter();
da.SelectCommand = cmd;
cmd.Connection = FrmGiris.conn;
FrmGiris.baglan();
GridDoldur();
KasiyerCek();
}
private void FrmSeansDuzenle_Load(object sender, EventArgs e)
{
cmd = new OleDbCommand();
cmd.Connection = FrmGiris.conn;
FrmGiris.baglan();
cmd.CommandText = "SELECT Filmler.FilmAdi FROM Filmler INNER JOIN Seanslar ON Filmler.FilmNo = Seanslar.FilmNo";
dr = cmd.ExecuteReader();
while (dr.Read())
{
lstFilm.Items.Add(dr["FilmAdi"].ToString());
}
dr.Close();
}
private void FrmFragman_Load(object sender, EventArgs e)
{
cmd = new OleDbCommand();
cmd.Connection = FrmGiris.conn;
FrmGiris.baglan();
cmd.CommandText = "select FragmanYol from Fragmanlar";
dr = cmd.ExecuteReader();
while (dr.Read())
{
IWMPMedia media = axWindowsMediaPlayer1.newMedia(dr["FragmanYol"].ToString());
axWindowsMediaPlayer1.currentPlaylist.appendItem(media);
}
dr.Close();
axWindowsMediaPlayer1.Ctlcontrols.play();
}
private void FrmFiyatlariAyarla_Load(object sender, EventArgs e)
{
cmd = new OleDbCommand();
cmd.Connection = FrmGiris.conn;
FrmGiris.baglan();
cmd.CommandText = "select * from SinemaBilgi";
OleDbDataReader dr = cmd.ExecuteReader();
if (dr.Read())
{
txtTam.Text = dr["TamFiyat"].ToString();
txtOgrenci.Text = dr["OgrFiyat"].ToString();
txtTam3d.Text = dr["3dTamFiyat"].ToString();
txtOgr3d.Text = dr["3dOgrFiyat"].ToString();
}
dr.Close();
}
private void doluKoltuklariGoster()
{
FrmGiris.baglan();
List <string> dizi = new List <string>();
cmd.CommandText = string.Format("Select KoltukNo From {0} where Seans=@Seans", salonadı);
cmd.Parameters.Clear();
cmd.Parameters.AddWithValue("@Seans", seans);
dr = cmd.ExecuteReader();
while (dr.Read())
{
dizi.Add(dr["KoltukNo"].ToString());
}
foreach (Control ckoltuk in this.grupSalon.Controls)
{
if (ckoltuk is Button)
{
Button koltuk = (Button)ckoltuk;
if (dizi.Contains(koltuk.Name))
{
koltuk.Enabled = false;
koltuk.BackColor = Color.DarkGray;
}
else
{
if (koltuk.Name.Contains("gkoltuk"))
{
koltuk.Enabled = true;
koltuk.FlatAppearance.MouseDownBackColor = Color.LightCoral;
koltuk.FlatAppearance.MouseOverBackColor = Color.LightCoral;
koltuk.BackColor = Color.LightCoral;
}
else if (koltuk.Name.Contains("koltuk"))
{
koltuk.Enabled = true;
koltuk.FlatAppearance.MouseDownBackColor = Color.Olive;
koltuk.FlatAppearance.MouseOverBackColor = Color.Olive;
koltuk.BackColor = Color.Olive;
}
}
}
}
dr.Close();
}
private void FrmFragmanEkle_Load(object sender, EventArgs e)
{
cmd = new OleDbCommand();
cmd.Connection = FrmGiris.conn;
FrmGiris.baglan();
}
