public void AddStatus(EnumDefine.EmailOrSmsStatusEnum status)
{
if (!CheckStatus(status))
{
Status |= status;
}
}
public async Task ChangeToSendSuccess(string id, DateTime sendDate, EnumDefine.EmailOrSmsStatusEnum status, string response)
{
await WithConnection(async (connection, transaction) =>
{
DynamicParameters parameters = new DynamicParameters();
parameters.Add("@Id", id, DbType.String);
parameters.Add("@SendDate", sendDate, DbType.DateTime);
parameters.Add("@Status", status.AsEnumToInt(), DbType.Int64);
parameters.Add("@Response", response, DbType.String);
var data = await connection.ExecuteAsync(ProcName.EmailSms_SendSuccess, parameters, transaction, commandType: CommandType.StoredProcedure);
return(data);
});
}
public async Task ChangeToSendSuccess(string id, DateTime sendDate, EnumDefine.EmailOrSmsStatusEnum status, string response)
{
await _emailSmsRepository.ChangeToSendSuccess(id, sendDate, status, response);
}
public async Task <REmailSms[]> Search(EnumDefine.EmailOrSmsTypeEnum type, EnumDefine.EmailOrSmsMessageTypeEnum messageType, string phoneNumber, string email, EnumDefine.EmailOrSmsStatusEnum status, DateTime?createdDateUtc, DateTime?sendDate, RefSqlPaging sqlPaging)
{
return(await _emailSmsRepository.Search(type, messageType, phoneNumber, email, status, createdDateUtc, sendDate, sqlPaging));
}
public bool CheckStatus(EnumDefine.EmailOrSmsStatusEnum status)
{
return(Status.HasFlag(status));
}
public async Task <REmailSms[]> Search(EnumDefine.EmailOrSmsTypeEnum type, EnumDefine.EmailOrSmsMessageTypeEnum messageType, string phoneNumber, string email, EnumDefine.EmailOrSmsStatusEnum status, DateTime?createdDateUtc, DateTime?sendDate, RefSqlPaging sqlPaging)
{
return(await WithConnection(async (connection) =>
{
DynamicParameters parameters = new DynamicParameters();
parameters.Add("@Type", type, DbType.Int32);
parameters.Add("@MessageType", messageType, DbType.Int32);
parameters.Add("@PhoneNumber", phoneNumber, DbType.String);
parameters.Add("@Email", email, DbType.String);
parameters.Add("@Status", status.AsEnumToInt(), DbType.Int32);
parameters.Add("@CreatedDateUtc", createdDateUtc, DbType.DateTime);
parameters.Add("@SendDate", sendDate, DbType.DateTime);
parameters.Add("@OFFSET", sqlPaging.OffSet, DbType.Int32);
parameters.Add("@FETCH", sqlPaging.PageSize, DbType.Int32);
var data = (await connection.QueryAsync <REmailSms>(ProcName.EmailSms_Search, parameters, commandType: CommandType.StoredProcedure)).ToArray();
if (data.Length > 0)
{
sqlPaging.TotalRow = data[0].TotalRow;
}
return data;
}));
}
