public IEnumerable <Order> GetSent()
{
var sql = $"select * from {SchemaName}.{OrdersTableName} where Status='Sent' order by Attempts, CreatedAt";
var orders = new List <Order>();
using (var conn = new SqlConnection(connectionString))
{
var dbOrders = conn.Query(sql);
foreach (var dbOrder in dbOrders)
{
var orderType = enumConverter.ToEnum <OrderType>(dbOrder.Type.ToString().Trim());
var orderStatus = enumConverter.ToEnum <OrderStatus>(dbOrder.Status.ToString().Trim());
orders.Add(new Order
{
MobileId = dbOrder.MobileId,
MobileOrderId = dbOrder.MobileOrderId,
Name = dbOrder.Name,
PhoneNumber = dbOrder.PhoneNumber,
Status = orderStatus,
Type = orderType,
CreatedAt = dbOrder.CreatedAt,
UpdatedAt = dbOrder.UpdatedAt,
Attempts = dbOrder.Attempts
});
}
}
return(orders);
}
public void ConvertStringToEnum(IEnumConverter conv, string input, Enum output)
{
var result = conv.ToEnum(input, typeof(TestEnum));
Assert.AreEqual(output, result);
}
