public override string SqlInsertString() { string sql = "declare @ID int\r\nEXEC @ID=InsertMT940statement 'MT940','{0}','{1}',{2},{3},'{4}','{5}','{6}',{7},{8}".Args( SenderAddress, AccountNumber, StatementNo, SequenceNo, Date.ToString("yyyyMMdd"), ContainingSwiftFileName.Replace(".working", ""), Currency, OpeningBalance, ClosingBalance ); foreach (MT940Activity activity in MT940Activities) { sql += " \r\nINSERT MT940Activity(ValueDate,Amount,Description,StatementID) VALUES ('{0}','{1}','{2}',@ID)".Args( activity.ValueDate.ToString("yyyyMMdd"), activity.Amount, activity.Description.Replace("'", "''") ); } return(sql); }
public override string SqlInsertString() { // Ensure file entry is there and grab the ID StringBuilder sql = new StringBuilder(); sql.AppendFormat("declare @ID int\r\nEXEC @ID=InsertSwiftFile '{0}'", ContainingSwiftFileName.Replace(".working", "")); sql.AppendFormat("EXEC InsertMT300message @ID,'{0}','{1}','{2}','{3}','{4}','{5}','{6}'", ApplicationID, ServiceID, LogicalTerminalAddress, SessionNumber, SequenceNumber, Direction, ReceiverAddress); sql.AppendFormat(",'{0}','{1}','{2}','{3}','{4}','{5}','{6}','{7}'", Priority, DeliveryMonitor, ObsolescencePeriod, InputDate, InputTime, MessageInputReference, OutputDate, OutputTime ); sql.AppendFormat(",'{0}','{1}','{2}','{3}','{4}','{5}','{6}','{7}'", SenderReference, TypeOfOperation, CommonReference, PartyA, PartyB, TradeDate.ToString("yyyyMMdd"), ValueDate.ToString("yyyyMMdd"), ExchangeRate ); sql.AppendFormat(",'{0}','{1}','{2}','{3}','{4}','{5}'", BoughtCurrency, BoughtAmount, BoughtReceivingAgent, SoldCurrency, SoldAmount, SoldReceivingAgent ); sql.AppendFormat("\r\ndeclare @recid int\r\nselect @recid = recid from tblrec where name='FX Confirmation'\r\nEXEC ScheduleRec @recid,'{0:ddMMMyy}'", ValueDate); return(sql.ToString()); }
public override string SqlInsertString() { string sql = "declare @ID int\r\nEXEC @ID=InsertMT535statement 'MT535','{0}','{1}',{2},{3},'{4}','{5}','{6}'".Args( SenderAddress, AccountNumber, StatementNo, SequenceNumber, Date.ToString("yyyyMMdd"), ContainingSwiftFileName.Replace(".working", ""), SenderReference ); foreach (MT535Activity activity in MT535Activities) { sql += " INSERT MT535Activity(SecurityIdentifier, Description, AggrBalance, StatementID) VALUES ('{0}','{1}',{2},@ID) \r\n".Args( activity.SecurityIdentifier, activity.Description.Replace("'", "''"), activity.AggrBalance ); } return(sql); }