public void enterEditDataDAL(movies movie, List <actors> actors, List <actors> newActors, producers producer)
{
using (movieDAL dal = new movieDAL())
{
//dal.Database.ExecuteSqlCommand("insert into movieNProducer(movieId, producerId) values(" + movieId[0].movieId + "," + prodId[0].producerId + ")");
var sqlMovie = @"Update movies set movieName = {0}, yor = {1}, plot = {2}, path = {3} where movieId = {4}";
dal.Database.ExecuteSqlCommand(sqlMovie, movie.movieName, movie.yor, movie.plot, movie.path, movie.movieId);
var sqlProducer = @"Update producers set producerName = {0}, producerSex = {1}, producerDOB = {2}, producerInfo = {3} where producerId = {4}";
dal.Database.ExecuteSqlCommand(sqlProducer, producer.producerName, producer.producerSex, producer.producerDOB, producer.producerInfo, producer.producerId);
foreach (actors actor in actors)
{
var sqlActor = @"Update actors set actorName = {0}, actorSex = {1}, actorDOB = {2}, actorInfo = {3} where actorId = {4}";
dal.Database.ExecuteSqlCommand(sqlActor, actor.actorName, actor.actorSex, actor.actorDOB, actor.actorInfo, actor.actorId);
}
foreach (actors actor in newActors)
{
dal.Database.ExecuteSqlCommand("insert into actors(actorName, actorSex, actorDOB, actorInfo) values('" + actor.actorName +
"','" + actor.actorSex + "','" + actor.actorDOB + "','" + actor.actorInfo + "')");
var actorId = dal.Actors.SqlQuery("Select * from actors where actorName=@p0", actor.actorName).ToList <actors>();
dal.Database.ExecuteSqlCommand("insert into movieNActor(movieId, actorId) values(" + movie.movieId + "," + actorId[0].actorId + ")");
}
}
}
public void enterDataDAL(string movieName, List <string> actorName, string producerName)
{
using (movieDAL dal = new movieDAL())
{
var prodId = dal.Producers.SqlQuery("Select * from producers where producerName=@p0", producerName).ToList <producers>(); //working
var movieId = dal.Movies.SqlQuery("Select * from movies where movieName =@p0", movieName).ToList <movies>(); //working
dal.Database.ExecuteSqlCommand("insert into movieNProducer(movieId, producerId) values(" + movieId[0].movieId + "," + prodId[0].producerId + ")");
foreach (string actor in actorName)
{
var actorId = dal.Actors.SqlQuery("Select * from actors where actorName=@p0", actor).ToList <actors>();
dal.Database.ExecuteSqlCommand("insert into movieNActor(movieId, actorId) values(" + movieId[0].movieId + "," + actorId[0].actorId + ")");
}
}
}