/// <summary>
/// Exec [EmailFax].[uspUpdate_PM_Server_LastBounceCheck_DT]
/// </summary>
/// <param name="iServerKey"></param>
private async Task UpdateServer(int iServerKey)
{
var lstParameters = new List <IDbDataParameter>();
using (var oSqlDataAdapter = new SqlDataAdapter(this.ConnectionString))
{
var oSqlParameter = oSqlDataAdapter.AddParameter("@Server_PK", DbType.Int32, iServerKey, ParameterDirection.Input);
lstParameters.Add(oSqlParameter);
await oSqlDataAdapter.ExecuteNonQueryAsync("[EmailFax].[uspPM_Update_Server_LastBounceCheck_DT]", lstParameters);
}
}
public async Task RecordLogin(string sUserID, bool bSuccess)
{
var lstParameters = new List <IDbDataParameter>();
using (var oSqlDataAdapter = new SqlDataAdapter(this.ConnectionString))
{
var oSqlParameter = oSqlDataAdapter.AddParameter("@User_Name", DbType.String, sUserID, ParameterDirection.Input, 25);
lstParameters.Add(oSqlParameter);
oSqlParameter = oSqlDataAdapter.AddParameter("@Status", DbType.Boolean, bSuccess, ParameterDirection.Input);
lstParameters.Add(oSqlParameter);
await oSqlDataAdapter.ExecuteNonQueryAsync("[ES].[usp_ins_LoginHistory]", lstParameters);
}
}
/// <summary>
/// Execute [EmailFax].[uspBounce_Insert]
/// </summary>
/// <param name="iServerKey"></param>
/// <param name="guidMessageID"></param>
/// <param name="sBounceType"></param>
/// <param name="sBounceDescription"></param>
/// <param name="sBounceDetails"></param>
/// <param name="sSendTo"></param>
/// <param name="sSendFrom"></param>
/// <param name="dtBounce"></param>
/// <param name="sSubject"></param>
/// <returns></returns>
public async Task RecordBounce(int iServerKey, Guid guidMessageID, string sBounceType, string sBounceDescription, string sBounceDetails,
string sSendTo, string sSendFrom, DateTime dtBounce, string sSubject, StreamWriter oLogStreamWriter)
{
var lstParameters = new List <IDbDataParameter>();
using (var oSqlDataAdapter = new SqlDataAdapter(this.ConnectionString))
{
var oSqlParameter = oSqlDataAdapter.AddParameter("@PM_Server_FK", DbType.Int32, iServerKey, ParameterDirection.Input);
lstParameters.Add(oSqlParameter);
oSqlParameter = oSqlDataAdapter.AddParameter("@MessageID", DbType.Guid, guidMessageID, ParameterDirection.Input);
lstParameters.Add(oSqlParameter);
oSqlParameter = oSqlDataAdapter.AddParameter("@BounceType", DbType.String, sBounceType, ParameterDirection.Input);
lstParameters.Add(oSqlParameter);
oSqlParameter = oSqlDataAdapter.AddParameter("@BounceDescription", DbType.String, sBounceDescription, ParameterDirection.Input);
lstParameters.Add(oSqlParameter);
oSqlParameter = oSqlDataAdapter.AddParameter("@BounceDetails", DbType.String, sBounceDetails, ParameterDirection.Input);
lstParameters.Add(oSqlParameter);
oSqlParameter = oSqlDataAdapter.AddParameter("@SendTo", DbType.StringFixedLength, sSendTo, ParameterDirection.Input, 255);
lstParameters.Add(oSqlParameter);
oSqlParameter = oSqlDataAdapter.AddParameter("@SendFrom", DbType.StringFixedLength, sSendFrom, ParameterDirection.Input, 255);
lstParameters.Add(oSqlParameter);
oSqlParameter = oSqlDataAdapter.AddParameter("@Bounce_DT", DbType.DateTime, dtBounce, ParameterDirection.Input);
lstParameters.Add(oSqlParameter);
oSqlParameter = oSqlDataAdapter.AddParameter("@BounceSubject", DbType.String, sSubject, ParameterDirection.Input);
lstParameters.Add(oSqlParameter);
string sProc = "[EmailFax].[uspPMBounce_Insert]";
try
{
await oSqlDataAdapter.ExecuteNonQueryAsync("[EmailFax].[uspPM_Bounce_Insert]", lstParameters);
sProc = "[EmailFax].[uspPM_Update_Server_LastBounceCheck_DT]";
await UpdateServer(iServerKey);
}
catch (Exception oException)
{
oLogStreamWriter.WriteLine($"{sProc} - {oException.Message}");
}
}
}
public async Task Update(int iRunID, string sCustomerID, string sStatus)
{
var lstParameters = new List <IDbDataParameter>();
using (var oSqlDataAdapter = new SqlDataAdapter(this.ConnectionString))
{
var oSqlParameter = oSqlDataAdapter.AddParameter("@Key", DbType.Int32, iRunID, ParameterDirection.Input);
lstParameters.Add(oSqlParameter);
oSqlParameter = oSqlDataAdapter.AddParameter("@Cust_ID", DbType.StringFixedLength, sCustomerID, ParameterDirection.Input, 8);
lstParameters.Add(oSqlParameter);
oSqlParameter = oSqlDataAdapter.AddParameter("@Status", DbType.StringFixedLength, sStatus, ParameterDirection.Input, 15);
lstParameters.Add(oSqlParameter);
await oSqlDataAdapter.ExecuteNonQueryAsync("[ES].[usp_updStop]", lstParameters);
}
}
public async Task UpdateLastRun(string sServerKey, StreamWriter oLogStreamWriter)
{
var lstParameters = new List <IDbDataParameter>();
using (var oSqlDataAdapter = new SqlDataAdapter(this.ConnectionString))
{
var oSqlParameter = oSqlDataAdapter.AddParameter("@sync_Type", DbType.StringFixedLength, sServerKey, ParameterDirection.Input, 10);
lstParameters.Add(oSqlParameter);
string sProc = "[Sync].[uspMonitor_Update_LastRun]";
try
{
await oSqlDataAdapter.ExecuteNonQueryAsync("[Sync].[uspMonitor_Update_LastRun]", lstParameters);
}
catch (Exception oException)
{
oLogStreamWriter.WriteLine($"{sProc} - {oException.Message}");
}
}
}
