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