private static ValidationResponse MakeDataAccessValidation(Func <object[], object> method, object[] parameters) { var vr = new ValidationResponse(); try { //abrir conexion //iniciar la conexion if (method != null) { var result = method(parameters); vr.Exito(result); } //commit } catch (Exception ex) { //rollback vr.Error(ex.Message); MailSender.SendErrorMail(ex); } return(vr); }
private static ValidationResponse MakeBusinessMethodValidation_NoParams(Func <ValidationResponse> method) { var vr = new ValidationResponse(); try { if (method != null) { vr = method(); } } catch (Exception ex) { vr.Error(ex.Message); MailSender.SendErrorMail(ex); } return(vr); }
private static ValidationResponse MakeOracleDataAccessValidation2(Func <object[], object> method, object[] parameters) { var vr = new ValidationResponse(); try { if (method != null) { vr = (ValidationResponse)method(parameters); } } catch (Exception ex) { vr.Error(ex.Message); MailSender.SendErrorMail(ex); } return(vr); }
//CLEVER //private static ValidationResponse MakeOracleDataAccessValidation(OracleConnection connection, Func<OracleConnection, object[], object> method, object[] parameters) //{ // var vr = new ValidationResponse(); // try // { // if (method != null) // { // using (var cnx = connection) // { // // Iniciar la conexion // if (cnx.State != ConnectionState.Open) // cnx.Open(); // // Iniciar la transacción // var tx = cnx.BeginTransaction(IsolationLevel.ReadCommitted); // try // { // // Ejecutamos la lógica de Acceso a Datos // var result = method(cnx, parameters); // vr.Exito(result); // // Realizamos el Commit // tx.Commit(); // } // catch (Exception ex) // { // //rollback // tx.Rollback(); // vr.Error(ex.Message); // MailSender.SendErrorMail(ex); // } // } // } // } // catch (Exception ex) // { // vr.Error(ex.Message); // MailSender.SendErrorMail(ex); // } // return vr; //} private static ValidationResponse MakeDataAccessMethodValidation_NoParams(Func <object> method) { var vr = new ValidationResponse(); try { if (method != null) { var result = method(); vr.Exito(result); } } catch (Exception ex) { vr.Error(ex.Message); MailSender.SendErrorMail(ex); } return(vr); }
private static ValidationResponse MakeBusinessMethodValidation(Func <object[], ValidationResponse> method, object[] parameters) { var vr = new ValidationResponse(); try { if (method != null) { vr = method(parameters); } } catch (Exception ex) { vr.Error(ex.Message); MailSender.SendErrorMail(ex); } return(vr); }