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 + ")"); } } }