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); } }
public async Task <IDataReader> Authenticate(string sUserID, string sPassword) { 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); byte[] aPasswordBytes = Md5Hash.Current.Compute(sPassword); oSqlParameter = oSqlDataAdapter.AddParameter("@Password", DbType.Binary, aPasswordBytes, ParameterDirection.Input); lstParameters.Add(oSqlParameter); return(await oSqlDataAdapter.QueryAsync("[ES].[usp_sel_GetAuthenticatedUser]", lstParameters)); } }
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 <IDataReader> Update(int iRunNo, string sNote, byte[] aSignature) { var lstParameters = new List <IDbDataParameter>(); using (var oSqlDataAdapter = new SqlDataAdapter(this.ConnectionString)) { var oSqlParameter = oSqlDataAdapter.AddParameter("@Run_No", DbType.Int32, iRunNo, ParameterDirection.Input); lstParameters.Add(oSqlParameter); oSqlParameter = oSqlDataAdapter.AddParameter("@Note", DbType.String, sNote, ParameterDirection.Input); lstParameters.Add(oSqlParameter); oSqlParameter = oSqlDataAdapter.AddParameter("@Signature", DbType.Binary, aSignature, ParameterDirection.Input, -1); lstParameters.Add(oSqlParameter); return(await oSqlDataAdapter.QueryAsync("[ES].usp_updDLog_RunHeader", 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 <IDataReader> List(int iRunID) { var lstParameters = new List <IDbDataParameter>(); using (var oSqlDataAdapter = new SqlDataAdapter(this.ConnectionString)) { var oSqlParameter = oSqlDataAdapter.AddParameter("@RunNumber", DbType.Int32, iRunID, ParameterDirection.Input); lstParameters.Add(oSqlParameter); return(await oSqlDataAdapter.QueryAsync("[ES].[usp_selDriverStops]", lstParameters)); } }
public async Task <IDataReader> List(string sLocationCode) { var lstParameters = new List <IDbDataParameter>(); using (var oSqlDataAdapter = new SqlDataAdapter(this.ConnectionString)) { var oSqlParameter = oSqlDataAdapter.AddParameter("@LocationCode", DbType.String, sLocationCode, ParameterDirection.Input, 2); lstParameters.Add(oSqlParameter); return(await oSqlDataAdapter.QueryAsync("[ES].[usp_selStatuses]", lstParameters)); } }
public async Task <IDataReader> Get(int iRunNo) { var lstParameters = new List <IDbDataParameter>(); using (var oSqlDataAdapter = new SqlDataAdapter(this.ConnectionString)) { var oSqlParameter = oSqlDataAdapter.AddParameter("@Run_No", DbType.Int32, iRunNo, ParameterDirection.Input); lstParameters.Add(oSqlParameter); return(await oSqlDataAdapter.QueryAsync("[ES].[usp_chkDLog_GetRunInfo]", lstParameters)); } }
public async Task <IDataReader> GetRunInfo(string sDriverCode) { var lstParameters = new List <IDbDataParameter>(); using (var oSqlDataAdapter = new SqlDataAdapter(this.ConnectionString)) { var oSqlParameter = oSqlDataAdapter.AddParameter("@Drv_CD", DbType.String, sDriverCode, ParameterDirection.Input, 4); lstParameters.Add(oSqlParameter); return(await oSqlDataAdapter.QueryAsync("[ES].[usp_sel_GetDriverInfo]", lstParameters)); } }
/// <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 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}"); } } }