internal long SaveConfirmation(t1no1.contractMessage msgZ04) { long result = -1; try { using (SqlConnection dbConn = new SqlConnection(connectionString)) { string qsAddReceived = ""; string qsRenewContractAperak = ""; string qsGetContractId = ""; if (msgZ04.contractInfo != null && msgZ04.contractInfo.contractId != "-1") { qsAddReceived = @"INSERT INTO [RECEIVED_MESSAGES] ([BODY], [CONTRACT_ID], [RELATED_MESSAGE]) VALUES (@BODY , @CONTRACT_ID ,@RELATED_MESSAGE); SELECT SCOPE_IDENTITY();"; qsRenewContractAperak = @"UPDATE [CONTRACT] SET [Z04_MESSAGE_ID] = @Z04_MESSAGE_ID ,[Z04_MESSAGE_RESULT] = @Z04_MESSAGE_RESULT ,[PROCESSING_ERROR] = @PROCESSING_ERROR WHERE [ID]=@ID"; } else { qsAddReceived = @"INSERT INTO [RECEIVED_MESSAGES] ([BODY] ,[CONTRACT_ID] ,[RELATED_MESSAGE]) VALUES (@BODY , (select MAX([ID]) from [CONTRACT] where [CLIENT_ID]=@CLIENT_ID) ,@RELATED_MESSAGE);SELECT SCOPE_IDENTITY();"; qsRenewContractAperak = @"UPDATE [CONTRACT] SET [Z04_MESSAGE_ID] = @Z04_MESSAGE_ID ,[Z04_MESSAGE_RESULT] = @Z04_MESSAGE_RESULT ,[PROCESSING_ERROR] = @PROCESSING_ERROR WHERE [CLIENT_ID]=@ID;"; qsGetContractId = "select MAX([ID]) from [CONTRACT] where [CLIENT_ID]=@CLIENT_ID"; } dbConn.Open(); SqlTransaction dbTrans = dbConn.BeginTransaction(); SqlCommand dbCommand = new SqlCommand(qsAddReceived, dbConn, dbTrans); dbCommand.Parameters.AddWithValue("@BODY", "Z04"); if (msgZ04.contractInfo != null && msgZ04.contractInfo.contractId != "-1") { dbCommand.Parameters.AddWithValue("@CONTRACT_ID", Int64.Parse(msgZ04.contractInfo.contractId)); } else { dbCommand.Parameters.AddWithValue("@CLIENT_ID", Int64.Parse(msgZ04.ClientParty.registryCode)); } dbCommand.Parameters.AddWithValue("@RELATED_MESSAGE", Int64.Parse((msgZ04.relatedMessageId == null) ? "0" : msgZ04.relatedMessageId)); try { long receivedId = Int64.Parse(dbCommand.ExecuteScalar().ToString()); dbCommand = new SqlCommand(qsRenewContractAperak, dbConn, dbTrans); dbCommand.Parameters.AddWithValue("@Z04_MESSAGE_ID", receivedId); dbCommand.Parameters.AddWithValue("@Z04_MESSAGE_RESULT", msgZ04.confirmed); dbCommand.Parameters.AddWithValue("@PROCESSING_ERROR", ""); if (msgZ04.contractInfo != null && msgZ04.contractInfo.contractId != "-1") { dbCommand.Parameters.AddWithValue("@ID", Int64.Parse(msgZ04.contractInfo.contractId)); } else { dbCommand.Parameters.AddWithValue("@ID", Int64.Parse(msgZ04.ClientParty.registryCode)); } result = dbCommand.ExecuteNonQuery(); if (msgZ04.contractInfo == null || msgZ04.contractInfo.contractId == "-1") { dbCommand = new SqlCommand(qsGetContractId, dbConn, dbTrans); dbCommand.Parameters.AddWithValue("@CLIENT_ID", Int64.Parse(msgZ04.ClientParty.registryCode)); result = Int64.Parse(dbCommand.ExecuteScalar().ToString()); } else { result = Int64.Parse(msgZ04.contractInfo.contractId); } dbTrans.Commit(); } catch (Exception queryExc) { Debug.WriteLine("Error inserting new confirmation : " + queryExc.Message); } dbCommand.Connection.Close(); } } catch (Exception connExc) { Debug.WriteLine("Error adding new received message confirmation: " + connExc.Message); if (msgZ04.contractInfo == null) { Debug.WriteLine("ContractInfo is null!"); } } return result; }
internal long SaveComposedMessage(t1no1.contractMessage msgz03) { long result = -1; try { using (SqlConnection dbConn = new SqlConnection(connectionString)) { string qsAddComposed = @"INSERT INTO [COMPOSED_MESSAGES] ([BODY] ,[CONTRACT_ID] ,[RECEIVER]) VALUES (@BODY , @CONTRACT_ID , (select MAX([PARTNER].[ID]) from [PARTNER] where [PARTNER].[REG_NUM]=@RECEIVER ) ); SELECT SCOPE_IDENTITY();"; dbConn.Open(); SqlTransaction dbTrans = dbConn.BeginTransaction(); SqlCommand dbCommand = new SqlCommand(qsAddComposed, dbConn, dbTrans); dbCommand.Parameters.AddWithValue("@BODY", "Z03"); dbCommand.Parameters.AddWithValue("@CONTRACT_ID", msgz03.contractInfo.contractId); dbCommand.Parameters.AddWithValue("@RECEIVER", msgz03.messageRecieverParty); try { result = Int64.Parse(dbCommand.ExecuteScalar().ToString()); dbTrans.Commit(); } catch (Exception queryExc) { Debug.WriteLine("Error inserting new composed message : " + queryExc.Message); } dbCommand.Connection.Close(); } } catch (Exception connExc) { Debug.WriteLine("Error adding new composed message: " + connExc.Message); } return result; }