Ejemplo n.º 1
0
 public void InsertSalaryPaymentStatement(SalaryPaymentStatementDTO salaryPaymentStatement)
 {
     try
     {
         SalaryPaymentStatementDAO.Instance.InsertSalaryPaymentStatement(salaryPaymentStatement);
     }
     catch (MySqlException ex)
     {
         throw new BUSException(ex.Message);
     }
 }
        public MySqlDataReader InsertSalaryPaymentStatement(SalaryPaymentStatementDTO salaryPaymentStatement)
        {
            try
            {
                // query
                string query = string.Format("insert into SALARYPAYMENTSTATEMENT values('{0}', '{1}', '{2}')",
                                             salaryPaymentStatement.ID, salaryPaymentStatement.Month, salaryPaymentStatement.Year);
                // excute query
                MySqlDataReader reader = MySqlConnectionDAO.Instance.ExcuteQuery(query);

                return(reader);
            }
            finally
            {
            }
        }