internal long SaveComposedMessage(t1es1.t1rk1.electricityProfile cMsg) { 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", "el.profile"); dbCommand.Parameters.AddWithValue("@CONTRACT_ID", cMsg.contractId); dbCommand.Parameters.AddWithValue("@RECEIVER", cMsg.toId); try { result = Int64.Parse(dbCommand.ExecuteScalar().ToString()); dbTrans.Commit(); } catch (Exception queryExc) { Debug.WriteLine("Error inserting new composed EP message : " + queryExc.Message); } dbCommand.Connection.Close(); } } catch (Exception connExc) { Debug.WriteLine("Error adding new composed EP message: " + connExc.Message); } return result; }
public void ReceiveMeterReading(t1es1.t1rk1.meterReading msgReading) { Trace.WriteLine("ReceiveMeterReading"); try { DataManager dataMan = new DataManager(); dataMan.SaveReadings(msgReading); try { this.SendConsumptionForecast(Int64.Parse(msgReading.contractId)); } catch (Exception scfExc) { Trace.WriteLine("Error sending forecast for cId: " + msgReading.contractId + "|" + scfExc.Message); } } catch (Exception rmrExc) { Trace.WriteLine("Error receiving meter reading: " + rmrExc.Message); } }