public string fnChangeInsert(SalesM salesM)
{
string sSql = " INSERT INTO [dbo].[MNDTsales_master] " +
" ([order_id] " +
" ,[id] " +
" ,[pay] " +
" ,[order_status] " +
" ,[datetime] " +
" ,[complete] " +
" ,[description] " +
" ,[create_id] " +
" ,[create_datetime]) " +
" SELECT TOP 1 [order_id] " +
" ,'" + salesM.create_id + "' " +
" ,'' " +
" ,'' " +
" ,GETDATE() " +
" ,'N' " +
" ,'' " +
" ,'" + salesM.create_id + "' " +
" ,GETDATE() " +
" FROM [MNDTquotes_master] " +
" WHERE order_id = '" + salesM.order_id + "' ";
sSql +=
" INSERT INTO [MNDTsales_details] " +
" ([seq] " +
" ,[order_id] " +
" ,[product_id] " +
" ,[warehouse_id] " +
" ,[amount] " +
" ,[price] " +
" ,[description] " +
" ,[create_id] " +
" ,[create_datetime] " +
" ,[modify_id] " +
" ,[modify_datetime]) " +
" SELECT Row_number() OVER(ORDER BY[product_id] ASC) NUM " +
" ,[order_id] " +
" ,[product_id] " +
" ,'' " +
" ,[modify_amount] " +
" ,[modify_price] " +
" ,'' " +
" ,'" + salesM.create_id + "' " +
" ,GETDATE() " +
" ,'" + salesM.create_id + "' " +
" ,GETDATE() " +
" FROM [MNDTquotes_details] " +
" WHERE order_id = '" + salesM.order_id + "' ";
return(PublicApi.fnExecuteSQL(sSql, "MNDT"));
}
public string fnDelete(KindM kindM)
{
string sDetailsSql = " SELECT COUNT([kind_id]) FROM [MNDTkind_details] WHERE [kind_id] = '" + kindM.kind_id + "' ";
string sCount = PublicApi.fnGetValue(sDetailsSql, "MNDT");
if (sCount == "0")
{
string sSql = " DELETE [MNDTkind_master] " +
" WHERE [kind_id] = '" + kindM.kind_id + "' ";
return(PublicApi.fnExecuteSQL(sSql, "MNDT"));
}
return("錯誤訊息：明細資料大於一筆。");
}
public string fnGetSeq(string sReturnId)
{
string sCondition = "";
sCondition += PublicApi.fnAddCondition("[return_id]", sReturnId);
string sSql =
" SELECT ISNULL(MAX([seq]), 0) + 1 " +
" FROM [MNDTSreturn_details] AS [return_d] " +
" WHERE 1 = 1 " + sCondition;
return(PublicApi.fnGetValue(sSql, "MNDT"));
}
public async Task TestGetGlobalDataAsync()
{
var globalData = await PublicApi.GetGlobalDataAsync();
Assert.IsNotNull(globalData, "globalData is null");
Assert.IsNotNull(globalData.TotalMarketCapUSD, "globalData.TotalMarketCapUSD is null");
globalData = await PublicApi.GetGlobalDataAsync(currency : "INR");
Assert.IsNotNull(globalData, "globalData is null");
Assert.IsNotNull(globalData.TotalMarketCapUSD, "globalData.TotalMarketCapUSD is null");
Assert.IsNotNull(globalData.TotalMarketCapINR, "globalData.TotalMarketCapINR is null");
}
public string fnGetSeq(ReceiveD receiveD)
{
string sCondition = "";
sCondition += PublicApi.fnAddCondition("[order_id]", receiveD.order_id);
string sSql =
" SELECT ISNULL(MAX([seq]), 0) + 1 " +
" FROM [MNDTreceive_details] AS [receive_d] " +
" WHERE 1 = 1 " + sCondition;
return(PublicApi.fnGetValue(sSql, "MNDT"));
}
public string fnVerifications(ReceiveD receiveD)
{
string sSql =
" UPDATE [MNDTreceive_details] " +
" SET [complete] = '" + receiveD.complete + "' " +
" ,[pay_complete] = '" + receiveD.pay_complete + "' " +
" ,[modify_id] = '" + receiveD.create_id + "' " +
" ,[modify_datetime] = GETDATE() " +
" WHERE [order_id] = '" + receiveD.order_id + "' " +
" AND [seq] = '" + receiveD.seq + "' ";
return(PublicApi.fnExecuteSQL(sSql, "MNDT"));
}
public string fnDelete(GroupM groupM)
{
string sDetailsSql = " SELECT COUNT([group_id]) FROM [MNDTgroup_details] WHERE [group_id] = '" + groupM.group_id + "' ";
string sCount = PublicApi.fnGetValue(sDetailsSql, "MNDT");
if (sCount == "0")
{
string sSql = " DELETE [MNDTgroup_master] " +
" WHERE [group_id] = '" + groupM.group_id + "' ";
return(PublicApi.fnExecuteSQL(sSql, "MNDT"));
}
return("錯誤訊息：明細資料大於一筆。");
}
public string fnChangeInsert(ReceiveM receiveM)
{
string sSql = " INSERT INTO [dbo].[MNDTreceive_master] " +
" ([order_id] " +
" ,[id] " +
" ,[datetime] " +
" ,[complete] " +
" ,[description] " +
" ,[create_id] " +
" ,[create_datetime]) " +
" VALUES " +
" ('" + receiveM.order_id + "' " +
" ,'" + receiveM.create_id + "' " +
" ,GETDATE() " +
" ,'N' " +
" ,'' " +
" ,'" + receiveM.create_id + "' " +
" ,GETDATE()) ";
sSql +=
" INSERT INTO [MNDTreceive_details] " +
" ([seq] " +
" ,[order_id] " +
" ,[material_id] " +
" ,[warehouse_id] " +
" ,[amount] " +
" ,[price] " +
" ,[complete] " +
" ,[pay_complete] " +
" ,[description] " +
" ,[create_id] " +
" ,[create_datetime] " +
" ,[modify_id] " +
" ,[modify_datetime]) " +
" SELECT Row_number() OVER(ORDER BY[material_id] ASC) NUM " +
" ,[order_id] " +
" ,[material_id] " +
" ,'' " +
" ,[modify_amount] " +
" ,[modify_price] " +
" ,'N' " +
" ,'N' " +
" ,'' " +
" ,'" + receiveM.create_id + "' " +
" ,GETDATE() " +
" ,'" + receiveM.create_id + "' " +
" ,GETDATE() " +
" FROM [MNDTpurchase_details] " +
" WHERE order_id = '" + receiveM.order_id + "' ";
return(PublicApi.fnExecuteSQL(sSql, "MNDT"));
}
//private string fnInsertsSql(MaterialStockTran materialStockTran)
//{
// string sSql =
// " INSERT INTO [MNDTmaterial_stock_tran] " +
// " ([material_id] " +
// " ,[ip] " +
// " ,[status] " +
// " ,[create_id] " +
// " ,[create_datetime]) " +
// " SELECT [material_id] " +
// " , '" + materialStockTran + "' " +
// " , '" + materialStockTran.status + "' " +
// " , '" + materialStockTran.create_id + "' " +
// " , GETDATE() " +
// " FROM [MNDTmaterial_stock] " +
// " WHERE [material_id] IN (" + materialStockTran.material_id + ")";
// return sSql;
//}
public string fnCount(MaterialStockTran materialStockTran)
{
string sCondition = "";
sCondition += PublicApi.fnAddCondition("[material_id]", materialStockTran.material_id);
sCondition += PublicApi.fnAddCondition("[warehouse_id]", materialStockTran.warehouse_id);
string sCountSql =
" SELECT COUNT(material_id) " +
" FROM [MNDTmaterial_stock_tran] " +
" WHERE 1 = 1 " + sCondition;
string sPageSize = PublicApi.fnGetValue(sCountSql, "MNDT");
return(sPageSize);
}
public string fnUpdate(QuotesD quotesD)
{
string sSql =
" UPDATE [MNDTquotes_details] " +
" SET [modify_amount] = '" + quotesD.modify_amount + "' " +
" ,[modify_price] = '" + quotesD.modify_price + "' " +
" ,[description] = '" + quotesD.description + "' " +
" ,[modify_id] = '" + quotesD.create_id + "' " +
" ,[modify_datetime] = GETDATE() " +
" WHERE [order_id] = '" + quotesD.order_id + "' " +
" AND [product_id] = '" + quotesD.product_id + "' ";
return(PublicApi.fnExecuteSQL(sSql, "MNDT"));
}
public string fnChange(QuotesM quotesM, string sIP)
{
string sSql = " UPDATE [dbo].[MNDTquotes_master] " +
" SET [complete] = 'Y' " +
" WHERE [order_id] = '" + quotesM.order_id + "' ";
QuotesMTran quotesMTran = new QuotesMTran();
quotesMTran.OrderId(quotesM.order_id)
.IP(sIP)
.Status("M")
.CreateId(quotesM.create_id);
sSql += fnInsertSql(quotesMTran);
return(PublicApi.fnExecuteSQL(sSql, "MNDT"));
}
public DataTable fnSelects(MaterialStock materialStock)
{
string sCondition = "";
sCondition += PublicApi.fnAddCondition("[material_id]", materialStock.material_id);
sCondition += PublicApi.fnAddCondition("[warehouse_id]", materialStock.warehouse_id);
sCondition += " ORDER BY [" + materialStock.order + "] ";
string sInquireSql =
" SELECT * " +
" FROM MNDTmaterial_stock " +
" WHERE 1 = 1 " + sCondition;
return(PublicApi.fnGetDt(sInquireSql, "MNDT"));
}
public async Task GetBoard()
{
var res1 = await PublicApi.GetBoard(ProductCode.BtcJpy);
Assert.NotNull(res1);
var res2 = await PublicApi.GetBoard(ProductCode.FxBtcJpy);
Assert.NotNull(res2);
var res3 = await PublicApi.GetBoard(ProductCode.EthBtc);
Assert.NotNull(res3);
}
public DataTable fnSelect(KindM kindM)
{
string sSql = " SELECT TOP 1 [kind_id] " +
" ,[name] " +
" ,[description] " +
" ,[create_id] " +
" ,CONVERT(char, [create_datetime], 120) [create_datetime] " +
" ,[modify_id] " +
" ,CONVERT(char, [modify_datetime], 120) [modify_datetime] " +
" FROM [MNDTkind_master] " +
" WHERE [kind_id] = '" + kindM.kind_id + "' ";
return(PublicApi.fnGetDt(sSql, "MNDT"));
}
public string fnCount(SReturnD sreturnD)
{
string sCondition = "";
sCondition += PublicApi.fnAddCondition("[return_id]", sreturnD.return_id);
string sCountSql =
" SELECT COUNT([return_id]) " +
" FROM [MNDTSreturn_details] " +
" WHERE 1 = 1 " + sCondition;
string sPageSize = PublicApi.fnGetValue(sCountSql, "MNDT");
return(sPageSize);
}
public string fnCount(KindD kindD)
{
string sCondition = "";
sCondition += PublicApi.fnAddCondition("[kind_id]", kindD.kind_id);
string sCountSql =
" SELECT COUNT([kind_id]) " +
" FROM [MNDTkind_details] " +
" WHERE 1 = 1 " + sCondition;
string sPageSize = PublicApi.fnGetValue(sCountSql, "MNDT");
return(sPageSize);
}
public DataTable fnSelect(User user)
{
string sSql = " SELECT TOP 1 [user].[id] " +
" ,[user].[account] " +
" ,[user].[password] " +
" ,[user].[name] " +
" ,[user].[address] " +
" ,[user].[phone] " +
" ,[user].[status] " +
" FROM [MNDTuser] [user] " +
" WHERE [user].[id] = '" + user.id + "' ";
return(PublicApi.fnGetDt(sSql, "MNDT"));
}
public string fnCount(SReturnMTran sreturnMTran)
{
string sCondition = "";
sCondition += PublicApi.fnAddCondition("[return_id]", sreturnMTran.return_id);
string sCountSql =
" SELECT COUNT(return_id) " +
" FROM [MNDTSreturn_master_tran] " +
" WHERE 1 = 1 " + sCondition;
string sPageSize = PublicApi.fnGetValue(sCountSql, "MNDT");
return(sPageSize);
}
public string fnCount(ClientTran clientTran)
{
string sCondition = "";
sCondition += PublicApi.fnAddCondition("[client_id]", clientTran.client_id);
string sCountSql =
" SELECT COUNT(client_id) " +
" FROM [MNDTclient_tran] " +
" WHERE 1 = 1 " + sCondition;
string sPageSize = PublicApi.fnGetValue(sCountSql, "MNDT");
return(sPageSize);
}
public string fnCount(UserTran userTran)
{
string sCondition = "";
sCondition += PublicApi.fnAddCondition("[id]", userTran.id);
string sCountSql =
" SELECT COUNT(id) " +
" FROM [MNDTuser_tran] " +
" WHERE 1 = 1 " + sCondition;
string sPageSize = PublicApi.fnGetValue(sCountSql, "MNDT");
return(sPageSize);
}
public async void DepthAsync_should_success(string jsonString, string currencyPair)
{
//arrange
var response = TestHelper.CreateJsonResponse(jsonString);
var obj = new PublicApi(TestHelper.CreateApiClientWithMockHttpAccessor(response));
//act
var actual = await obj.DepthAsync(currencyPair);
//assert
Assert.NotNull(actual);
Assert.IsAssignableFrom <DepthResponse>(actual);
}
public DataTable fnSelects(ProductStock productStock)
{
string sCondition = "";
sCondition += PublicApi.fnAddCondition("[product_id]", productStock.product_id);
sCondition += PublicApi.fnAddCondition("[warehouse_id]", productStock.warehouse_id);
sCondition += " ORDER BY [" + productStock.order + "] ";
string sInquireSql =
" SELECT * " +
" FROM MNDTproduct_stock " +
" WHERE 1 = 1 " + sCondition;
return(PublicApi.fnGetDt(sInquireSql, "MNDT"));
}
//private string fnInsertsSql(ProductStockTran productStockTran)
//{
// string sSql =
// " INSERT INTO [MNDTproduct_stock_tran] " +
// " ([product_id] " +
// " ,[ip] " +
// " ,[status] " +
// " ,[create_id] " +
// " ,[create_datetime]) " +
// " SELECT [product_id] " +
// " , '" + productStockTran + "' " +
// " , '" + productStockTran.status + "' " +
// " , '" + productStockTran.create_id + "' " +
// " , GETDATE() " +
// " FROM [MNDTproduct_stock] " +
// " WHERE [product_id] IN (" + productStockTran.product_id + ")";
// return sSql;
//}
public string fnCount(ProductStockTran productStockTran)
{
string sCondition = "";
sCondition += PublicApi.fnAddCondition("[product_id]", productStockTran.product_id);
sCondition += PublicApi.fnAddCondition("[warehouse_id]", productStockTran.warehouse_id);
string sCountSql =
" SELECT COUNT(product_id) " +
" FROM [MNDTproduct_stock_tran] " +
" WHERE 1 = 1 " + sCondition;
string sPageSize = PublicApi.fnGetValue(sCountSql, "MNDT");
return(sPageSize);
}
public string fnSelect(KindD kindD)
{
string sCondition = "";
sCondition += PublicApi.fnAddCondition("[kind_id]", kindD.kind_id);
sCondition += PublicApi.fnAddCondition("[code_id]", kindD.code_id);
string sSql =
" SELECT TOP 1 [kind_d].[parameter] " +
" FROM [MNDTkind_details] AS [kind_d] " +
" WHERE 1 = 1 " + sCondition;
return(PublicApi.fnGetValue(sSql, "MNDT"));
}
public DataTable fnSelect(ReceiveD receiveD)
{
string sCondition = "";
sCondition += PublicApi.fnAddCondition("[order_id]", receiveD.order_id);
sCondition += PublicApi.fnAddCondition("[seq]", receiveD.seq);
string sInquireSql =
" SELECT [receive_d].* " +
" FROM [MNDTreceive_details] AS [receive_d] " +
" WHERE 1 = 1 " + sCondition;
return(PublicApi.fnGetDt(sInquireSql, "MNDT"));
}
public string fnCount(ReceiveD receiveD)
{
string sCondition = "";
sCondition += PublicApi.fnAddCondition("[order_id]", receiveD.order_id);
string sCountSql =
" SELECT COUNT([order_id]) " +
" FROM [MNDTreceive_details] " +
" WHERE 1 = 1 " + sCondition;
string sPageSize = PublicApi.fnGetValue(sCountSql, "MNDT");
return(sPageSize);
}
public string fnUpdate(ProgramD programD)
{
string sSql =
" UPDATE [MNDTprogram_details] " +
" SET [read] = '" + programD.read + "' " +
" ,[write] = '" + programD.write + "' " +
" ,[execute] = '" + programD.execute + "' " +
" ,[modify_id] = '" + programD.create_id + "' " +
" ,[modify_datetime] = GETDATE() " +
" WHERE [program_id] = '" + programD.program_id + "' " +
" AND [group_id] = '" + programD.group_id + "' ";
return(PublicApi.fnExecuteSQL(sSql, "MNDT"));
}
public string fnCount(ReceiveMTran receiveMTran)
{
string sCondition = "";
sCondition += PublicApi.fnAddCondition("[order_id]", receiveMTran.order_id);
string sCountSql =
" SELECT COUNT(order_id) " +
" FROM [MNDTreceive_master_tran] " +
" WHERE 1 = 1 " + sCondition;
string sPageSize = PublicApi.fnGetValue(sCountSql, "MNDT");
return(sPageSize);
}
public static void CurrenciesJsonToCode(string fileName)
{
var api = new PublicApi();
var res = api.Currencies("all").Result;
// var ordered = res.Result.OrderBy(c => c.CurrencyPairValue);
using (var stream = File.AppendText(fileName))
{
foreach (var item in res)
{
stream.WriteLine(" " + item.Name + ",");
}
}
}
public async Task GetExecutions()
{
var res1 = await PublicApi.GetExecutions(ProductCode.BtcJpy);
Assert.NotNull(res1);
var res2 = await PublicApi.GetExecutions(ProductCode.FxBtcJpy, 500, 272500, 272000);
Assert.NotNull(res2);
var res3 = await PublicApi.GetExecutions(ProductCode.EthBtc);
Assert.NotNull(res3);
}
void Events_AfterCreate(PublicApi.PollAfterCreateEventArgs e)
{
if (e.IsEnabled)
{
var story = GetStory(e.Id);
if (story == null)
{
_storyController.Create(new ActivityStoryCreateOptions
{
ContentId = e.ContentId,
ContentTypeId = PublicApi.Polls.ContentTypeId,
LastUpdate = DateTime.UtcNow,
Actors = new List<ActivityStoryActor>
{
new ActivityStoryActor
{
UserId = e.AuthorUserId,
Verb = "Add",
Date = DateTime.UtcNow
}
}
});
}
}
}
void Events_AfterCreate(PublicApi.PollVoteAfterCreateEventArgs e)
{
var story = GetStory(e.PollId);
if (story != null)
{
_storyController.Update(story.StoryId, new ActivityStoryUpdateOptions
{
LastUpdate = DateTime.UtcNow
});
}
}
private ContextItem BuildPollContextItem(PublicApi.Poll poll)
{
var item = new ContextItem()
{
TypeName = "Poll",
ApplicationId = poll.Group.ApplicationId,
ApplicationTypeId = Telligent.Evolution.Components.ContentTypes.Group,
ContainerId = poll.Group.ContainerId,
ContainerTypeId = Telligent.Evolution.Components.ContentTypes.Group,
ContentId = poll.ContentId,
ContentTypeId = PublicApi.Polls.ContentTypeId,
Id = poll.ContentId.ToString()
};
return item;
}
void Events_AfterUpdate(PublicApi.PollVoteAfterUpdateEventArgs e)
{
_metricController.QueueForCalculation(e.PollId, PublicApi.Polls.ContentTypeId);
}
void Events_AfterDelete(PublicApi.PollAfterDeleteEventArgs e)
{
if (_contentState != null)
_contentState.Deleted(e.ContentId);
}
void PollVoteEvents_AfterDelete(PublicApi.PollVoteAfterDeleteEventArgs e)
{
var poll = PublicApi.Polls.Get(e.PollId);
if (poll == null || !poll.Author.Id.HasValue || poll.Author.Id.Value == e.UserId)
return;
DeleteNotification(e.PollId, PublicApi.Polls.ContentTypeId, poll.Author.Id.Value, e.UserId);
}
void Events_Render(PublicApi.PollRenderEventArgs e)
{
if (e.RenderedProperty == "Description")
{
if (_hashTagController != null)
e.RenderedHtml = _hashTagController.FormatHashTagsForRendering(Get(e.ContentId), e.RenderedHtml, e.RenderTarget);
if (_mentionController != null)
e.RenderedHtml = _mentionController.FormatMentionsForRendering(e.RenderedHtml, e.RenderTarget);
}
}
void Events_AfterUpdate(PublicApi.PollAfterUpdateEventArgs e)
{
if (_hashTagController != null)
{
_hashTagController.AddUpdateHashTags(e.ContentId, "Description", e.Description("raw"));
var tags = _hashTagController.GetHashTagsInUnRenderedHtml(e.Name);
if (tags != null && tags.Length > 0)
{
TEApi.Tags.Add(e.ContentId, e.ContentTypeId, null, string.Join(",", tags));
var name = _hashTagController.FormatHashTagsInUnRenderedHtml(e.Name);
PublicApi.Polls.Update(e.Id, name);
}
}
if (_mentionController != null)
_mentionController.AddUpdateLoggedMentions(e.ContentId, "Description", e.Description("raw"));
}
