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