internal long SaveInvoice(t1rk1.balanceInvoice invoice)
{
long result = -1;
try
{
using (SqlConnection dbConn = new SqlConnection(connectionString))
{
string qsAddReceived = @"INSERT INTO [RECEIVED_MESSAGES]
([BODY]
,[CONTRACT_ID]
)
VALUES
(@BODY
, @CONTRACT_ID
);SELECT SCOPE_IDENTITY();
";
string qsAddInvoice = @"INSERT INTO [INVOICE]
([DATE]
,[CONTRACT_ID]
,[DUE_DATE]
,[EXPLANATION]
,[AMOUNT]
,[INVOICE_NR]
, [KRADO_ID])
VALUES
(@DATE
,@CONTRACT_ID
,@DUE_DATE
,@EXPLANATION
,@AMOUNT
,@INVOICE_NR
,@KRADO_ID)
;";
dbConn.Open();
SqlTransaction dbTrans = dbConn.BeginTransaction();
SqlCommand dbCommand = new SqlCommand(qsAddReceived, dbConn, dbTrans);
dbCommand.Parameters.AddWithValue("@BODY", "INVOICE");
dbCommand.Parameters.AddWithValue("@CONTRACT_ID", Int64.Parse(invoice.contractId));
try
{
long receivedId = Int64.Parse(dbCommand.ExecuteScalar().ToString());
dbCommand = new SqlCommand(qsAddInvoice, dbConn, dbTrans);
dbCommand.Parameters.AddWithValue("@DATE", invoice.date);
dbCommand.Parameters.AddWithValue("@CONTRACT_ID", Int64.Parse(invoice.contractId));
dbCommand.Parameters.AddWithValue("@DUE_DATE", invoice.dueDate);
dbCommand.Parameters.AddWithValue("@EXPLANATION", invoice.explanation);
dbCommand.Parameters.AddWithValue("@AMOUNT", invoice.amount);
dbCommand.Parameters.AddWithValue("@INVOICE_NR", invoice.invoiceNo);
dbCommand.Parameters.AddWithValue("@KRADO_ID", invoice.kradoId);
result = dbCommand.ExecuteNonQuery();
dbTrans.Commit();
}
catch (Exception queryExc)
{
Debug.WriteLine("Error inserting new invoice : " + queryExc.Message);
}
dbCommand.Connection.Close();
}
}
catch (Exception connExc)
{
Debug.WriteLine("Error adding new received invoice: " + connExc.Message);
}
return result;
}
internal long SaveProfile(t1rk1.electricityProfile profile)
{
long result = -1;
try
{
using (SqlConnection dbConn = new SqlConnection(connectionString))
{
string qsAddReceived = @"INSERT INTO [RECEIVED_MESSAGES]
([BODY]
,[CONTRACT_ID]
)
VALUES
(@BODY
, @CONTRACT_ID
);";
dbConn.Open();
SqlTransaction dbTrans = dbConn.BeginTransaction();
SqlCommand dbCommand = new SqlCommand(qsAddReceived, dbConn, dbTrans);
dbCommand.Parameters.AddWithValue("@BODY", "PROFILE");
dbCommand.Parameters.AddWithValue("@CONTRACT_ID", Int64.Parse(profile.contractId));
try
{
result = dbCommand.ExecuteNonQuery();
dbTrans.Commit();
}
catch (Exception queryExc)
{
Debug.WriteLine("Error inserting new profile : " + queryExc.Message);
}
dbCommand.Connection.Close();
}
}
catch (Exception connExc)
{
Debug.WriteLine("Error adding new received profile: " + connExc.Message);
}
return result;
}
