private void WriteFailed(DbCommand sp, FailedEmailDto email) { _dbLayer.AddParameter(sp, "@questionnaire_FK", ParameterDirection.Input, DbType.Int32, email.QuestionnaireFK); _dbLayer.AddParameter(sp, "@email_text", ParameterDirection.Input, DbType.String,email.EmailText); _dbLayer.AddParameter(sp, "@email_format", ParameterDirection.Input, DbType.String, email.EmailFormat); }
private FailedEmailDto ReadFailed(IDataReader reader, ref bool alreadyRead) { FailedEmailDto retval = null; int questionnaireFK = reader.GetInt32(0); string emailText = reader.GetString(1); DateTime failureDate = reader.GetDateTime(2); string emailFormat = reader.GetString(3); retval = new FailedEmailDto((long)questionnaireFK, emailText, failureDate, emailFormat); return retval; }
public void CreateFailedEmail(FailedEmailDto email) { DbCommand sp = null; DbConnection connection = null; IDataReader reader = null; try { connection = _dbLayer.GetConnection(); sp = connection.CreateCommand(); sp.CommandText = "insert_failed_email"; sp.CommandType = CommandType.StoredProcedure; WriteFailed(sp, email); _dbLayer.AddReturnParameter(sp); sp.ExecuteNonQuery(); int code = _dbLayer.GetReturnValue(sp); if (code < 0) { Trace.WriteLine("EmailDao.CreateFailedEmail(" + email + "): returned " + code); throw new Exception(code.ToString()); } else { Trace.WriteLine("EmailDao.CreateFailedEmail(" + email + "): returned " + code); } } finally { if (reader != null && !reader.IsClosed) { reader.Close(); } if (sp != null) { sp.Dispose(); } if (connection != null) { _dbLayer.ReturnConnection(connection); } else { _dbLayer.ReturnConnection(connection, true); } } }