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