public string GetFinCocode()
{
var request = new TableApiRequest()
{
TableName = "FinancialCompanies",
ColumnNames = "CompanyCode",
PredicateRows = new List <DynamicPredicateRowApi>
{
new DynamicPredicateRowApi
{
Display = true,
LeftOperand = "Description",
Operator = DynamicPredicateRowApiOperator.Eq,
RightOperand = new List <string> {
ServerConnection.Current.GetCompany().CompanyName
}
}
},
Page = 1,
Rows = 1
};
var result = wbClient.TableApi_PostAsync(request);
if (result.Result.Rows.Count() != 0)
{
return(result.Result.Rows.FirstOrDefault().Key.KeyValue);
}
return("01");
}
public void SaveFinCocode()
{
var httpClient = new HttpClient()
{
BaseAddress = new Uri(ConfigurationManager.AppSettings["WorkbenchUrl"])
};
httpClient.DefaultRequestHeaders.Authorization = !string.IsNullOrEmpty(ConfigurationManager.AppSettings["WorkbenchApiKey"]) ?
new AuthenticationHeaderValue("Bearer ", ConfigurationManager.AppSettings["WorkbenchApiKey"]) :
new AuthenticationHeaderValue("Basic", (ConfigurationManager.AppSettings["WorkbenchUserName"] + ":" + ConfigurationManager.AppSettings["WorkbenchPassword"].FromBase64()).ToBase64());
var wbClient = new Client(httpClient);
var request = new TableApiRequest()
{
TableName = "FinancialCompanies",
ColumnNames = "CompanyCode",
PredicateRows = new List <DynamicPredicateRowApi>
{
new DynamicPredicateRowApi
{
Display = true,
LeftOperand = "Description",
Operator = DynamicPredicateRowApiOperator.Eq,
RightOperand = new List <string> {
ServerConnection.Current.GetCompany().CompanyName
}
}
},
Page = 1,
Rows = 1
};
var result = wbClient.TableApi_PostAsync(request);
var finCo = "";
if (result.Result.Rows.Count() != 0)
{
finCo = result.Result.Rows.FirstOrDefault().Key.KeyValue;
}
SettingsModelList.SetFinCoCode(finCo);
}
