Esempio n. 1
0
        public void UpdateTransaction(DTO_Class.TransactionDTO transactionDTO)
        {
            sqlConnection.Open();

            string sqlQuery = "Update trans SET MonthYear='" + transactionDTO.DATE + "' where MonthYear='" + transactionDTO.DATE + "'";

            sqlCommand = new SqlCommand(sqlQuery, sqlConnection);
            sqlCommand.ExecuteNonQuery();

            string sqlQuery1 = "Update trans SET Revenue='" + transactionDTO.REVENUE + "' where MonthYear='" + transactionDTO.DATE + "'";

            sqlCommand1 = new SqlCommand(sqlQuery1, sqlConnection);
            sqlCommand1.ExecuteNonQuery();

            string sqlQuery2 = "Update trans SET Expense='" + transactionDTO.EXPENSE + "' where MonthYear='" + transactionDTO.DATE + "'";

            sqlCommand2 = new SqlCommand(sqlQuery2, sqlConnection);
            sqlCommand2.ExecuteNonQuery();


            string sqlQuery3 = "Update trans SET Profit='" + transactionDTO.PROFIT + "' where MonthYear='" + transactionDTO.DATE + "'";

            sqlCommand3 = new SqlCommand(sqlQuery3, sqlConnection);
            sqlCommand3.ExecuteNonQuery();

            sqlConnection.Close();
        }
Esempio n. 2
0
        public void CreateTransaction(DTO_Class.TransactionDTO transactionDTO)
        {
            try
            {
                sqlConnection.Open();
                string sqlQuery = " insert into trans values('" + transactionDTO.DATE +
                                  "','" + transactionDTO.REVENUE +
                                  "','" + transactionDTO.EXPENSE +
                                  "','" + transactionDTO.PROFIT +
                                  "')";

                sqlCommand = new SqlCommand(sqlQuery, sqlConnection);
                sqlCommand.ExecuteNonQuery();

                sqlConnection.Close();
            }
            catch (Exception ex)
            {
                MessageBox.Show("Invalid Input!", "alert", MessageBoxButtons.OK, MessageBoxIcon.Error);
            }
        }