public EmailOrSmsBaseCommand(EnumDefine.EmailOrSmsTypeEnum type, EnumDefine.EmailOrSmsMessageTypeEnum messageType, string phoneNumber, string email)
{
Type = type;
MessageType = messageType;
PhoneNumber = phoneNumber;
Email = email;
}
public void AddMessageType(EnumDefine.EmailOrSmsMessageTypeEnum messageType)
{
if (!CheckMessageType(messageType))
{
MessageType |= messageType;
}
}
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;
}));
}
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 CheckMessageType(EnumDefine.EmailOrSmsMessageTypeEnum messageType)
{
return(MessageType.HasFlag(messageType));
}
