private async Task <string> CreateOrder(Product product)
{
var order = new Order()
{
Id = Guid.NewGuid().ToString(),
ProductId = product.Id,
Status = 1,
Time = DateTimeOffset.Now.ToUnixTimeSeconds(),
};
var request = new SqlessEditRequest()
{
Table = Tables.Order,
AccessParams = new string[] { User.Uid, User.Password },
};
request.LoadFromObject(order);
try
{
await SqlessClient.Insert(request);
return(order.Id);
}
catch (Exception ex)
{
MessageBox.Show(ex.Message);
return(null);
}
}
public async void Init()
{
var request = new SqlessSelectRequest()
{
AccessParams = new string[] { WpfGlobal.LoginUser.Uid, WpfGlobal.LoginUser.Password },
Table = Tables.Order
};
request.LoadFromType(typeof(Order));
try {
var orders = await SqlessClient.Select <Order>(request);
foreach (var order in orders)
{
Orders.Add(order);
}
} catch (SqlessRequestException ex) {
MessageBox.Show(ex.Message);
}
}
private async Task <bool> Payment(string orderId)
{
var request = new SqlessEditRequest()
{
Table = Tables.Order,
AccessParams = new string[] { User.Uid, User.Password },
Fields = new System.Collections.Generic.List <SqlessEditField>()
{
new SqlessEditField()
{
Field = nameof(Order.Status),
Value = 2,
Type = System.Data.DbType.Int32
}
},
Queries = new System.Collections.Generic.List <SqlessQuery>()
{
new SqlessQuery()
{
Field = nameof(Product.Id),
Type = SqlessQueryType.Equal,
Value = orderId
}
}
};
try
{
await SqlessClient.Update(request);
return(true);
}
catch (Exception ex)
{
MessageBox.Show(ex.Message);
return(false);
}
}
public async void Init()
{
var request = new SqlessSelectRequest()
{
AccessParams = new string[] { User.Uid, User.Password },
Table = Tables.Product
};
request.LoadFromType(typeof(Product));
try
{
var products = await SqlessClient.Select <Product>(request);
foreach (var product in products)
{
Products.Add(product);
}
}
catch (SqlessRequestException ex)
{
MessageBox.Show(ex.Message);
}
}
