public void deleteTransaction(InvoiceTransactionDTO invoiceTransaction)
{
sqlConnection.Open();
String update;
update = " delete from InvoiceTransaction where InvoiceID =" + invoiceTransaction.INVOICEID + " ";
sqlCommand = new SqlCommand(update, sqlConnection);
sqlCommand.ExecuteNonQuery();
sqlConnection.Close();
}
public void updateTraction(InvoiceTransactionDTO invoiceTransaction)
{
sqlConnection.Open();
String update;
update = " update InvoiceTransaction set Date ='" + invoiceTransaction.DATE + "', SellingCash= " + invoiceTransaction.SELLINGCASH + " ,Profit=" + invoiceTransaction.PROFIT + " ,OtherExpense = " + invoiceTransaction.OTHEREXPENSE + " where InvoiceID =" + invoiceTransaction.INVOICEID + " ";
System.Diagnostics.Debug.WriteLine(update);
sqlCommand = new SqlCommand(update, sqlConnection);
sqlCommand.ExecuteNonQuery();
sqlConnection.Close();
}
public void addInvoice(InvoiceTransactionDTO invoiceTransaction)
{
//databaseConnection.databaseOpenConnection();
sqlConnection.Open();
String query = "insert into InvoiceTransaction values ('" + invoiceTransaction.INVOICEID + "'," +
"'" + invoiceTransaction.DATE + "'," +
"'" + invoiceTransaction.SELLINGCASH + "'," +
"'" + invoiceTransaction.PROFIT + "'," +
"'" + invoiceTransaction.OTHEREXPENSE + "'," +
"'" + invoiceTransaction.SHORTAGE + "')";
sqlCommand = new SqlCommand(query, sqlConnection);
sqlCommand.ExecuteNonQuery();
sqlConnection.Close();
}
