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 }); } }