public async Task <IActionResult> GetPrices([FromBody] Request request,
[FromQuery(Name = "symbol")] string[] symbols,
[FromQuery(Name = "type")] string type = "query")
{
if (string.IsNullOrEmpty(request.ApiKey))
{
return(BadRequest());
}
type = type.ToLower() switch
{
"sell" => "sell",
"buy" => "buy",
_ => "query"
};
var query = new PriceQuery
{
ApiKey = request.ApiKey,
Symbols = symbols,
Type = type
};
await _mediator.Send(query);
return(Ok());
}
}
public void Initialize()
{
cashRegister = new CashRegister();
priceQuery = new PriceQuery(
ItemReference.aReference().withItemCode("APPLE").withUnitPrice(1.20).build(),
ItemReference.aReference().withItemCode("BANANA").withUnitPrice(1.90).build());
}
/// <summary>
/// Test Find using the Query class
/// </summary>
private void Step_30_TestFindByQuery_Generated()
{
using (TransactionManager tm = CreateTransaction())
{
//Insert Mock Instance
Price mock = CreateMockInstance(tm);
bool result = DataRepository.PriceProvider.Insert(tm, mock);
Assert.IsTrue(result, "Could Not Test FindByQuery, Insert Failed");
PriceQuery query = new PriceQuery();
query.AppendEquals(PriceColumn.GoodsId, mock.GoodsId.ToString());
if (mock.Rtprice != null)
{
query.AppendEquals(PriceColumn.Rtprice, mock.Rtprice.ToString());
}
if (mock.Averimppr != null)
{
query.AppendEquals(PriceColumn.Averimppr, mock.Averimppr.ToString());
}
if (mock.Lastimppr != null)
{
query.AppendEquals(PriceColumn.Lastimppr, mock.Lastimppr.ToString());
}
if (mock.Wsprice != null)
{
query.AppendEquals(PriceColumn.Wsprice, mock.Wsprice.ToString());
}
if (mock.Prefprice != null)
{
query.AppendEquals(PriceColumn.Prefprice, mock.Prefprice.ToString());
}
if (mock.Discpercent != null)
{
query.AppendEquals(PriceColumn.Discpercent, mock.Discpercent.ToString());
}
if (mock.DiscFrdate != null)
{
query.AppendEquals(PriceColumn.DiscFrdate, mock.DiscFrdate.ToString());
}
if (mock.DiscTodate != null)
{
query.AppendEquals(PriceColumn.DiscTodate, mock.DiscTodate.ToString());
}
TList <Price> results = DataRepository.PriceProvider.Find(tm, query);
Assert.IsTrue(results.Count == 1, "Find is not working correctly. Failed to find the mock instance");
}
}
public static string LoadAllFoodMonitorSites()
{
try
{
string result = new PriceQuery().GetAllMonitorSites();
return(result);
}
catch (Exception ex)
{
LogHelper.GetInstance().Error(ex.ToString());
var exResult = new { Code = 0, ex.Message };
return(JsonConvert.SerializeObject(exResult));
}
}
public static string LoadFoodMonitorCount(string category, string foodname, string site)
{
try
{
string result = new PriceQuery().GetFoodMonitorCount(string.IsNullOrEmpty(category) ? null : category,
string.IsNullOrEmpty(foodname) ? null : foodname, string.IsNullOrEmpty(site) ? null : site);
return(result);
}
catch (Exception ex)
{
LogHelper.GetInstance().Error(ex.ToString());
var exResult = new { Code = 0, ex.Message };
return(JsonConvert.SerializeObject(exResult));
}
}
public static string LoadFoodByCategory(string category)
{
try
{
string result =
new PriceQuery().FilterFoodsByCategory(string.IsNullOrWhiteSpace(category) ? null : category);
return(result);
}
catch (Exception ex)
{
LogHelper.GetInstance().Error(ex.ToString());
var exResult = new { Code = 0, ex.Message };
return(JsonConvert.SerializeObject(exResult));
}
}
public async Task <IActionResult> GetPricesDemo([FromQuery(Name = "symbol")] string[] symbols,
[FromQuery(Name = "type")] string type = "query")
{
type = type.ToLower() switch
{
"sell" => "sell",
"buy" => "buy",
_ => "query"
};
var query = new PriceQuery
{
Symbols = symbols,
ApiKey = _default.ApiKey,
Type = type
};
await _mediator.Send(query);
return(Ok());
}
void AfterUnload(PriceQuery sch, string TableName, int LastVersion)
{
if (sch.InsertStatments == null)
return;
using (SqlConnection conn = new SqlConnection(ConfigurationManager.ConnectionStrings["apt"].ConnectionString))
{
if (conn.State != ConnectionState.Open)
conn.Open();
using (SqlCommand cmd = conn.CreateCommand())
{
cmd.CommandText = string.Format(sch.InsertStatments, TableName);
cmd.Parameters.Add("ImportSession", SqlDbType.Int).Value = LastVersion;
foreach (var variable in sch.Variables)
{
cmd.Parameters.Add(variable.Key, SqlDbType.VarChar).Value = variable.Value;
}
cmd.ExecuteNonQuery();
}
}
Log.Info("Изменения сохранены " + scheme.Type + ": " + LastVersion);
}
bool Upload(PriceQuery query, DataTable dt, int LastVersion)
{
if (!TableCreator.BulkData(scheme, dt, p => AfterUnload(query, p, LastVersion)))
{
Log.Error("Изменения не зафиксированы " + scheme.Type + " " + query.Name);
return false;
}
return true;
}
private void FoodPriceBinding()
{
var query = new PriceQuery();
string json = query.GetFoodMonitorCount("蔬菜", null, null);
var source = new List <FoodPriceVo>();
int count = 0;
if (json.JObjCodeTrue())
{
count = json.JobjMessageConvert <int>();
if (count > 0)
{
json = query.GetFoodMonitorsByPage("蔬菜", null, null, 1, 1);
var food1 = (from item in json.JObjMessageToken()
select new FoodPriceVo
{
Category = "蔬菜",
Food = item["FoodName"].ValueOrDefault <string>(),
Price = item["Price"].ValueOrDefault <string>(),
Unit = item["Unit"].ValueOrDefault <string>(),
Site = item["SiteName"].ValueOrDefault <string>(),
Count = count
}).FirstOrDefault();
source.Add(food1);
}
}
json = query.GetFoodMonitorCount("肉", null, null);
if (json.JObjCodeTrue())
{
count = json.JobjMessageConvert <int>();
if (count > 0)
{
json = query.GetFoodMonitorsByPage("肉", null, null, 1, 1);
var food1 = (from item in json.JObjMessageToken()
select new FoodPriceVo
{
Category = "肉",
Food = item["FoodName"].ValueOrDefault <string>(),
Price = item["Price"].ValueOrDefault <string>(),
Unit = item["Unit"].ValueOrDefault <string>(),
Site = item["SiteName"].ValueOrDefault <string>(),
Count = count
}).FirstOrDefault();
source.Add(food1);
}
}
json = query.GetFoodMonitorCount("鱼", null, null);
if (json.JObjCodeTrue())
{
count = json.JobjMessageConvert <int>();
if (count > 0)
{
json = query.GetFoodMonitorsByPage("鱼", null, null, 1, 1);
var food1 = (from item in json.JObjMessageToken()
select new FoodPriceVo
{
Category = "鱼",
Food = item["FoodName"].ValueOrDefault <string>(),
Price = item["Price"].ValueOrDefault <string>(),
Unit = item["Unit"].ValueOrDefault <string>(),
Site = item["SiteName"].ValueOrDefault <string>(),
Count = count
}).FirstOrDefault();
source.Add(food1);
}
}
json = query.GetFoodMonitorCount("蛋", null, null);
if (json.JObjCodeTrue())
{
count = json.JobjMessageConvert <int>();
if (count > 0)
{
json = query.GetFoodMonitorsByPage("蛋", null, null, 1, 1);
var food1 = (from item in json.JObjMessageToken()
select new FoodPriceVo
{
Category = "蛋",
Food = item["FoodName"].ValueOrDefault <string>(),
Price = item["Price"].ValueOrDefault <string>(),
Unit = item["Unit"].ValueOrDefault <string>(),
Site = item["SiteName"].ValueOrDefault <string>(),
Count = count
}).FirstOrDefault();
source.Add(food1);
}
}
json = query.GetFoodMonitorCount("水果", null, null);
if (json.JObjCodeTrue() && count > 0)
{
count = json.JobjMessageConvert <int>();
if (count > 0)
{
json = query.GetFoodMonitorsByPage("水果", null, null, 1, 1);
var food1 = (from item in json.JObjMessageToken()
select new FoodPriceVo
{
Category = "水果",
Food = item["FoodName"].ValueOrDefault <string>(),
Price = item["Price"].ValueOrDefault <string>(),
Unit = item["Unit"].ValueOrDefault <string>(),
Site = item["SiteName"].ValueOrDefault <string>(),
Count = count
}).FirstOrDefault();
source.Add(food1);
}
}
RepeaterFood.DataSource = source;
RepeaterFood.DataBind();
}
