public static int DeleteLastVoucherInformation(tLastVoucherInformation lastVoucher) { int rowsAdded; var query = "DELETE FROM tLastVoucherInformation"; using (IDbConnection connection = DbConnectionHelper.GetConnection()) { rowsAdded = connection.Execute(query, lastVoucher); } return rowsAdded; }
public static int AddLastVoucherInformation(tLastVoucherInformation lastVoucher) { int rowsAdded; using (IDbConnection connection = DbConnectionHelper.GetConnection()) { var query = SqlQueryHelper.GetInsertQuery<tLastVoucherInformation>(); rowsAdded = connection.Execute(query, lastVoucher); } return rowsAdded; }