private bool SaveToDB(string ePaymentSessionId, LoginInfo info, Collection<InvoiceDetails> invoicesCurent, string email) { try { var myOracle = new MyOracle(ConfigurationManager.ConnectionStrings["OracleConnString"].ToString()); var isSuccess = myOracle.CreateEPayment(ePaymentSessionId, email, info.MSISDN); if (!isSuccess) { return false; } foreach (var inv in invoicesCurent) { myOracle = new MyOracle(ConfigurationManager.ConnectionStrings["OracleConnString"].ToString()); var orderId = myOracle.GenerateOrderId(); myOracle = new MyOracle(ConfigurationManager.ConnectionStrings["OracleConnString"].ToString()); isSuccess = myOracle.CreateEPaymentDetails( orderId, ePaymentSessionId, inv.Invoice_Ref_Number, Convert.ToDecimal(inv.Invoice_Unbilled_Amount)); if (!isSuccess) { return false; } } } catch (Exception ex) { //Utils.LogError(ex); return false; } return true; }