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