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