public IActionResult MicroServiceProcessOPLDFile(List <OPLD> opldObjectList)
        {
            try
            {
                //Push OPLD in DB
                SakilaContext context = new SakilaContext("server=127.0.01;port=3306;database=ams;user=root;password=techM@Ups1");
                //SakilaContext context = new SakilaContext("server=techm.cooavdyjxzoz.us-east-1.rds.amazonaws.com;port=3306;database=ams;user=root;password=Password123");

                foreach (var opldObject in opldObjectList)
                {
                    var addOPLDResult = context.AddNewOPLD(opldObject);
                    if (addOPLDResult.Item1)
                    {
                        opldObject.Packages.ForEach(m => m.OPLDId = addOPLDResult.Item2);

                        context.AddNewOPLDPackages(opldObject.Packages);
                    }
                }

                log.Info(DateTime.Now.ToString() + " AMS-POC-MicroServiceProcessOPLDNDIALSFiles: OPLD Data inserted in DB.");

                //Push OPLD in to Active MQ2
                CommonUtility <OPLD> .PushToActiveMQ(opldObjectList, 1);

                log.Info(DateTime.Now.ToString() + " AMS-MicroServiceProcessOPLDNDIALSFiles: OPLD message pushed to MQ.");
            }
            catch (Exception ex)
            {
                log.Error(DateTime.Now.ToString() + " AMS-MicroServiceProcessOPLDNDIALSFiles: " + Convert.ToString(ex.Message));
                return(new JsonResult(new { Result = System.Net.HttpStatusCode.InternalServerError }));
            }

            return(Ok(new { Result = "Success" }));
        }