public static object GetEditByID(Guid id)
{
try
{
DA_TRN trn = DealUIP.GetByID(id);
MA_INSTRUMENT ins = InstrumentUIP.GetByID(SessionInfo, trn.MA_INSRUMENT.ID);
var query = new
{
ID = trn.ID,
TradeDate = trn.TRADE_DATE.HasValue ? trn.TRADE_DATE.Value.ToString(FormatTemplate.DATE_DMY_LABEL) : string.Empty,
SpotDate = trn.SPOT_DATE.HasValue ? trn.SPOT_DATE.Value.ToString(FormatTemplate.DATE_DMY_LABEL) : string.Empty,
MaturityDate = trn.MATURITY_DATE.HasValue ? trn.MATURITY_DATE.Value.ToString(FormatTemplate.DATE_DMY_LABEL) : string.Empty,
Counterparty = trn.CTPY_ID.ToString(),
Portfolio = trn.PORTFOLIO_ID.ToString(),
Instrument = trn.INSTRUMENT_ID.ToString(),
BuySell = trn.FLAG_BUYSELL,
CCY1 = trn.FIRST.CCY_ID.ToString(),
SpotRate = trn.FIRST.RATE - (trn.FIRST.SWAP_POINT.HasValue ? trn.FIRST.SWAP_POINT : 0),
SwapPoint = trn.FIRST.SWAP_POINT,
Remark = trn.REMARK,
flag_settle = trn.FLAG_SETTLE,
Notional1 = Math.Abs(trn.FIRST.NOTIONAL.Value),
Notional2 = Math.Abs(trn.SECOND.NOTIONAL.Value)
};
return(new { Result = "OK", record = query, CCY = new { CURRENCY1 = ins.MA_CURRENCY.LABEL, CURRENCY2 = ins.MA_CURRENCY2.LABEL, CURRENCYID1 = ins.MA_CURRENCY.ID, CURRENCYID2 = ins.MA_CURRENCY2.ID, FLAG_MULTIPLY = ins.FLAG_MULTIPLY } });
}
catch (Exception ex)
{
return(new { Result = "ERROR", Message = ex.Message });
}
}
public static object GetEditByID(Guid id)
{
try
{
DA_TRN trn = DealUIP.GetByID(id);
var query = new
{
ID = trn.ID,
TradeDate = trn.TRADE_DATE.HasValue ? trn.TRADE_DATE.Value.ToString(FormatTemplate.DATE_DMY_LABEL) : string.Empty,
BuySell = trn.FLAG_BUYSELL,
MaturityDate = trn.MATURITY_DATE.HasValue ? trn.MATURITY_DATE.Value.ToString(FormatTemplate.DATE_DMY_LABEL) : string.Empty,
EffectiveDate = trn.START_DATE.HasValue ? trn.START_DATE.Value.ToString(FormatTemplate.DATE_DMY_LABEL) : string.Empty,
Counterparty = trn.CTPY_ID.ToString(),
Portfolio = trn.PORTFOLIO_ID.ToString(),
Instrument = trn.INSTRUMENT_ID.ToString(),
Notional = Math.Abs(trn.FIRST.NOTIONAL.Value),
Remark = trn.REMARK
};
return(new { Result = "OK", record = query });
}
catch (Exception ex)
{
return(new { Result = "ERROR", Message = ex.Message });
}
}
public static object GetEditByID(Guid id)
{
try
{
DA_TRN trn = DealUIP.GetByID(id);
var query = new
{
ID = trn.ID,
TradeDate = trn.TRADE_DATE.HasValue ? trn.TRADE_DATE.Value.ToString(FormatTemplate.DATE_DMY_LABEL) : string.Empty,
EffectDate = trn.START_DATE.HasValue ? trn.START_DATE.Value.ToString(FormatTemplate.DATE_DMY_LABEL) : string.Empty,
MaturityDate = trn.MATURITY_DATE.HasValue ? trn.MATURITY_DATE.Value.ToString(FormatTemplate.DATE_DMY_LABEL) : string.Empty,
Counterparty = trn.CTPY_ID.ToString(),
Portfolio = trn.PORTFOLIO_ID.HasValue ? trn.PORTFOLIO_ID.Value.ToString() : "-1",
Instrument = trn.PORTFOLIO_ID.HasValue ? trn.INSTRUMENT_ID.Value.ToString() : "-1",
Notional1 = Math.Abs(trn.FIRST.NOTIONAL.Value),
Notional2 = Math.Abs(trn.SECOND.NOTIONAL.Value),
FlagFixed1 = trn.FIRST.FLAG_FIXED.HasValue ? (trn.FIRST.FLAG_FIXED.Value ? "1" : "0") : "0",
FixAmt1 = trn.FIRST.FIRSTFIXINGAMT,
Rate1 = trn.FIRST.RATE,
Feq1 = trn.FIRST.FREQTYPE_ID.HasValue ? trn.FIRST.FREQTYPE_ID.Value.ToString() : string.Empty,
FlagFixed2 = trn.SECOND.FLAG_FIXED.HasValue ? (trn.SECOND.FLAG_FIXED.Value ? "1" : "0") : "0",
FixAmt2 = trn.SECOND.FIRSTFIXINGAMT,
Rate2 = trn.SECOND.RATE,
Feq2 = trn.SECOND.FREQTYPE_ID.HasValue ? trn.SECOND.FREQTYPE_ID.Value.ToString() : string.Empty,
CCY1 = trn.FIRST.CCY_ID,
CCY2 = trn.SECOND.CCY_ID
};
return(new { Result = "OK", record = query });
}
catch (Exception ex)
{
return(new { Result = "ERROR", Message = ex.Message });
}
}
public static object GetEditByID(Guid id)
{
try
{
DA_TRN lastTrn1 = DealUIP.GetByID(id);
DA_TRN lastTrn2 = DealUIP.GetFXSwapPair(SessionInfo, lastTrn1.INT_DEAL_NO, lastTrn1.VERSION, lastTrn1.ID);
MA_INSTRUMENT ins = InstrumentUIP.GetByID(SessionInfo, lastTrn1.MA_INSRUMENT.ID);
var NearLeg = lastTrn1.FLAG_NEARFAR == "N" ? lastTrn1 : lastTrn2;
var FarLeg = lastTrn2.FLAG_NEARFAR == "F" ? lastTrn2 : lastTrn1;
var query = new
{
TradeDate = lastTrn1.TRADE_DATE.HasValue ? lastTrn1.TRADE_DATE.Value.ToString(FormatTemplate.DATE_DMY_LABEL) : string.Empty,
Counterparty = lastTrn1.CTPY_ID.ToString(),
Portfolio = lastTrn1.PORTFOLIO_ID.ToString(),
Instrument = lastTrn1.INSTRUMENT_ID.ToString(),
ContractCcy = lastTrn1.FIRST.CCY_ID.ToString(),
SpotDate = lastTrn1.SPOT_DATE.HasValue ? lastTrn1.SPOT_DATE.Value.ToString(FormatTemplate.DATE_DMY_LABEL) : string.Empty,
SpotRate = lastTrn1.FIRST.RATE.Value - lastTrn1.FIRST.SWAP_POINT.Value,
BSN = NearLeg.FLAG_BUYSELL,
BSF = FarLeg.FLAG_BUYSELL,
SetDateN = NearLeg.MATURITY_DATE.HasValue ? NearLeg.MATURITY_DATE.Value.ToString(FormatTemplate.DATE_DMY_LABEL) : string.Empty,
SetDateF = FarLeg.MATURITY_DATE.HasValue ? FarLeg.MATURITY_DATE.Value.ToString(FormatTemplate.DATE_DMY_LABEL) : string.Empty,
SwapPoitN = NearLeg.FIRST.SWAP_POINT,
SwapPoitF = FarLeg.FIRST.SWAP_POINT,
ContAmtN = Math.Abs(NearLeg.FIRST.NOTIONAL.Value),
CountAmtN = Math.Abs(NearLeg.SECOND.NOTIONAL.Value),
ContAmtF = Math.Abs(FarLeg.FIRST.NOTIONAL.Value),
CountAmtF = Math.Abs(FarLeg.SECOND.NOTIONAL.Value),
flag_settle = lastTrn1.FLAG_SETTLE,
};
return(new { Result = "OK", record = query, productid2 = lastTrn2.ID.ToString(), CCY = new { CURRENCY1 = ins.MA_CURRENCY.LABEL, CURRENCY2 = ins.MA_CURRENCY2.LABEL, CURRENCYID1 = ins.MA_CURRENCY.ID, CURRENCYID2 = ins.MA_CURRENCY2.ID, FLAG_MULTIPLY = ins.FLAG_MULTIPLY } });
}
catch (Exception ex)
{
return(new { Result = "ERROR", Message = ex.Message });
}
}
public static object GetEditByID(Guid id)
{
try
{
DA_TRN trn = DealUIP.GetByID(id);
var query = new
{
ID = trn.ID,
TradeDate = trn.TRADE_DATE.HasValue ? trn.TRADE_DATE.Value.ToString(FormatTemplate.DATE_DMY_LABEL) : string.Empty,
BuySell = trn.FLAG_BUYSELL,
MaturityDate = trn.MATURITY_DATE.HasValue ? trn.MATURITY_DATE.Value.ToString(FormatTemplate.DATE_DMY_LABEL) : string.Empty,
Counterparty = trn.CTPY_ID.ToString(),
Portfolio = trn.PORTFOLIO_ID.ToString(),
Instrument = trn.INSTRUMENT_ID.ToString(),
Notional1 = Math.Abs(trn.FIRST.NOTIONAL.Value),
SettleFlag = trn.FLAG_SETTLE.HasValue ? (trn.FLAG_SETTLE.Value ? "1" : "0") : "0",
Remark = trn.REMARK,
Yield = trn.FIRST.RATE,
Unit = trn.DA_TMBA_EXTENSION.UNIT,
CPrice = trn.DA_TMBA_EXTENSION.CLEAN_PRICE,
GPrice = trn.DA_TMBA_EXTENSION.GROSS_PRICE,
PMarket = trn.FLAG_PCE.HasValue ? (trn.FLAG_PCE.Value ? "1" : "0") : "0",
YType = trn.DA_TMBA_EXTENSION.YIELD_TYPE,
Purpose = trn.DA_TMBA_EXTENSION.PURPOSE,
ReportBy = trn.DA_TMBA_EXTENSION.IS_REPORT_CLEAN ? "0" : "1",
Term = trn.DA_TMBA_EXTENSION.TERM.HasValue ? trn.DA_TMBA_EXTENSION.TERM.Value.ToString() : "",
Rate = trn.DA_TMBA_EXTENSION.RATE.HasValue ? trn.DA_TMBA_EXTENSION.RATE.Value.ToString() : "",
TBMARemark = trn.DA_TMBA_EXTENSION.REMARK,
LotSize = trn.MA_INSRUMENT.LOT_SIZE
};
return(new { Result = "OK", record = query });
}
catch (Exception ex)
{
return(new { Result = "ERROR", Message = ex.Message });
}
}
