public ActorProducerDetails getProducerActorMethod()
{
ActorProducerDetails actorproducerDetails = new ActorProducerDetails();
SqlConnection sqlconnection = null;
try
{
List <ActorData> actorList = new List <ActorData>();
List <ProducerData> producerList = new List <ProducerData>();
List <Task> tableFetch = new List <Task>();
using (sqlconnection = sqlsetup.SqlConnectionSetup())
{
sqlconnection.Open();
tableFetch.Add(Task.Run(() => {
actorList = sqlconnection.Query <ActorData>("SELECT * FROM IMDB.dbo.Actors;").ToList();
}));
tableFetch.Add(Task.Run(() =>
{
producerList = sqlconnection.Query <ProducerData>("SELECT * FROM IMDB.dbo.Producers;").ToList();
}));
Task.WaitAll(tableFetch.ToArray());
}
actorproducerDetails.actorList = new List <ActorData>(actorList);
actorproducerDetails.producerList = new List <ProducerData>(producerList);
}
catch {
}
finally
{
sqlconnection.Close();
}
return(actorproducerDetails);
}
public IHttpActionResult getActorProducerDetails()
{
ActorProducerDetails actorproducerdetails = moviedata.getProducerActorMethod();
return(Ok(actorproducerdetails));
}
