private void filmToolStripMenuItem_Click(object sender, EventArgs e)
{
if (db_cont.BookShopDao.OnlineFelhasznalo != null && db_cont.BookShopDao.OnlineFelhasznalo.admine)
{
using (NewFilm dialog = new NewFilm(this))
{
dialog.ShowDialog(this);
}
}
else
{
MessageBox.Show("Nem vagy bejelentkezve vagy nincs jogosultságod úgy könyv felvételére :/");
}
}
public int AddFilm(string cs, NewFilm newfilm)
{
int AddedByID = 0;
if (newfilm.AddersName == "Kyle")
{
AddedByID = 1;
}
else
{
AddedByID = 2;
}
using var con = new MySqlConnection(cs);
con.Open();
using (MySqlCommand cmd = new MySqlCommand())
{
cmd.Connection = con;
cmd.CommandText = "spAddFilm"; // The name of the Stored Proc
cmd.CommandType = CommandType.StoredProcedure; // It is a Stored Proc
cmd.Parameters.AddWithValue("@FilmName", newfilm.FilmName);
cmd.Parameters.AddWithValue("@ReleaseDate", newfilm.ReleaseDate);
cmd.Parameters.AddWithValue("@AddedDate", newfilm.AddedDate);
cmd.Parameters.AddWithValue("@GenreID", newfilm.GenreID);
cmd.Parameters.AddWithValue("@Watched", newfilm.Watched);
cmd.Parameters.AddWithValue("@AddedByID", AddedByID);
cmd.Parameters.Add("@FilmID", MySqlDbType.Int32);
cmd.Parameters["@FilmID"].Direction = ParameterDirection.Output; // from System.Data
cmd.ExecuteNonQuery();
Object obj = cmd.Parameters["@FilmID"].Value;
var lParam = (Int32)obj; // more useful datatype
con.Close();
return(lParam);
}
}
