public void InsertActor(localMoviesWebService.ActorsDetails actor) //מכניסה שחקן למאגר נתונים
{
string name = actor.Name;
OleDbCommand myCmd = new OleDbCommand("ActorInsInto", myConn);
myCmd.CommandType = CommandType.StoredProcedure;
objParam = myCmd.Parameters.Add("@actorName", OleDbType.BSTR);
objParam.Direction = ParameterDirection.Input;
objParam.Value = name;
try
{
myConn.Open();
myCmd.ExecuteNonQuery();
}
catch (Exception ex)
{
throw ex;
}
finally
{
myConn.Close();
}
}
protected void submit_Click(object sender, EventArgs e)
{
localMoviesWebService.MoviesDetails movie = new localMoviesWebService.MoviesDetails();
string MovieName = movieName.Text;
string Director = director.Text;
string Genre = genres.SelectedValue;
string Description = description.Text;
string actorsList = actors.Text;
string Duration = duration.Text;
string Image = image.Text;
string Trailer = trailer.Text;
movie.MovieName = MovieName;
movie.Director = Director;
movie.MovieGenre = Genre;
movie.Description = Description;
movie.Duration = Duration;
movie.ImgURL = Image;
movie.TrailerURL = Trailer;
localMoviesWebService.MoviesWebService moviesWeb = new localMoviesWebService.MoviesWebService();
moviesWeb.InsertMovie(movie);
string[] arrActorString = actorsList.Split(','); //Split Actors By ','
localMoviesWebService.ActorsDetails[] arrActors = new localMoviesWebService.ActorsDetails[arrActorString.Length];
for (int i = 0; i < arrActors.Length; i++)
{
arrActors[i] = new localMoviesWebService.ActorsDetails();
arrActors[i].Name = arrActorString[i];
arrActors[i].Name.Trim();
if (moviesWeb.ActorGetIDbyName(arrActors[i].Name) == -1)
{
moviesWeb.InsertActor(arrActors[i]);
}
}
int movieID = moviesWeb.GetIDbyName(movie.MovieName);
int firstActorID = moviesWeb.ActorGetIDbyName(arrActors[0].Name);
for (int i = 0; i < arrActors.Length; i++)
{
moviesWeb.InsertActorInMovie(movieID, firstActorID + i);
}
userMsg.Attributes.Add("class", "alert alert-success");
msg = "You Added A Movie";
}
