private void findButton_Click(object sender, EventArgs e)
{
SqlConnection con = new SqlConnection("Data Source=.;Initial Catalog=IMDB_DB;Integrated Security=True");
SqlCommand cmd;
SqlDataReader dr;
string sqlString = "";
con.Open();
sqlString = "SELECT m_no,name FROM Movies WHERE name=@name";
cmd = new SqlCommand(sqlString, con);
cmd.Parameters.AddWithValue("@name", searchTextBox.Text);
dr = cmd.ExecuteReader();
dr.Read();
if (dr.HasRows)
{
DetailsMovieForm detailMovie = new DetailsMovieForm();
detailMovie.gelenM_No = dr[0].ToString();
detailMovie.gelenU_No = gelenU_No;
detailMovie.ShowDialog();
}
else
{
MessageBox.Show("Aradığınız film bulunamadı.");
}
con.Close();
}
private void coverPictureBox_Click(object sender, EventArgs e)
{
DetailsMovieForm detailMovie = new DetailsMovieForm();
detailMovie.gelenM_No = comingSoonMovie[comingSoonCounter].getM_no();
detailMovie.gelenU_No = user.getU_No();
detailMovie.ShowDialog();
}
private void knownForPictureBox4_Click(object sender, EventArgs e)
{
DetailsMovieForm detailMovie = new DetailsMovieForm();
detailMovie.gelenM_No = knownForInformation[3, 2];
detailMovie.gelenU_No = gelenU_No;
this.Close();
detailMovie.Show();
}
private void movieCover_Click(object sender, EventArgs e)
{
string m_no = "";
PictureBox ogren = sender as PictureBox;
m_no = ogren.Name.Substring(0, ogren.Name.IndexOf("@"));
DetailsMovieForm detailMovie = new DetailsMovieForm();
detailMovie.gelenM_No = m_no;
detailMovie.gelenU_No = user.getU_No();
detailMovie.ShowDialog();
}
private void nameLabel_Click(object sender, EventArgs e)
{
string m_no = "";
Label ogren = sender as Label;
m_no = ogren.Name.Substring(0, ogren.Name.IndexOf("@"));
DetailsMovieForm detailMovie = new DetailsMovieForm();
detailMovie.gelenM_No = m_no;
detailMovie.gelenU_No = user.getU_No();
detailMovie.ShowDialog();
}
private void findButton_Click(object sender, EventArgs e)
{
SqlConnection con = new SqlConnection("Data Source=.;Initial Catalog=IMDB_DB;Integrated Security=True");
SqlCommand cmd;
SqlDataReader dr;
string sqlString = "";
con.Open();
if (searchTypeComboBox.SelectedIndex == 1)
{
sqlString = "SELECT m_no,name FROM Movies WHERE name=@name";
cmd = new SqlCommand(sqlString, con);
cmd.Parameters.AddWithValue("@name", searchTextBox.Text);
dr = cmd.ExecuteReader();
dr.Read();
if (dr.HasRows)
{
DetailsMovieForm detailMovie = new DetailsMovieForm();
detailMovie.gelenM_No = dr[0].ToString();
detailMovie.gelenU_No = user.getU_No();
detailMovie.ShowDialog();
}
else
{
MessageBox.Show("Aradığınız film bulunamadı.");
}
con.Close();
}
else
{
sqlString = "SELECT h_no,name,l_name FROM Human WHERE name=@name AND l_name=@l_name";
cmd = new SqlCommand(sqlString, con);
string name, lname;
if (searchTextBox.TextLength < 3)
{
MessageBox.Show("Lütfen aranacak kişinin isim ve soyadını giriniz.");
}
else
{
int temp = searchTextBox.Text.IndexOf(" ");
name = searchTextBox.Text.Substring(0, temp);
temp++;
lname = searchTextBox.Text.Substring(temp, searchTextBox.Text.Length - temp);
cmd.Parameters.AddWithValue("@name", name);
cmd.Parameters.AddWithValue("@l_name", lname);
dr = cmd.ExecuteReader();
dr.Read();
if (dr.HasRows)
{
DetailsHumanForm detailHuman = new DetailsHumanForm();
detailHuman.gelenH_No = dr[0].ToString();
detailHuman.gelenU_No = user.getU_No();
detailHuman.ShowDialog();
}
else
{
MessageBox.Show("Aradığınız kişi bulunamadı.");
}
con.Close();
}
}
}
